Hi Cenk On 14 January 2014 18:33, Dan <d...@dancocos.com> wrote:
> 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 /opt/dhis2 directory should only be searched if you are running linux. Its a long time since I ran dhis2-live (even though I wrote most of it) but one of the main motivations was to have a relatively configuration free install ie. you unzip and run. Consequently, by default, the application should look for a hibernate.properties under the conf directory of where you unzipped it. You said it didn't help with postgresql ... what do you mean more exactly? All I can say is that it *should* have worked. Can you give some detail what is (or isn't ) happening. Bob > 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 > > > > > > _______________________________________________ > 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
