DHIS2 on virtual machine

Hello team,
I am trying to Install DHIS 2 on a virtual machine windows 7 on my Mac OS X. I set up the DHIS2_Home variable for the hibernate file but still I cannot replace the database H2 by postgreSQL.

Some help if anyone worked on it already.
Thank you!
Germine.

Hi Germine,

I suppose that you have already created postgreSQL database with name dhis2 and dhis:dhis (user:password) in Windows 7.

Maybe you wrote DHIS2_Home instead of DHIS2_HOME??
or
If you are using dhis-live version(81 Mb v2.14), has you checked dhis-live/conf/hibernate.properties?? In this file you have to comment (#) H2 database's lines and to uncomment postgreSQL database.

regards,

Ricardo.

···

On Feb 26, 2014, at 11:44 PM, "Seide, Germine" <GSeide@futuresgroup.com> wrote:

Hello team,
I am trying to Install DHIS 2 on a virtual machine windows 7 on my Mac OS X. I set up the DHIS2_Home variable for the hibernate file but still I cannot replace the database H2 by postgreSQL.

Some help if anyone worked on it already.
Thank you!
Germine.

_______________________________________________
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

Hi Germine,

when you created DHIS2_HOME environment variable with a specific value like C:\DHIS2\config

DHIS2_HOME=C:\DHIS2\config

Did you add the hibernate.properties file in C:\DHIS2\config?

hibernate.properties should include:

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect hibernate.connection.driver_class = org.postgresql.Driver hibernate.connection.url = jdbc:postgresql:dhis2 hibernate.connection.username = dhis hibernate.connection.password = dhis hibernate.hbm2ddl.auto = update

···

else could you give more information about what manual did you follow to configure it?

Ricardo.

On Thu, Feb 27, 2014 at 2:19 PM, Seide, Germine GSeide@futuresgroup.com wrote:

Hello J.,
I did all the configuration. See in attached file the description.

Germine.

Le 26 févr. 2014 à 18:15, J. Ricardo de Juan Cajide jricardo.dejuan@gmail.com a écrit :

Hi Germine,

I suppose that you have already created postgreSQL database with name dhis2 and dhis:dhis (user:password) in Windows 7.

Maybe you wrote DHIS2_Home instead of DHIS2_HOME??

or

If you are using dhis-live version(81 Mb v2.14), has you checked dhis-live/conf/hibernate.properties?? In this file you have to comment (#) H2 database’s lines and to uncomment postgreSQL database.

regards,

Ricardo.

On Feb 26, 2014, at 11:44 PM, “Seide, Germine” GSeide@futuresgroup.com wrote:

Hello team,

I am trying to Install DHIS 2 on a virtual machine windows 7 on my Mac OS X. I set up the DHIS2_Home variable for the hibernate file but still I cannot replace the database H2 by postgreSQL.

Some help if anyone worked on it already.

Thank you!

Germine.


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

Hello,
Here is my file

···

else could you give more information about what manual did you follow to configure it?

Ricardo.

On Thu, Feb 27, 2014 at 2:19 PM, Seide, Germine
GSeide@futuresgroup.com wrote:

Hello J.,
I did all the configuration. See in attached file the description.

Germine.

<Capture d’écran 2014-02-27 08.06.46.png>

Le 26 févr. 2014 à 18:15, J. Ricardo de Juan Cajide jricardo.dejuan@gmail.com a écrit :

Hi Germine,

I suppose that you have already created postgreSQL database with name dhis2 and dhis:dhis (user:password) in Windows 7.

Maybe you wrote DHIS2_Home instead of DHIS2_HOME??

or

If you are using dhis-live version(81 Mb v2.14), has you checked dhis-live/conf/hibernate.properties?? In this file you have to comment (#) H2 database’s lines and to uncomment postgreSQL database.

regards,

Ricardo.

On Feb 26, 2014, at 11:44 PM, “Seide, Germine” GSeide@futuresgroup.com wrote:

Hello team,

I am trying to Install DHIS 2 on a virtual machine windows 7 on my Mac OS X. I set up the DHIS2_Home variable for the hibernate file but still I cannot replace the database H2 by postgreSQL.

Some help if anyone worked on it already.

Thank you!

Germine.


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

Hi,

the last thing that comes to mind:

here http://www.dhis2.org/doc/snapshot/en/implementer/html/ch08s02.html#d5e515 when you have to configure Tomcat, you have to edit “tomcat-dhis/bin/setenv.sh” with:

export JAVA_HOME='/usr/lib/jvm/java-7-openjdk' export JAVA_OPTS='-Xmx7500m -Xms4000m -XX:MaxPermSize=500m -XX:PermSize=300m' export DHIS2_HOME='/home/dhis/config'

this configuration is for Ubuntu, you should adjust to your Windows environment.

Best regards,

Ricardo.

···

else could you give more information about what manual did you follow to configure it?

Ricardo.

On Thu, Feb 27, 2014 at 2:19 PM, Seide, Germine
GSeide@futuresgroup.com wrote:

Hello J.,
I did all the configuration. See in attached file the description.

Germine.

<Capture d’écran 2014-02-27 08.06.46.png>

Le 26 févr. 2014 à 18:15, J. Ricardo de Juan Cajide jricardo.dejuan@gmail.com a écrit :

Hi Germine,

I suppose that you have already created postgreSQL database with name dhis2 and dhis:dhis (user:password) in Windows 7.

Maybe you wrote DHIS2_Home instead of DHIS2_HOME??

or

If you are using dhis-live version(81 Mb v2.14), has you checked dhis-live/conf/hibernate.properties?? In this file you have to comment (#) H2 database’s lines and to uncomment postgreSQL database.

regards,

Ricardo.

On Feb 26, 2014, at 11:44 PM, “Seide, Germine” GSeide@futuresgroup.com wrote:

Hello team,

I am trying to Install DHIS 2 on a virtual machine windows 7 on my Mac OS X. I set up the DHIS2_Home variable for the hibernate file but still I cannot replace the database H2 by postgreSQL.

Some help if anyone worked on it already.

Thank you!

Germine.


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

Hi,
Thank yo for your help. I tried to set up the variables but it did not work.

Germine.

···

else could you give more information about what manual did you follow to configure it?

Ricardo.

On Thu, Feb 27, 2014 at 2:19 PM, Seide, Germine
GSeide@futuresgroup.com wrote:

Hello J.,
I did all the configuration. See in attached file the description.

Germine.

<Capture d’écran 2014-02-27 08.06.46.png>

Le 26 févr. 2014 à 18:15, J. Ricardo de Juan Cajide jricardo.dejuan@gmail.com a écrit :

Hi Germine,

I suppose that you have already created postgreSQL database with name dhis2 and dhis:dhis (user:password) in Windows 7.

Maybe you wrote DHIS2_Home instead of DHIS2_HOME??

or

If you are using dhis-live version(81 Mb v2.14), has you checked dhis-live/conf/hibernate.properties?? In this file you have to comment (#) H2 database’s lines and to uncomment postgreSQL database.

regards,

Ricardo.

On Feb 26, 2014, at 11:44 PM, “Seide, Germine” GSeide@futuresgroup.com wrote:

Hello team,

I am trying to Install DHIS 2 on a virtual machine windows 7 on my Mac OS X. I set up the DHIS2_Home variable for the hibernate file but still I cannot replace the database H2 by postgreSQL.

Some help if anyone worked on it already.

Thank you!

Germine.


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

Have you checked that your user “postgres” has permissions to read hibernate.properties?

Ricardo.

···

else could you give more information about what manual did you follow to configure it?

Ricardo.

On Thu, Feb 27, 2014 at 2:19 PM, Seide, Germine
GSeide@futuresgroup.com wrote:

Hello J.,
I did all the configuration. See in attached file the description.

Germine.

<Capture d’écran 2014-02-27 08.06.46.png>

Le 26 févr. 2014 à 18:15, J. Ricardo de Juan Cajide jricardo.dejuan@gmail.com a écrit :

Hi Germine,

I suppose that you have already created postgreSQL database with name dhis2 and dhis:dhis (user:password) in Windows 7.

Maybe you wrote DHIS2_Home instead of DHIS2_HOME??

or

If you are using dhis-live version(81 Mb v2.14), has you checked dhis-live/conf/hibernate.properties?? In this file you have to comment (#) H2 database’s lines and to uncomment postgreSQL database.

regards,

Ricardo.

On Feb 26, 2014, at 11:44 PM, “Seide, Germine” GSeide@futuresgroup.com wrote:

Hello team,

I am trying to Install DHIS 2 on a virtual machine windows 7 on my Mac OS X. I set up the DHIS2_Home variable for the hibernate file but still I cannot replace the database H2 by postgreSQL.

Some help if anyone worked on it already.

Thank you!

Germine.


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

No, can you tell me how to do that?
Germine.

···

else could you give more information about what manual did you follow to configure it?

Ricardo.

On Thu, Feb 27, 2014 at 2:19 PM, Seide, Germine
GSeide@futuresgroup.com wrote:

Hello J.,
I did all the configuration. See in attached file the description.

Germine.

<Capture d’écran 2014-02-27 08.06.46.png>

Le 26 févr. 2014 à 18:15, J. Ricardo de Juan Cajide jricardo.dejuan@gmail.com a écrit :

Hi Germine,

I suppose that you have already created postgreSQL database with name dhis2 and dhis:dhis (user:password) in Windows 7.

Maybe you wrote DHIS2_Home instead of DHIS2_HOME??

or

If you are using dhis-live version(81 Mb v2.14), has you checked dhis-live/conf/hibernate.properties?? In this file you have to comment (#) H2 database’s lines and to uncomment postgreSQL database.

regards,

Ricardo.

On Feb 26, 2014, at 11:44 PM, “Seide, Germine” GSeide@futuresgroup.com wrote:

Hello team,

I am trying to Install DHIS 2 on a virtual machine windows 7 on my Mac OS X. I set up the DHIS2_Home variable for the hibernate file but still I cannot replace the database H2 by postgreSQL.

Some help if anyone worked on it already.

Thank you!

Germine.


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

In this link you have a solution to change read permissions for user “postgres”:

http://technet.microsoft.com/en-us/library/cc754344.aspx

you have to give read permissions to user “postgres” because it is owner of dhis2 database in PostgreSQL.

Besides, the database’s password is in clear and only should be able to read hibernate.properties file the owner(postgres).

First, you give read permissions for everybody to hibernate.properties file and if it works, you should do the above.

Ricardo.

···

else could you give more information about what manual did you follow to configure it?

Ricardo.

On Thu, Feb 27, 2014 at 2:19 PM, Seide, Germine
GSeide@futuresgroup.com wrote:

Hello J.,
I did all the configuration. See in attached file the description.

Germine.

<Capture d’écran 2014-02-27 08.06.46.png>

Le 26 févr. 2014 à 18:15, J. Ricardo de Juan Cajide jricardo.dejuan@gmail.com a écrit :

Hi Germine,

I suppose that you have already created postgreSQL database with name dhis2 and dhis:dhis (user:password) in Windows 7.

Maybe you wrote DHIS2_Home instead of DHIS2_HOME??

or

If you are using dhis-live version(81 Mb v2.14), has you checked dhis-live/conf/hibernate.properties?? In this file you have to comment (#) H2 database’s lines and to uncomment postgreSQL database.

regards,

Ricardo.

On Feb 26, 2014, at 11:44 PM, “Seide, Germine” GSeide@futuresgroup.com wrote:

Hello team,

I am trying to Install DHIS 2 on a virtual machine windows 7 on my Mac OS X. I set up the DHIS2_Home variable for the hibernate file but still I cannot replace the database H2 by postgreSQL.

Some help if anyone worked on it already.

Thank you!

Germine.


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