Not sure what you mean by running as there's no daemon for Sqlite as I understand nor can I find a log for it. I don't see any duplicates of the uuid column of the configs table.
sqlite> .schema configs CREATE TABLE configs (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name, nvt_selector, comment, family_count INTEGER, nvt_count INTEGER, families_growing INTEGER, nvts_growing INTEGER, type, scanner, creation_time, modification_time); sqlite> select uuid from configs; 085569ce-73ed-11df-83c3-002264764cea 2d3f051c-55ba-11e3-bf43-406186ea4fc5 698f691e-7489-11df-9d8c-002264764cea 708f25c4-7489-11df-8094-002264764cea 74db13d6-7489-11df-91b9-002264764cea 8715c877-47a0-438d-98a3-27c7a6ab2196 bbca7412-a950-11e3-9109-406186ea4fc5 daba56c8-73ec-11df-a475-002264764cea On Tue, May 29, 2018 at 04:09:18PM +0200, Christoph Gruber wrote: > Hi! > > Sqlite is running? What does the sqlite log say? > > > Am 29.05.2018 um 15:49 schrieb Kyle Tucker <ky...@panix.com>: > > > > That did not resolve it. This was logged when that's run and > > --get-users still fails. > > > > md main:MESSAGE:2018-05-29 13h48.12 utc:13311: OpenVAS Manager version > > 7.0.2 (DB revision 184) > > md main: INFO:2018-05-29 13h48.12 utc:13311: rebuild_nvt_cache_retry: > > Reloading NVT cache > > md main: INFO:2018-05-29 13h48.12 utc:13312: > > update_or_rebuild_nvt_cache: Rebuilding NVT cache > > md manage:WARNING:2018-05-29 13h48.13 utc:13312: sql_exec_internal: > > sqlite3_step failed: UNIQUE constraint failed: configs.uuid > > md manage:WARNING:2018-05-29 13h48.13 utc:13312: sqlv: sql_exec_internal > > failed > > > > > > On Tue, May 29, 2018 at 03:35:15PM +0200, Christoph Gruber wrote: > >> Hi! > >> > >> Have you tried openvasmd ???rebuild? > >> > >> Kindest regards > >> > >>> Am 29.05.2018 um 15:15 schrieb Kyle Tucker <ky...@panix.com>: > >>> > >>> Hello, > >>> > >>> I've had a OpenVAS V9 instance running for some time. There's always > >>> been something "off" about the users where the Super Admin users can't > >>> do anything via GSA as they would get permission denied errors. I had to > >>> add all Super Users via command line. Last week I was unable to change > >>> users passwords via command line. Eventually I noticed that the command > >>> "openvasmd --get-users" was showing no users and exiting with code 1. We > >>> were able to log in with those accounts though and set up and run scans. > >>> I just rebooted this system and now I get the error "Login failed. > >>> Waiting for OMP service to become available." as the openvasmd service > >>> is failing to start. I now see these errors in /var/log/openvasmd.log: > >>> > >>> md main:MESSAGE:2018-05-29 12h52.15 utc:10852: OpenVAS Manager > >>> version 7.0.2 (DB revision 184) > >>> md manage:WARNING:2018-05-29 12h52.15 utc:10853: sql_exec_internal: > >>> sqlite3_step failed: UNIQUE constraint failed: configs.uuid > >>> md manage:WARNING:2018-05-29 12h52.15 utc:10853: sqlv: sql_exec_internal > >>> failed > >>> > >>> I show all my users in the sqlite database. > >>> > >>> 1|00943c9a-cae5-4d81-be85-34c903734381||admin||a7028e6d04e17b35aa33a320f60099dd > >>> 664dba6f85c9802bd15c12d3c305ddb6|||0||0|file|1517856884|1517856884 > >>> 5|28c3431a-7875-4ac2-8659-4678f1f807ef||sadmin||64054ff51cd79d85fd189d0a439fc9b7 > >>> 145b2f54e245ad372713e1a9a778d889|||0||0|file|1517867637|1517867847 > >>> 6|389de8b8-d237-4df4-8360-82f8e8ddf513||myuserid||7b5ee8dc628403b6635db42b8a099f1d > >>> d9e8501585d0e74e928ccaaa138f2007|America/New_York||0||0|file|1517868030|1518113161 > >>> > >>> Any thoughts or suggestions on fixing this? Thanks. > >>> > >>> - Kyle > >>> _______________________________________________ > >>> Openvas-discuss mailing list > >>> Openvas-discuss@wald.intevation.org > >>> https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss > >> > >> -- > >> Christoph Gruber > >> l...@guru.at > >> Patience is not the ability to wait, but to have a good attitude while > >> waiting! > >> > >> PGP-Key-ID: 11C558E8 > >> PGP-Key-Fingerprint: BC67 4E98 9B2E 70F7 C24F A7B7 3ADD C4B4 11C5 58E8 > >> > > > > -- > > - Kyle > > -- > Christoph Gruber > l...@guru.at > Patience is not the ability to wait, but to have a good attitude while > waiting! > > PGP-Key-ID: 11C558E8 > PGP-Key-Fingerprint: BC67 4E98 9B2E 70F7 C24F A7B7 3ADD C4B4 11C5 58E8 > -- - Kyle _______________________________________________ Openvas-discuss mailing list Openvas-discuss@wald.intevation.org https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
