Hi Nicholas,
Did you delete the person with the PID 1 from the database? This is the
default user that packetfence uses to add a node to the database, and
should NOT be deleted.
This error is triggered because you are trying to add a node with a PID
that doesn't exists in the person table.
On 11-01-17 10:30 PM, Ritter, Nicholas wrote:
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
--
Francois Gaudreault, ing. jr
[email protected] :: +1.514.447.4918 (x130) :: www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
------------------------------------------------------------------------------
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
