Hi Andrew, > > Yes, there is something in the logs. I did not see it before as my > production box is very noisy especially now that school is starting. > Here is what I see: > > Aug 17 08:09:56 pfcmd(0) INFO: pfcmd calling node_modify for > 00:21:9b:3d:65:7b (main::command_param) > Aug 17 08:09:56 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)
The constraint links the node.pid to person.pid. Do you have a person for the pid you are trying to set the node to? For example: pfcmd node edit 00:21:9b:3d:65:7b status="reg",pid="bill" You need to have a person "bill" to already exist. Calling 'pfcmd person edit bill' would create such a pid. Let me know if this doesn't solve the issue. Cheers! -- Olivier Bilodeau [email protected] :: +1.514.447.4918 *115 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------------ Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user administration capabilities and model configuration. Take the hassle out of deploying and managing Subversion and the tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2 _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
