Scan configs missing

rippledj · February 26, 2024, 8:35am

Can you make sure that PostgreSQL is running on port 5432? Otherwise, it’s hard to parse the logs you posted since they seem vary according to time they were issued.

gsad  gmp:MESSAGE:2024-02-20 13h47.42 GMT:71613: Authentication success for 'admin' from 127.0.0.1

Seems, you can connect to PostgreSQL, yet you have no corresponding logs from gvmd from the same time.

md   main:MESSAGE:2024-02-20 00h01.20 utc:485010:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-20 00h01.20 utc:485011: sql_open: PQconnectStart to 'gvmd' failed: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
        Is the server running locally and accepting connections on that socket?

This indicates gvmd can’t connect to PostgresSQL.

Nathanexact · February 26, 2024, 9:04am

How would I fix that?

rippledj · February 26, 2024, 9:09am

Since this is an issue with PostgreSQL, not Greenbone you need to look for support from the PostgreSQL documentation online.

Nathanexact · February 26, 2024, 9:10am

Ok Thanks.

Nathanexact · February 26, 2024, 9:38am

I have ran the following command.

sudo netstat -nlp | grep 5432
[sudo] password for kali: 
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      3369/postgres       
tcp6       0      0 ::1:5432                :::*                    LISTEN      3369/postgres       
unix  2      [ ACC ]     STREAM     LISTENING     36811    3369/postgres        /var/run/postgresql/.s.PGSQL.5432

Would this indicate that postgres is listening on that correct port?

Also looked in the postgres.conf file and it looks correct

#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

#listen_addresses = 'localhost'		# what IP address(es) to listen on;
					# comma-separated list of addresses;
					# defaults to 'localhost'; use '*' for all
					# (change requires restart)
port = 5432				# (change requires restart)

Nathanexact · February 26, 2024, 10:24am

Aslo seem to be able to connect to postgreSQL if I use the following command.

sudo -u _gvm psql gvmd
[sudo] password for kali: 
psql (16.1 (Debian 16.1-1+b1))
Type "help" for help.

Nathanexact · February 26, 2024, 11:10am

Looking at “sudo zcat /var/log/gvm/gvmd.log.2.gz”
I ran the command again and get this.

md   main:MESSAGE:2024-02-20 13h33.50 utc:77879:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:   INFO:2024-02-20 13h33.50 utc:77879:    Modifying user password.
md manage:WARNING:2024-02-20 13h33.50 utc:77879: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-20 13h33.50 utc:77879: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  role "root" does not exist
md manage:WARNING:2024-02-20 13h33.50 utc:77879: init_manage_open_db: sql_open failed
md manage:   INFO:2024-02-20 13h34.03 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2019.xml
md manage:   INFO:2024-02-20 13h35.27 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2010.xml
md    gmp:WARNING:2024-02-20 13h35.44 utc:79235: Authentication failure for 'admin' from unix_socket
md manage:   INFO:2024-02-20 13h35.45 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2021.xml
md    gmp:WARNING:2024-02-20 13h36.01 utc:79381: Authentication failure for 'admin' from unix_socket
md manage:   INFO:2024-02-20 13h37.03 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2016.xml
md manage:   INFO:2024-02-20 13h37.27 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2004.xml
md manage:   INFO:2024-02-20 13h37.36 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2023.xml
md manage:   INFO:2024-02-20 13h38.52 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2013.xml
md manage:   INFO:2024-02-20 13h39.12 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2014.xml
md manage:   INFO:2024-02-20 13h39.31 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2018.xml
md manage:   INFO:2024-02-20 13h40.38 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2008.xml
md manage:   INFO:2024-02-20 13h41.00 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2011.xml
md manage:   INFO:2024-02-20 13h41.19 UTC:71519: Updating /var/lib/gvm/scap-data/nvdcve-2.0-2020.xml
md   main:MESSAGE:2024-02-20 13h41.43 utc:82476:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:   INFO:2024-02-20 13h41.43 utc:82476:    Modifying user password.
md manage:MESSAGE:2024-02-20 13h41.43 utc:82476: No SCAP database found
md manage:   INFO:2024-02-20 13h42.28 UTC:71519: Updating CVSS scores and CVE counts for CPEs
md manage:   INFO:2024-02-20 13h47.02 UTC:71519: Updating placeholder CPEs
md manage:   INFO:2024-02-20 13h47.25 UTC:71519: Updating Max CVSS for DFN-CERT
md manage:   INFO:2024-02-20 13h47.34 UTC:71519: Updating DFN-CERT CVSS max succeeded.
md manage:   INFO:2024-02-20 13h47.34 UTC:71519: Updating Max CVSS for CERT-Bund
md manage:   INFO:2024-02-20 13h47.38 UTC:71519: Updating CERT-Bund CVSS max succeeded.
md manage:   INFO:2024-02-20 13h47.41 UTC:71519: update_scap_end: Updating SCAP info succeeded
event target:MESSAGE:2024-02-20 13h49.38 UTC:87181: Target could not be created by admin
event wizard:MESSAGE:2024-02-20 13h49.38 UTC:87181: Wizard quick_first_scan could not be run by admin
event target:MESSAGE:2024-02-20 13h50.07 UTC:87451: Target could not be created by admin
event wizard:MESSAGE:2024-02-20 13h50.07 UTC:87451: Wizard quick_first_scan could not be run by admin
event target:MESSAGE:2024-02-20 13h50.22 UTC:87609: Target could not be created by admin
event wizard:MESSAGE:2024-02-20 13h50.22 UTC:87609: Wizard quick_first_scan could not be run by admin
event target:MESSAGE:2024-02-20 13h51.34 UTC:88313: Target could not be created by admin
event wizard:MESSAGE:2024-02-20 13h51.34 UTC:88313: Wizard quick_task could not be run by admin
event port_list:MESSAGE:2024-02-20 14h22.05 UTC:105405: Port List All TCP and UDP (624beaf3-d149-4c77-82c1-87d9377fda2e) has been created by admin
event target:MESSAGE:2024-02-20 14h35.00 UTC:112639: Target  (58dc3c74-48b0-43e0-bd47-3126605b770a) has been created by admin
event task:MESSAGE:2024-02-20 14h36.00 UTC:113245: Status of task  (d582c987-4b4c-43bf-8abf-0cadc86399c0) has changed to New
event config:MESSAGE:2024-02-20 14h38.52 UTC:114856: Config could not be created by admin
event config:MESSAGE:2024-02-20 14h39.02 UTC:114953: Config could not be created by admin
md    gmp:WARNING:2024-02-20 15h08.50 utc:130781: Authentication failure for 'Admin' from unix_socket

Can anyone help with this? Looking at the last line “Authentication failure for ‘Admin’ from unix_socket”
Would this mean my Admin user doesn’t have the correct privileges?

Nathanexact · February 27, 2024, 1:53pm

Hi sorry to be a pain but can anyone help with what I posted?

bricks · February 27, 2024, 2:47pm

Most likely your user is just “admin” and not “Admin”. I think the user names are case sensitive.

bricks · February 27, 2024, 2:48pm

this error message is caused when running some management command as root user instead of the _gvm user.

bricks · February 27, 2024, 2:54pm

I am still bothered by all these could not be created messages because I’ve never seen them before.

Nathanexact · February 27, 2024, 3:12pm

Thanks for the reply. what would you recommend I try? would it be worth completely uninstalling OpenVAS and PostgreSQL and reinstalling If I did that could you provide me with a complete install guide?

Also Is there a command I can run on my kali system to uninstall PostgreSQL and OpenVAS completely?

rippledj · February 28, 2024, 5:17pm

Personally, I would start with a full fresh install of Kali and complete a full sudo apt update and sudo apt upgrade before installing GVM. Otherwise, you can uninstall gvm with either of these commands:

sudo apt remove gvm -y

sudo apt remove openvas -y

You can also use this guide for Kali Linux, which includes instructions for fixing PostgreSQL errors when you are required to upgrade the cluster.

bricks · February 29, 2024, 7:13am

Does Kali also remove the data from /var/lib/gvm and /var/lib/openvas? What about /var/log/gvm? I suppose they are kept when running apt remove gvm.

It could be enough to just drop the gvmd database in postgres and restart gvmd.

# stop gvmd
sudo systemctl stop gvmd

# get access to the postgres database CLI as postgres user
sudo -u postgres -i psql

# issue a SQL statement to remove the gvmd database
DROP DATABASE gvmd;

# restart gvmd
sudo systemctl start gvmd

Nathanexact · February 29, 2024, 10:05am

I will give this a go first and let you know how I get on. Thanks

Nathanexact · February 29, 2024, 10:24am

So this is what I get when I run those command.

(kali㉿kali)-[~]
└─$ sudo systemctl stop gvmd
[sudo] password for kali: 
                                                                                                                                                                                                                                           
┌──(kali㉿kali)-[~]
└─$ sudo -u postgres -i psql
psql (16.1 (Debian 16.1-1+b1))
Type "help" for help.

postgres=# DROP DATABASE gvmd;
DROP DATABASE

When I run sudo systemctl start gvmd I get this

(kali㉿kali)-[~]
└─$ sudo systemctl start gvmd
[sudo] password for kali: 
Job for gvmd.service failed because a timeout was exceeded.
See "systemctl status gvmd.service" and "journalctl -xeu gvmd.service" for details.

bricks · February 29, 2024, 10:44am

again you need to take a look at /var/log/gvm/gvmd.log for errors

Nathanexact · February 29, 2024, 11:53am

Thanks, here is the log.

md   main:MESSAGE:2024-02-29 10h13.04 utc:877910:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h13.04 utc:877911: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h13.04 utc:877911: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h13.04 utc:877911: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h14.35 utc:878643:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h14.35 utc:878644: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h14.35 utc:878644: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h14.35 utc:878644: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h16.05 utc:879383:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h16.05 utc:879384: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h16.05 utc:879384: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h16.05 utc:879384: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h17.36 utc:880113:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h17.36 utc:880114: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h17.36 utc:880114: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h17.36 utc:880114: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h19.06 utc:880842:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h19.06 utc:880851: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h19.06 utc:880851: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h19.06 utc:880851: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h20.37 utc:881578:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h20.37 utc:881579: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h20.37 utc:881579: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h20.37 utc:881579: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h22.07 utc:882306:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h22.07 utc:882307: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h22.07 utc:882307: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h22.07 utc:882307: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h23.38 utc:883041:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h23.38 utc:883042: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h23.38 utc:883042: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h23.38 utc:883042: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h25.08 utc:883822:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h25.08 utc:883823: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h25.08 utc:883823: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h25.08 utc:883823: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h26.39 utc:884556:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h26.39 utc:884557: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h26.39 utc:884557: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h26.39 utc:884557: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h28.09 utc:885291:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h28.09 utc:885292: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h28.09 utc:885292: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h28.09 utc:885292: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h29.40 utc:886018:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h29.40 utc:886019: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h29.40 utc:886019: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h29.40 utc:886019: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h31.10 utc:886751:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h31.10 utc:886752: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h31.10 utc:886752: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h31.10 utc:886752: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h32.41 utc:887489:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h32.41 utc:887490: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h32.41 utc:887490: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h32.41 utc:887490: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h34.11 utc:888216:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h34.11 utc:888217: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h34.11 utc:888217: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h34.11 utc:888217: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h35.42 utc:888947:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h35.42 utc:888948: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h35.42 utc:888948: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h35.42 utc:888948: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h37.12 utc:889684:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h37.12 utc:889685: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h37.12 utc:889685: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h37.12 utc:889685: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h38.43 utc:890417:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h38.43 utc:890418: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h38.43 utc:890418: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h38.43 utc:890418: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h40.13 utc:891192:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h40.13 utc:891193: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h40.13 utc:891193: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h40.13 utc:891193: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h41.44 utc:891928:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h41.44 utc:891929: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h41.44 utc:891929: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h41.44 utc:891929: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h43.14 utc:892658:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h43.14 utc:892659: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h43.14 utc:892659: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h43.14 utc:892659: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h44.45 utc:893386:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h44.45 utc:893395: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h44.45 utc:893395: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h44.45 utc:893395: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h46.15 utc:894126:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h46.15 utc:894127: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h46.15 utc:894127: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h46.15 utc:894127: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h47.46 utc:894861:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h47.46 utc:894862: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h47.46 utc:894862: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h47.46 utc:894862: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h49.16 utc:895596:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h49.16 utc:895597: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h49.16 utc:895597: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h49.16 utc:895597: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h50.47 utc:896761:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h50.47 utc:896762: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h50.47 utc:896762: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h50.47 utc:896762: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h52.17 utc:897490:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h52.17 utc:897491: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h52.17 utc:897491: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h52.17 utc:897491: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h53.48 utc:898229:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h53.48 utc:898230: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h53.48 utc:898230: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h53.48 utc:898230: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h55.18 utc:898960:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h55.18 utc:898961: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h55.18 utc:898961: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h55.18 utc:898961: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h56.49 utc:899688:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h56.49 utc:899689: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h56.49 utc:899689: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h56.49 utc:899689: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h58.19 utc:900430:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h58.19 utc:900431: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h58.19 utc:900431: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h58.19 utc:900431: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 10h59.50 utc:901157:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 10h59.50 utc:901158: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 10h59.50 utc:901158: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 10h59.50 utc:901158: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h01.20 utc:901885:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h01.20 utc:901886: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h01.20 utc:901886: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h01.20 utc:901886: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h02.51 utc:902625:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h02.51 utc:902626: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h02.51 utc:902626: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h02.51 utc:902626: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h04.21 utc:903353:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h04.21 utc:903354: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h04.21 utc:903354: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h04.21 utc:903354: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h05.52 utc:904085:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h05.52 utc:904086: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h05.52 utc:904086: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h05.52 utc:904086: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h07.22 utc:904821:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h07.22 utc:904822: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h07.22 utc:904822: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h07.22 utc:904822: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h08.53 utc:905557:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h08.53 utc:905558: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h08.53 utc:905558: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h08.53 utc:905558: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h10.23 utc:906330:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h10.23 utc:906339: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h10.23 utc:906339: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h10.23 utc:906339: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h11.54 utc:907065:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h11.54 utc:907066: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h11.54 utc:907066: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h11.54 utc:907066: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h13.24 utc:907795:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h13.24 utc:907796: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h13.24 utc:907796: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h13.24 utc:907796: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h14.55 utc:908532:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h14.55 utc:908533: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h14.55 utc:908533: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h14.55 utc:908533: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h16.25 utc:909263:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h16.25 utc:909264: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h16.25 utc:909264: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h16.25 utc:909264: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h17.56 utc:910000:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h17.56 utc:910001: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h17.56 utc:910001: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h17.56 utc:910001: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h19.26 utc:910736:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h19.26 utc:910737: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h19.26 utc:910737: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h19.26 utc:910737: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h20.57 utc:911466:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h20.57 utc:911467: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h20.57 utc:911467: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h20.57 utc:911467: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h22.27 utc:912193:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h22.27 utc:912194: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h22.27 utc:912194: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h22.27 utc:912194: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h23.58 utc:912931:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h23.58 utc:912932: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h23.58 utc:912932: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h23.58 utc:912932: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h25.28 utc:913663:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h25.28 utc:913664: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h25.28 utc:913664: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h25.28 utc:913664: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h26.59 utc:914392:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h26.59 utc:914393: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h26.59 utc:914393: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h26.59 utc:914393: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h28.29 utc:915133:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h28.29 utc:915134: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h28.29 utc:915134: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h28.29 utc:915134: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h30.00 utc:915861:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h30.00 utc:915862: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h30.00 utc:915862: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h30.00 utc:915862: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h31.30 utc:916588:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h31.30 utc:916589: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h31.30 utc:916589: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h31.30 utc:916589: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h33.01 utc:917328:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h33.01 utc:917329: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h33.01 utc:917329: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h33.01 utc:917329: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h34.31 utc:918055:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h34.31 utc:918056: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h34.31 utc:918056: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h34.31 utc:918056: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h36.02 utc:918786:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h36.02 utc:918795: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h36.02 utc:918795: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h36.02 utc:918795: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h37.32 utc:919522:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h37.32 utc:919523: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h37.32 utc:919523: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h37.32 utc:919523: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h39.03 utc:920303:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h39.03 utc:920304: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h39.03 utc:920304: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h39.03 utc:920304: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h40.33 utc:921039:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h40.33 utc:921040: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h40.33 utc:921040: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h40.33 utc:921040: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h42.04 utc:921766:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h42.04 utc:921767: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h42.04 utc:921767: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h42.04 utc:921767: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h43.34 utc:922497:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h43.34 utc:922498: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h43.34 utc:922498: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h43.34 utc:922498: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h45.05 utc:923237:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h45.05 utc:923238: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h45.05 utc:923238: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h45.05 utc:923238: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h46.35 utc:923965:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h46.35 utc:923966: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h46.35 utc:923966: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h46.35 utc:923966: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h48.06 utc:924699:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h48.06 utc:924700: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h48.06 utc:924700: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h48.06 utc:924700: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h49.36 utc:925435:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h49.36 utc:925436: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h49.36 utc:925436: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h49.36 utc:925436: init_manage_open_db: sql_open failed
md   main:MESSAGE:2024-02-29 11h51.07 utc:926164:    Greenbone Vulnerability Manager version 23.1.0 (DB revision 255)
md manage:WARNING:2024-02-29 11h51.07 utc:926165: sql_open: PQconnectPoll failed
md manage:WARNING:2024-02-29 11h51.07 utc:926165: sql_open: PQerrorMessage (conn): connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "gvmd" does not exist
md manage:WARNING:2024-02-29 11h51.07 utc:926165: init_manage_open_db: sql_open failed

bricks · February 29, 2024, 12:49pm

Oh sorry, of course we need to re-create the db. My fault.

As far as I can remember there was a script in Kali to do that but I can’t remember its name.

To do it manually you can run the following commands:

sudo -u postgres bash
cd
createdb -O gvm gvmd
psql gvmd -c "create role dba with superuser noinherit; grant dba to gvm;"
exit

the psql command might give you some error because I am not sure if we need to re-create the role.

bricks · February 29, 2024, 12:53pm

Ok, it’s better to just run gvm-setup