Re: [Health-dev] Connecting to local database

[Ramakrishna, K (RK)]

Hello Alex and Bruno,

Just in case, if this helps in pointing me in direction -

When I am trying into install demo database per instrcutions   here..: http://en.wikibooks.org/wiki/GNU_Health/The_Demo_database#Installing_a_local_Demo_Database

I am getting the below error:

python health_demo_server.py
Traceback (most recent call last):
  File "health_demo_server.py", line 228, in <module>
    options.demo_password)
  File "health_demo_server.py", line 195, in main
    config = set_config(database, password)
  File "health_demo_server.py", line 26, in set_config
    return pconfig.set_trytond(database, password=password)
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/proteus/config.py", line 264, in set_trytond
    language=language, password=password, config_file=config_file)
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/proteus/config.py", line 205, in __init__
    with Transaction().start(None, 0) as transaction:
  File "/usr/lib/python2.7/dist-packages/trytond/transaction.py", line 77, in start
    database = Database().connect()
  File "/usr/lib/python2.7/dist-packages/trytond/backend/postgresql/database.py", line 68, in connect
    self._connpool = ThreadedConnectionPool(minconn, maxconn, dsn)
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/psycopg2/pool.py", line 156, in __init__
    self, minconn, maxconn, *args, **kwargs)
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/psycopg2/pool.py", line 58, in __init__
    self._connect()
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/psycopg2/pool.py", line 62, in _connect
    conn = psycopg2.connect(*self._args, **self._kwargs)
  File "/home/gnuhealth/.local/lib/python2.7/site-packages/psycopg2/__init__.py", line 164, in connect
    conn = _connect(dsn, connection_factory=connection_factory, async=async)
psycopg2.OperationalError: FATAL:  Peer authentication failed for user "postgres"

On Thu, Feb 6, 2014 at 10:28 PM, Ramakrishna, K (RK) <address@hidden> wrote:

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

On Thu, Feb 6, 2014 at 10:07 PM, Axel Braun <address@hidden> wrote:

On 6. Februar 2014 17:31:47 MEZ, "Bruno M. Villasanti" <address@hidden> wrote:
>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

Potentially. But in my installations it works with the default settings. So maybe this is a secondary problem?