dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Hi Cenk

On 14 January 2014 18:33, Dan <dan@xxxxxxxxxxxx> 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 <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
>
>
>
>
>
> _______________________________________________
> 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
>
>