Database problem.. thinking

Posting log… have idea???

sudo nano /var/log/gvm/gvmd.log
GNU nano 5.4 /var/log/gvm/gvmd.log
md main:MESSAGE:2022-02-02 15h53.17 utc:18700: Greenbone Vulnerability Manager version 21.4.4 (DB revision 242)
md manage: INFO:2022-02-02 15h53.17 utc:18700: Creating user.
md manage:WARNING:2022-02-02 15h53.17 utc:18700: sql_exec_internal: PQexec failed: ERRORE: la relazione “public.meta” non esiste
LINE 1: SELECT value FROM public.meta WHERE name = 'database_version…
^
(7)
md manage:WARNING:2022-02-02 15h53.17 utc:18700: sql_exec_internal: SQL: SELECT value FROM public.meta WHERE name = ‘database_version’;
md manage:WARNING:2022-02-02 15h53.17 utc:18700: sql_x: sql_exec_internal failed
md manage:MESSAGE:2022-02-02 15h53.17 utc:18700: No SCAP database found
md manage:MESSAGE:2022-02-02 15h53.17 utc:18700: No CERT database found
md manage:WARNING:2022-02-02 15h53.17 utc:18700: sql_exec_internal: PQexec failed: ERRORE: caricamento della libreria “/usr/local/lib/libgvm-pg-server.so” fal>
(7)
md manage:WARNING:2022-02-02 15h53.17 utc:18700: sql_exec_internal: SQL: CREATE OR REPLACE FUNCTION hosts_contains (text, text) RETURNS boolean AS '/usr/local/>
md manage:WARNING:2022-02-02 15h53.17 utc:18700: sqlv: sql_exec_internal failed
md main:MESSAGE:2022-02-02 15h53.34 utc:18702: Greenbone Vulnerability Manager version 21.4.4 (DB revision 242)
md manage: INFO:2022-02-02 15h53.34 utc:18702: Creating user.
md manage:WARNING:2022-02-02 15h53.34 utc:18702: sql_exec_internal: PQexec failed: ERRORE: la relazione “public.meta” non esiste
LINE 1: SELECT value FROM public.meta WHERE name = 'database_version…
^
(7)
md manage:WARNING:2022-02-02 15h53.34 utc:18702: sql_exec_internal: SQL: SELECT value FROM public.meta WHERE name = ‘database_version’;
md manage:WARNING:2022-02-02 15h53.34 utc:18702: sql_x: sql_exec_internal failed
md manage:MESSAGE:2022-02-02 15h53.34 utc:18702: No SCAP database found
md manage:MESSAGE:2022-02-02 15h53.34 utc:18702: No CERT database found
md manage:WARNING:2022-02-02 15h53.34 utc:18702: sql_exec_internal: PQexec failed: ERRORE: caricamento della libreria “/usr/local/lib/libgvm-pg-server.so” fal>
(7)
md manage:WARNING:2022-02-02 15h53.34 utc:18702: sql_exec_internal: SQL: CREATE OR REPLACE FUNCTION hosts_contains (text, text) RETURNS boolean AS '/usr/local/>
md manage:WARNING:2022-02-02 15h53.34 utc:18702: sqlv: sql_exec_internal failed
md main:MESSAGE:2022-02-02 15h54.15 utc:18708: Greenbone Vulnerability Manager version 21.4.4 (DB revision 242)
md manage: INFO:2022-02-02 15h54.15 utc:18708: Getting users.
md manage:WARNING:2022-02-02 15h54.15 utc:18708: sql_exec_internal: PQexec failed: ERRORE: la relazione “public.meta” non esiste
LINE 1: SELECT value FROM public.meta WHERE name = 'database_version…
^
(7)
md manage:WARNING:2022-02-02 15h54.15 utc:18708: sql_exec_internal: SQL: SELECT value FROM public.meta WHERE name = ‘database_version’;

thx

Hello @Daniel770,

could you please more specify about the whole story - it happens after a GSA update or what was the previous state? Used Postgres version and used GSA version?

And yes, it is a DB issue.

Are you able to connect directly to Postgres? Did you try to repair the DB?

Seems to be many questions here :slight_smile:

I used Postgres 14 …for know gsa version?

It seems also that some parts of the posted logs have been stripped off and are also in Italian. Two suggestions:

  • Changing the language of the base OS to English to get error messages which can be used for an easier search on existing topics
  • Posting the full / non-stripped error messages
2 Likes

As @cfi suggests.

Anyway, you should be able to log in to Postgres and you should be able to verify the gvm user rights. You still do not sufficiently answer the basic information about your system. I suggest you read this article. It can help verify requirements and users’ rights.

https://greenbone.github.io/docs/gvm-21.04/index.html#

1 Like

i follow extaclty that guide but i install postgres14 not 11 problem ??
i try to post error log in english…