Re: [Health] Creating the GNU Health database

[Roberto Novaes]

> I have installed GNU Health, on Ubumtu 14.04 LTS following all steps and
> requirements in https://en.wikibooks.org/wiki/GNU_Health/Installation but I
> didn't succeed yet. I have the Tryton Client installed on the same machine
> but in another user. My pg_hba.conf is set as follows:
>
> local   all             all                                     trust
>
> host    all             all             127.0.0.1/32            trust
>
> My trytond.conf is set as follows:
> [database]
> uri = postgresql://localhost:5432
> path = /home/gnuhealth/attach
>
> [session]
> super_pwd = M0thnfkds987
>
> [jsonrpc]
> listen: *:8000
>
> The error I have recieved is:
> 3405 140594225813248 [2016-04-24 15:52:10,305] ERROR
> trytond.protocols.dispatcher CREATE DB: gnuhealth failed Traceback (most
> recent call last): File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/protocols/dispatcher.py",
> line 229, in create pool.init(update=['res', 'ir'], lang=[lang]) File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/pool.py",
> line 144, in init self.start() File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/pool.py",
> line 97, in start register_classes() File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/modules/__init__.py",
> line 319, in register_classes import trytond.ir File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/ir/__init__.py",
> line 4, in <module> from .configuration import * File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/ir/configuration.py",
> line 3, in <module> from ..model import ModelSQL, ModelSingleton, fields
> File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/model/__init__.py",
> line 3, in <module> from .model import Model File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/model/model.py",
> line 9, in <module> from trytond.model import fields File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/model/fields/__init__.py",
> line 4, in <module> from .field import * File
> "/home/gnuhealth/gnuhealth/tryton/server/trytond-3.8.5/trytond/model/fields/field.py",
> line 7, in <module> from sql import operators, Column, Literal, Select,
> CombiningQuery, Null ImportError: cannot import name Null
>

It appears that all of your settings are correct. But you have not
installed one of the dependencies: python-sql.

You can install it with pip install python-sql

Hope it helps,

Roberto Novaes
www.silexsistemas.com.br