Updated - Error: openvasmd: undefined symbol: sqlite3_errstr

Support/Development for OpenVAS
lintegras
New Forum User
New Forum User
Posts: 3
Joined: Fri May 13, 2016 3:19 am
Location: Phoenix, AZ

Updated - Error: openvasmd: undefined symbol: sqlite3_errstr

Unread post 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?
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

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

Unread post by scott »

Which sqlite package are you using?
lintegras
New Forum User
New Forum User
Posts: 3
Joined: Fri May 13, 2016 3:19 am
Location: Phoenix, AZ

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

Unread post 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
anusooya
New Forum User
New Forum User
Posts: 2
Joined: Mon Sep 12, 2016 3:42 am
Location: kalpakkam

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

Unread post 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
hayjumper
New Forum User
New Forum User
Posts: 2
Joined: Tue Sep 13, 2016 4:21 pm
Location: Blacksburg, VA, USA

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

Unread post 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
octet
Forum User
Forum User
Posts: 64
Joined: Fri Dec 14, 2007 11:35 am

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

Unread post 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
anusooya
New Forum User
New Forum User
Posts: 2
Joined: Mon Sep 12, 2016 3:42 am
Location: kalpakkam

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

Unread post by anusooya »

Why no solution updated till now? :?

Kindly somebody update us with a correct solution for this Error
alex.k1b
New Forum User
New Forum User
Posts: 1
Joined: Wed Sep 21, 2016 3:33 am
Location: Russia

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

Unread post 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.
hayjumper
New Forum User
New Forum User
Posts: 2
Joined: Tue Sep 13, 2016 4:21 pm
Location: Blacksburg, VA, USA

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

Unread post 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
lintegras
New Forum User
New Forum User
Posts: 3
Joined: Fri May 13, 2016 3:19 am
Location: Phoenix, AZ

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

Unread post 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!
Casale
New Forum User
New Forum User
Posts: 1
Joined: Mon Nov 20, 2017 5:49 am
Location: Seattle, WA

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

Unread post 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?
Post Reply