Is anyone playing around with (either in production or in testing)
PacketFence v2? I am having all sorts of errors with it. I am running
PacketFence v2 on CentOS v5.5 x86_64, although I tried the ZEN version
as well and encountered many of the same problems. Most recently, I had
errors where adding a node didn't give an error (via the web browser)
but the node was not inserted into the database either.
I do have database errors in the packetfence log:
Jan 17 21:00:22 pfcmd(0) WARN: database query failed with: Cannot add or
update a child row: a foreign key constraint fails (`pf/node`,
CONSTRAINT `0_57` FOREIGN KEY (`pid`) REFERENCES `person` (`pid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Jan 17 21:00:22 pfcmd(0) WARN: database query failed with: Cannot add or
update a child row: a foreign key constraint fails (`pf/node`,
CONSTRAINT `0_57` FOREIGN KEY (`pid`) REFERENCES `person` (`pid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Jan 17 21:00:22 pfcmd(0) WARN: database query failed with: Cannot add or
update a child row: a foreign key constraint fails (`pf/node`,
CONSTRAINT `0_57` FOREIGN KEY (`pid`) REFERENCES `person` (`pid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Jan 17 21:00:22 pfcmd(0) ERROR: Database issue: We tried 3 times to
serve query node_add_sql called from pf::node::node_add and we failed.
Is the database running? (pf::db::db_query_execute)
Jan 17 21:09:15 pfcmd(0) INFO: pfcmd calling node_add for
00:50:56:85:00:11 (main::command_param)
Jan 17 21:09:15 pfcmd(0) WARN: database query failed with: Cannot add or
update a child row: a foreign key constraint fails (`pf/node`,
CONSTRAINT `0_57` FOREIGN KEY (`pid`) REFERENCES `person` (`pid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Jan 17 21:09:15 pfcmd(0) WARN: database query failed with: Cannot add or
update a child row: a foreign key constraint fails (`pf/node`,
CONSTRAINT `0_57` FOREIGN KEY (`pid`) REFERENCES `person` (`pid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Jan 17 21:09:15 pfcmd(0) WARN: database query failed with: Cannot add or
update a child row: a foreign key constraint fails (`pf/node`,
CONSTRAINT `0_57` FOREIGN KEY (`pid`) REFERENCES `person` (`pid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Jan 17 21:09:15 pfcmd(0) ERROR: Database issue: We tried 3 times to
serve query node_add_sql called from pf::node::node_add and we failed.
Is the database running? (pf::db::db_query_execute)
I tested the mysql username/password for packetfence as configured by
the installer.pl script, and it works. Is there a way to put packetfence
into a higher debug mode so that I can better figure out where the
problem is?
I checked the mysql server processes, and I see the pf user connected
to it several times, so I am pretty sure it is not a
username/password/privilege issue.
On a related note, PacketFence is inserting nodes (as unreg) that it is
seeing via dhcp listening. Any help figuring this out would be
appreciated.
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Packetfence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
