Hi Looking for some help with VOIP auto registration on stacked cisco
3750's
it's an out the box packet fence zen 9.1 setup all works fine until I plug
in an ip phone then packetfence.log gives me:
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) INFO:
[mac:08:00:0f:7d:73:aa] secureMacAddrViolation trap received on 10.4.4.230
ifIndex 10018 for 08:00:0f:7d:73:aa
(pf::task::pfsnmp::handleSecureMacAddrViolationTrap)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) INFO:
[mac:08:00:0f:7d:73:aa] Will try to check on this node's previous switch if
secured entry needs to be removed. Old Switch IP: 10.4.4.230
(pf::task::pfsnmp::do_port_security)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) INFO:
[mac:08:00:0f:7d:73:aa] MAC not found on node's previous switch secure
table or switch inaccessible. (pf::task::pfsnmp::do_port_security)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) WARN:
[mac:08:00:0f:7d:73:aa] Use of uninitialized value $pid in concatenation
(.) or string at /usr/local/pf/lib/pf/node.pm line 630.
(pf::node::node_register)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) INFO:
[mac:08:00:0f:7d:73:aa] creating person because it doesn't exist
(pf::node::node_register)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: Use of uninitialized value $pid in
concatenation (.) or string at /usr/local/pf/lib/pf/node.pm line 630.
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Trying to save a NULL value in a non nullable field
person.pid (pf::dal::validate_field)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Skipping invalid value (NULL) in when inserting
field person.pid (pf::dal::_insert_data)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Database query failed with non retryable error:
Duplicate entry '1-' for key 'PRIMARY' (errno: 1062) [INSERT INTO `person`
( `address`, `anniversary`, `apartment_number`, `birthday`,
`building_number`, `cell_phone`, `company`, `custom_field_1`,
`custom_field_2`, `custom_field_3`, `custom_field_4`, `custom_field_5`,
`custom_field_6`, `custom_field_7`, `custom_field_8`, `custom_field_9`,
`email`, `firstname`, `gender`, `lang`, `lastname`, `nickname`, `notes`,
`portal`, `potd`, `psk`, `room_number`, `source`, `sponsor`, `telephone`,
`tenant_id`, `title`, `work_phone`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)]{NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, no,
NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL} (pf::dal::db_execute)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) WARN:
[mac:08:00:0f:7d:73:aa] Use of uninitialized value $pid in concatenation
(.) or string at /usr/local/pf/lib/pf/person.pm line 135.
(pf::person::person_add)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: Use of uninitialized value $pid in
concatenation (.) or string at /usr/local/pf/lib/pf/person.pm line 135.
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] attempt to add existing person
(pf::person::person_add)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3303) INFO: [mac:unknown]
undefined source id provided (pf::lookup::person::lookup_person)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Trying to save a NULL value in a non nullable field
person.pid (pf::dal::validate_field)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Skipping invalid value (NULL) in when inserting
field person.pid (pf::dal::_insert_data)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Trying to save a NULL value in a non nullable field
person.pid (pf::dal::validate_field)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Skipping invalid value (NULL) in when inserting
field person.pid (pf::dal::_insert_data)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) WARN:
[mac:08:00:0f:7d:73:aa] Use of uninitialized value $pid in lc at
/usr/local/pf/lib/pf/person.pm line 252.
(pf::person::person_modify)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) WARN:
[mac:08:00:0f:7d:73:aa] Use of uninitialized value $new_pid in lc at
/usr/local/pf/lib/pf/person.pm line 252.
(pf::person::person_modify)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: Use of uninitialized value $pid in
lc at /usr/local/pf/lib/pf/person.pm line 252.
Nov 2 10:40:06 PacketFence-ZEN pfqueue: Use of uninitialized value
$new_pid in lc at /usr/local/pf/lib/pf/person.pm line 252.
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Trying to save a NULL value in a non nullable field
person.pid (pf::dal::validate_field)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Skipping invalid value (NULL) in when inserting
field person.pid (pf::dal::_insert_data)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Trying to save a NULL value in a non nullable field
person.pid (pf::dal::validate_field)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Skipping invalid value (NULL) in when inserting
field person.pid (pf::dal::_insert_data)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) WARN:
[mac:08:00:0f:7d:73:aa] Use of uninitialized value $pid in string ne at
/usr/local/pf/lib/pf/person.pm line 261.
(pf::person::person_modify)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) WARN:
[mac:08:00:0f:7d:73:aa] Use of uninitialized value $new_pid in string ne at
/usr/local/pf/lib/pf/person.pm line 261.
(pf::person::person_modify)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: Use of uninitialized value $pid in
string ne at /usr/local/pf/lib/pf/person.pm line 261.
Nov 2 10:40:06 PacketFence-ZEN pfqueue: Use of uninitialized value
$new_pid in string ne at /usr/local/pf/lib/pf/person.pm line 261.
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) WARN:
[mac:08:00:0f:7d:73:aa] Use of uninitialized value $pid in string eq at
/usr/local/pf/lib/pf/node.pm line 1061.
(pf::node::is_max_reg_nodes_reached)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: Use of uninitialized value $pid in
string eq at /usr/local/pf/lib/pf/node.pm line 1061.
Nov 2 10:40:06 PacketFence-ZEN pfqueue: Use of uninitialized value $pid in
string eq at /usr/local/pf/lib/pf/node.pm line 1061.
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) WARN:
[mac:08:00:0f:7d:73:aa] Use of uninitialized value $pid in string eq at
/usr/local/pf/lib/pf/node.pm line 1061.
(pf::node::is_max_reg_nodes_reached)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Trying to save a NULL value in a non nullable field
node.pid (pf::dal::validate_field)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Skipping invalid value (NULL) in when inserting
field node.pid (pf::dal::_insert_data)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Trying to save a NULL value in a non nullable field
node.pid (pf::dal::validate_field)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) ERROR:
[mac:08:00:0f:7d:73:aa] Skipping invalid value (NULL) in when updating
field node.pid (pf::dal::_update_data)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) INFO:
[mac:08:00:0f:7d:73:aa] security_event 1300003 force-closed for
08:00:0f:7d:73:aa (pf::security_event::security_event_force_close)
Nov 2 10:40:06 PacketFence-ZEN pfqueue: pfqueue(3294) INFO:
[mac:08:00:0f:7d:73:aa] Instantiate profile default
(pf::Connection::ProfileFactory::_from_profile)
Nov 2 10:40:07 PacketFence-ZEN pfqueue: pfqueue(3294) INFO:
[mac:08:00:0f:7d:73:aa] authorizing VoIP 08:00:0f:7d:73:aa at new location
10.4.4.230 ifIndex 10018 VLAN 101
(pf::task::pfsnmp::handleSecureMacAddrViolationTrap)
Nov 2 10:40:07 PacketFence-ZEN pfqueue: pfqueue(3294) WARN:
[mac:08:00:0f:7d:73:aa] SNMP error tyring to remove or add secure rows to
ifIndex 10018 in port-security table. This could be normal. Error message:
Received commitFailed(14) error-status at error-index 1
(pf::Switch::Cisco::Catalyst_2960::authorizeMAC)
this repeats every few seconds I guess something is missing in my config
but have no idear what
any sugestions?
thanks
Steven
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
