Re: [Health] GnuHealth cannot create database nor connect to server

[Bruno M. Villasanti]

Hi Antonio,

2015-02-04 16:32 GMT-03:00 Antonio Palacín Lasheras <address@hidden>:

Hello:

I hope somebody can help me. I am trying to install GnuHealth on my own server. I have Ubuntu 14.04 64 bits, 2 GB RAM and 100 GB space.

After following official documents for installing tryton and gnuhealth it seenms cannot connect to the server anyway and also cannot create any database.

This is the configuration of the trytond.conf

[database]

uri = postgresql://localhost:5432

Here you must add the user database you created `gnuhealth`, followed by the password [1]:

    uri = postgresql://user:address@hidden:5432/

Where `user` sets `gnuhealth`, and replace `password` that you set using the following procedure:

    $ sudo su - postgres

    $ psql -c "ALTER ROLE gnuhealth WITH ENCRYPTED PASSWORD 'YourPassword' ;"

As a result it should be as follows:​

    ​uri = postgresql://gnuhealth:address@hidden:5432/​

 

path = /home/gnuhealth/attach

[session]

You forgot run the script `serverpass.py` to set the password admin for Tryton.

In this case do not need to edit the file.

But logged as user `gnuhealth` just run:

​    $ python $HOME/gnuhealth/tryton/server/util/serverpass.py

Type the password and it will be included in `trytond.conf` automatically.

 

[jsonrpc]

listen=*:80

Here I think you should change 80, the default port 8000.

 

tryond daemon is running , here are the details:

~/gnuhealth/tryton/server/trytond-3.4.1/bin $ ./trytond

You must pass the location of the configuration file, which is stored in the environment variable `TRYTOND_CONFIG`:

    $ ./trytond -c $TRYTOND_CONFIG​

 

[Wed Feb 04 19:28:33 2015] INFO:trytond.server:using /home/gnuhealth/gnuhealth/tryton/server/config/trytond.conf as configuration file

[Wed Feb 04 19:28:33 2015] INFO:trytond.server:initialising distributed objects services

[Wed Feb 04 19:28:33 2015] INFO:trytond.server:starting JSON-RPC protocol on 0.0.0.0:8000

but whenever I try to connect to the server via the tryton client I have this message from server console:

[04/Feb/2015 19:30:23] code 400, message Bad HTTP/0.9 request type ('\x16\x03\x01\x02\x00\x01\x00\x01\xfc\x03\x03\x88\xceH\xec\x18\xac\xbaq\xd0\xd7#\xc3$I=\x9fKy\xf2')

[Wed Feb 04 19:30:23 2015] INFO:database:connect to "template1"

it seems there are communication between server and client but for some reason , connection cannot be made.

I hope anybody can give me some light:

thanks in advance

​Regards.​

​--

[1] http://trytond.readthedocs.org/en/3.4/topics/configuration.html#configuration-file-for-tryton​

--

Bruno M. Villasanti

thymbr@