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 _______________________________________________ Openvas-discuss mailing list Openvas-discuss@wald.intevation.org https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
