OpenVAS 9: After Update Scans Fail: Sqlite Error
Posted: Sun Apr 07, 2019 5:24 pm
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!
/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!