Have OpenVas 8 installed on Gentoo Linux system and Openvasmd will not start.
Linux ndspc43V 4.1.7-hardened-r1 openvas 8.0.5 openvas-libraries 8.0 5 openvas-manager 6.0.6-r1 openvas-scanner 5.0.4 openvas-tools 0_pre20512 openvas-cli 1.4.3 sqlite 3.8.10.2 redis 2.8.17-r1 Starting openvasmd in foreground and verbose mode results in the following log: -------------------------------------------------------------------------------------------- md main: DEBUG:2015-11-27 20h30.52 utc:13390: sql: SELECT id, uuid, name, comment, iso_time (creation_time), iso_time (modification_time), creation_time AS created, modification_time AS modified, (SELECT name FROM users AS inner_users WHERE inner_users.id = tasks.owner) AS _owner, owner, run_status, (SELECT count(*) FROM reports WHERE task = tasks.id) AS total, (SELECT uuid FROM reports WHERE task = tasks.id AND scan_run_status = 1 ORDER BY date ASC LIMIT 1) AS first_report, task_threat_level (id, opts.override, opts.min_qod) AS threat, task_trend (id, opts.override, opts.min_qod) AS trend, run_status_name (run_status) AS status, (SELECT uuid FROM reports WHERE task = tasks.id AND scan_run_status = 1 ORDER BY date DESC LIMIT 1) AS last_report, task_severity (id, opts.override, opts.min_qod) AS severity, (SELECT count(*) FROM reports WHERE task = tasks.id AND scan_run_status = 1), hosts_ordering, scanner, (SELECT schedules.name FROM schedules WHERE schedules.id = tasks.schedule) AS schedule, (CASE WHEN schedule_next_time IS NULL THEN -1 WHEN schedule_next_time = 0 AND tasks.schedule > 0 THEN (SELECT first_time FROM schedules WHERE schedules.id = tasks.schedule) ELSE schedule_next_time END) AS next_due, (SELECT date FROM reports WHERE task = tasks.id AND scan_run_status = 1 ORDER BY date ASC LIMIT 1) AS first, (SELECT date FROM reports WHERE task = tasks.id AND scan_run_status = 1 ORDER BY date DESC LIMIT 1) AS last FROM tasks , (SELECT 0 AS override, 70 AS min_qod) AS opts WHERE t () AND hidden = 0 ORDER BY lower (name) ASC LIMIT -1 OFFSET 0; md main: DEBUG:2015-11-27 20h30.52 utc:13390: sql: UPDATE reports SET scan_run_status = 12 WHERE scan_run_status = 0 OR scan_run_status = 14 OR scan_run_status = 17 OR scan_run_status = 16 OR scan_run_status = 3 OR scan_run_status = 4 OR scan_run_status = 10 OR scan_run_status = 15 OR scan_run_status = 11; md main: DEBUG:2015-11-27 20h30.52 utc:13390: sql: SELECT id, uuid, name, comment, iso_time (creation_time), iso_time (modification_time), creation_time AS created, modification_time AS modified, '' AS _owner, 0, oid, version, name, summary, copyright, cve, bid, xref, tag, category, family, cvss_base, cvss_base AS severity, cvss_base AS cvss, qod, qod_type, solution_type, tag AS script_tags FROM nvts ORDER BY name ASC; md main:WARNING:2015-11-27 20h30.54 utc:13390: Failed to create manager socket: Address family not supported by protocol md main: DEBUG:2015-11-27 20h30.54 utc:13390: Cleaning up. md main: DEBUG:2015-11-27 20h30.54 utc:13390: Exiting. ------------------------------------------------------------------------------------------ Running the last SQL statement with sqlite3 results in the following: -> Error: no such function: iso_time Researching this issues finds there are only 5 standard date/time functions in Sqlite (but it is possible to change that). date(timestring, modifier, modifier, ...) time(timestring, modifier, modifier, ...) datetime(timestring, modifier, modifier, ...) julianday(timestring, modifier, modifier, ...) strftime(format, timestring, modifier, modifier, ...) I would like some advice on what todo to workaround or correct the problem. -- Fred Austin N-Dimension Solutions *Cyber Security Protection for Critical Infrastructure Assets*This email and any files transmitted with it are solely intended for the use of the named recipient(s) and may contain information that is privileged and confidential. If you receive this email in error, please immediately notify the sender and delete this message in all its forms. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore N-Dimension Solutions Inc. does not accept liability for any errors or omission in the contents of the message which arise as a result of e-mail transmission.
_______________________________________________ Openvas-discuss mailing list [email protected] https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
