dhis2-devs team mailing list archive

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

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.


On Feb 27, 2014, at 8:17 PM, "Seide, Germine" <GSeide@xxxxxxxxxxxxxxxx> wrote:

> No, can you tell me how to do that?
> Germine.
> Le 27 févr. 2014 à 14:04, J. Ricardo de Juan Cajide <jricardo.dejuan@xxxxxxxxx> a écrit :
> 
>> 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
>>>>>>> 
>>>>>> 
>>>>>> 
>>>>> 
>>>> 
>>> 
>> 
>