OpenVAS 9: After Update Scans Fail: Sqlite Error

Support/Development for OpenVAS
mtomaschett
New Forum User
New Forum User
Posts: 1
Joined: Sat Mar 30, 2019 1:16 pm
Location: New York

OpenVAS 9: After Update Scans Fail: Sqlite Error

Unread post by mtomaschett »

After a recent update of OpenVAS 9, all previously-working scans fail. Here is the relevant log:

/var/log/openvas/openvasmd.log:

event task:MESSAGE:2019-04-07 16h27.36 EDT:8108: Status of task Mail (full and very deep) (7188b961-1a6a-4b4c-9f2e-69523890acf6) has changed to Requested
event task:MESSAGE:2019-04-07 16h27.36 EDT:8108: Task Mail (full and very deep) (7188b961-1a6a-4b4c-9f2e-69523890acf6) has been requested to start by admin
md manage:WARNING:2019-04-07 16h27.47 EDT:8111: sql_prepare_internal: sqlite3_prepare failed: near "(": syntax error
md manage:WARNING:2019-04-07 16h27.47 EDT:8111: init_iterator: sql_prepare failed
md manage:WARNING:2019-04-07 16h27.47 EDT:8111: manage_cleanup_process_error: Error exit, setting running task to Internal Error
md manage:WARNING:2019-04-07 16h27.47 EDT:8111: sql_prepare_internal: sqlite3_prepare failed: near "(": syntax error
md manage:WARNING:2019-04-07 16h27.47 EDT:8111: init_iterator: sql_prepare failed

System: Centos 7.6
OpenVAS 9: openvasmd: 7.0.3; openvassd: 5.1.3; gsad: 7.0.3

Googling the error suggests that the sqlite version in use by openvasmd is outdated, requiring 3.8. I have sqlite 3.7 installed:

[root@mail openvas]# rpm -ql sqlite
/usr/bin/sqlite3
/usr/lib64/libsqlite3.so.0
/usr/lib64/libsqlite3.so.0.8.6
/usr/share/doc/sqlite-3.7.17
/usr/share/doc/sqlite-3.7.17/README
/usr/share/man/man1/sqlite3.1.gz

I also have sqlite 3.8 installed from the atomic package:

[root@mail openvas]# rpm -ql atomic-sqlite-sqlite
/opt/atomic/atomic-sqlite/root/usr/bin/sqlite3
/opt/atomic/atomic-sqlite/root/usr/lib64/libsqlite3.so.0
/opt/atomic/atomic-sqlite/root/usr/lib64/libsqlite3.so.0.8.6
/opt/atomic/atomic-sqlite/root/usr/share/doc/atomic-sqlite-sqlite-3.8.5
/opt/atomic/atomic-sqlite/root/usr/share/doc/atomic-sqlite-sqlite-3.8.5/README.md
/opt/atomic/atomic-sqlite/root/usr/share/man/man1/sqlite3.1.gz

If the sqlite version is causing the error, and the solution is to use the later version, then how can I force openvasmd to use the later version?

Thanks for any help!
ElodinHolden
New Forum User
New Forum User
Posts: 1
Joined: Mon Apr 08, 2019 8:38 pm
Location: San Diego

Re: OpenVAS 9: After Update Scans Fail: Sqlite Error

Unread post by ElodinHolden »

I have been searching for a solution, I have the sqlite-3.8 version installed in /opt/atomic/atomic-sqlite/ but it seems openvas is not using that version and is instead using the OS version. I have tried replacing sqlite (and broke yum/rpm DB) but still it doesn't run any scans.

Is there a way to force openvas (openvassd.conf) to load sqlite3 from the atomic path?
Post Reply