Re: [Health] GNU HEALTH LIVE CD

[Luis Falcon]

On Wed, 26 Mar 2014 19:36:49 +0100
Axel Braun <address@hidden> wrote:

> Hi Luis,
> 
> Am Sonntag, 23. März 2014, 16:01:07 schrieb Luis Falcon:
> 
> [....]
>  
> > > (Means: No authorisation for Relation  ir_module_module)
> > 
> > Did you create the database and restore it with the "gnuhealth"
> > user, the one that runs the tryton server ?
> 
> Of course not ;-)

:)

> 
> > The gnuhealth user should have enough permissions at PG level.
> > 
> > 
> > gnuhealth $ createdb your_db_name --encoding=unicode
> > gnuhealth $ psql your_db_name < gnuhealth_demo24-mar23
> > 
> > gnuhealth $ cdexe
> > 
> > gnuhealth $ ./trytond
> > 
> > The name of the DB should not matter. Make sure that is the
> > *gnuhealth* user who boots the tryton server.
> 
> Standard-Postgres runs under system user postgres
> Tryton Server runs under system user tryton, both normally without
> login, just for security reasons.
> I know that gnuhealth takes a side path on this by running the system
> under a 'normal' user.
> 
> > Let us know how it went.
> 
> After some reading I cerated the roles gnuhealth and tryton, and
> granted gnuhealh role to tryton:
> 
> psql -c "CREATE USER gnuhealth WITH CREATEDB;"
> createdb gnuhealth24 --encoding='UTF8' –owner=gnuhealth
> psql gnuhealth24 < /mnt/gnuhealth_demo24-mar23
> 
> psql -c "ALTER DATABASE gnuhealth24 OWNER To tryton;"
> psql -c "GRANT gnuhealth TO tryton;“
> 
> That worked in my VM, I will put on the Live CD soon.

Thanks for the update and glad you got it working !

Best
> 
> Thanks
> Axel



-- 
Luis Falcon
GNU Health : The Free Health and Hospital Information System
http://health.gnu.org
@gnuhealth

signature.asc
Description: PGP signature