Re: [Health-dev] Localization German - new database on Raspi4 GH3.8

[Axel Braun]

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