Hi, I tried the latest version of code from the github repository (great move migrating everything to github)> it still seems like the issue is present when I try to upgrade the DB version 188 to 190. A database migration is most likely working as the columns *overrides.result_nvt *and *results.result_nvt* are not present and the gvmd-pg --migrate errors out. Thanks TN
On 31 December 2017 at 03:53, TN TN <mpm7...@gmail.com> wrote: > Hi, > > I'm trying to upgrade a test server to the latest openvas9-beta1 build > (Checked out revision 30039) . I'm currently running the stable version of > Openvas9. When I used an older revision of beta1 the migrate would work. In > the newer version the migrate for the DB displays the following error. Any > assistance would be greatly appreciated. > > > gvmd --migrate > > (gvmd:27819): md manage-WARNING **: sql_exec_internal: PQexec failed: > ERROR: column overrides.result_nvt does not exist > LINE 1: ...overrides.new_severity FROM overrides WHERE overrides.... > ^ > (7) > > > (gvmd:27819): md manage-WARNING **: sql_exec_internal: SQL: CREATE OR > REPLACE FUNCTION report_severity (report integer, > overrides integer, min_qod > integer) RETURNS double precision AS $$ WITH max_severity AS (SELECT > max(severity) AS max FROM > report_counts WHERE report = > $1 AND override = $2 AND > min_qod = $3 AND (end_time = 0 or end_time >= m_now > ())) SELECT CASE WHEN EXISTS (SELECT max FROM > max_severity) AND (SELECT max FROM max_severity) IS NOT > NULL THEN (SELECT max::double precision FROM max_severity) > WHEN dynamic_severity () AND $2::boolean THEN (SELECT > max ( coalesce ((SELECT overrides.new_severity > FROM overrides WHERE overrides.result_nvt = results.result_nvt AND > ((overrides.owner IS NULL) OR (overrides.owner = > (SELECT id FROM users WHERE users.uuid = > (SELECT uuid FROM current_credentials)))) AND > ((overrides.end_time = 0) OR (overrides.end_time >= m_now ())) > AND (overrides.task = results.task OR overrides.task = 0) AND > (overrides.result = results.id OR overrides.result = 0) AND > (overrides.hosts is NULL OR overrides.hosts = '' OR > hosts_contains (overrides.hosts, > results.host)) AND (overrides.port is NULL OR overrides.port = > '' OR overrides.port = results.port) AND > severity_matches_ov (current_severity (results.severity, > results.nvt), overrides.severity) ORDER BY overrides.result > DESC, overrides.task DESC, overrides.port > DESC, overrides.severity ASC, > overrides.creation_time DESC LIMIT 1), current_severity > (results.severity, results.nvt))) FROM > results WHERE results.report = $1 AND > results.qod >= $3) WHEN dynamic_severity () THEN (SELECT > max (CASE WHEN results.type IS > NULL THEN 0::real > ELSE current_severity (results.severity, > results.nvt) END) FROM > results WHERE results.report = $1 AND > results.qod >= $3) WHEN $2::boolean THEN (SELECT max ( > coalesce ((SELECT overrides.new_severity FROM overrides WHERE > overrides.result_nvt = results.result_nvt AND ((overrides.owner IS > NULL) OR (overrides.owner = (SELECT id FROM > users WHERE users.uuid = (SELECT > uuid FROM current_credentials)))) AND > ((overrides.end_time = 0) OR (overrides.end_time >= m_now ())) > AND (overrides.task = results.task OR overrides.task = 0) AND > (overrides.result = results.id OR overrides.result = 0) AND > (overrides.hosts is NULL OR overrides.hosts = '' OR > hosts_contains (overrides.hosts, > results.host)) AND (overrides.port is NULL OR overrides.port = > '' OR overrides.port = results.port) AND > severity_matches_ov (results.severity, overrides.severity) ORDER > BY overrides.result DESC, overrides.task DESC, > overrides.port DESC, overrides.severity ASC, > overrides.creation_time DESC LIMIT 1), results.severity)) > FROM results WHERE results.report = $1 AND > results.qod >= $3) ELSE (SELECT max (CASE > WHEN results.type IS NULL THEN > 0::real ELSE results.severity > END) FROM results WHERE results.report = > $1 AND results.qod >= $3) END;$$ LANGUAGE SQL; > > > (gvmd:27819): md manage-WARNING **: sqlv: sql_exec_internal failed > > Thanks, TN > >
_______________________________________________ Openvas-devel mailing list Openvas-devel@wald.intevation.org https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-devel