Unable to update SCAP and CERT feed

Use this category only if you have build GVM from sources or if you use packages provided by a 3rdparty repository.

Please read About the Greenbone Source Edition (GSE) and About GVM Architecture before posting.

When posting you should provide information about your environment using the following template:

GVM versions

**gsad: Greenbone Security Assistant 9.0.1(‘gsad --version’)
**gvmd:Greenbone Vulnerability Manager 9.0.1 Manager DB revision 221 (‘gvmd --version’)
**openvas-scanner: OpenVAS 7.0.1 (‘openvas --version’, in older GVM versions < 11: ‘openvassd --version’)
**gvm-libs:gvm-libs 11.0.1

Environment

**Operating system:Kali Linux
**Kernel:Linux kali 5.9.0-kali2-amd64 #1 SMP Debian 5.9.6-1kali1 (2020-11-11) x86_64 GNU/Linux (‘uname -a’)
Installation method / source:

md main:MESSAGE:2020-11-25 00h31.35 utc:1067: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage:WARNING:2020-11-25 00h31.35 utc:1068: sql_open: PQconnectPoll failed
md manage:WARNING:2020-11-25 00h31.35 utc:1068: sql_open: PQerrorMessage (conn): FATAL: role “_gvm” does not exist
md manage:WARNING:2020-11-25 00h31.35 utc:1068: init_manage_process: sql_open failed
md main:MESSAGE:2020-11-25 00h33.55 utc:1096: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage:WARNING:2020-11-25 00h33.55 utc:1099: sql_open: PQconnectPoll failed
md manage:WARNING:2020-11-25 00h33.55 utc:1099: sql_open: PQerrorMessage (conn): FATAL: role “_gvm” does not exist
md manage:WARNING:2020-11-25 00h33.55 utc:1099: init_manage_process: sql_open failed
md main:MESSAGE:2020-11-25 01h01.11 utc:1271: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage:WARNING:2020-11-25 01h01.11 utc:1273: sql_open: PQconnectPoll failed
md manage:WARNING:2020-11-25 01h01.11 utc:1273: sql_open: PQerrorMessage (conn): FATAL: role “_gvm” does not exist
md manage:WARNING:2020-11-25 01h01.11 utc:1273: init_manage_process: sql_open failed
md main:MESSAGE:2020-11-25 01h12.15 utc:1461: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage:WARNING:2020-11-25 01h12.15 utc:1464: sql_open: PQconnectPoll failed
md manage:WARNING:2020-11-25 01h12.15 utc:1464: sql_open: PQerrorMessage (conn): FATAL: role “_gvm” does not exist
md manage:WARNING:2020-11-25 01h12.15 utc:1464: init_manage_process: sql_open failed
md main:MESSAGE:2020-11-30 04h22.55 utc:1025: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage:WARNING:2020-11-30 04h22.55 utc:1026: sql_open: PQconnectPoll failed
md manage:WARNING:2020-11-30 04h22.55 utc:1026: sql_open: PQerrorMessage (conn): FATAL: role “_gvm” does not exist
md manage:WARNING:2020-11-30 04h22.55 utc:1026: init_manage_process: sql_open failed
md main:MESSAGE:2020-11-30 05h16.52 utc:1569: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage: INFO:2020-11-30 05h16.52 utc:1569: Getting users.
md manage:WARNING:2020-11-30 05h16.52 utc:1569: 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:2020-11-30 05h16.52 utc:1569: sql_exec_internal: SQL: SELECT value FROM public.meta WHERE name = ‘database_version’;
md manage:WARNING:2020-11-30 05h16.52 utc:1569: sql_x_internal: sql_exec_internal failed
md manage:WARNING:2020-11-30 05h16.52 utc:1569: database must be initialised from scanner
md manage:MESSAGE:2020-11-30 05h16.52 utc:1569: No SCAP database found
md manage:MESSAGE:2020-11-30 05h16.52 utc:1569: No CERT database found
md main:MESSAGE:2020-11-30 05h16.56 utc:1574: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage: INFO:2020-11-30 05h16.56 utc:1574: Creating user.
md manage:WARNING:2020-11-30 05h16.56 utc:1574: database must be initialised from scanner
md manage:MESSAGE:2020-11-30 05h16.56 utc:1574: No SCAP database found
md manage:MESSAGE:2020-11-30 05h16.56 utc:1574: No CERT database found
md main:MESSAGE:2020-11-30 05h17.11 utc:1609: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage: INFO:2020-11-30 05h17.11 utc:1609: Getting scanners.
md manage:WARNING:2020-11-30 05h17.12 utc:1609: database must be initialised from scanner
md manage:MESSAGE:2020-11-30 05h17.12 utc:1609: No SCAP database found
md manage:MESSAGE:2020-11-30 05h17.12 utc:1609: No CERT database found
md main:MESSAGE:2020-11-30 05h17.12 utc:1613: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage: INFO:2020-11-30 05h17.12 utc:1613: Modifying scanner.
md manage:WARNING:2020-11-30 05h17.12 utc:1613: database must be initialised from scanner
md manage:MESSAGE:2020-11-30 05h17.12 utc:1613: No SCAP database found
md manage:MESSAGE:2020-11-30 05h17.12 utc:1613: No CERT database found
md main:MESSAGE:2020-11-30 05h36.23 utc:1733: Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage:WARNING:2020-11-30 05h36.23 utc:1737: database must be initialised from scanner
– VISUAL – 4 30,71 Top

Your database is not correct setup, please read the error message it´s printed in plain.
You need to create the databases first, no tables no user …

1 Like