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 <dcer...@gmail.com> 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 <pgra...@criticalsoftware.com> > 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....@lists.launchpad.net] > 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 <knu...@gmail.com> 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 <sa3...@columbia.edu> 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@lists.launchpad.net > 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
