dhis2-devs team mailing list archive

[Dan <dan@xxxxxxxxxxxx>]

Hi Cenk

You need to make sure the hibernate.properties file is being loaded. One way to do this is to create the /opt/dhis2/hibernate.properties and ensure that your the permissions for the account running has permission to read it. The file should look something like this 

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgresql:databaseName
hibernate.connection.username = databaseUser
hibernate.connection.password = databasePassword
hibernate.hbm2ddl.auto = update 

In the log file you should see the following:
* INFO  2014-01-14 13:30:13,718 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-01-14 13:30:13,720 Environment variable DHIS2_HOME not set (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-01-14 13:30:13,721 Home directory set to /opt/dhis2 (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-01-14 13:30:14,992 Hibernate configuration loaded, using dialect: org.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])



Another alternative is to set the DHIS2_HOME environment variable for the account for this example DHIS2_HOME = /opt/dhis2 
* INFO  2014-01-14 13:30:13,718 System property dhis2.home not set (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-01-14 13:30:13,720 Environment variable DHIS2_HOME not set (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-01-14 13:30:13,721 Home directory set to /opt/dhis2 (DefaultLocationManager.java [localhost-startStop-1])
* INFO  2014-01-14 13:30:14,992 Hibernate configuration loaded, using dialect: org.hibernate.dialect.PostgreSQLDialect (DefaultHibernateConfigurationProvider.java [localhost-startStop-1])

The important part is to see the line 
Hibernate configuration loaded, using dialect: org.hibernate.dialect.PostgreSQLDialect 

Dan


Dan Cocos
BAO Systems
www.baosystems.com
T: +1 202-352-2671 | skype: dancocos

On Jan 14, 2014, at 12:28 PM, D. Cenk Erdil <dcerdil@xxxxxxxxx> wrote:

> Hi Paulo, 
> 
> Thanks for the feedback. It is becoming one of our nightmares to support DHIS Live (even worse, plan on deliverables that use a DHIS Live instance). 
> 
> I think we'll eventually need to pull the plug from using Live, but we are not there yet (need to upgrade quite a number of instances to DHIS 2.13/14). 
> 
> Any ideas on how I can make a DHIS Live instance to use the local postgres instead of the embedded H2? 
> 
> I've changed the hibernate.properties file in conf directory, but that does not seem to help. 
> 
> I've inspected the jar file (of DHIS Live) and couldn't find the reference to the database. 
> 
> Any feedback is appreciated. 
> 
> 
> --
> -Cenk.
> 
> 
> On Mon, Jan 13, 2014 at 7:09 PM, Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx> wrote:
> Hi Cenk,
> 
>  
> 
> It looks like you are facing the same problem we are in Mozambique. Please see https://bugs.launchpad.net/dhis2/+bug/1268787
> 
>  
> 
> If it’s just for demo propose you can always use postgresql instead of h2 default database. You will need to install postgresql on demonstration computers, and all you need is a restore from central server database;
> 
> If these are final installations to use in production environment be aware that you may need bidirectional data transmission, and on that case you can’t simply replace live databases with a dump from central server.
> 
>  
> 
> Regards,
> 
> Paulo Grácio
> 
>  
> 
> From: Dhis2-devs [mailto:dhis2-devs-bounces+pgracio=criticalsoftware.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of D. Cenk Erdil
> Sent: segunda-feira, 13 de Janeiro de 2014 20:09
> To: Knut Staring
> Cc: DHIS 2 developers
> Subject: Re: [Dhis2-devs] [Bug 1267561] Re: dataset reports, pivot tables, and data visualizer does not work after upgrade from 2.4 to 2.13
> 
>  
> 
> Hi Knut, 
> 
>  
> 
> (I work with Sharada)
> 
>  
> 
> We host server instances for in-country teams, but we need several off-line copies for demonstration and training. 
> 
>  
> 
> Also, the possibility to enter data while offline, and sync it with the server would be nice, as most our facilities do not have internet. 
> 
>  
> 
> Thus, the need to move data between server and live editions. 
> 
>  
> 
> In response to your recommendation, we might try dumping data from postgres and putting it in h2 (unless you've meant something else). 
> 
>  
> 
> I've done some googling and it looks like there are several methods to do that. 
> 
>  
> 
> Since we are time-constrained this week (our M&E staff are traveling in-country for demo/training of a shiny instance of brand new DHIS 2.13 with all its bells and whistles), I wanted to get your feedback on what would be the easiest way to move data from 2.13 server to live edition. 
> 
>  
> 
> Any feedback is greatly appreciated. 
> 
>  
> 
> Thanks. 
> 
>  
> 
>  
> 
>  
> 
>  
> 
> 
> 
> 
> --
> -Cenk.
> 
>  
> 
> On Sat, Jan 11, 2014 at 4:31 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
> 
> Hi Sharada,
> 
>  
> 
> What exactly is your use case - you want to work with the same data offline on multiple computers? You did an export + import? Could you perhaps just do a db dump and clone the database?
> 
>  
> 
> Knut
> 
>  
> 
> On Fri, Jan 10, 2014 at 11:27 PM, Sharada Acharya <sa3119@xxxxxxxxxxxx> wrote:
> 
> Hi Knut,
> 
> After generating the Analytics table, we could see the data in the Pivot
> Tables and Data set reports. Now, we have created a new DHIS live
> instance (2.13), in which we imported the data from the another DHIS
> instance (in which Pivot tables, reports woroked). But in this DHIS
> instance, we are still not able to see the data after generating
> Analytics tables. We verified that the data is present in the data set.
> 
> 
> --
> You received this bug notification because you are a member of DHIS 2
> developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/1267561
> 
> Title:
>   dataset reports, pivot tables, and data visualizer does not work after
>   upgrade from 2.4 to 2.13
> 
> Status in DHIS 2:
>   New
> 
> Bug description:
>   Hello,
> 
>   We have upgraded one of our DHIS server instances from 2.4 to 2.13
>   last month.
> 
>   Upon user feedback, we have come to realize that the three modules
>   have issues working on data that exist in the system.
> 
>   In particular:
>   1) Data Set Reports
>   2) Pivot Tables
>   3) Data Visualizer
> 
>   With the data set reports, the system generates a report with blank
>   values in the 2.13 vs. a complete report in 2.4 (see attached
>   screenshots).
> 
>   With Pivot Tables and Data Visualizer, the front-end gives "no values
>   found" error, while we see the Tomcat log references some missing
>   relationships in the postgres database (see attached catalina.out).
> 
>   This behavior is consistent with two separate DHIS instances (with two
>   different countries), both upgraded from 2.4 to 2.13. It also behaves
>   similarly on a DHIS Live (2.13) instance which was setup on a local
>   machine and data was imported from a server instance for the same
>   country.
> 
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/1267561/+subscriptions
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
> 
> 
> 
> 
>  
> 
> --
> 
> Knut Staring
> 
> Dept. of Informatics, University of Oslo
> 
> +4791880522
> 
> http://dhis2.org
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
> 
>  
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp

Attachment: smime.p7s
Description: S/MIME cryptographic signature