Page 1 of 1

Updated - Error: openvasmd: undefined symbol: sqlite3_errstr

Posted: Thu Sep 08, 2016 8:15 pm
by lintegras
After running my weekly update from @atomic, I am no longer able to log into the web GUI (Login failed. Waiting for OMP service to become available.) or start openvasmd (openvasmd: symbol lookup error: openvasmd: undefined symbol: sqlite3_errstr).

I am a little novice in my *nix skills so, please provide commands and/or locations for anything suggested.

Code: Select all

#openvas-check-setup
openvas-check-setup 2.3.0
  Test completeness and readiness of OpenVAS-8
  (add '--v6' or '--v7' or '--9'
   if you want to check for another OpenVAS version)

  Please report us any non-detected problems and
  help us to improve this check routine:
  http://lists.wald.intevation.org/mailman/listinfo/openvas-discuss

  Send us the log-file (/tmp/openvas-check-setup.log) to help analyze the problem.

  Use the parameter --server to skip checks for client tools
  like GSD and OpenVAS-CLI.

Step 1: Checking OpenVAS Scanner ...
        OK: OpenVAS Scanner is present in version 5.0.6.
        OK: OpenVAS Scanner CA Certificate is present as /var/lib/openvas/CA/cacert.pem.
        OK: NVT collection in /var/lib/openvas/plugins contains 49184 NVTs.
        WARNING: Signature checking of NVTs is not enabled in OpenVAS Scanner.
        SUGGEST: Enable signature checking (see http://www.openvas.org/trusted-nvts.html).
        OK: The NVT cache in /var/cache/openvas contains 49184 files for 49184 NVTs.
        OK: redis-server is present in version v=3.0.7.
        OK: scanner (kb_location setting) is configured properly using the redis-server socket: /tmp/redis.sock
        OK: redis-server is running and listening on socket: /tmp/redis.sock.
        OK: redis-server configuration is OK and redis-server is running.
Step 2: Checking OpenVAS Manager ...
        ERROR: No OpenVAS Manager (openvasmd) found.
        FIX: Please install OpenVAS Manager.

 ERROR: Your OpenVAS-8 installation is not yet complete!

Please follow the instructions marked with FIX above and run this
script again.

If you think this result is wrong, please report your observation
and help us to improve this check routine:
http://lists.wald.intevation.org/mailman/listinfo/openvas-discuss
Please attach the log-file (/tmp/openvas-check-setup.log) to help us analyze the problem.

Code: Select all

#rpm -qa | grep openvas
openvas-cli-1.4.4-10.el6.art.x86_64
openvas-libraries-8.0.8-25.el6.art.x86_64
openvas-1.0-17.el6.art.noarch
openvas-manager-6.0.9-36.el6.art.x86_64
openvas-smb-1.0.1-1.el6.art.x86_64
openvas-scanner-5.0.6-24.el6.art.x86_64
Ideas?

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Fri Sep 09, 2016 9:19 am
by scott
Which sqlite package are you using?

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Fri Sep 09, 2016 12:10 pm
by lintegras
scott wrote:Which sqlite package are you using?
Hey Scott,

Code: Select all

#rpm -qa | grep sqlite
sqlite-3.7.9-1.el6.art.x86_64
sqlite-devel-3.7.9-1.el6.art.x86_64

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Mon Sep 12, 2016 3:53 am
by anusooya
I am also facing the same problem "Error: openvasmd: undefined symbol: sqlite3_errstr"

kindly give me some solution to make openvas manager work

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Tue Sep 13, 2016 4:25 pm
by hayjumper
I can confirm, same error message running on CentOS 6.8. I also noticed dependency problems upgrading the 'nettle' package, may or may not be related:

Code: Select all

---> Package nettle.x86_64 0:3.2-2.el6 will be an update
--> Finished Dependency Resolution
Error: Package: 1:atomic-gnutls3-gnutls-3.1.25-1.el6.art.x86_64 (@atomic)
           Requires: libnettle.so.4()(64bit)
           Removing: nettle-2.7.1-3.el6.art.x86_64 (@atomic)
               libnettle.so.4()(64bit)
           Updated By: nettle-3.2-2.el6.x86_64 (epel)
               Not found
Error: Package: 1:atomic-gnutls3-gnutls-3.1.25-1.el6.art.x86_64 (@atomic)
           Requires: libhogweed.so.2()(64bit)
           Removing: nettle-2.7.1-3.el6.art.x86_64 (@atomic)
               libhogweed.so.2()(64bit)
           Updated By: nettle-3.2-2.el6.x86_64 (epel)
               Not found

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Sat Sep 17, 2016 4:32 am
by octet
Same error here on CentOS 6.8

Code: Select all

Step 3: Choose the GSAD admin users password.
The admin user is used to configure accounts,
Update NVT's manually, and manage roles.

Enter administrator username [Default: admin] : 
Enter Administrator Password: 
Verify Administrator Password: 

/usr/sbin/openvasmd: symbol lookup error: /usr/sbin/openvasmd: undefined symbol: sqlite3_errstr

Setup complete, you can now access GSAD at:
  https://<IP>:9392

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Tue Sep 20, 2016 2:34 am
by anusooya
Why no solution updated till now? :?

Kindly somebody update us with a correct solution for this Error

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Wed Sep 21, 2016 3:44 am
by alex.k1b
Hello folks,

Here is the solution:

- you should install atomic-sqlite-sqlite-devel.x86_64 and/or atomic-sqlite-sqlite.x86_64

This should solve the issue. But if openvas-manager will not start after installing atomic-sqlite packages, check log /var/log/openvas/openvasmd.log
If you will see following:

Code: Select all

Failed to create manager socket: Address family not supported by protocol
Failed to create manager socket: Address family not supported by protocol
You should edit init file /etc/init.d/openvas-manager to change a string in start section:
from $prog
to
$prog --listen=127.0.0.1

Code: Select all

start() {
        echo "Starting $progname:"
        #daemon --pidfile=/var/run/$prog.pid $prog $OPTIONS
       $prog --listen=127.0.0.1
        RETVAL=$?
        echo
        [ $RETVAL -eq 0 ] && touch $lockfile
        return $RETVAL
}
Thanks.

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Wed Sep 21, 2016 1:38 pm
by hayjumper
Just FYI, while awaiting an updated package, I have been able to work around this by downgrading *just* the openvas-manager package via:

yum downgrade openvas-manager-6.0.8-35.el6.art

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Tue Sep 27, 2016 6:54 pm
by lintegras
alex.k1b wrote:Hello folks,

Here is the solution:

- you should install atomic-sqlite-sqlite-devel.x86_64 and/or atomic-sqlite-sqlite.x86_64

This should solve the issue.
This successfully resolved my problem - thank you!

Re: Updated - Error: openvasmd: undefined symbol: sqlite3_er

Posted: Wed Nov 22, 2017 11:33 am
by Casale
lintegras wrote:
alex.k1b wrote:Hello folks,

Here is the solution:

- you should install atomic-sqlite-sqlite-devel.x86_64 and/or atomic-sqlite-sqlite.x86_64

This should solve the issue.
This successfully resolved my problem - thank you!
Same issue but that didn't work for me :( Is there something else I can try?