I dropped the configs table and reloaded it but the error persisted. I dropped the table and ran the --get-users command and that worked so I tried to start the openvas manager service and it started properly and I could log in. More interesting is that the configs table was recreated by something and all my tasks were back in the table. Odd.
Kyle On Tue, May 29, 2018 at 10:39:34AM -0400, Kyle Tucker wrote: > 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 > -- - Kyle _______________________________________________ Openvas-discuss mailing list Openvas-discuss@wald.intevation.org https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
