Gvm-migrate-to-postgres: Database version not supported

good afternoon

I installed the greenbone-vulnerability-manager on the Centos 7 operating system successfully

command executed

yum install greenbone-vulnerability-manager

sed -i ‘/^#.*unixsocket/s/^# //’ /etc/redis.conf

systemctl enable redis && systemctl restart redis

echo ‘OPTIONS="–listen=0.0.0.0 --port=9392"’ > /etc/sysconfig/gsad

systemctl start gsad

openvas-setup

I need to migrate the sqlite database to postgres, but it was not possible, I request support

database installation procedure

yum install postgresql-server postgresql postgresql-contrib

  • Versions installed
    postgresql-server-9.2.24-1.el7_5.x86_64
    postgresql-9.2.24-1.el7_5.x86_64
    postgresql-contrib-9.2.24-1.el7_5.x86_64

postgresql-setup initdb

systemctl enable postgresql ; systemctl start postgresql

sudo -u postgres bash

createuser -DRS openvas10

createdb -O openvas10 gvmd

sudo -u postgres bash

psql gvmd

create role dba with superuser noinherit;

grant dba to openvas10;

sudo -u postgres bash

psql gvmd

create extension “uuid-ossp”;

createuser -DRS root

grant dba to root;

ALTER USER root with password ‘password’;

vim /var/lib/pgsql/data/postgresql.conf

listen_addresses = ‘*’

vim /var/lib/pgsql/data/pg_hba.conf

TYPE DATABASE USER ADDRESS METHOD

“local” is for Unix domain socket connections only

local all all ident

IPv4 local connections:

host all all 127.0.0.1/32 trust

IPv6 local connections:

host all all ::1/128 ident

host all all 172.16.34.0/24 trust

systemctl restart postgresql

gvm-migrate-to-postgres

gvm-migrate-to-postgres: Checking SQLite3 database.
gvm-migrate-to-postgres: SQLite: DROP INDEX report_hosts_by_host;
gvm-migrate-to-postgres: SQLite: CREATE INDEX report_hosts_by_host ON report_hosts (host);
gvm-migrate-to-postgres: SQLite: PRAGMA integrity_check;
gvm-migrate-to-postgres: PG: SELECT EXISTS (SELECT table_name FROM information_schema.tables WHERE table_catalog = ‘gvmd’ AND table_schema = ‘public’ AND table_name = ‘meta’) ::integer;
gvm-migrate-to-postgres: Database version not supported:

What do I need to do to correct the problem?

Thank you in advance for your attention.

Att

Hi,

it’s very likely that you have a too old version of OpenVAS. You have to update at best to the latest gvmd 9 release (GVM-9 (old stable, initial release 2017-03-07)) first.

Good Morning,

I made the installation through the atomic repository
yum install greenbone-vulnerability-manager 10.0.0-6947.el7.art

below installed versions

gvmd --version

Greenbone Vulnerability Manager 8.0.0
DB Manager revision 205

openvassd --version

OpenVAS Scanner 6.0.0
Most new code since 2005: © 2018 Greenbone Networks GmbH

gsad --version

Greenbone Security Assistant 8.0.0
Copyright © 2010-2016 Greenbone Networks GmbH

psql --version

psql (PostgreSQL) 9.2.24

sqlite3 --version

3.7.17 2013-05-20 00:56:22

Do I need to upgrade? What’s the procedure?

Att

Please get back to Atomic, we can´t support any 3rd party packets here. You need either psql or sqlite so both are not simultaneously needed, please ensure that GVM is build with PSQL support as well.

I would suggest to build it from the source with the last GVM 10 release and not relay to 3rd party packets that are known to be buggy or insecure.

Hello,

would have some manual for compiling the solution with postgres in Centos 7?

Att

Yes you need to go to our github and under “installation and usage” is described how to build the software.

You should be familiar with your Linux system …