Saw this thread below from August 27-- I had the same problem, and after some frustration found an answer.
Turns out that openvasmd requires a 'recent' sqlite version. I'm guessing > ver 3.5, per this URL that explains the shared cache mode differences after v3.5: http://www.sqlite.org/sharedcache.html I was installing on CentOS 5, which comes with sqlite 3.3.6-5 even with the latest yum update. And given the dependencies of other CentOS packages on sqlite (like yum), I dare not mess with that. So I installed sqlite-3.7.3 from source into /opt/sqlite, then added the command export LD_LIBRARY_PATH=/opt/sqlite/lib to the running shell (and put it in the startup script, or add to /etc/profile for persistence across restarts). Then running openvasmd -s 9391 --rebuild worked just fine. -------------- next part -------------- From elceedub at gmail.com Fri Aug 27 20:47:26 2010 From: elceedub at gmail.com (LC W) Date: Fri, 27 Aug 2010 11:47:26 -0700 Subject: [Openvas-discuss] Manager can't update/rebuild DB: database table is locked Message-ID: Hello all. I've built and installed openvas-libraries-3.1.2, openvas-scanner-3.1.0, and openvas-manager-1.0.2 from source on RHEL5.5.? I created the "om" account/certs per the README, and started openvassd on port 9391, then tried to do a rebuild of the manager database by running "openvasmd --sport 9391 --rebuild --verbose".? If I watch the manager log, I see that it connects to the scanner, and then a bunch of SQL statements as if the manager is building it's database.? This does not complete, however.? The last bit of the log looks like this: md?? main:? DEBUG:2010-08-27 17h41.47 utc :21657:??? sql: UPDATE configs SET family_count = 2, nvt_count = 3, families_growing = 1, nvts_growing = 1 WHERE name = 'Full and fast'; md?? main:WARNING:2010-08-27 17h41.47 utc :21657: sql: sqlite3_step failed: database table is locked md?? main:CRITICAL:2010-08-27 17h41.47 utc :21657: handle_sigabrt: abort md?? main:? DEBUG:2010-08-27 17h41.47 utc :21657:??? Cleaning up. md?? main:? DEBUG:2010-08-27 17h41.47 utc :21657:??? Exiting. The current sqlite version on RHEL5 is 3.3.6-5. I've tried to do the --update as well, and it fails in the same place. The manager refuses to start, and tells me to run and update or rebuild. Any ideas? -kml From matthew.mundell at greenbone.net Fri Aug 27 21:32:26 2010 From: matthew.mundell at greenbone.net (Matthew Mundell) Date: 27 Aug 2010 19:31:26 -0001 Subject: [Openvas-discuss] Manager can't update/rebuild DB: database table is locked In-Reply-To: Message of Fri, 27 Aug 2010 11:47:26 -0700. Message-ID: > to start, and tells me to run and update or rebuild. Any ideas? Perhaps there is an old Manager running that has the lock on the database?
_______________________________________________ Openvas-discuss mailing list [email protected] http://lists.wald.intevation.org/mailman/listinfo/openvas-discuss
