Hi, I faced an issue after updating PostgresSQL 18 on my Kali Linux: some Linux scans are stopped at 98-99% and other Windows scans doesn’t displays all vulnerabilities discovered earlier.After a short research I found that is caused by DB incomapitibilities on this Postgresl version Has somebody else faced the same problem - and what was your solution ? ( Downgradind on PostgreSQL 17 isn’t solves this issue: libgvmd requires PostgreSQL 18). .Thank you !
You should follow the instructions here (replace the relevant versions in the commands) to upgrade your PG cluster to v18. The pg-gvm package for v17 may no longer be available in Kali’s repository so downgrade to v17 may not be possible.
Hi Joseph, thanks for your suggestion.
I followed your instructions and successfully installed GSA version 25.3.1. Unfortunately, this does not solve my original problem: Linux scans are stopping at 98% again:
Review my comments above you will see no such advice. As for your installation, I cannot support for why your Kali installation broke, but you can check the gvm system logs to see if there are any errors. If someone else can share their insight and offer you a solution, then I will be happy for you.
1 Like
upgrade postgresql and drop old version & reboot.
Eero
@CsiszerA and what logs say? are processes still running? last procent can take a lot time?
Eero
Hi,
I have this error message in gvmd.log:
sql_open: PQconnectPoll failed
sql_open: PQerrorMessage (conn): connection to server on socket “/var/run/postgresql/.s.PGSQL.5432” failed: FATAL: role “root” does not exist
init_manage_open_db: sql_open failed
I have other instances with the same OpenVas version but they are running PSQL 17 version and no errors in gvmd.log:
Status of task scan-Codlea (a76f9a0b-92c6-46ad-b876-ca5cf38d22ab) has changed to Processing
Status of task scan-Codlea (a76f9a0b-92c6-46ad-b876-ca5cf38d22ab) has changed to Done
Thanks for your help
@CsiszerA this means that postgresql failed to start. check out logs for reason.
Eero
This topic was automatically closed after 90 days. New replies are no longer allowed.