[stork-users] Stork server startup on Ubuntu 22

[Slawek Figiel]

Hello Ben!

I confirm the problem. When you run the Stork server as the SystemD 
service, the default system user is `stork-server`, and the default 
database user is always `stork`. If the `peer` authentication method is 
used to authorize users in the database, it causes the described problem.
I have opened https://gitlab.isc.org/isc-projects/stork/-/issues/1203 to 
address the problem.

Regards,
Slawek Figiel

On 16/10/2023 19:38, Ben Bridges wrote:
> Hi,
> 
> I installed Stork Server 1.13.0 on Ubuntu 22.04.03 per the instructions 
> in the Stork 1.13.0 ARM.  When I tried to start the stork server (using 
> systemctl), it would not connect to the database.  Postgres logged 
> messages “stork at stork LOG: provided user name (stork) and authenticated 
> user name (stork-server) do not match” and “Peer authentication failed 
> for user "stork" and indicated that stork server was trying to make a 
> local (i.e. Unix socket) connection to the database.  I changed the 
> stork server.env file to explicitly configure the postgres host and port 
> (localhost and 5432), and stork server then successfully connected to 
> the database.  It appears that by default stork server tries to make a 
> Unix socket connection to the database even though the ARM says the 
> default STORK_DATABASE_HOST is localhost and the default 
> STORK_DATABASE_PORT is 5432.  Just thought I’d mention it in case 
> something has changed in stork server and the documentation has not been 
> updated.  This behavior has changed from Stork 1.9.0.
> 
> .Ben Bridges.
> 
>