Hey Community, I have been lurking here for the past 4 days trying to get my install to work, im currently running debian 10 with openvas 20.08 compiled from source following this guide: https://kifarunix.com/install-and-setup-gvm-20-08-on-debian/
I have gotten to the point of installing everything and even being able to log in to the web interface, but i cant run a scan, the scap databases are always updating and according to my GVMD logs there is an issue with SQL, as soon as the sql error appears, the whole thing crashes, i hope someone can help me i have been searching for 3 days now and havent been able to find a solution, any help will be greatly appreciated. below is my GVMD log
GVM versions
gsad: (‘gsad --20.08’)
gvmd: (‘gvmd --20.08’)
openvas-scanner: ('openvas --20.08, )
gvm-libs: 20.08
Environment
Debian 10 buster
Linux debian 4.19.0-16-amd64 #1 SMP Debian 4.19.181-1 (2021-03-19) x86_64
GNU/Linux
Compiled from source
md main:MESSAGE:2021-06-12 06h07.40 utc:1569: Greenbone Vulnerability Manager version 20.08.1~git-e35a75a25-gvmd-20.08 (GIT revision e35a75a25-gvmd-20.08) (DB revision 233)
md manage:WARNING:2021-06-12 06h07.41 utc:1571: 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:2021-06-12 06h07.41 utc:1571: sql_exec_internal: SQL: SELECT value FROM public.meta WHERE name = ‘database_version’;
md manage:WARNING:2021-06-12 06h07.41 utc:1571: sql_x: sql_exec_internal failed
md manage:MESSAGE:2021-06-12 06h07.41 utc:1571: No SCAP database found
md manage:MESSAGE:2021-06-12 06h07.41 utc:1571: No CERT database found
util gpgme:MESSAGE:2021-06-12 06h07.52 utc:1571: Setting GnuPG dir to ‘/opt/gvm/var/lib/gvm/gvmd/gnupg’
util gpgme:MESSAGE:2021-06-12 06h07.52 utc:1571: Created GnuPG dir ‘/opt/gvm/var/lib/gvm/gvmd/gnupg’
util gpgme:MESSAGE:2021-06-12 06h07.53 utc:1571: Using OpenPGP engine version ‘2.2.12’
util gpgme: INFO:2021-06-12 06h07.53 utc:1571: starting key generation …
util gpgme: INFO:2021-06-12 06h07.53 utc:1571: OpenPGP key ‘GVM Credential Encryption’ has been generated
md manage:WARNING:2021-06-12 06h08.33 utc:1640: update_scap: No SCAP db present, rebuilding SCAP db from scratch
md manage: INFO:2021-06-12 06h08.33 utc:1642: Initializing CERT database
md manage: INFO:2021-06-12 06h08.35 utc:1642: sync_cert: Updating data from feed
md manage: INFO:2021-06-12 06h08.35 utc:1642: update_dfn_xml: dfn-cert-2019.xml
md manage: INFO:2021-06-12 06h08.35 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2019.xml
md manage: INFO:2021-06-12 06h08.36 utc:1640: update_scap: Updating data from feed
md manage: INFO:2021-06-12 06h08.36 utc:1640: Updating CPEs
md manage: INFO:2021-06-12 06h08.38 utc:1642: update_dfn_xml: dfn-cert-2017.xml
md manage: INFO:2021-06-12 06h08.38 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2017.xml
md manage: INFO:2021-06-12 06h08.41 utc:1642: update_dfn_xml: dfn-cert-2021.xml
md manage: INFO:2021-06-12 06h08.41 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2021.xml
md manage: INFO:2021-06-12 06h08.43 utc:1642: update_dfn_xml: dfn-cert-2013.xml
md manage: INFO:2021-06-12 06h08.43 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2013.xml
md manage: INFO:2021-06-12 06h08.45 utc:1642: update_dfn_xml: dfn-cert-2018.xml
md manage: INFO:2021-06-12 06h08.45 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2018.xml
md manage: INFO:2021-06-12 06h08.48 utc:1642: update_dfn_xml: dfn-cert-2009.xml
md manage: INFO:2021-06-12 06h08.48 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2009.xml
md manage: INFO:2021-06-12 06h08.48 utc:1642: update_dfn_xml: dfn-cert-2011.xml
md manage: INFO:2021-06-12 06h08.48 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2011.xml
md manage: INFO:2021-06-12 06h08.50 utc:1642: update_dfn_xml: dfn-cert-2016.xml
md manage: INFO:2021-06-12 06h08.50 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2016.xml
md manage: INFO:2021-06-12 06h08.53 utc:1642: update_dfn_xml: dfn-cert-2010.xml
md manage: INFO:2021-06-12 06h08.53 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2010.xml
md manage: INFO:2021-06-12 06h08.54 utc:1642: update_dfn_xml: dfn-cert-2015.xml
md manage: INFO:2021-06-12 06h08.54 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2015.xml
md manage: INFO:2021-06-12 06h08.56 utc:1642: update_dfn_xml: dfn-cert-2020.xml
md manage: INFO:2021-06-12 06h08.56 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2020.xml
md manage: INFO:2021-06-12 06h09.00 utc:1642: update_dfn_xml: dfn-cert-2014.xml
md manage: INFO:2021-06-12 06h09.00 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2014.xml
md manage: INFO:2021-06-12 06h09.02 utc:1642: update_dfn_xml: dfn-cert-2008.xml
md manage: INFO:2021-06-12 06h09.02 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2008.xml
md manage: INFO:2021-06-12 06h09.02 utc:1642: update_dfn_xml: dfn-cert-2012.xml
md manage: INFO:2021-06-12 06h09.02 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/dfn-cert-2012.xml
md manage: INFO:2021-06-12 06h09.04 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/CB-K14.xml
md manage: INFO:2021-06-12 06h09.05 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/CB-K19.xml
md manage: INFO:2021-06-12 06h09.07 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/CB-K17.xml
md manage: INFO:2021-06-12 06h09.10 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/CB-K13.xml
md manage: INFO:2021-06-12 06h09.11 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/CB-K18.xml
md manage: INFO:2021-06-12 06h09.12 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/CB-K21.xml
md manage: INFO:2021-06-12 06h09.13 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/CB-K16.xml
md manage: INFO:2021-06-12 06h09.16 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/CB-K15.xml
md manage: INFO:2021-06-12 06h09.18 utc:1642: Updating /opt/gvm/var/lib/gvm/cert-data/CB-K20.xml
md manage: INFO:2021-06-12 06h09.20 utc:1642: sync_cert: Updating CERT info succeeded.
md main:MESSAGE:2021-06-12 06h13.52 utc:802: Greenbone Vulnerability Manager version 20.08.1~git-e35a75a25-gvmd-20.08 (GIT revision e35a75a25-gvmd-20.08) (DB revision 233)
md manage:MESSAGE:2021-06-12 06h13.54 utc:811: No SCAP database found
util gpgme:MESSAGE:2021-06-12 06h13.55 utc:811: Setting GnuPG dir to ‘/opt/gvm/var/lib/gvm/gvmd/gnupg’
util gpgme:MESSAGE:2021-06-12 06h13.55 utc:811: Using OpenPGP engine version ‘2.2.12’
md main:MESSAGE:2021-06-12 06h15.04 utc:861: Greenbone Vulnerability Manager version 20.08.1~git-e35a75a25-gvmd-20.08 (GIT revision e35a75a25-gvmd-20.08) (DB revision 233)
md manage: INFO:2021-06-12 06h15.04 utc:861: Creating scanner.
md manage:MESSAGE:2021-06-12 06h15.05 utc:861: No SCAP database found
util gpgme:MESSAGE:2021-06-12 06h15.05 utc:861: Setting GnuPG dir to ‘/opt/gvm/var/lib/gvm/gvmd/gnupg’
util gpgme:MESSAGE:2021-06-12 06h15.05 utc:861: Using OpenPGP engine version ‘2.2.12’
md main:MESSAGE:2021-06-12 06h15.15 utc:884: Greenbone Vulnerability Manager version 20.08.1~git-e35a75a25-gvmd-20.08 (GIT revision e35a75a25-gvmd-20.08) (DB revision 233)
md manage: INFO:2021-06-12 06h15.15 utc:884: Getting scanners.
md manage:MESSAGE:2021-06-12 06h15.16 utc:884: No SCAP database found
md main:MESSAGE:2021-06-12 06h16.04 utc:901: Greenbone Vulnerability Manager version 20.08.1~git-e35a75a25-gvmd-20.08 (GIT revision e35a75a25-gvmd-20.08) (DB revision 233)
md manage: INFO:2021-06-12 06h16.04 utc:901: Verifying scanner.
md manage:MESSAGE:2021-06-12 06h16.05 utc:901: No SCAP database found
util gpgme:MESSAGE:2021-06-12 06h16.05 utc:901: Setting GnuPG dir to ‘/opt/gvm/var/lib/gvm/gvmd/gnupg’
util gpgme:MESSAGE:2021-06-12 06h16.05 utc:901: Using OpenPGP engine version ‘2.2.12’
md manage:WARNING:2021-06-12 06h16.26 utc:926: update_scap: No SCAP db present, rebuilding SCAP db from scratch
md manage: INFO:2021-06-12 06h16.28 utc:926: update_scap: Updating data from feed
md manage: INFO:2021-06-12 06h16.28 utc:926: Updating CPEs
md main:MESSAGE:2021-06-12 06h16.36 utc:939: Greenbone Vulnerability Manager version 20.08.1~git-e35a75a25-gvmd-20.08 (GIT revision e35a75a25-gvmd-20.08) (DB revision 233)
md manage: INFO:2021-06-12 06h16.36 utc:939: Creating user.
md manage:MESSAGE:2021-06-12 06h16.37 utc:939: No SCAP database found
md main:MESSAGE:2021-06-12 06h17.00 utc:949: Greenbone Vulnerability Manager version 20.08.1~git-e35a75a25-gvmd-20.08 (GIT revision e35a75a25-gvmd-20.08) (DB revision 233)
md manage: INFO:2021-06-12 06h17.00 utc:949: Getting users.
md manage:MESSAGE:2021-06-12 06h17.01 utc:949: No SCAP database found
md main:MESSAGE:2021-06-12 06h17.35 utc:983: Greenbone Vulnerability Manager version 20.08.1~git-e35a75a25-gvmd-20.08 (GIT revision e35a75a25-gvmd-20.08) (DB revision 233)
md manage: INFO:2021-06-12 06h17.35 utc:983: Modifying setting.
md manage:MESSAGE:2021-06-12 06h17.36 utc:983: No SCAP database found
event port_list:MESSAGE:2021-06-12 06h17.37 utc:987: Port list All TCP and Nmap top 100 UDP (730ef368-57e2-11e1-a90f-406186ea4fc5) has been created by admin
event port_list:MESSAGE:2021-06-12 06h17.37 utc:987: Port list All IANA assigned TCP (33d0cd82-57c6-11e1-8ed1-406186ea4fc5) has been created by admin
event port_list:MESSAGE:2021-06-12 06h17.37 utc:987: Port list All IANA assigned TCP and UDP (4a4717fe-57d2-11e1-9a26-406186ea4fc5) has been created by admin
event report_format:MESSAGE:2021-06-12 06h17.37 utc:987: Report format PDF (c402cc3e-b531-11e1-9163-406186ea4fc5) has been created by admin
event report_format:MESSAGE:2021-06-12 06h17.37 utc:987: Report format CSV Results (c1645568-627a-11e3-a660-406186ea4fc5) has been created by admin
event report_format:MESSAGE:2021-06-12 06h17.37 utc:987: Report format Anonymous XML (5057e5cc-b825-11e4-9d0e-28d24461215b) has been created by admin
event report_format:MESSAGE:2021-06-12 06h17.37 utc:987: Report format TXT (a3810a62-1f62-11e1-9219-406186ea4fc5) has been created by admin
event report_format:MESSAGE:2021-06-12 06h17.38 utc:987: Report format XML (a994b278-1f62-11e1-96ac-406186ea4fc5) has been created by admin
event report_format:MESSAGE:2021-06-12 06h17.38 utc:987: Report format ITG (77bd6c4a-1f62-11e1-abf0-406186ea4fc5) has been created by admin
md manage: INFO:2021-06-12 06h18.50 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2016.xml
md manage: INFO:2021-06-12 06h19.08 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2017.xml
md manage: INFO:2021-06-12 06h19.36 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2015.xml
md manage: INFO:2021-06-12 06h19.51 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2002.xml
md manage: INFO:2021-06-12 06h20.01 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2018.xml
md manage: INFO:2021-06-12 06h20.47 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2006.xml
md manage: INFO:2021-06-12 06h20.59 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2005.xml
md manage: INFO:2021-06-12 06h21.08 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2009.xml
md manage: INFO:2021-06-12 06h21.31 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2014.xml
md manage: INFO:2021-06-12 06h21.51 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2020.xml
md manage: INFO:2021-06-12 06h22.47 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2012.xml
md manage: INFO:2021-06-12 06h23.03 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2013.xml
md manage: INFO:2021-06-12 06h23.20 utc:926: Updating /opt/gvm/var/lib/gvm/scap-data/nvdcve-2.0-2007.xml
md main:MESSAGE:2021-06-12 06h36.59 utc:950: Greenbone Vulnerability Manager version 20.08.1~git-e35a75a25-gvmd-20.08 (GIT revision e35a75a25-gvmd-20.08) (DB revision 233)
md manage:WARNING:2021-06-12 06h37.00 utc:957: sql_open: PQconnectPoll failed
md manage:WARNING:2021-06-12 06h37.00 utc:957: sql_open: PQerrorMessage (conn): FATAL: the database system is starting up
md manage:WARNING:2021-06-12 06h37.00 utc:957: init_manage_process: sql_open failed