Hi list,
when I change from from grace to Registered:
May 23 14:52:25 httpd.admin(0) INFO: grace expired on violation 1200001 for
node 00:0b:5d:23:02:4d (pf::violation::violation_add)
May 23 14:52:25 httpd.admin(0) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`violation`,
CONSTRAINT `0_61` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
May 23 14:52:25 httpd.admin(0) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`violation`,
CONSTRAINT `0_61` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
May 23 14:52:25 httpd.admin(0) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`violation`,
CONSTRAINT `0_61` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
May 23 14:52:25 httpd.admin(0) ERROR: Database issue: We tried 3 times to
serve query violation_add_sql called from pf::violation::violation_add and
we failed. Is the database running? (pf::db::db_query_execute)
May 23 14:52:25 httpd.admin(0) INFO: re-evaluating access for node
00:0b:5d:23:02:4d (node_modify called) (pf::enforcement::reevaluate_access)
May 23 14:52:25 httpd.admin(0) INFO: 00:0b:5d:23:02:4d is currentlog
connected at 10.2.253.2 ifIndex 10115 in VLAN 223
(pf::enforcement::_should_we_reassign_vlan)
May 23 14:52:25 httpd.admin(0) INFO: MAC: 00:0b:5d:23:02:4d, PID: admin,
Status: reg. Returned VLAN: 223 (pf::vlan::fetchVlanForNode)
What could it be?
thanks
LT
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
