Hi Edgar, Am Dienstag, 27. April 2021, 11:34:28 CEST schrieb Edgar Hagenbichler:
> still I am working on the the translation issue, and I tried to make a > new database: [....] > as postgres@GNUHealth-Raspi4:/home/test: > > nano /var/lib/pgsql/data/pg_hba.conf postgres@GHInVBox:~> pwd /var/lib/pgsql postgres@GHInVBox:~> dir data insgesamt 60 drwx------ 1 postgres postgres 70 27. Apr 09:32 base -rw------- 1 postgres postgres 44 27. Apr 09:32 current_logfiles drwx------ 1 postgres postgres 668 27. Apr 09:36 global drwx------ 1 postgres postgres 512 27. Apr 09:32 log drwx------ 1 postgres postgres 0 22. Apr 13:16 pg_commit_ts drwx------ 1 postgres postgres 0 22. Apr 13:16 pg_dynshmem -rw------- 1 postgres postgres 4517 22. Apr 13:16 pg_hba.conf -rw------- 1 postgres postgres 1636 22. Apr 13:16 pg_ident.conf drwx------ 1 postgres postgres 76 27. Apr 12:10 pg_logical drwx------ 1 postgres postgres 28 22. Apr 13:16 pg_multixact drwx------ 1 postgres postgres 8 24. Apr 12:40 pg_notify drwx------ 1 postgres postgres 0 22. Apr 13:16 pg_replslot drwx------ 1 postgres postgres 0 22. Apr 13:16 pg_serial drwx------ 1 postgres postgres 0 22. Apr 13:16 pg_snapshots drwx------ 1 postgres postgres 0 24. Apr 12:40 pg_stat drwx------ 1 postgres postgres 162 27. Apr 12:11 pg_stat_tmp drwx------ 1 postgres postgres 8 22. Apr 13:16 pg_subtrans drwx------ 1 postgres postgres 0 22. Apr 13:16 pg_tblspc drwx------ 1 postgres postgres 0 22. Apr 13:16 pg_twophase -rw------- 1 postgres postgres 3 22. Apr 13:16 PG_VERSION drwx------ 1 postgres postgres 1180 27. Apr 09:39 pg_wal drwx------ 1 postgres postgres 8 22. Apr 13:16 pg_xact -rw------- 1 postgres postgres 88 22. Apr 13:16 postgresql.auto.conf -rw------- 1 postgres postgres 26717 22. Apr 13:16 postgresql.conf -rw------- 1 postgres postgres 62 24. Apr 12:40 postmaster.opts -rw------- 1 postgres postgres 100 24. Apr 12:40 postmaster.pid In my installation the file is where postgres expects it. Actually, if you have already GNU Health running on your machine, there is no need to touch this file unless you want to change the database access (e.g. set a user/password)! openSUSE-gnuhealth-setup should have performed the right settings at start! No need to touch it again! > output: "folder var/lib/pgsql/data/ does not exist!" > > searching for "pg_hba.conf*" with PCMan-FMQt: F3, in /, also subdirs > and hidden: writes at the bottom line: 11 objects, 20 hidden, needs then > 7 minutes to find 2 files pg_hba.conf.sample: one in > /usr/share/postgresql13 , the other in /usr/share/postgresql12 > > So that was the wrong way, and I skipped the rest. Ah, you have already a newer postgres version installed. Anyhow, the active version is automatically linked into /var/lib/pgsql update-alternatives --display postgresql tells you which postgres you are using > Then I tried to make the new database as described in your email from > 24.4.2021, 12:54 MESZ by Axel Braun: [...] > su tryton -s /bin/bash > > => Passwort: test > > => su: Fehler bei Authentifizierung => first back to root, then again > to > su tryton -s /bin/bash => works yes, i should have mentioned this - if you follow the flow in the documentation, you would have been loged in as user root. The GNU Heath server runs under the no-login user tryton, that gives a bit more security > trytond-admin -c /usr/bin/trytond.conf --all -d health38_V2 -v > > => OSError: Database "health38_V2.sqlite doesn't exist" The configuration is in /etc/tryton/trytond.conf > Then I gave up. > > Now I think: would it be possible to have a feature in the GNUHealth or > the Tryton-client, that would just make a new database via the client, > if I am already connected to a database? So that in fact it makes just a > copy of the current database, or uses the same template of the current > database, that was used during the first installation of that database? > I think, that would be great and would help a lot for laymen or simple > users as I am. That was a feature in earlier versions of Tryton, but was dropped as it was considered unsecure. I agree, that feature was nice and made life easy.... Cheers Axel
