Hi Don ,
still on 4.0.0 .., sorry about the lame question, but how I upgrade to
4.0.1 ? cause the new release only said:
"This release only fixes various bugs and doesn’t need the database
schema to be modified. Simply update the file
/usr/local/pf/conf/currently-at to match the new release number."
cheers
LT
Citando Don Greer <[email protected]>:
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
