Re: [Health] installation problem on unix

[Luis Falcon]

Hi Dirk !

On Mon, 4 Sep 2017 23:32:25 +0200

> postgresql:/// connects over a UNIX socket and can use the Unix
> userid to authenticate.
> 
> postgresql://host:port/ connects over TCP, where the userid of the 
> remote end is not known (or cannot be trusted).
> 
> It's a bit of a simplification to say pg_hba.conf doesn't matter: you 
> need to allow Unix domain socket connections in that config file if
> you want paswordless logins. It's just that the default settings
> already allow that.
> 
>
> see => uri = postgresql:///localhost:5432

Thanks for the update! Yeah, it's a bit tricky, and different Operating
Systems / distros come with different default pg_hba.conf files.

[...]
 
> address@hidden:/export/home/gnuhealth/gnuhealth/tryton/server/trytond-4.2.6/bin
>  
> $ ./trytond-admin -c 
> /export/home/gnuhealth/gnuhealth/tryton/server/config/trytond.conf -d 
> vic --all -v -p
> Admin Password Confirmation:
> 
> Now everything works cool :)
> 
> 
> So GNUHEALTH is running on OmniOSCE server and tryton-client on a
> debian with remote connection over lan
> 

Wonderful ! Congratulations !!

> 
> 
> Next thing to do is installing the NGINX config and encrypt
> everything with Let's encrypt and giving you the install
> documentation like promised so some little patient please I'm having
> a busy weeks on my work ...
> 

Great ! Thanks a lot . Documentation is key :)
> 
> 
> Ps => GNUHealth zone is using 315 MB on Memory
> 
> GNUHealth  0.00 0.00%     -     - 315M 0.42% 99.8%  381M 0.49%     -
> 

>   and use 2,36 GB  on disk => full OS + postgress => ok without any
> data just installed it from scratch
> 
> DATA/Zones2/GNUHealth 2,36G   741G    24K  /Zones2/GNUHealth

Nice ! It is indeed a quite small footprint in memory and disk (disk
space will grow though :-) ).

Actually I was about to tell you that it would be nice to have some
specs on GNU Health running on OmniOSCE. We should come up with some
benchmark tools for GNU Health to test different components and
scenarios.

> Keep you posting with all the documentation after the NGINX setup ...
> 
> Thanks again Luis you're a very great man very much appreciations !!!
> 
Thanks to you, Dirk, for all the work and very valuable feedback.
Welcome again to the GNU Health community !

All the best,
Luis

> Kind Regards,
> 
> Dirk
> 
> 
> On 04-09-17 20:16, Luis Falcon wrote:
> > Hi Dirk !
> >
> > On Mon, 4 Sep 2017 16:09:48 +0200
> > Dirk Willems <address@hidden> wrote:
> >  
> >> Hello Luis,
> >>
> >>
> >> Installed the gtar and now is working fine, server is listen on
> >> *:8000 :)
> >>  
> > Excellent news ! :)
> >  
> >> Database is created but when running the trytond-admin it goes
> >> wrong ...
> >>
> >> address@hidden:/export/home/gnuhealth/gnuhealth/tryton/server/trytond-4.2.6/bin
> >> $ ./trytond-admin --all --database=vic
> >>
> >>
> >> Any suggestions what I miss or can I created the database
> >> completely manually ?
> >>
> >> Thanks in advance.
> >>  
> > Use the "trust" method to connect to the DB. Check the following
> >
> > https://en.wikibooks.org/wiki/GNU_Health/Installation#Verify_PostgreSQL_authentication_method
> >
> > And restart postgresql server.
> >
> > Let us know how it went... you're almost there ! :)
> >
> > Bests,
> > Luis
> >  
>