Error in creating dhis database

Support - Assistance technique
1

Hi,
i have setup dhis server in ubuntu, with postgresql database. the server is running fine. but whenever my tomcat6 restarts my database is deleted. i have to re create the database. the dataabse is empty. can anyone suggest me as to why this is happening?

also is there anyway that i can change my database from postgresql to mysql?

thank you

···

–
------------------------------------------------------------------------------------------->>

AWANTHIKA SENARATH
Undergraduate

Department of Electronics and Telecommunication Engineering

University of Moratuwa

2

Hi,

Can you post the log? it sounds like you are running a db in memory, which means that the configuration you are using is wrong. Looking at the log will give you hints about this.

You can read about postgresql setup at:

http://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e451

···

–
Morten

On Fri, Oct 18, 2013 at 11:44 AM, awanth sen wnthksnrth@gmail.com wrote:

Hi,
i have setup dhis server in ubuntu, with postgresql database. the server is running fine. but whenever my tomcat6 restarts my database is deleted. i have to re create the database. the dataabse is empty. can anyone suggest me as to why this is happening?

also is there anyway that i can change my database from postgresql to mysql?

------------------------------------------------------------------------------------------->>

AWANTHIKA SENARATH
Undergraduate

Department of Electronics and Telecommunication Engineering

University of Moratuwa

thank you

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

3

On this page - http://www.dhis2.org/development
scroll down to database setup and you’ll find changes to hibernate.properties that needs to be done for MySQL

···

Regards,
Saptarshi PURKAYASTHA

From: mortenoh@gmail.com
Date: Fri, 18 Oct 2013 11:47:35 +0200
To: wnthksnrth@gmail.com
CC: dhis2-devs@lists.launchpad.net
Subject: Re: [Dhis2-devs] Error in creating dhis database

Hi,

Can you post the log? it sounds like you are running a db in memory, which means that the configuration you are using is wrong. Looking at the log will give you hints about this.

You can read about postgresql setup at:

http://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e451

–
Morten

On Fri, Oct 18, 2013 at 11:44 AM, awanth sen wnthksnrth@gmail.com wrote:

Hi,
i have setup dhis server in ubuntu, with postgresql database. the server is running fine. but whenever my tomcat6 restarts my database is deleted. i have to re create the database. the dataabse is empty. can anyone suggest me as to why this is happening?

also is there anyway that i can change my database from postgresql to mysql?

------------------------------------------------------------------------------------------->>

AWANTHIKA SENARATH
Undergraduate

Department of Electronics and Telecommunication Engineering

University of Moratuwa

thank you

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: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help