Well, I don't really know if gentoo version really works :) report bug to maintainer.
by grepping openvasmd sources, looks like iso_time function is provided to sql from openvas manager sources. -- Eero 2015-11-27 23:50 GMT+02:00 Fred Austin <[email protected]>: > 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 >
_______________________________________________ Openvas-discuss mailing list [email protected] https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
