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, <[email protected]> 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 <[email protected]> > *Date: *Sun, 12 May 2013 09:49:41 +0300 > *To: *Dayo Adeyomoye<[email protected]> > *Cc: *[email protected]<[email protected]> > *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 <[email protected]>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: [email protected], [email protected] >> Yahoo IM: deemoyes >> Facebook: pharael >> twitter:pharaell >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > 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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
