Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)

kaushalshriyan · August 9, 2020, 6:07pm

Hi,

I am running Greenbone Vulnerability Manager on Kali GNU/Linux 2020.3

PRETTY_NAME=“Kali GNU/Linux Rolling”
NAME=“Kali GNU/Linux”
ID=kali
VERSION=“2020.3”
VERSION_ID=“2020.3”
VERSION_CODENAME=“kali-rolling”
ID_LIKE=debian
ANSI_COLOR=“1;31”

systemctl restart gvmd.service
Job for gvmd.service failed because a timeout was exceeded.
See "systemctl status gvmd.service" and "journalctl -xe" for details.

cat /var/log/gvm/gvmd.log
md   main:MESSAGE:2020-08-09 17h56.09 utc:22177:    Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage:WARNING:2020-08-09 17h56.09 utc:22178: manage_create_sql_functions: PostgreSQL extension uuid-ossp required
md manage:WARNING:2020-08-09 17h56.09 utc:22178: init_manage_process: failed to create functions
md   main:MESSAGE:2020-08-09 17h59.42 utc:22267:    Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage:WARNING:2020-08-09 17h59.42 utc:22268: manage_create_sql_functions: PostgreSQL extension uuid-ossp required
md manage:WARNING:2020-08-09 17h59.42 utc:22268: init_manage_process: failed to create functions

Any help will be highly appreciated. I look forward to hearing from you.

Best Regards,

Kaushal

cfi · August 10, 2020, 5:31am

The message is telling you that your setup is lacking the uuid-ossp PostgreSQL extension which is required as shown in the install manual below.

Please contact the Kali package maintainer about this issue if the packages doesn’t provide / use this extension.

github.com

greenbone/gvmd/blob/v9.0.1/INSTALL.md#configure-postgresql-database-backend

# INSTALLATION INSTRUCTIONS FOR GREENBONE VULNERABILITY MANAGER

Please note: The reference system used by most of the developers is Debian
GNU/Linux 'Stretch' 9. The build might fail on any other system. Also, it is
necessary to install dependent development packages.

IMPORTANT NOTICE: This version changes quite a number of locations
and names compared to the previous version. It is highly recommended to
consider the section "Migrating to Version 8.0", unless you do not have
an old setup on your system.


## Prerequisites for Greenbone Vulnerability Manager

Prerequisites:
* cmake >= 3.0
* glib-2.0 >= 2.42
* gnutls >= 3.2.15
* libgvm_base, libgvm_util, libgvm_osp, libgvm_gmp >= 11.0.0
* PostgreSQL database >= 9.6

This file has been truncated. show original

mcrabb · August 10, 2020, 8:54am

Hi Kaushal

I think I received the same messge installing GVM on Kali check the version of postgresql your running psql --version I did a fresh install and had mutilple different versions running I removed all execpt 12.2.

Thanks

Matt

kaushalshriyan · August 10, 2020, 11:38pm

@cfi Thanks for the reply.

I am referring to https://github.com/greenbone/gvmd/blob/v9.0.1/INSTALL.md#configure-postgresql-database-backend

systemctl restart gvmd.service
Job for gvmd.service failed because a timeout was exceeded.
See "systemctl status gvmd.service" and "journalctl -xe" for details.

systemctl status gvmd.service
● gvmd.service - Open Vulnerability Assessment System Manager Daemon
     Loaded: loaded (/lib/systemd/system/gvmd.service; enabled; vendor preset: disabled)
     Active: failed (Result: timeout) since Tue 2020-08-11 04:51:24 IST; 3min 40s ago
       Docs: man:gvmd(8)
             https://www.greenbone.net
    Process: 41904 ExecStart=/usr/sbin/gvmd --osp-vt-update=/run/ospd/ospd.sock (code=exited, status=0/SUCCESS)

Aug 11 04:49:54 kalilinux systemd[1]: Starting Open Vulnerability Assessment System Manager Daemon...
Aug 11 04:49:54 kalilinux systemd[1]: gvmd.service: Can't open PID file /run/gvm/gvmd.pid (yet?) after start: Operation not permitted
Aug 11 04:51:24 kalilinux systemd[1]: gvmd.service: start operation timed out. Terminating.
Aug 11 04:51:24 kalilinux systemd[1]: gvmd.service: Failed with result 'timeout'.
Aug 11 04:51:24 kalilinux systemd[1]: Failed to start Open Vulnerability Assessment System Manager Daemon.


cat /var/log/gvm/gvmd.log
md   main:MESSAGE:2020-08-10 23h19.54 utc:41904:    Greenbone Vulnerability Manager version 9.0.1 (DB revision 221)
md manage:WARNING:2020-08-10 23h19.54 utc:41905: sql_exec_internal: PQexec failed: ERROR:  permission denied to set role "dba"
 (7)
md manage:WARNING:2020-08-10 23h19.54 utc:41905: sql_exec_internal: SQL: SET role dba;
md manage:WARNING:2020-08-10 23h19.54 utc:41905: sqlv: sql_exec_internal failed 


sudo -u postgres bash
createuser -DRS vaptadmin
createdb -O vaptadmin gvmd


gvmd=# create role dba with superuser noinherit;
gvmd=# grant dba to vaptadmin;
gvmd=# create extension "uuid-ossp";


#sudo -u postgres bash
psql gvmd
create extension "uuid-ossp";


1. Make Postgres aware of the gvm libraries if not installed in a ld-aware directory. For example create file  `/etc/ld.so.conf.d/gvm.conf`  with appropriate path and then run  `ldconfig` .

psql gvmd

psql --version
psql (PostgreSQL) 12.3 (Debian 12.3-1+b1)

Any help will be highly appreciated. I look forward to hearing from you.

Best Regards,

Kaushal

cfi · August 11, 2020, 6:36am

Please have a look at the documentation of the Kali packages how the setup should look like in that environment (e.g. which user Kali is runnig GVM as etc.).