Hello to everyone, I'm trying to integrate GVM 20.08 with PF 10.2. The scan task is created and started with success, but then in "packetfence.log" I'm not seeing any log about the report. If I get it right, GVM has to send back a report to PacketFence after the scanning is complete.
All I'm seeing is a suspicious warning alert: "Warning: 1048: Column 'report_id' cannot be null (pf::dal::db_execute)". For this reason I entered the MySQL database in PacketFence and checked the "scan" table, this is the result: MariaDB [pf]> SELECT * FROM scan; +------------------+-----------+----------------+----------------+---------+---------------------+---------------------+---------+-----------+ | id | tenant_id | ip | mac | type | start_date | update_date | status | report_id | +------------------+-----------+----------------+----------------+---------+---------------------+---------------------+---------+-----------+ | 16147789469415f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 14:42:26 | 2021-03-03 14:42:26 | started | | | 16147801673515f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 15:02:47 | 2021-03-03 15:02:47 | started | | | 16147815671615f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 15:26:07 | 2021-03-03 15:26:08 | started | | | 16147835106915f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 15:58:30 | 2021-03-03 15:58:30 | started | | | 16147836276515f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 16:00:27 | 2021-03-03 16:00:27 | started | | | 16147837829515f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 16:03:02 | 2021-03-03 16:03:03 | started | | | 16147854223415f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 16:30:22 | 2021-03-03 16:30:22 | started | | | 16147881864515f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 17:16:26 | 2021-03-03 17:16:26 | started | | | 16147883733415f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 17:19:33 | 2021-03-03 17:19:33 | started | | | 1614789990615f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 17:46:30 | 2021-03-03 17:46:31 | started | | | 16147911416815f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-03 18:05:41 | 2021-03-03 18:05:42 | started | | | 1614846375715f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-04 09:26:15 | 0000-00-00 00:00:00 | new | NULL | | 16148467124915f5 | 1 | 192.168.10.112 | 192.168.10.112 | openvas | 2021-03-04 09:31:52 | 2021-03-04 09:31:52 | started | | +------------------+-----------+----------------+----------------+---------+---------------------+---------------------+---------+-----------+ 13 rows in set (0.00 sec) I setup GVM 20.08 on Debian 10 not in the same PF server which is on Debian 9 Stretch. Can someone explain me how to get task's report from GVM 20.08 to PF please? Also a clear explaination of the integration between PF and GVM would be very usefull. Some logs: #REPORT WITHOUT DEBUG Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Instantiate profile MAB (pf::Connection::ProfileFactory::_from_profile) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] grace expired on security event 1200005 for node f8:a9:63:2a:15:f5 (pf::security_event::security_event_add) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] security event 1200005 added for f8:a9:63:2a:15:f5 as open (pf::security_event::security_event_add) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] executing action 'log' on class 1200005 (pf::action::action_execute) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] /usr/local/pf/logs/security_event.log 2021-03-04 09:31:51: Pre Reg System Scan (1200005) detected on node f8:a9:63:2a:15:f5 (192.168.10.112) (pf::action::action_log) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Pre Registration Scan - Current Scan Engine is : OpenVAS (pf::api::trigger_scan) Mar 4 09:31:51 debian pfqueue: pfqueue(2521) WARN: [mac:f8:a9:63:2a:15:f5] Unable to match MAC address to IP '192.168.10.112' (pf::ip4log::ip2mac) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Instantiate profile MAB (pf::Connection::ProfileFactory::_from_profile) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] grace expired on security event 1200005 for node f8:a9:63:2a:15:f5 (pf::security_event::security_event_add) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] security event 1200005 added for f8:a9:63:2a:15:f5 as open (pf::security_event::security_event_add) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] executing action 'log' on class 1200005 (pf::action::action_execute) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] /usr/local/pf/logs/security_event.log 2021-03-04 09:31:51: Pre Reg System Scan (1200005) detected on node f8:a9:63:2a:15:f5 (192.168.10.112) (pf::action::action_log) Mar 4 09:31:51 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Pre Registration Scan - Current Scan Engine is : OpenVAS (pf::api::trigger_scan) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Instantiate profile MAB (pf::Connection::ProfileFactory::_from_profile) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] New ID generated: 16148467124915f5 (pf::util::generate_id) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] CREATING a new scan target named 16148467124915f51614846712.04995 for host 192.168.10.112 (pf::scan::openvas::createTarget) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Instantiate profile MAB (pf::Connection::ProfileFactory::_from_profile) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] New ID generated: 16148467124915f5 (pf::util::generate_id) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] CREATING a new scan target named 16148467124915f51614846712.04995 for host 192.168.10.112 (pf::scan::openvas::createTarget) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan target named 16148467124915f51614846712.04995 successfully created with id: cbd4b153-d37f-4f77-a3ff-dbd458bd58ad (pf::scan::openvas::createTarget) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Creating a new scan task named 16148467124915f51614846712.04995 (pf::scan::openvas::createTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan task named 16148467124915f51614846712.04995 successfully created with id: 3bbfd1e2-ab3b-469f-8a17-1509235c0a6a (pf::scan::openvas::createTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Starting scan task named 16148467124915f51614846712.04995 (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan task starting command: omp -h 192.168.50.228 -p 9390 -u admin -w admin -X '<start_task task_id="3bbfd1e2-ab3b-469f-8a17-1509235c0a6a"/>' (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan target named 16148467124915f51614846712.04995 successfully created with id: cbd4b153-d37f-4f77-a3ff-dbd458bd58ad (pf::scan::openvas::createTarget) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Creating a new scan task named 16148467124915f51614846712.04995 (pf::scan::openvas::createTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan task named 16148467124915f51614846712.04995 successfully created with id: 3bbfd1e2-ab3b-469f-8a17-1509235c0a6a (pf::scan::openvas::createTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan task starting output: <start_task_response status_text="OK, request submitted" status="202"><report_id>1c487ea7-7aef-4f3e-b71e-e6a4ef4690a2</report_id></start_task_response> (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] REPORT ID: 1c487ea7-7aef-4f3e-b71e-e6a4ef4690a2 (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan task named 16148467124915f51614846712.04995 successfully started (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Starting scan task named 16148467124915f51614846712.04995 (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan task starting command: omp -h 192.168.50.228 -p 9390 -u admin -w admin -X '<start_task task_id="3bbfd1e2-ab3b-469f-8a17-1509235c0a6a"/>' (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan task starting output: <start_task_response status_text="OK, request submitted" status="202"><report_id>1c487ea7-7aef-4f3e-b71e-e6a4ef4690a2</report_id></start_task_response> (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] REPORT ID: 1c487ea7-7aef-4f3e-b71e-e6a4ef4690a2 (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) INFO: [mac:f8:a9:63:2a:15:f5] Scan task named 16148467124915f51614846712.04995 successfully started (pf::scan::openvas::startTask) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) WARN: [mac:f8:a9:63:2a:15:f5] Warning: 1048: Column 'report_id' cannot be null (pf::dal::db_execute) Mar 4 09:31:52 debian pfqueue: pfqueue(11919) WARN: [mac:f8:a9:63:2a:15:f5] Warning: 1048: Column 'report_id' cannot be null (pf::dal::db_execute) Mar 4 09:32:04 debian pfqueue: pfqueue(12142) INFO: [mac:f8:a9:63:2a:15:f5] Instantiate profile MAB (pf::Connection::ProfileFactory::_from_profile) Mar 4 09:32:04 debian pfqueue: pfqueue(12142) INFO: [mac:f8:a9:63:2a:15:f5] 3587 grace remaining on security event 1200005 for node f8:a9:63:2a:15:f5. Not adding security_event. (pf::security_event::security_event_add) Mar 4 09:32:04 debian pfqueue: pfqueue(12142) INFO: [mac:f8:a9:63:2a:15:f5] Instantiate profile MAB (pf::Connection::ProfileFactory::_from_profile) #REPORT WITH DEBUG Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Trying to match IP address to MAC 'f8:a9:63:2a:15:f5' using SQL 'ip4log' table (pf::ip4log::mac2ip) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Viewing an 'ip4log' table entry for the following MAC address 'f8:a9:63:2a:15:f5' (pf::ip4log::_view_by_mac) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] preparing statement query SELECT `mac`, `ip`, `start_time`, `end_time` FROM `ip4log` WHERE ( ( ( `end_time` = ? OR (end_time + INTERVAL 30 SECOND) > NOW() ) AND `ip4log`.`tenant_id` = ? AND `mac` = ? ) ) ORDER BY `start_time` DESC LIMIT ? OFFSET ? with bind (0000-00-00 00:00:00, 1, f8:a9:63:2a:15:f5, 1, 0) at /usr/local/pf/lib/pf/ dal.pm line 984. Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Matched MAC 'f8:a9:63:2a:15:f5' to IP address '192.168.10.112' using SQL 'ip4log' table (pf::ip4log::mac2ip) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key FilterEngine::Profile() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key FilterEngine::Profile() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Profiles() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Instantiate profile MAB (pf::Connection::ProfileFactory::_from_profile) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Profiles() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] instantiating new pf::Connection::Profile object (pf::Connection::Profile::new) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Generating a new ID with epoch 1614848084 and mac f8:a9:63:2a:15:f5 (pf::util::generate_id) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] New ID generated: 16148480847215f5 (pf::util::generate_id) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] preparing statement query INSERT INTO `scan` ( `id`, `ip`, `mac`, `report_id`, `start_date`, `status`, `tenant_id`, `type`, `update_date`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) with bind (16148480847215f5, 192.168.10.112, 192.168.10.112, NULL, 2021-03-04 09:54:44, new, 1, openvas, 0000-00-00 00:00:00) at /usr/local/pf/lib/pf/ dal.pm line 1136. Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] CREATING a new scan target named 16148480847215f51614848084.25977 for host 192.168.10.112 (pf::scan::openvas::createTarget) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Scan target creation command: omp -h 192.168.50.228 -p 9390 -u admin -w admin -X '<create_target><name>16148480847215f51614848084.25977</name><port_list id="33d0cd82-57c6-11e1-8ed1-406186ea4fc5"></port_list><hosts>192.168.50.56</hosts></create_target>' (pf::scan::openvas::createTarget) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Scan target creation output: <create_target_response id="30d8ec1a-7a22-4f52-8d9a-6979beb718e2" status_text="OK, resource created" status="201"></create_target_response> (pf::scan::openvas::createTarget) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan target named 16148480847215f51614848084.25977 successfully created with id: 30d8ec1a-7a22-4f52-8d9a-6979beb718e2 (pf::scan::openvas::createTarget) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Creating a new scan task named 16148480847215f51614848084.25977 (pf::scan::openvas::createTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Scan task creation command: omp -h 192.168.50.228 -p 9390 -u admin -w admin -X '<create_task><name>16148480847215f51614848084.25977</name><config id="daba56c8-73ec-11df-a475-002264764cea"/><target id="30d8ec1a-7a22-4f52-8d9a-6979beb718e2"/><alert id="dcd89bc3-a5c3-495a-a3ac-731de3cec152"/></create_task>' (pf::scan::openvas::createTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] pf::node::node_view getting 'f8:a9:63:2a:15:f5' at /usr/local/pf/lib/pf/node.pm line 373. Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] preparing statement query SELECT `node`.`tenant_id` AS `tenant_id`, `node`.`mac` AS `mac`, `node`.`pid` AS `pid`, `node`.`category_id` AS `category_id`, `node`.`detect_date` AS `detect_date`, `node`.`regdate` AS `regdate`, `node`.`unregdate` AS `unregdate`, `node`.`lastskip` AS `lastskip`, `node`.`time_balance` AS `time_balance`, `node`.`bandwidth_balance` AS `bandwidth_balance`, `node`.`status` AS `status`, `node`.`user_agent` AS `user_agent`, `node`.`computername` AS `computername`, `node`.`notes` AS `notes`, `node`.`last_arp` AS `last_arp`, `node`.`last_dhcp` AS `last_dhcp`, `node`.`dhcp_fingerprint` AS `dhcp_fingerprint`, `node`.`dhcp6_fingerprint` AS `dhcp6_fingerprint`, `node`.`dhcp_vendor` AS `dhcp_vendor`, `node`.`dhcp6_enterprise` AS `dhcp6_enterprise`, `node`.`device_type` AS `device_type`, `node`.`device_class` AS `device_class`, `node`.`device_version` AS `device_version`, `node`.`device_score` AS `device_score`, `node`.`device_manufacturer` AS `device_manufacturer`, `node`.`bypass_vlan` AS `bypass_vlan`, `node`.`voip` AS `voip`, `node`.`autoreg` AS `autoreg`, `node`.`sessionid` AS `sessionid`, `node`.`machine_account` AS `machine_account`, `node`.`bypass_role_id` AS `bypass_role_id`, `node`.`last_seen` AS `last_seen`, `nc`.`name` AS `category`, `nr`.`name` AS `bypass_role` FROM node LEFT OUTER JOIN `node_category` AS `nc` ON ( `node`.`category_id` = `nc`.`category_id` ) LEFT OUTER JOIN `node_category` AS `nr` ON ( `node`.`bypass_role_id` = `nr`.`category_id` ) WHERE ( ( `node`.`mac` = ? AND `node`.`tenant_id` = ? ) ) with bind (f8:a9:63:2a:15:f5, 1) at /usr/local/pf/lib/pf/dal.pm line 1279. Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] preparing statement query SELECT `locationlog`.`switch` AS `last_switch`, `locationlog`.`port` AS `last_port`, `locationlog`.`ifDesc` AS `last_ifDesc`, `locationlog`.`vlan` AS `last_vlan`, IF(ISNULL(`locationlog`.`connection_type`), '', `locationlog`.`connection_type`) AS `last_connection_type`, IF(ISNULL(`locationlog`.`connection_sub_type`), '', `locationlog`.`connection_sub_type`) AS `last_connection_sub_type`, `locationlog`.`dot1x_username` AS `last_dot1x_username`, `locationlog`.`ssid` AS `last_ssid`, `locationlog`.`stripped_user_name` AS `stripped_user_name`, `locationlog`.`realm` AS `realm`, `locationlog`.`switch_mac` AS `last_switch_mac`, `locationlog`.`start_time` AS `last_start_time`, `locationlog`.`end_time` AS `last_end_time`, `locationlog`.`role` AS `last_role`, UNIX_TIMESTAMP(`locationlog`.`start_time`) AS `last_start_timestamp` FROM `locationlog` WHERE ( ( `mac` = ? AND `tenant_id` = ? ) ) with bind (f8:a9:63:2a:15:f5, 1) at /usr/local/pf/lib/pf/dal.pm line 984. Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Trying to match IP address to MAC 'f8:a9:63:2a:15:f5' using SQL 'ip4log' table (pf::ip4log::mac2ip) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Viewing an 'ip4log' table entry for the following MAC address 'f8:a9:63:2a:15:f5' (pf::ip4log::_view_by_mac) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] preparing statement query SELECT `mac`, `ip`, `start_time`, `end_time` FROM `ip4log` WHERE ( ( ( `end_time` = ? OR (end_time + INTERVAL 30 SECOND) > NOW() ) AND `ip4log`.`tenant_id` = ? AND `mac` = ? ) ) ORDER BY `start_time` DESC LIMIT ? OFFSET ? with bind (0000-00-00 00:00:00, 1, f8:a9:63:2a:15:f5, 1, 0) at /usr/local/pf/lib/pf/ dal.pm line 984. Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Matched MAC 'f8:a9:63:2a:15:f5' to IP address '192.168.10.112' using SQL 'ip4log' table (pf::ip4log::mac2ip) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key FilterEngine::Profile() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key FilterEngine::Profile() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Profiles() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Instantiate profile MAB (pf::Connection::ProfileFactory::_from_profile) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Profiles() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::authentication_sources() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] instantiating new pf::Connection::Profile object (pf::Connection::Profile::new) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Generating a new ID with epoch 1614848084 and mac f8:a9:63:2a:15:f5 (pf::util::generate_id) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] New ID generated: 16148480847215f5 (pf::util::generate_id) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] preparing statement query INSERT INTO `scan` ( `id`, `ip`, `mac`, `report_id`, `start_date`, `status`, `tenant_id`, `type`, `update_date`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) with bind (16148480847215f5, 192.168.10.112, 192.168.10.112, NULL, 2021-03-04 09:54:44, new, 1, openvas, 0000-00-00 00:00:00) at /usr/local/pf/lib/pf/ dal.pm line 1136. Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] CREATING a new scan target named 16148480847215f51614848084.25977 for host 192.168.10.112 (pf::scan::openvas::createTarget) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Scan target creation command: omp -h 192.168.50.228 -p 9390 -u admin -w admin -X '<create_target><name>16148480847215f51614848084.25977</name><port_list id="33d0cd82-57c6-11e1-8ed1-406186ea4fc5"></port_list><hosts>192.168.50.56</hosts></create_target>' (pf::scan::openvas::createTarget) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Scan target creation output: <create_target_response id="30d8ec1a-7a22-4f52-8d9a-6979beb718e2" status_text="OK, resource created" status="201"></create_target_response> (pf::scan::openvas::createTarget) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan target named 16148480847215f51614848084.25977 successfully created with id: 30d8ec1a-7a22-4f52-8d9a-6979beb718e2 (pf::scan::openvas::createTarget) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Creating a new scan task named 16148480847215f51614848084.25977 (pf::scan::openvas::createTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Scan task creation command: omp -h 192.168.50.228 -p 9390 -u admin -w admin -X '<create_task><name>16148480847215f51614848084.25977</name><config id="daba56c8-73ec-11df-a475-002264764cea"/><target id="30d8ec1a-7a22-4f52-8d9a-6979beb718e2"/><alert id="dcd89bc3-a5c3-495a-a3ac-731de3cec152"/></create_task>' (pf::scan::openvas::createTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Scan task creation output: <create_task_response id="b74da615-ae95-44cd-aa05-ae05cd8fbadc" status_text="OK, resource created" status="201"></create_task_response> (pf::scan::openvas::createTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan task named 16148480847215f51614848084.25977 successfully created with id: b74da615-ae95-44cd-aa05-ae05cd8fbadc (pf::scan::openvas::createTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Starting scan task named 16148480847215f51614848084.25977 (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan task starting command: omp -h 192.168.50.228 -p 9390 -u admin -w admin -X '<start_task task_id="b74da615-ae95-44cd-aa05-ae05cd8fbadc"/>' (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan task starting output: <start_task_response status_text="OK, request submitted" status="202"><report_id>d234d397-9534-4a63-8715-1c58cc3cc4ef</report_id></start_task_response> (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] REPORT ID: d234d397-9534-4a63-8715-1c58cc3cc4ef (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan task named 16148480847215f51614848084.25977 successfully started (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] (Re)Connecting to MySQL (pid: 1818) (pf::CHI::db::db_connect) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] connected (pf::CHI::db::db_connect) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] checking handle (pf::CHI::db::is_old_connection_good) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] we are currently connected (pf::CHI::db::is_old_connection_good) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] not checking db handle, it has been less than 30 sec from last connection (pf::CHI::db::is_old_connection_good) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] cache set for namespace='openvas_scans', key='info-16148480847215f51614848084.25977', size=127, expires='2h', cache='DBI', time='0ms' (CHI::Driver::_log_set_result) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] preparing statement query UPDATE `scan` SET `report_id` = ?, `status` = ? WHERE ( ( `id` = ? AND `scan`.`tenant_id` = ? ) ) with bind ((undef), started, 16148480847215f5, 1) at /usr/local/pf/lib/pf/dal.pm line 1164. Mar 4 09:54:44 debian pfqueue: pfqueue(1818) WARN: [mac:f8:a9:63:2a:15:f5] Warning: 1048: Column 'report_id' cannot be null (pf::dal::db_execute) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] Scan task creation output: <create_task_response id="b74da615-ae95-44cd-aa05-ae05cd8fbadc" status_text="OK, resource created" status="201"></create_task_response> (pf::scan::openvas::createTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan task named 16148480847215f51614848084.25977 successfully created with id: b74da615-ae95-44cd-aa05-ae05cd8fbadc (pf::scan::openvas::createTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Starting scan task named 16148480847215f51614848084.25977 (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan task starting command: omp -h 192.168.50.228 -p 9390 -u admin -w admin -X '<start_task task_id="b74da615-ae95-44cd-aa05-ae05cd8fbadc"/>' (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key resource::unified_api_system_user() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan task starting output: <start_task_response status_text="OK, request submitted" status="202"><report_id>d234d397-9534-4a63-8715-1c58cc3cc4ef</report_id></start_task_response> (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] REPORT ID: d234d397-9534-4a63-8715-1c58cc3cc4ef (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) INFO: [mac:f8:a9:63:2a:15:f5] Scan task named 16148480847215f51614848084.25977 successfully started (pf::scan::openvas::startTask) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] (Re)Connecting to MySQL (pid: 1818) (pf::CHI::db::db_connect) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] connected (pf::CHI::db::db_connect) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] checking handle (pf::CHI::db::is_old_connection_good) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] we are currently connected (pf::CHI::db::is_old_connection_good) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] not checking db handle, it has been less than 30 sec from last connection (pf::CHI::db::is_old_connection_good) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) DEBUG: [mac:f8:a9:63:2a:15:f5] cache set for namespace='openvas_scans', key='info-16148480847215f51614848084.25977', size=127, expires='2h', cache='DBI', time='0ms' (CHI::Driver::_log_set_result) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] preparing statement query UPDATE `scan` SET `report_id` = ?, `status` = ? WHERE ( ( `id` = ? AND `scan`.`tenant_id` = ? ) ) with bind ((undef), started, 16148480847215f5, 1) at /usr/local/pf/lib/pf/dal.pm line 1164. Mar 4 09:54:44 debian pfqueue: pfqueue(1818) WARN: [mac:f8:a9:63:2a:15:f5] Warning: 1048: Column 'report_id' cannot be null (pf::dal::db_execute) Mar 4 09:54:44 debian pfqueue: pfqueue(1818) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) DEBUG: [mac:unknown] instantiating new pf::inline object (pf::inline::new) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] preparing statement query SELECT `node`.`tenant_id` AS `tenant_id`, `node`.`mac` AS `mac`, `node`.`pid` AS `pid`, `node`.`category_id` AS `category_id`, `node`.`detect_date` AS `detect_date`, `node`.`regdate` AS `regdate`, `node`.`unregdate` AS `unregdate`, `node`.`lastskip` AS `lastskip`, `node`.`time_balance` AS `time_balance`, `node`.`bandwidth_balance` AS `bandwidth_balance`, `node`.`status` AS `status`, `node`.`user_agent` AS `user_agent`, `node`.`computername` AS `computername`, `node`.`notes` AS `notes`, `node`.`last_arp` AS `last_arp`, `node`.`last_dhcp` AS `last_dhcp`, `node`.`dhcp_fingerprint` AS `dhcp_fingerprint`, `node`.`dhcp6_fingerprint` AS `dhcp6_fingerprint`, `node`.`dhcp_vendor` AS `dhcp_vendor`, `node`.`dhcp6_enterprise` AS `dhcp6_enterprise`, `node`.`device_type` AS `device_type`, `node`.`device_class` AS `device_class`, `node`.`device_version` AS `device_version`, `node`.`device_score` AS `device_score`, `node`.`device_manufacturer` AS `device_manufacturer`, `node`.`bypass_vlan` AS `bypass_vlan`, `node`.`voip` AS `voip`, `node`.`autoreg` AS `autoreg`, `node`.`sessionid` AS `sessionid`, `node`.`machine_account` AS `machine_account`, `node`.`bypass_role_id` AS `bypass_role_id`, `node`.`last_seen` AS `last_seen`, `nc`.`name` AS `category`, `nr`.`name` AS `bypass_role` FROM node LEFT OUTER JOIN `node_category` AS `nc` ON ( `node`.`category_id` = `nc`.`category_id` ) LEFT OUTER JOIN `node_category` AS `nr` ON ( `node`.`bypass_role_id` = `nr`.`category_id` ) WHERE ( ( `node`.`mac` = ? AND `node`.`tenant_id` = ? ) ) with bind (f8:a9:63:2a:15:f5, 1) at /usr/local/pf/lib/pf/dal.pm line 1279. Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] preparing statement query SELECT `locationlog`.`switch` AS `last_switch`, `locationlog`.`port` AS `last_port`, `locationlog`.`ifDesc` AS `last_ifDesc`, `locationlog`.`vlan` AS `last_vlan`, IF(ISNULL(`locationlog`.`connection_type`), '', `locationlog`.`connection_type`) AS `last_connection_type`, IF(ISNULL(`locationlog`.`connection_sub_type`), '', `locationlog`.`connection_sub_type`) AS `last_connection_sub_type`, `locationlog`.`dot1x_username` AS `last_dot1x_username`, `locationlog`.`ssid` AS `last_ssid`, `locationlog`.`stripped_user_name` AS `stripped_user_name`, `locationlog`.`realm` AS `realm`, `locationlog`.`switch_mac` AS `last_switch_mac`, `locationlog`.`start_time` AS `last_start_time`, `locationlog`.`end_time` AS `last_end_time`, `locationlog`.`role` AS `last_role`, UNIX_TIMESTAMP(`locationlog`.`start_time`) AS `last_start_timestamp` FROM `locationlog` WHERE ( ( `mac` = ? AND `tenant_id` = ? ) ) with bind (f8:a9:63:2a:15:f5, 1) at /usr/local/pf/lib/pf/dal.pm line 984. Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] preparing statement query INSERT INTO `node` ( `autoreg`, `bandwidth_balance`, `bypass_role_id`, `bypass_vlan`, `category_id`, `computername`, `detect_date`, `device_class`, `device_manufacturer`, `device_score`, `device_type`, `device_version`, `dhcp6_enterprise`, `dhcp6_fingerprint`, `dhcp_fingerprint`, `dhcp_vendor`, `last_arp`, `last_dhcp`, `last_seen`, `lastskip`, `mac`, `machine_account`, `notes`, `pid`, `regdate`, `sessionid`, `status`, `tenant_id`, `time_balance`, `unregdate`, `user_agent`, `voip`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ON DUPLICATE KEY UPDATE `last_dhcp` = ?, `tenant_id` = ? with bind (no, (undef), (undef), (undef), (undef), LenovoUbuntu, 2021-03-04 09:54:04, (undef), (undef), (undef), (undef), (undef), (undef), (undef), 1,3,12,15,6,2,26,28,121,33,40,41,42,54,119,249,252,17, , 0000-00-00 00:00:00, 2021-03-04 09:54:57, 2021-03-04 09:54:44, 0000-00-00 00:00:00, f8:a9:63:2a:15:f5, (undef), (undef), default, 0000-00-00 00:00:00, (undef), unreg, 1, (undef), 0000-00-00 00:00:00, (undef), no, 2021-03-04 09:54:57, 1) at /usr/local/pf/lib/pf/dal.pm line 1150. Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] instantiating new pf::inline object (pf::inline::new) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] Memory configuration is still valid for key FilterEngine::DhcpScopes() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] Instantiate a new iptables modification method. pf::ipset (pf::inline::get_technique) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] instantiating new pf::iptables object (pf::iptables::new) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) DEBUG: [mac:unknown] cache get for namespace='fingerbank', key='fingerbank::Config::read_config', cache='Redis', time='0ms': HIT (CHI::Driver::_log_get_result) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) DEBUG: [mac:unknown] cache get for namespace='fingerbank', key='fingerbank::Config::read_config-cached_at', cache='Redis', time='0ms': HIT (CHI::Driver::_log_get_result) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) DEBUG: [mac:unknown] Skipping Fingerbank processing because no API key is configured (pf::fingerbank::process) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] instantiating new pf::access_filter::dhcp (pf::access_filter::new) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) DEBUG: [mac:unknown] Skipping Fingerbank processing because no API key is configured (pf::fingerbank::process) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18440) TRACE: [mac:unknown] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] instantiating new pf::access_filter::dhcp (pf::access_filter::new) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Network(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] cache get for namespace='Default', key='inreadonly', cache='RawMemory', time='0ms': MISS (expired) (CHI::Driver::_log_get_result) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] checking handle (pf::db::is_old_connection_good) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] we are currently connected (pf::db::is_old_connection_good) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] not checking db handle, it has been less than 30 sec from last connection (pf::db::is_old_connection_good) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] No wsrep provider so considering wsrep as healthy (pf::db::db_wsrep_healthy) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] cache set for namespace='Default', key='inreadonly', size=1, expires='5s', cache='RawMemory', time='0ms' (CHI::Driver::_log_set_result) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] preparing statement query SELECT 1 FROM `node` WHERE ( ( `node`.`mac` = ? AND `node`.`tenant_id` = ? ) ) LIMIT ? OFFSET ? with bind (f8:a9:63:2a:15:f5, 1, 1, 0) at /usr/local/pf/lib/pf/dal.pm line 984. Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] Viewing an 'ip4log' table entry for the following MAC address 'f8:a9:63:2a:15:f5' (pf::ip4log::_view_by_mac) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] preparing statement query SELECT `mac`, `ip`, `start_time`, `end_time` FROM `ip4log` WHERE ( ( ( `end_time` = ? OR (end_time + INTERVAL 30 SECOND) > NOW() ) AND `ip4log`.`tenant_id` = ? AND `mac` = ? ) ) ORDER BY `start_time` DESC LIMIT ? OFFSET ? with bind (0000-00-00 00:00:00, 1, f8:a9:63:2a:15:f5, 1, 0) at /usr/local/pf/lib/pf/dal.pm line 984. Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:unknown] Viewing an 'ip4log' table entry for the following IP address '192.168.10.112' (pf::ip4log::_view_by_ip) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] preparing statement query SELECT `mac`, `ip`, `start_time`, `end_time` FROM `ip4log` WHERE ( ( ( `end_time` = ? OR (end_time + INTERVAL 30 SECOND) > NOW() ) AND `ip` = ? AND `ip4log`.`tenant_id` = ? ) ) ORDER BY `start_time` DESC LIMIT ? OFFSET ? with bind (0000-00-00 00:00:00, 192.168.10.112, 1, 1, 0) at /usr/local/pf/lib/pf/dal.pm line 984. Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key resource::stats_levels() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] preparing statement query UPDATE `node` SET `last_seen` = NOW() WHERE ( ( `mac` = ? AND `node`.`tenant_id` = ? ) ) with bind (f8:a9:63:2a:15:f5, 1) at /usr/local/pf/lib/pf/dal.pm line 1164. Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:unknown] Memory configuration is still valid for key config::Pf(debian) in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) TRACE: [mac:f8:a9:63:2a:15:f5] Memory configuration is still valid for key config::Firewall_SSO() in local cached_hash (pfconfig::cached::is_valid) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:f8:a9:63:2a:15:f5] Trying to do firewall SSO without any firewall SSO configured. Exiting (pf::firewallsso::do_sso) Mar 4 09:54:57 debian pfqueue: pfqueue(18446) DEBUG: [mac:f8:a9:63:2a:15:f5] Fork trigger_scan off (pf::api::can_fork::notify) #SECURITY_EVENTS.CONF file: /usr/local/pf/conf/security_events.conf # Example config to block a whole class of devices based on their MAC address vendor # Trigger format: The number is the ID of the MAC vendor from the 'MAC Vendor' list in Fingerbank (either 'upstream' or 'local' or both) # # The below example blocks MAC Vendor ID 42 which is 'IMC Networks corp.' # [1100003] trigger=internal::node_discovered actions=reevaluate_access,log window=dynamic auto_enable=N access_duration=12h [1200005] window=dynamic trigger= access_duration=12h # Copyright (C) Inverse inc. #SCAN.CONF file: /usr/local/pf/conf/scan.conf [OpenVAS] openvas_alertid=dcd89bc3-a5c3-495a-a3ac-731de3cec152 openvas_reportformatid=c1645568-627a-11e3-a660-406186ea4fc5 password=admin ip=192.168.50.228 categories= pre_registration=1 oses= port=9390 openvas_configid=daba56c8-73ec-11df-a475-002264764cea username=admin post_registration=1 type=openvas registration=0 duration=20s #PF.CONF [interface ens18.10] enforcement=vlan mask=255.255.255.0 type=internal ip=192.168.10.100 [interface ens18.20] ip=192.168.20.100 type=internal mask=255.255.255.0 enforcement=vlan [interface ens18.30] mask=255.255.255.0 type=other,dhcp-listener [interface ens18] ip=192.168.50.56 type=management,portal mask=255.255.255.0
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
