Report Generation failing

Archive Greenbone Community Edition
1

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.

GVM versions

gsa: (‘gsad --version’) 8.01
gvm: (‘gvmd --version’) 8.01
openvas-scanner: (‘openvassd --version’) 6.01
gvm-libs: 1.5.32

Environment

Operating system: Ubuntu 18.04
Kernel: (‘uname -a’) 4.15.0…65
Installation method / source: source

2

Did you re-compile your GVM with the correct PSQL libraries ? If not please do so.

1 Like
3

If you build from source you can check the gvmd symlink in your sbin directory. It links to the binary used for the database backend e.g. gvmd-pg.

1 Like
5

This seems to be sorted now. Thanks for the input gentlemen!

6

Hi @jamesber, how did you fix this issue? I also get the same errors. I am using docker container from securecompliance/gvm image.

7

It’s a while back, but I failed to follow the instructions for postgre install. Your milage may vary dependiong on whetehr this is a new install or a migraton.

These lniks may help:


https://sadsloth.net/post/install-gvm11-src-on-debian/

1 Like