I'm seeing a recurring issue in my logs, where the webservices module tries, and fails, to create a locationlog entry for a node, but I can't seem to figure out why. I saw one other thread that seemed related, but the circumstances leading up to the error didn't seem the same as mine. This just seems to happen whenever PF sees a new device (i've anonymized the MAC, in case you're wondering about 'XX'):
Oct 29 15:58:19 httpd.aaa(31090) INFO: [XX:f8:1d:b3:77:36] handling radius autz request: from switch_ip => (172.18.36.2), connection_type => Wireless-802.11-EAP,switch_mac => (18:e7:28:7d:b1:40), mac => [XX:f8:1d:b3:77:36], port => 1, username => "jeremyf" (pf::radius::authorize) Oct 29 15:58:19 httpd.aaa(31090) INFO: [XX:f8:1d:b3:77:36] does not yet exist in database. Adding it now (pf::radius::authorize) Oct 29 15:58:19 httpd.aaa(31090) INFO: [XX:f8:1d:b3:77:36] is of status unreg; belongs into registration VLAN (pf::vlan::getRegistrationVlan) Oct 29 15:58:19 httpd.aaa(31090) INFO: [XX:f8:1d:b3:77:36] (172.18.36.2) Returning ACCEPT with VLAN 2 and role (pf::Switch::returnRadiusAccessAccept) Oct 29 15:58:32 httpd.webservices(31126) INFO: Instantiate profile With-dot1x (pf::Portal::ProfileFactory::instantiate) Oct 29 15:58:32 httpd.webservices(31126) WARN: unable to convert connection_type to string. called from pf::api pf::locationlog::locationlog_insert_closed (pf::config::util::connection_type_to_str) Oct 29 15:58:32 httpd.webservices(31126) INFO: Asked to insert a locationlog entry with connection type unknown. (pf::locationlog::locationlog_insert_closed) Oct 29 15:58:32 httpd.webservices(31126) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Oct 29 15:58:32 httpd.webservices(31126) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Oct 29 15:58:32 httpd.webservices(31126) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Oct 29 15:58:32 httpd.webservices(31126) ERROR: Database issue: We tried 3 times to serve query locationlog_insert_closed_sql called from pf::locationlog::locationlog_insert_closed and we failed. Is the database running? (pf::db::db_query_execute) Oct 29 15:58:32 httpd.webservices(31126) INFO: Instantiate profile With-dot1x (pf::Portal::ProfileFactory::instantiate) Oct 29 15:58:47 httpd.webservices(31126) WARN: unable to convert connection_type to string. called from pf::api pf::locationlog::locationlog_insert_closed (pf::config::util::connection_type_to_str) Oct 29 15:58:47 httpd.webservices(31126) INFO: Asked to insert a locationlog entry with connection type unknown. (pf::locationlog::locationlog_insert_closed) Oct 29 15:58:47 httpd.webservices(31126) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Oct 29 15:58:47 httpd.webservices(31126) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Oct 29 15:58:47 httpd.webservices(31126) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Oct 29 15:58:47 httpd.webservices(31126) ERROR: Database issue: We tried 3 times to serve query locationlog_insert_closed_sql called from pf::locationlog::locationlog_insert_closed and we failed. Is the database running? (pf::db::db_query_execute) Oct 29 15:58:47 httpd.webservices(31126) INFO: Instantiate profile With-dot1x (pf::Portal::ProfileFactory::instantiate) Oct 29 15:59:40 httpd.aaa(31090) INFO: [3c:15:c2:e1:6c:66] handling radius autz request: from switch_ip => (172.18.36.2), connection_type => Wireless-802.11-EAP,switch_mac => (20:3a:07:e4:54 Dale Whiteaker-Lewis Security Engineering Indeed
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
