Re: [Health-dev] Connecting to local database

[Bruno M. Villasanti]

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

Dear Alex,

Thank you for your attention.

Is your database running?

>> Yes, I believe, from ps -eaf output:: postgres 28129     1  0 20:27 ?        00:00:00 /usr/lib/postgresql/9.1/bin/postgres -D /var/lib/postgresql/9.1/main -c config_file=/etc/postgresql/9.1/main/postgresql.conf

Is tryton server running?

>> Yes, I believe, from the command line

/trytond
/home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/trytond/modules/__init__.py:37: UserWarning: Module trytond was already imported from /home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/trytond/__init__.pyc, but /usr/lib/python2.7/dist-packages is being added to sys.path import pkg_resources
[Thu Feb 06 15:31:27 2014] INFO:server:using /etc/trytond.conf as configuration file
[Thu Feb 06 15:31:27 2014] INFO:server:initialising distributed objects services
[Thu Feb 06 15:31:27 2014] INFO:server:starting JSON-RPC protocol on localhost:8000

Are you connecting from localhost?

>>Yes.

how does your trytond.conf look?

It is default /etc/trytond.conf

I am attaching the conf file, the error I am getting when trying to connect and when I try to create a DB.

Also, I tried using the conf file in trytond directory.. but it didn't help either,

./trytond -c /home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/etc/trytond.conf
/home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/trytond/modules/__init__.py:37: UserWarning: Module trytond was already imported from /home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/trytond/__init__.pyc, but /usr/lib/python2.7/dist-packages is being added to sys.path
  import pkg_resources
[Thu Feb 06 15:53:09 2014] INFO:server:using /home/gnuhealth/gnuhealth/tryton/server/trytond-3.0.2/etc/trytond.conf as configuration file
[Thu Feb 06 15:53:09 2014] INFO:server:initialising distributed objects services
[Thu Feb 06 15:53:09 2014] INFO:server:starting JSON-RPC protocol on *:8000

Tryton and Postgres are installed newly as a pre-requisite for gnuhealth.

Thanks and Regards,

RK

According to the error message:

FATAL: Invalid value for parameter "TimeZone": "IST"

You should find your respective time zone [1], and set it to the value for "timezone" in the configuration file "trytond.conf" [2].

For example:

timezone = America/Argentina/Buenos_Aires

Regards.

--

[1] http://en.wikipedia.org/wiki/List_of_tz_database_time_zones

[2] http://en.wikibooks.org/wiki/GNU_Health/Installation?Setting-Up-your-Server-Timezone#Setting_Up_your_Server_Timezone

--

Bruno M. Villasanti

thymbr@