dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Since you loose your work everytime Tomcat stops, this indicates that DHIS2
is not connecting to Postgres, but rather using the in-memory H2 database,
in other words, either the hibernate.properties file is not found, or it is
not correct. The environment variables should be system variables. You may
have to reboot Windows for Tomcat to pick them up - sometimes it is easier
to place them in the startup script. You avoid all this trouble if you use
DHIS Live.

You can check what database you are using by selecting Help -> About DHIS2
in the menu. You can share with us the content of that page, and also your
Tomcat log.

Knut


On Sun, May 12, 2013 at 9:56 AM, <deemoyes@xxxxxxxxx> wrote:

> **
> Thank you very much,
>
> Ȋ̝̊̅ have done all these and it still does not work. There are 2 sections
> under environmental variables. Do you mean user variables for administrator
> or system variables?
>
>
> The DHIS instance loads, Ȋ̝̊̅ am able t̶̲̥̅̊ợ̣̣̇̇̇ login but all work
> Ȋ̝̊̅§ lost after Ȋ̝̊̅f Ȋ̝̊̅ restart apache or the computer.
>
> This Ȋ̝̊̅§ the same issue Ȋ̝̊̅ have on doing α linux installation.
>
> Thank you.
>
> Dayo
> Sent from my BlackBerry® smartphone from Etisalat. Enjoy high speed mobile
> broadband on our easyblaze and plans for BlackBerry. Visit
> www.etisalat.com.ng for details.
> ------------------------------
> *From: * Sam Kasozi <kasozis@xxxxxxxxx>
> *Date: *Sun, 12 May 2013 09:49:41 +0300
> *To: *Dayo Adeyomoye<deemoyes@xxxxxxxxx>
> *Cc: *dhis2-users@xxxxxxxxxxxxxxxxxxx<dhis2-users@xxxxxxxxxxxxxxxxxxx>
> *Subject: *Re: [Dhis2-users] dhis.war deployment on Windows platform
>
> Hi  Dayo, assuming PostgreSQL is installed and the database is created
> with the following:
>
> Login Role (User): dhisuser
> User password: dhispwd
> Database: dhis2dbase
>
> Then the hibernate.properties configuration file would be as thus:
>
> hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
> hibernate.connection.driver_class = org.postgresql.Driver
> hibernate.connection.url = jdbc:postgresql:dhis2ug
> hibernate.connection.username = dhisuser
> hibernate.connection.password = dhispwd
> hibernate.hbm2ddl.auto = update
>
> To tell the DHIS 2 where to find the configuration file, create a system
> Environment Variable DHIS2_HOME, with the directory path to the
> hibernate.properties configuration file
> i.e DHIS2_HOME: C:\...
>
> Another Environment Variable you need to set is the JAVA_OPTS, which
> allocates memory to the java process
> JAVA_OPTS: -Xms512m -Xmx1024m -XX:PermSize=128m -XX:MaxPermSize=256m
>
> The current DHIS2 WAR file (version 2.11) is about 80MB, which is higher
> than the default maximum size that can be deployed by Tomcat 7.x. To
> correct this, increase the max-file-size and max-request-size from 50MB
> (52428800) to at least 100MB (104857600) by editing the ‘web.xml’ file in
> the directory: C:\Program Files (x86)\Apache Software Foundation\Tomcat
> 7.0\webapps\manager\WEB-INF (in my case).
>
> http://dhis2.org/development
>
> From the Tomcat Manager:
> Under Deploy section, choose the WAR file to upload, Deploy and wait
> (about 3-5 minutes in my case)
>
> If all is well, then the DHIS2 instance will be loaded under the
> Applications Section
> Click on it under the ‘Path’ column to start
>
> Hope this helps,
> Sam
>
>
>
> On Sat, May 11, 2013 at 9:12 PM, Dayo Adeyomoye <deemoyes@xxxxxxxxx>wrote:
>
>> Hi All,
>>
>> What config does one need to do if dhis.war is deployed on windows using
>> apache tomcat. I mean the hibernate.properties connection to be able to use
>> postgres and the system&user environment variables.
>>
>> Thank you.
>>
>> Adedayo
>>
>> BlackBerry: 3114F90C
>> Phone: 08028851441, 08035560463
>> emails: deemoyes@xxxxxxxxx, addyraph@xxxxxxxxx
>> Yahoo IM: deemoyes
>> Facebook: pharael
>> twitter:pharaell
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org