---------- Forwarded message ---------- From: Brandon Perry <[email protected]> Date: Fri, Oct 15, 2010 at 5:26 PM Subject: Re: [Openvas-discuss] Manager can't update/rebuild DB: database table is locked To: [email protected]
Maybe I am misunderstanding what the intended outcome is, but should it not be this for consistency's sake? export LD_LIBRARY_PATH="$LD_LIBRARY_PATH";/opt/sqlite/lib On Oct 15, 2010 5:21 PM, "[email protected]" <[email protected]> wrote: 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: <[email protected]> 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. <[email protected]> Message-ID: <[email protected]> > 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 -- http://volatile-minds.blogspot.com -- blog http://www.volatileminds.net -- website _______________________________________________ Openvas-discuss mailing list [email protected] http://lists.wald.intevation.org/mailman/listinfo/openvas-discuss
