Gvmd postgresql issue in a LXC container

Building from Source and Advanced Topics
1

Hi, I’m trying to fix/create openrc scripts for Gentoo and I installed a gvm suite on a LXC container that does not use systemd.
I have a problem that I don’t think it is related to LXC, but I cannot understand where it comes from.
Th output in gvmd.log is the same both if I start the service with rc-service command and if I start the service manually.
I am using this command to start it:

sudo -u gvm /usr/bin/gvmd --foreground --osp-vt-update=/run/ospd/ospd-openvas.sock --listen=127.0.0.1 --port=9390 --scanner-host=/run/ospd/ospd-openvas.sock --gnutls-priorities=SECURE256:+SUITEB192:+SECURE192:+SECURE128:+SUITEB128:-MD5:-SHA1:-VERS-TLS1.0:-VERS-TLS1.1:-VERS-SSL3.0

The logs registered are:
md main:MESSAGE:2023-10-01 10h12.01 utc:17629: Greenbone Vulnerability Manager version 22.9.0 (DB revision 255)
md manage:WARNING:2023-10-01 10h12.01 utc:17629: sql_exec_internal: PQexec failed: ERROR: relation “public.meta” does not exist
LINE 1: SELECT value FROM public.meta WHERE name = 'database_version…
^
(7)
md manage:WARNING:2023-10-01 10h12.01 utc:17629: sql_exec_internal: SQL: SELECT value FROM public.meta WHERE name = ‘database_version’;
md manage:WARNING:2023-10-01 10h12.01 utc:17629: sql_x: sql_exec_internal failed
md manage:MESSAGE:2023-10-01 10h12.01 utc:17629: No SCAP database found
md manage:MESSAGE:2023-10-01 10h12.01 utc:17629: No CERT database found
md manage:WARNING:2023-10-01 10h12.01 utc:17629: sql_exec_internal: PQexec failed: ERROR: permission denied for schema public
(7)
md manage:WARNING:2023-10-01 10h12.01 utc:17629: sql_exec_internal: SQL: CREATE OR REPLACE FUNCTION level_max_severity (lvl text, cls text)RETURNS double precision AS $$DECLARE v double precision;BEGIN CASE WHEN lower (lvl) = ‘log’ THEN v := 0.0; WHEN lower (lvl) = ‘false positive’ THEN v := -1.0; WHEN lower (lvl) = ‘error’ THEN v := -3.0; ELSE CASE WHEN lower (lvl) = ‘high’ THEN v := 10.0; WHEN lower (lvl) = ‘medium’ THEN v := 6.9; WHEN lower (lvl) = ‘low’ THEN v := 3.9; ELSE v := -98.0; END CASE; END CASE; return v;END;$$ LANGUAGE plpgsql;
md manage:WARNING:2023-10-01 10h12.01 utc:17629: sqlv: sql_exec_internal failed

postgresql is v. 15 and I run
grant ALL on SCHEMA public TO gvm;
with user postgres on psql

2

Gentoo does ship OpenRC Scritps with PSQL, so that is NOT your issue.
IMHO you just did not initialized the database correctly :wink:

3

postgresql-15 starts regularly.
To make a check I deleted the data dir and reinitialized it, but the problem on starting gvmd is the same and it is still there.

4

I didn’t grant the gvm user permission to modify the public schema of the gvmd database.

…
You are now connected to database “gvmd” as user “postgres”.
gvmd=# grant ALL on SCHEMA public TO gvm;
GRANT
gvmd=# \q

1 Like