Gvmd 23.8.0 - can't create admin user

Building from Source and Advanced Topics
1

I am trying to create admin user on gvmd 23.8.0 but nothing happens. I am running Ubuntu 22.04.

from gvmd.log

md   main:MESSAGE:2024-07-24 19h19.06 utc:6608:    Greenbone Vulnerability Manager version 23.8.0 (DB revision 256)
md manage:   INFO:2024-07-24 19h19.06 utc:6608:    Creating user.
md manage:WARNING:2024-07-24 19h19.06 utc:6608: sql_open: PQconnectPoll failed
md manage:WARNING:2024-07-24 19h19.06 utc:6608: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  role "root" does not exist
md manage:WARNING:2024-07-24 19h19.06 utc:6608: init_manage_open_db: sql_open failed
md manage:WARNING:2024-07-24 19h19.12 utc:6610: osp_scanner_feed_version: failed to connect to /run/ospd/ospd-openvas.sock

I never told anywhere in the configuration to use role root as role dba is created per installation guide.

2

Your database is broken, not running etc … please check your file socket first.

3

No, all good there. Socket is there

Followed guide exactly as it says…

sudo -u postgres bash
cd
createuser -DRS gvm
createdb -O gvm gvmd
psql gvmd -c "create role dba with superuser noinherit; grant dba to gvm;"
exit

And here is proof

root@openvas:~# psql
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  role "root" does not exist
root@openvas:~# su postgres
postgres@openvas:/root$ psql
psql (16.3 (Ubuntu 16.3-0ubuntu0.24.04.1))

So the question would be who told gvmd to use root user to connect to database when dba role is created for user gvm and where.

One more thing to add, running pgsql 16 instead 15.

4

Well LOL…

 sudo -u gvm /usr/local/sbin/gvmd --create-user=admin

That did the trick.