Re: [Health-dev] Connecting to local database

[Bruno M. Villasanti]

2014-02-06 13:58 GMT-03:00 Ramakrishna, K (RK) <address@hidden>:

Hello Alex and Bruno,

Thank you.

I have modified the config file for both dbname and time xone.

But I am still receiving the same error.

I have attached the conf file here

Thanks and Regards,

RK

Note that if you followed the installation tutorial, you already have a user database with the name "gnuhealth" [1]. This is the username that should be used on trytond.conf:

db_user = gnuhealth

db_password = gnusolidario

As you just explicit a specific user database, you need to assign password to that user as follows (login as root):

# psql -U postgres -c "ALTER ROLE gnuhealth ENCRYPTED PASSWORD 'gnusolidario' ;"

.. if it fails, retry adding the host:

# psql -U postgres -h localhost -c "ALTER ROLE gnuhealth ENCRYPTED PASSWORD 'gnusolidario' ;"

Furthermore, removes the two preceding spaces to the 'timezone' key:

··timezone·=·Atlantic/Canary

Aligned to the left margin:

timezone = Atlantic/Canary

Now you can retry.

Remember testing always pointing to the 'trytond.conf' configuration file, and using the user 'gnuhealth' Linux:

gnuhealth$ ./trytond -c /home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/etc/trytond.conf 

--

[1] http://en.wikibooks.org/wiki/GNU_Health/Installation#Creating_the_Database_user

--

Bruno M. Villasanti

thymbr@