Hello Edgar, looks like you had a hard time....
Am Samstag, 24. April 2021, 11:20:52 CEST schrieb Edgar Hagenbichler: > Am 23.04.2021 um 15:44 schrieb Axel Braun: > >> As test@GNUHealth-Raspi4 I want now to create a new database as Luis > >> suggests: with > >> > >> createdb health38 > >> > >> then I got "could not connect to template1: FATAL: role "test" does not > >> exist". > > > > you need to use the right user, who has a role in postgres. This is either > > the user postgres, or the user tryton, see: > > https://en.opensuse.org/GNUHealth_on_openSUSE#Quick_Start > > Now I changed first to user root (su root), then cd /tmp, then su > postgres, then "createdb health38". No error so far. Yes, that works, but the database has the owner 'postgres' now. As it is empty you can savely run dropdb health38 and afterwards createdb health38 --encoding='UTF-8' --owner=tryton > Then cdexe," python3 .trytond-admin --all database=health38" (like > described in > https://en.wikibooks.org/wiki/GNU_Health/Installation#Initialize_the_databas > e_instance). cdexe is not needed when sing GNU Halth from packages, as trytond-admin is installed in /usr/bin (run cnf trytond-admin to find out in which package and in which path it is) > ==> python3: cant´t open file 'trytond-admin': [Errno 2] No such > file > > Searching for the file: is within usr/bin > > changing to this directory, executing the command again: no such file ... > > trying again with python3 trytond-admin --all database=health38 > > => File > "usr/lib/python3.6/site-packages/trytond/backend/sqlite/database.py" > line 265, in connect raise IOError ('Database "%s" does not exist! % > db_filename) OSError: Database "health38.sqlite" does not exist!" As described in https://en.opensuse.org/GNUHealth_on_openSUSE#Setup_more_in_detail you need to tell trytond-admin where the configuration file is (as long as you have not set it in the shell environment, see Luis' mail from last days) So, a proper call would be su tryton -s /bin/bash trytond-admin -c /etc/tryton/trytond.conf --all -d health38 -v (the -v is not required, but gives you some entertainment while the database is initialized) > Searching for health38* in trytond+subdirectories => no files > > Searching for ghdemo38* (that is the database which connects at > localhost) in root+subdirectories, also hidden files => no files > > Any ideas? Where can I find the database file itself? somehwere under /var/lib/pgsql - the standard path of a postgres database (but you dont really want do do anything in there) HTH Axel
