[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


From: Axel Braun
Subject: Re: [Health] GNU HEALTH LIVE CD
Date: Wed, 26 Mar 2014 19:36:49 +0100
User-agent: KMail/4.11.5 (Linux/3.11.10-7-desktop; KDE/4.11.5; x86_64; ; )

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.


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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]