dhis2-devs team mailing list archive

["J. Ricardo de Juan Cajide" <jricardo.dejuan@xxxxxxxxx>]

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

Ricardo.
On Feb 27, 2014, at 7:40 PM, "Seide, Germine" <GSeide@xxxxxxxxxxxxxxxx> wrote:

> Hi,
> Thank yo for your help. I tried to set up the variables but it did not work.
>  Germine.
> 
> Le 27 févr. 2014 à 11:09, J. Ricardo de Juan Cajide <jricardo.dejuan@xxxxxxxxx> a écrit :
> 
>> 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.
>> 
>> 
>> On Feb 27, 2014, at 4:51 PM, "Seide, Germine" <GSeide@xxxxxxxxxxxxxxxx> wrote:
>> 
>>> Hello,
>>> Here is my file
>>> <Capture d'écran 2014-02-27 09.56.28.png>
>>> <Capture d'écran 2014-02-27 10.16.54.png>
>>> 
>>> Le 27 févr. 2014 à 09:40, J. Ricardo de Juan Cajide <jricardo.dejuan@xxxxxxxxx> a écrit :
>>> 
>>>> 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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>> 
>>>> 
>>>> 
>>> 
>> 
>