Luis,
Are you running 4.0.0 or 4.0.1? There was a bug in 4.0.0 that prevented it
from populating the class DB.
Been there, done that, haven’t had the problem since I upgraded.
Don
From: luis torres [mailto:[email protected]]
Sent: Thursday, May 23, 2013 8:59 AM
To: packetfence-users
Subject: [PacketFence-users] ERROR: Database issue: (on Node Status change)
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
