I have an old GVM 11 appliance as I havent been able to update it since it is always in use. Thanks for the great product btw.
Anyways I wanted the latest and greatest GVM version.
So I made a new vm with docker installed. Created a GVM 20.8 container (Everything built from source), tested it and everything seemed to work. So it was time to import db from GVM 9.
I exported postgresql dump from GVM 9 in the form of a plain text sql script(also tried with tar archive later).
I dropped the db from GVM 20.08 and built a new one with the commands:
su -c "createdb -O gvm gvmd" postgres su -c "psql --dbname=gvmd --command='create extension \"uuid-ossp\";'" postgres su -c "psql --dbname=gvmd --command='create extension pgcrypto';" postgres
And imported the dump from GVM 9. Did all the necessary NVT, CERT, SCAP, GVMD Data syncs and all completed successfully. After that i migrated postgresql db with gvmd --migrate. No errors.
Next i tried getting uuid for admin account with gvmd --get-users, and it says “Database is wrong version.”
Checked gvmd logs, it says
md manage: INFO:2020-09-15 05h22.29 utc:4505: Getting users.
md manage:MESSAGE:2020-09-15 05h22.29 utc:4505: check_db_versions: database version of SCAP database: 15
md manage:MESSAGE:2020-09-15 05h22.29 utc:4505: check_db_versions: SCAP database version supported by manager: 16
So I reran migration and checked the logs:
md main:MESSAGE:2020-09-15 05h35.11 utc:65: Migrating SCAP database
md manage:WARNING:2020-09-15 05h35.11 utc:65: gvm_migrate_secinfo: unsupported feed_type
md main:CRITICAL:2020-09-15 05h35.11 utc:65: gvmd: SCAP database migration failed
Is GVM 9 too old to be imported into GVM 20.8? Should I drop the feeds tables from db and try syncing again?