Re: [Health] GNU HEALTH LIVE CD

[Axel Braun]

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
Axel

signature.asc
Description: This is a digitally signed message part.