Re: [Health] Could not connect to server problem

[Maria Cecilia Santos Popper]

Hi Scott!

El 12/06/2015 14:17, "Scott Hazelhurst" <address@hidden> escribió:
>
>
> Dear Mailing List
>
> I am trying to install gnuhealth and have run into this problem where the client can’t seem to connect to the server — the triton client gives me the message “Could not connect to the server". I see others have had the same problem but I can’t see anything  to help me. Obviously, I’m missing something obvious, so please help me
>In my experience, this is due to the datavase user's settings in the trytond.conf file you are using.
The tryton client is trying to connect or create a database but the credentials given in the file are not appropriate.
Check is you have somethig of the sort "user:address@hidden" in the database connection part of the trytond.conf file. And make sure that when running Tryton server you are pointing to that file.
Hope it helps.

> Many thanks
>
> Scott
>Cecilia
>
>
> 1. We have install this on a machine running Ubuntu 15.04
> 2. At the  moment only in localhost mode — the server is running as the gnuhealth user, and the client is running as another user
> 3. In the postgres log file I see
>
> tail postgresql-9.4-main.log
>
> 2015-06-12 16:58:18 SAST [10670-1] address@hidden LOG:  could not receive data from client: Connection reset by peer
> 2015-06-12 17:06:03 SAST [11167-1] address@hidden LOG:  could not receive data from client: Connection reset by peer
> 2015-06-12 17:06:06 SAST [11174-1] address@hidden LOG:  could not receive data from client: Connection reset by peer
> 2015-06-12 17:06:57 SAST [11233-1] address@hidden LOG:  could not receive data from client: Connection reset by peer
> 2015-06-12 17:07:41 SAST [11289-1] address@hidden LOG:  could not receive data from client: Connection reset by peer
>
> 4. When I try to connect, the server prints out the following
>
>
> [Fri Jun 12 15:07:41 2015] INFO:database:connect to “template1"
>
>
> 5. My trytond.conf file says
>
> [database]
> uri = postgresql://localhost:5432
> path = /home/gnuhealth/attach
>
> [jsonrpc]
> listen = localhost:8000
>
> [session]
>
>
> 6.  My pg_hba.conf file presently says
>
> local   all             all                                     trust
> # IPv4 local connections:
> host    all             all             127.0.0.1/32            trust
> host    all             all             localhost            trust
>
>
>
> 7. As the gnuhealth user I can make psql connections
>
> address@hidden:~ $ createdb foo
> address@hidden:~ $ psql foo
> psql (9.4.2)
> Type "help" for help.
>
>
>
> 8. Running gnuhealth 2.8.1 and tryton 3.4.2
>
> Many thanks
>
> Scott
>
>
>
> <table width="100%" border="0" cellspacing="0" cellpadding="0" style="width:100%;">
> <tr>
> <td align="left" style="text-align:justify;"><font face="arial,sans-serif" size="1" color="#999999"><span style="font-size:11px;">This communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorised signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary. </span></font></td>
> </tr>
> </table