* Ralf Hildebrandt <[email protected]>:
> I think it's time to ramp up the logging as you suggested.
Logging from level=128 (openvasmd.log) is attached.
# openvasmd --rebuild --progress --verbose
Rebuilding NVT cache... /
still hangs
--
Ralf Hildebrandt Charite Universitätsmedizin Berlin
[email protected] Campus Benjamin Franklin
http://www.charite.de Hindenburgdamm 30, 12203 Berlin
Geschäftsbereich IT, Abt. Netzwerk fon: +49-30-450.570.155
md main: INFO:2016-04-11 11h38.19 utc:459: OpenVAS Manager version 6.0.8
(DB revision 146)
md main: INFO:2016-04-11 11h38.19 utc:459: rebuild_nvt_cache_retry:
Reloading NVT cache
md main: INFO:2016-04-11 11h38.19 utc:460: update_or_rebuild_nvt_cache:
Rebuilding NVT cache
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_open: db open, max retry
sleep time is 0
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: ATTACH DATABASE
'/var/lib/openvas/cert-data/cert.db' AS cert;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT value FROM
main.meta WHERE name = 'database_version';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main:MESSAGE:2016-04-11 11h38.19 utc:460: No SCAP database found
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
cert.sqlite_master WHERE type = 'table' AND name = 'dfn_cert_advs';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
cert.sqlite_master WHERE type = 'table' AND name = 'dfn_cert_advs';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT value FROM
cert.meta WHERE name = 'database_version' LIMIT 1;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS agents (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, installer TEXT, installer_64 TEXT, installer_filename,
installer_signature_64 TEXT, installer_trust INTEGER, installer_trust_time,
howto_install TEXT, howto_use TEXT, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS agents_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, installer TEXT, installer_64 TEXT, installer_filename,
installer_signature_64 TEXT, installer_trust INTEGER, installer_trust_time,
howto_install TEXT, howto_use TEXT, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS config_preferences (id INTEGER PRIMARY KEY, config INTEGER, type, name,
value, default_value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS config_preferences_trash (id INTEGER PRIMARY KEY, config INTEGER, type,
name, value, default_value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS 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, creation_time,
modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS configs_trash (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, creation_time,
modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS alert_condition_data (id INTEGER PRIMARY KEY, alert INTEGER, name, data);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS alert_condition_data_trash (id INTEGER PRIMARY KEY, alert INTEGER, name,
data);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS alert_event_data (id INTEGER PRIMARY KEY, alert INTEGER, name, data);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS alert_event_data_trash (id INTEGER PRIMARY KEY, alert INTEGER, name,
data);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS alert_method_data (id INTEGER PRIMARY KEY, alert INTEGER, name, data);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS alert_method_data_trash (id INTEGER PRIMARY KEY, alert INTEGER, name,
data);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS alerts (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, event INTEGER, condition INTEGER, method INTEGER, filter INTEGER,
creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS alerts_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, event INTEGER, condition INTEGER, method INTEGER, filter INTEGER,
filter_location INTEGER, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS filters (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, type, term, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS filters_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, type, term, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS groups (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS groups_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, type, term, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS group_users (id INTEGER PRIMARY KEY, `group` INTEGER, user INTEGER);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS group_users_trash (id INTEGER PRIMARY KEY, `group` INTEGER, user
INTEGER);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS lsc_credentials (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER,
name, login, password, comment, private_key TEXT, creation_time,
modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS lsc_credentials_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner
INTEGER, name, login, password, comment, private_key TEXT, creation_time,
modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS meta (id INTEGER PRIMARY KEY, name UNIQUE, value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS notes (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, nvt,
creation_time, modification_time, text, hosts, port, severity, task INTEGER,
result INTEGER, end_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS notes_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, nvt,
creation_time, modification_time, text, hosts, port, severity, task INTEGER,
result INTEGER, end_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS nvt_preferences (id INTEGER PRIMARY KEY, name, value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS nvt_selectors (id INTEGER PRIMARY KEY, name, exclude INTEGER, type
INTEGER, family_or_nvt, family);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvt_selectors_by_name ON nvt_selectors (name);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvt_selectors_by_family_or_nvt ON nvt_selectors (type, family_or_nvt);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS nvts (id INTEGER PRIMARY KEY, uuid, oid, version, name, comment,
summary, copyright, cve, bid, xref, tag, category INTEGER, family, cvss_base,
creation_time, modification_time, solution_type TEXT, qod INTEGER, qod_type
TEXT);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvts_by_oid ON nvts (oid);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvts_by_name ON nvts (name);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvts_by_family ON nvts (family);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS nvt_cves (nvt, oid, cve_name)
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvts_by_creation_time ON nvts (creation_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvts_by_modification_time ON nvts (modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvts_by_cvss_base ON nvts (cvss_base);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvts_by_solution_type ON nvts (solution_type);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS nvt_cves_by_oid ON nvt_cves (oid);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS overrides (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, nvt,
creation_time, modification_time, text, hosts, port, severity, new_severity,
task INTEGER, result INTEGER, end_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS overrides_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER,
nvt, creation_time, modification_time, text, hosts, port, severity,
new_severity, task INTEGER, result INTEGER, end_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS permissions (id INTEGER PRIMARY KEY, uuid UNIQUE, owner, name, comment,
resource_type, resource, resource_uuid, resource_location, subject_type,
subject, subject_location, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS permissions_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner, name,
comment, resource_type, resource, resource_uuid, resource_location,
subject_type, subject, subject_location, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS port_lists (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS port_lists_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER,
name, comment, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS port_names (id INTEGER PRIMARY KEY, number INTEGER, protocol, name,
UNIQUE (number, protocol) ON CONFLICT REPLACE);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS port_ranges (id INTEGER PRIMARY KEY, uuid UNIQUE, port_list INTEGER,
type, start, end, comment, exclude);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS port_ranges_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, port_list
INTEGER, type, start, end, comment, exclude);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS report_host_details (id INTEGER PRIMARY KEY, report_host INTEGER,
source_type, source_name, source_description, name, value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS report_host_details_by_report_host_and_name_and_value ON
report_host_details (report_host, name, value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS report_hosts (id INTEGER PRIMARY KEY, report INTEGER, host, start_time,
end_time, current_port, max_port);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS report_hosts_by_host ON report_hosts (host);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS report_hosts_by_report ON report_hosts (report);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS report_format_param_options (id INTEGER PRIMARY KEY,
report_format_param, value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS report_format_param_options_trash (id INTEGER PRIMARY KEY,
report_format_param, value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS report_format_params (id INTEGER PRIMARY KEY, report_format, name, type
INTEGER, value, type_min, type_max, type_regex, fallback);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS report_format_params_trash (id INTEGER PRIMARY KEY, report_format, name,
type INTEGER, value, type_min, type_max, type_regex, fallback);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS report_formats (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name,
extension, content_type, summary, description, signature, trust INTEGER,
trust_time, flags INTEGER, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS report_formats_trash (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name,
extension, content_type, summary, description, signature, trust INTEGER,
trust_time, flags INTEGER, original_uuid, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS reports (id INTEGER PRIMARY KEY, uuid, owner INTEGER, hidden INTEGER,
task INTEGER, date INTEGER, start_time, end_time, nbefile, comment,
scan_run_status INTEGER, slave_progress, slave_task_uuid, slave_uuid,
slave_name, slave_host, slave_port, source_iface);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS report_counts (id INTEGER PRIMARY KEY, report INTEGER, user INTEGER,
severity, count, override, end_time INTEGER);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS report_counts_by_report_and_override ON report_counts (report, override);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS results (id INTEGER PRIMARY KEY, uuid, task INTEGER, host, port, nvt,
type, description, report, nvt_version, severity REAL, qod INTEGER, qod_type
TEXT, owner INTEGER, date INTEGER)
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS results_by_host ON results (host);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS results_by_report_host ON results (report, host);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS results_by_task ON results (task);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS results_by_task_qod_severity ON results (task, qod, severity);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS results_by_type ON results (type);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS roles (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS roles_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS role_users (id INTEGER PRIMARY KEY, role INTEGER, user INTEGER);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS role_users_trash (id INTEGER PRIMARY KEY, role INTEGER, user INTEGER);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS scanners (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name, comment,
host, port, type, ca_pub, key_pub, key_priv, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS scanners_trash (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name,
comment, host, port, type, ca_pub, key_pub, key_priv, creation_time,
modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS schedules (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name, comment,
first_time, period, period_months, duration, timezone, initial_offset,
creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS schedules_trash (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name,
comment, first_time, period, period_months, duration, timezone,
initial_offset, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS slaves (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name, comment,
host, port, login, password, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS slaves_trash (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name,
comment, host, port, login, password, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS settings (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name, comment,
value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS tags (id INTEGER PRIMARY KEY, uuid UNIQUE, owner, name, comment,
creation_time, modification_time, resource_type, resource, resource_uuid,
resource_location, active, value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS tags_by_resource ON tags (resource_type, resource);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE INDEX IF NOT
EXISTS tags_by_name ON tags (name);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE UNIQUE INDEX IF
NOT EXISTS tags_by_uuid ON tags (uuid);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS tags_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner, name, comment,
creation_time, modification_time, resource_type, resource, resource_uuid,
resource_location, active, value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS targets (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
hosts, exclude_hosts, reverse_lookup_only, reverse_lookup_unify, comment,
lsc_credential INTEGER, ssh_port, smb_lsc_credential INTEGER, port_range,
alive_test, creation_time, modification_time, esxi_lsc_credential);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS targets_trash (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
hosts, exclude_hosts, reverse_lookup_only, reverse_lookup_unify, comment,
lsc_credential INTEGER, ssh_port, smb_lsc_credential INTEGER, port_range,
ssh_location INTEGER, smb_location INTEGER, port_list_location INTEGER,
alive_test, creation_time, modification_time, esxi_lsc_credential,
esxi_location INTEGER);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS task_files (id INTEGER PRIMARY KEY, task INTEGER, name, content);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS task_alerts (id INTEGER PRIMARY KEY, task INTEGER, alert INTEGER,
alert_location INTEGER);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS task_preferences (id INTEGER PRIMARY KEY, task INTEGER, name, value);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS tasks (id INTEGER PRIMARY KEY, uuid, owner INTEGER, name, hidden
INTEGER, time, comment, run_status INTEGER, start_time, end_time, config
INTEGER, target INTEGER, schedule INTEGER, schedule_next_time,
schedule_periods INTEGER, slave INTEGER, config_location INTEGER,
target_location INTEGER, schedule_location INTEGER, slave_location INTEGER,
upload_result_count INTEGER, hosts_ordering, scanner, alterable,
creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE TABLE IF NOT
EXISTS users (id INTEGER PRIMARY KEY, uuid UNIQUE, owner INTEGER, name,
comment, password, timezone, hosts, hosts_allow, ifaces, ifaces_allow,
method, creation_time, modification_time);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: BEGIN EXCLUSIVE;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: DROP VIEW IF EXISTS
result_overrides;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE VIEW
result_overrides AS SELECT users.id AS user, results.id as result,
overrides.id AS override, overrides.severity AS ov_old_severity,
overrides.new_severity AS ov_new_severity FROM users, results, overrides WHERE
overrides.nvt = results.nvt AND (overrides.result = 0 OR overrides.result =
results.id) AND ((overrides.owner IS NULL) OR (overrides.owner =
(users.id)) OR EXISTS (SELECT * FROM permissions WHERE name =
'Super' AND ((resource = 0) OR ((resource_type =
'user') AND (resource = overrides.owner))
OR ((resource_type = 'role') AND (resource
IN (SELECT DISTINCT role FROM
role_users WHERE "user"
= overrides.owner))) OR ((resource_type = 'group')
AND (resource IN (SELECT
DISTINCT "group" FROM group_users
WHERE "user" =
overrides.owner)))) AND subject_location = 0
AND ((subject_type = 'user' AND subject
= (users.id)) OR (subject_type = 'group'
AND subject IN (SELECT DISTINCT "group"
FROM group_users WHERE "user"
= (users.id))) OR
(subject_type = 'role' AND subject
IN (SELECT DISTINCT role FROM role_users
WHERE "user" =
(users.id))))) OR EXISTS (SELECT id FROM permissions WHERE resource =
overrides.
id AND resource_type = 'override' AND resource_location = 0 AND
subject_location = 0 AND ((subject_type = 'user' AND subject
= (users.id)) OR (subject_type = 'group' AND subject
IN (SELECT DISTINCT "group" FROM group_users
WHERE "user" = (users.id))) OR
(subject_type = 'role' AND subject IN (SELECT DISTINCT
role FROM role_users WHERE "user"
= (users.id)))) AND (name = 'get_overrides'))) AND
((overrides.end_time = 0) OR (overrides.end_time >= m_now ())) AND
(overrides.task = (SELECT reports.task FROM reports WHERE
results.report = reports.id) 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.por
t is NULL OR overrides.port = '' OR overrides.port = results.port)
ORDER BY overrides.result DESC, overrides.task DESC, overrides.port DESC,
overrides.severity ASC, overrides.creation_time DESC
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: COMMIT;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: BEGIN EXCLUSIVE;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: DROP VIEW IF EXISTS
result_new_severities;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE VIEW
result_new_severities AS SELECT results.id as result, users.id as user,
dynamic, override, CASE WHEN dynamic THEN CASE WHEN override THEN
coalesce ((SELECT ov_new_severity FROM result_overrides
WHERE result = results.id AND result_overrides.user =
users.id AND severity_matches_ov
(coalesce ((CASE WHEN results.severity
> 0.0 THEN (SELECT cvss_base
FROM nvts
WHERE nvts.oid = results.nvt)
ELSE results.severity END),
results.severity),
ov_old_severity)), coalesce ((CASE WHEN results.severity
> 0.0 THEN (SELECT
cvss_base FROM nvts
WHERE nvts.oid = results.nvt) ELSE
results.severity END),
results.severity)) ELSE coalesce ((CASE WHEN results.severity
> 0.0 THEN (SELECT cvss_base
FROM nvts WHERE nvts.oid = results.nvt)
ELSE results.severity END),
results.severity) END ELSE CASE WHEN override THEN coalesce
((SELECT ov_new_severity FROM result_overrides WHERE result =
results.id AND result_overrides.user = users.id
AND severity_matches_ov (results.severity,
ov_old_severity)),
results.severity) ELSE results.severity END END
AS new_severity FROM results, users JOIN (SELECT 0 AS override UNION SELECT 1
AS override_opts) JOIN (SELECT 0 AS dynamic UNION SELECT 1 AS dynamic_opts);
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: COMMIT;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: BEGIN EXCLUSIVE;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: DROP VIEW IF EXISTS
results_autofp;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: CREATE VIEW
results_autofp AS SELECT results.id as result, autofp_selection, (CASE
autofp_selection WHEN 1 THEN (CASE WHEN (((SELECT
family FROM nvts WHERE oid = results.nvt) IN ('AIX Local Security
Checks', 'CentOS Local Security Checks', 'Debian Local Security Checks',
'Fedora Local Security Checks', 'FreeBSD Local Security Checks', 'Gentoo Local
Security Checks', 'HP-UX Local Security Checks', 'Mac OS X Local Security
Checks', 'Mandrake Local Security Checks', 'Red Hat Local Security Checks',
'Solaris Local Security Checks', 'SuSE Local Security Checks', 'Ubuntu Local
Security Checks', 'Windows : Microsoft Bulletins', 'Privilege escalation'))
OR results.nvt = '0' OR EXISTS (SELECT id FROM
nvts WHERE oid = results.nvt AND (cve
= 'NOCVE' OR cve NOT IN (SELECT cve FROM nvts
WHERE oid IN (SELECT source_name
FROM report_host_details WHERE report_host
= (SELECT id
FROM report_hosts WHERE report =
139707964762920 AND host = results.host)
AND name = 'EXIT_CODE'
AND value = 'EXIT_NOTVULN') AND
family IN ('AIX Local Security Checks', 'CentOS Local Security Checks', 'Debian
Local Security Checks', 'Fedora Local Security Checks', 'FreeBSD Local Security
Checks', 'Gentoo Local Security Checks', 'HP-UX Local Security Checks', 'Mac OS
X Local Security Checks', 'Mandrake Local Security Checks', 'Red Hat Local
Security Checks', 'Solaris Local Security Checks', 'SuSE Local Security
Checks', 'Ubuntu Local Security Checks', 'Windows : Microso
ft Bulletins', 'Privilege escalation'))))) THEN NULL WHEN
severity = -3.0 THEN NULL ELSE 1 END) WHEN 2 THEN
(CASE WHEN (((SELECT family FROM nvts WHERE oid = results.nvt)
IN ('AIX Local Security Checks', 'CentOS Local Security Checks', 'Debian
Local Security Checks', 'Fedora Local Security Checks', 'FreeBSD Local Security
Checks', 'Gentoo Local Security Checks', 'HP-UX Local Security Checks', 'Mac OS
X Local Security Checks', 'Mandrake Local Security Checks', 'Red Hat Local
Security Checks', 'Solaris Local Security Checks', 'SuSE Local Security
Checks', 'Ubuntu Local Security Checks', 'Windows : Microsoft Bulletins',
'Privilege escalation')) OR results.nvt = '0' OR EXISTS
(SELECT id FROM nvts AS outer_nvts WHERE oid =
results.nvt AND (cve = 'NOCVE' OR NOT
EXISTS (SELECT cve FROM nvts WHERE o
id IN (SELECT source_name FROM
report_host_details WHERE report_host
= (SELECT id FROM
report_hosts WHERE report = results.report
AND host = results.host)
AND name = 'EXIT_CODE' AND value =
'EXIT_NOTVULN') AND family IN ('AIX Local Security Checks',
'CentOS Local Security Checks', 'Debian Local Security Checks', 'Fedora Local
Security Checks', 'FreeBSD Local Security Checks', 'Gentoo Local Security
Checks', 'HP-UX Local Security Checks', 'Mac OS X Local Security Checks',
'Mandrake Local Security Checks', 'Red Hat Local Security Checks', 'Solaris
Local Security Checks', 'SuSE Local Security Checks', 'Ubuntu Local Security
Checks', 'Windows : Microsoft Bulletins', 'Privilege escalation')
A
ND common_cve (nvts.cve, outer_nvts.cve))))) THEN NULL
WHEN severity = -3.0 THEN NULL ELSE 1 END) ELSE 0 END) AS
autofp FROM results, (SELECT 0 AS autofp_selection UNION SELECT 1 AS
autofp_selection UNION SELECT 2 AS autofp_selection) AS autofp_opts;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: COMMIT;
md main: DEBUG:2016-04-11 11h38.19 utc:460: -
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: DELETE FROM main.meta
WHERE name = 'database_version';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: INSERT INTO main.meta
(name, value) VALUES ('database_version', '146');
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
main.meta WHERE name = 'update_nvti_cache';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: UPDATE main.meta SET
value = 0 WHERE name = 'update_nvti_cache';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
nvt_selectors WHERE name = '54b45713-d4f4-4435-b20d-304c175ed8c5' AND type = 0;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
nvt_selectors WHERE name = '54b45713-d4f4-4435-b20d-304c175ed8c5' AND type = 2
AND family_or_nvt = '1.3.6.1.4.1.25623.1.0.810002';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
nvt_selectors WHERE name = '54b45713-d4f4-4435-b20d-304c175ed8c5' AND type = 2
AND family_or_nvt = '1.3.6.1.4.1.25623.1.0.810003';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
nvt_selectors WHERE name = '54b45713-d4f4-4435-b20d-304c175ed8c5' AND type = 1
AND family_or_nvt = 'Port scanners';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
nvt_selectors WHERE name = '54b45713-d4f4-4435-b20d-304c175ed8c5' AND type = 2
AND family_or_nvt = '1.3.6.1.4.1.25623.1.0.14259';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
nvt_selectors WHERE name = '54b45713-d4f4-4435-b20d-304c175ed8c5' AND type = 2
AND family_or_nvt = '1.3.6.1.4.1.25623.1.0.100315';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count(*) FROM
nvt_selectors WHERE name = '54b45713-d4f4-4435-b20d-304c175ed8c5' AND type = 2
AND family_or_nvt = '1.3.6.1.4.1.25623.1.0.80109';
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT count (*) FROM
nvt_cves;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: BEGIN IMMEDIATE;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: DELETE FROM nvt_cves;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: SELECT id, oid, cve FROM
nvts;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: REINDEX nvt_cves_by_oid;
md main: DEBUG:2016-04-11 11h38.19 utc:460: sql: COMMIT;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
configs WHERE name = 'Full and fast';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
configs WHERE name = 'Full and fast ultimate';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
configs WHERE name = 'Full and very deep';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
configs WHERE name = 'Full and very deep ultimate';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
configs WHERE uuid = '085569ce-73ed-11df-83c3-002264764cea';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
configs WHERE uuid = '8715c877-47a0-438d-98a3-27c7a6ab2196';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: DELETE FROM
nvt_selectors WHERE name = '0d9a2738-8fe2-4e22-8f26-bb886179e759' AND family =
'Service detection' AND (((SELECT family FROM nvts WHERE oid =
nvt_selectors.family_or_nvt) = 'Product detection') OR NOT EXISTS
(SELECT * FROM nvts WHERE oid =
nvt_selectors.family_or_nvt));
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
configs WHERE uuid = '2d3f051c-55ba-11e3-bf43-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: BEGIN EXCLUSIVE;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count (*) FROM
config_preferences WHERE config = (SELECT id FROM configs WHERE uuid =
'2d3f051c-55ba-11e3-bf43-406186ea4fc5') AND type = 'PLUGINS_PREFS'
AND name = 'Global variable settings[checkbox]:Strictly unauthenticated';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count (*) FROM
nvt_selectors WHERE name = (SELECT nvt_selector FROM configs
WHERE uuid = '2d3f051c-55ba-11e3-bf43-406186ea4fc5') AND family_or_nvt =
'1.3.6.1.4.1.25623.1.0.12288';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: COMMIT;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
configs WHERE uuid = 'bbca7412-a950-11e3-9109-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
port_lists WHERE uuid = 'c7e03b6c-3bbe-11e1-a057-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
port_lists WHERE uuid = 'fd591a34-56fd-11e1-9f27-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
port_lists WHERE uuid = '730ef368-57e2-11e1-a90f-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
port_lists WHERE uuid = '9ddce1ae-57e7-11e1-b13c-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
port_lists WHERE uuid = '492b72f4-56fe-11e1-98a7-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
port_lists WHERE uuid = '5f2029f6-56fe-11e1-bb94-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
port_lists WHERE uuid = '33d0cd82-57c6-11e1-8ed1-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
port_lists WHERE uuid = '4a4717fe-57d2-11e1-9a26-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
port_lists WHERE uuid = 'ab33f6b0-57f8-11e1-96f5-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE port_ranges SET
"end" = 65535 WHERE "end" = 65536;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE port_ranges SET
start = 65535 WHERE start = 65536;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
targets WHERE name = 'Localhost';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE targets SET
port_range = (SELECT id FROM port_lists WHERE uuid =
'c7e03b6c-3bbe-11e1-a057-406186ea4fc5') WHERE uuid =
'b493b7a8-7489-11df-a3ec-002264764cea';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
scanners WHERE uuid = '08b69003-5fc2-4037-a479-93b440211c73';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
tasks WHERE uuid = '343435d6-91b0-11de-9478-ffd71f4c6f29';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
reports WHERE uuid = '343435d6-91b0-11de-9478-ffd71f4c6f30';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = '5ceff8ba-1f62-11e1-ab9f-406186ea4fc5', modification_time = m_now ()
WHERE uuid = 'a0704abb-2120-489f-959f-251c9f4ffebd';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = '5ceff8ba-1f62-11e1-ab9f-406186ea4fc5' WHERE data =
'a0704abb-2120-489f-959f-251c9f4ffebd';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = '6c248850-1f62-11e1-b082-406186ea4fc5', modification_time = m_now ()
WHERE uuid = 'b993b6f5-f9fb-4e6e-9c94-dd46c00e058d';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = '6c248850-1f62-11e1-b082-406186ea4fc5' WHERE data =
'b993b6f5-f9fb-4e6e-9c94-dd46c00e058d';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = '77bd6c4a-1f62-11e1-abf0-406186ea4fc5', modification_time = m_now ()
WHERE uuid = '929884c6-c2c4-41e7-befb-2f6aa163b458';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = '77bd6c4a-1f62-11e1-abf0-406186ea4fc5' WHERE data =
'929884c6-c2c4-41e7-befb-2f6aa163b458';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = '7fcc3a1a-1f62-11e1-86bf-406186ea4fc5', modification_time = m_now ()
WHERE uuid = '9f1ab17b-aaaa-411a-8c57-12df446f5588';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = '7fcc3a1a-1f62-11e1-86bf-406186ea4fc5' WHERE data =
'9f1ab17b-aaaa-411a-8c57-12df446f5588';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = '9ca6fe72-1f62-11e1-9e7c-406186ea4fc5', modification_time = m_now ()
WHERE uuid = 'f5c2a364-47d2-4700-b21d-0a7693daddab';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = '9ca6fe72-1f62-11e1-9e7c-406186ea4fc5' WHERE data =
'f5c2a364-47d2-4700-b21d-0a7693daddab';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = 'a0b5bfb2-1f62-11e1-85db-406186ea4fc5', modification_time = m_now ()
WHERE uuid = '1a60a67e-97d0-4cbf-bc77-f71b08e7043d';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = 'a0b5bfb2-1f62-11e1-85db-406186ea4fc5' WHERE data =
'1a60a67e-97d0-4cbf-bc77-f71b08e7043d';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = 'a3810a62-1f62-11e1-9219-406186ea4fc5', modification_time = m_now ()
WHERE uuid = '19f6f1b3-7128-4433-888c-ccc764fe6ed5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = 'a3810a62-1f62-11e1-9219-406186ea4fc5' WHERE data =
'19f6f1b3-7128-4433-888c-ccc764fe6ed5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = 'a994b278-1f62-11e1-96ac-406186ea4fc5', modification_time = m_now ()
WHERE uuid = 'd5da9f67-8551-4e51-807b-b6a873d70e34';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = 'a994b278-1f62-11e1-96ac-406186ea4fc5' WHERE data =
'd5da9f67-8551-4e51-807b-b6a873d70e34';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = 'a684c02c-b531-11e1-bdc2-406186ea4fc5', modification_time = m_now ()
WHERE uuid = '7fcc3a1a-1f62-11e1-86bf-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = 'a684c02c-b531-11e1-bdc2-406186ea4fc5' WHERE data =
'7fcc3a1a-1f62-11e1-86bf-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = 'c402cc3e-b531-11e1-9163-406186ea4fc5', modification_time = m_now ()
WHERE uuid = 'a0b5bfb2-1f62-11e1-85db-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = 'c402cc3e-b531-11e1-9163-406186ea4fc5' WHERE data =
'a0b5bfb2-1f62-11e1-85db-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: BEGIN IMMEDIATE;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: CREATE TEMPORARY TABLE
duplicates AS SELECT id, uuid, make_uuid () AS new_uuid, owner,
(SELECT uuid FROM users WHERE users.id = outer_report_formats.owner)
AS owner_uuid, (SELECT owner from report_formats
WHERE uuid = outer_report_formats.uuid
ORDER BY id ASC LIMIT 1) AS original_owner, (SELECT
uuid FROM users WHERE users.id = (SELECT owner from report_formats
WHERE uuid = outer_report_formats.uuid
ORDER BY id ASC LIMIT 1)) AS original_owner_uuid
FROM report_formats AS outer_report_formats WHERE id > (SELECT id from
report_formats WHERE uuid = outer_report_formats.uuid
ORDER BY id ASC LIMIT 1);
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE alert_method_data
SET data = (SELECT new_uuid FROM duplicates WHERE duplicates.id =
alert_method_data.alert) WHERE alert IN (SELECT id FROM duplicates);
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT id, uuid,
new_uuid, owner, owner_uuid, original_owner, original_owner_uuid FROM
duplicates;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: UPDATE report_formats
SET uuid = (SELECT new_uuid FROM duplicates WHERE duplicates.id =
report_formats.id) WHERE id IN (SELECT id FROM duplicates);
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: DROP TABLE duplicates;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: COMMIT;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = '5057e5cc-b825-11e4-9d0e-28d24461215b';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = '910200ca-dc05-11e1-954f-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = '5ceff8ba-1f62-11e1-ab9f-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = 'c1645568-627a-11e3-a660-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = '9087b18c-626c-11e3-8892-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = '6c248850-1f62-11e1-b082-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = '77bd6c4a-1f62-11e1-abf0-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = 'a684c02c-b531-11e1-bdc2-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = '9ca6fe72-1f62-11e1-9e7c-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = 'c402cc3e-b531-11e1-9163-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = 'a3810a62-1f62-11e1-9219-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = 'a994b278-1f62-11e1-96ac-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = '9e5e5deb-879e-4ecc-8be6-a71cd0875cdd';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = 'c15ad349-bd8d-457a-880a-c7056532ee15';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_format_params WHERE report_format = (SELECT id FROM report_formats
WHERE uuid = 'c15ad349-bd8d-457a-880a-c7056532ee15') AND name =
'Attach HTML report';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_format_params WHERE report_format = (SELECT id FROM report_formats
WHERE uuid = 'c15ad349-bd8d-457a-880a-c7056532ee15') AND name = 'ISM
Control Description';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
report_formats WHERE uuid = '50c9950a-f326-11e4-800c-28d24461215b';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
roles WHERE uuid = '7a8cb5b4-b74d-11e2-8187-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
roles WHERE uuid = 'cc9cac5e-39a3-11e4-abae-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
roles WHERE uuid = '5f8fd16c-c550-11e3-b6ab-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
roles WHERE uuid = '12cdb536-480b-11e4-8552-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
roles WHERE uuid = '8d453140-b74d-11e2-b0be-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
roles WHERE uuid = '9c5a6ec6-6fe2-11e4-8cb6-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
roles WHERE uuid = '87a7ebce-b74d-11e2-a81f-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
permissions WHERE uuid = 'b3b56a8c-c2fd-11e2-a135-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
permissions WHERE uuid = 'a9801074-6fe2-11e4-9d81-406186ea4fc5';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
permissions WHERE subject_type = 'role' AND subject = (SELECT id FROM roles
WHERE uuid = 'cc9cac5e-39a3-11e4-abae-406186ea4fc5') AND resource =
0;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
permissions WHERE subject_type = 'role' AND subject = (SELECT id FROM roles
WHERE uuid = '5f8fd16c-c550-11e3-b6ab-406186ea4fc5') AND resource =
0;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
permissions WHERE subject_type = 'role' AND subject = (SELECT id FROM roles
WHERE uuid = '12cdb536-480b-11e4-8552-406186ea4fc5') AND resource =
0;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
permissions WHERE subject_type = 'role' AND subject = (SELECT id FROM roles
WHERE uuid = '8d453140-b74d-11e2-b0be-406186ea4fc5') AND resource =
0;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
permissions WHERE subject_type = 'role' AND subject = (SELECT id FROM roles
WHERE uuid = '87a7ebce-b74d-11e2-a81f-406186ea4fc5') AND resource =
0;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
settings WHERE uuid = '6765549a-934e-11e3-b358-406186ea4fc5' AND owner IS NULL;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
settings WHERE uuid = '5f5a8712-8017-11e1-8556-406186ea4fc5' AND owner IS NULL;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
settings WHERE uuid = '20f3034c-e709-11e1-87e7-406186ea4fc5' AND owner IS NULL;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
settings WHERE uuid = 'f16bb236-a32d-4cd5-a880-e0fcf2599f59' AND owner IS NULL;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
settings WHERE uuid = '77ec2444-e7f2-4a80-a59b-f4237782d93f' AND owner IS NULL;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
settings WHERE uuid = '578a1c14-e2dc-45ef-a591-89d31391d007' AND owner IS NULL;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
settings WHERE uuid = 'a6ac88c5-729c-41ba-ac0a-deea4a3441f2' AND owner IS NULL;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
settings WHERE uuid = '0872a6ed-4f85-48c5-ac3f-a5ef5e006745' AND owner IS NULL;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
settings WHERE uuid = 'e1a2ae0b-736e-4484-b029-330c9e15b900' AND owner IS NULL;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT owner,
uuid, (SELECT uuid FROM users WHERE users.id =
report_formats.owner) FROM report_formats;
md main: DEBUG:2016-04-11 11h38.20 utc:460: \
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: DELETE FROM group_users
WHERE "user" NOT IN (SELECT id FROM users);
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: DELETE FROM
group_users_trash WHERE "user" NOT IN (SELECT id FROM users);
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: DELETE FROM role_users
WHERE "user" NOT IN (SELECT id FROM users);
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: DELETE FROM
role_users_trash WHERE "user" NOT IN (SELECT id FROM users);
md main: DEBUG:2016-04-11 11h38.20 utc:460: 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: INFO:2016-04-11 11h38.20 utc:460: Updating NVT cache.
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_open: db open, max retry
sleep time is 0
md main: DEBUG:2016-04-11 11h38.20 utc:460: |
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: BEGIN EXCLUSIVE;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: DELETE FROM nvt_cves;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: DELETE FROM nvts;
md main: DEBUG:2016-04-11 11h38.20 utc:460: /
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: DELETE FROM
nvt_preferences;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT EXISTS (SELECT *
FROM permissions WHERE name = 'Super'
AND ((resource = 0) OR ((resource_type = 'user')
AND (resource = (SELECT scanners.owner
FROM scanners WHERE
uuid = '08b69003-5fc2-4037-a479-93b440211c73'))) OR
((resource_type = 'role') AND (resource
IN (SELECT DISTINCT role FROM
role_users WHERE "user"
= (SELECT scanners.owner
FROM scanners WHERE uuid
=
'08b69003-5fc2-4037-a479-93b440211c73')))) OR
((resource_type = 'group')
AND (resource IN (SELECT
DISTINCT "group" FROM group_users
WHERE "user" =
(SELECT scanners.owner FROM scanners
WHERE uuid =
'08b69003-5fc2-4037-a479-93b440211c73'))))) AND subject_location
= 0 AND ((subject_type = 'user' AND subject
= (SELECT id FROM users
WHERE users.uuid = '')) OR (subject_type = 'group'
AND subject IN (SELECT DISTINCT
"group" FROM group_users
WHERE "user" = (SELECT id
FROM users
WHERE users.uuid = '')))
OR (subject_type = 'role' AND
subject IN (SELECT DISTINCT role
FROM role_users WHERE "user"
= (SELECT id
FROM users WHERE users.uuid
= '')))));
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT count(*) FROM
scanners WHERE uuid = '08b69003-5fc2-4037-a479-93b440211c73' AND ((owner IS
NULL) OR (owner = (SELECT users.id FROM users WHERE users.uuid = '')));
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT id FROM scanners
WHERE uuid = '08b69003-5fc2-4037-a479-93b440211c73';
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT type FROM
scanners WHERE id = 1;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT host FROM
scanners WHERE id = 1;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT port FROM
scanners WHERE id = 1;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT ca_pub FROM
scanners WHERE id = 1;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT key_pub FROM
scanners WHERE id = 1;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql: SELECT key_priv FROM
scanners WHERE id = 1;
md main: DEBUG:2016-04-11 11h38.20 utc:460: sql_x end
lib serv: DEBUG:2016-04-11 11h38.20 utc:460: Connected to server on socket
7.
_______________________________________________
Openvas-discuss mailing list
[email protected]
https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
