Failed to start Greenbone Vulnerability Manager daemon (gvmd)

Building from Source and Advanced Topics
1

Hello,

I followed the instructions to install Greenbone on a Ubuntu 22.04 Server (using this link : Building 22.4 from Source - Greenbone Community Documentation)

Everything went almost well, all services are running except the gvmd service which failed to start.

Here are the errors I have in my gvmd.log :

 (7)
md manage:WARNING:2023-09-28 12h04.28 utc:1823798: sql_exec_internal: SQL: SELECT value FROM public.meta WHERE name = 'database_version';
md manage:WARNING:2023-09-28 12h04.28 utc:1823798: sql_x: sql_exec_internal failed
md manage:MESSAGE:2023-09-28 12h04.28 utc:1823798: No SCAP database found
md manage:MESSAGE:2023-09-28 12h04.28 utc:1823798: No CERT database found
md manage:WARNING:2023-09-28 12h04.28 utc:1823798: sql_exec_internal: PQexec failed: ERROR:  syntax error in file "/usr/share/postgresql/
 (7)
md manage:WARNING:2023-09-28 12h04.28 utc:1823798: sql_exec_internal: SQL: SELECT count(*) FROM pg_available_extensions WHERE name = 'uui
md manage:WARNING:2023-09-28 12h04.28 utc:1823798: sql_x: sql_exec_internal failed
md   main:MESSAGE:2023-09-28 12h04.28 utc:1823800:    Greenbone Vulnerability Manager version 22.9.0 (DB revision 255)
md manage:WARNING:2023-09-28 12h04.28 utc:1823800: sql_exec_internal: PQexec failed: ERROR:  relation "public.meta" does not exist
LINE 1: SELECT value FROM public.meta WHERE name = 'database_version...

I’m using postgresql14 => Mayve that’s the problem ?

Also here’s some piece of information about my database :

 List of databases
   Name    |  Owner   | Encoding | Collate |  Ctype  | ICU Locale | Locale Provider |   Access privileges
-----------+----------+----------+---------+---------+------------+-----------------+-----------------------
 gvmd      | gvm      | UTF8     | C.UTF-8 | C.UTF-8 |            | libc            |
 postgres  | postgres | UTF8     | C.UTF-8 | C.UTF-8 |            | libc            |
 template0 | postgres | UTF8     | C.UTF-8 | C.UTF-8 |            | libc            | =c/postgres          +
           |          |          |         |         |            |                 | postgres=CTc/postgres
 template1 | postgres | UTF8     | C.UTF-8 | C.UTF-8 |            | libc            | =c/postgres          +
           |          |          |         |         |            |                 | postgres=CTc/postgres


                                   List of roles
 Role name |                         Attributes                         | Member of
-----------+------------------------------------------------------------+-----------
 _gvm      |                                                            | {dba}
 dba       | Superuser, No inheritance, Cannot login                    | {}
 gvm       | Create role, Create DB                                     | {dba}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

Any idea of what can be wrong ?

I guess that you would need more information to solve this out but I’m not sure of what kind of information could be relevant, so don’t hesistate to advice me.

Thanks.

2

It works now.
I disabled my cluster 14, reinstalled properly postgresql15, created my new 15 cluster and I did again all the steps regarding postgresql from the documentation and it works.

Hope these instructions can help anyone else !

2 Likes
3

Welcome @nekzzz :slight_smile: I’m glad you figured it out and and posted the solution to help other people.

1 Like