And now for my weekly GVM question. I deployed gvm10 under sqlite3 and over a week or so performance slowly deteriorated as scans were run and reports were imported from our old system. . I then ran the script to convert to postgres, which per the script, did run successfully. TBH though, I’m not sure if the newer database is being used. Is there a clear way to tell?
The larger problem I have today is that reports can not longer be generated by generating a PDF or scheduling an alert. We just get a timeout similar to.
A timeout for the request to url https://192.168.20.137/gmp?token=0166ac53-6e86-409a-8c06-4b96e58c1562&cmd=get_report&report_id=20e598cb-b5ef-459e-aae6-a189288ef7f4&report_format_id=c402cc3e-b531-11e1-9163-406186ea4fc5&filter=apply_overrides%3D0%20min_qod%3D70%20rows%3D-1%20first%3D1%20sort%3Dname%20levels%3Dhml%20notes%3D1%20overrides%3D1 occurred.
I’m guessing the SQL Server is swamping? Any ideas on where to look on this one? the various log files aren’t showing much.
gsa: (‘gsad --version’) 8.01
gvm: (‘gvmd --version’) 8.01
openvas-scanner: (‘openvassd --version’) 6.01
Operating system: Ubuntu 18.04
Kernel: (‘uname -a’) 4.15.0…65
Installation method / source: source