Hi Tim On 2013-06-03, at 5:35 PM, "Palmer, Tim" <[email protected]> wrote:
> I'm using the most recent devel snapshot ( 4.0.2-0.20130529.el6) You should try a more recent build. > When I make any edits to the violations page of the Configuration tab, > packetfence.log shows: > > Jun 03 17:23:55 httpd.admin(0) INFO: called reload_violation_config > (pf::config::cached::reload_violation_config) > Jun 03 17:23:55 httpd.admin(0) INFO: called file_reload_violation_config > (pf::config::cached::file_reload_violation_config) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Column > 'window' cannot be null. (errno: 1048), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Column > 'window' cannot be null. (errno: 1048), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Column > 'window' cannot be null. (errno: 1048), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) ERROR: Database issue: We tried 3 times to > serve query class_add_sql called from pf::class::class_add and we failed. Is > the database running? (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`action`, > CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`action`, > CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`action`, > CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) ERROR: Database issue: We tried 3 times to > serve query action_add_sql called from pf::action::action_add and we failed. > Is the database running? (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`action`, > CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`action`, > CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`action`, > CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) ERROR: Database issue: We tried 3 times to > serve query action_add_sql called from pf::action::action_add and we failed. > Is the database running? (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`action`, > CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`action`, > CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`action`, > CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) ERROR: Database issue: We tried 3 times to > serve query action_add_sql called from pf::action::action_add and we failed. > Is the database running? (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`trigger`, > CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`trigger`, > CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`trigger`, > CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) ERROR: Database issue: We tried 3 times to > serve query trigger_add_sql called from pf::trigger::trigger_add and we > failed. Is the database running? (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`trigger`, > CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`trigger`, > CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) WARN: database query failed with: Cannot add > or update a child row: a foreign key constraint fails (`pf`.`trigger`, > CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE > CASCADE ON UPDATE CASCADE). (errno: 1452), will try again > (pf::db::db_query_execute) > Jun 03 17:23:59 httpd.admin(0) ERROR: Database issue: We tried 3 times to > serve query trigger_add_sql called from pf::trigger::trigger_add and we > failed. Is the database running? (pf::db::db_query_execute) > Jun 03 17:24:03 httpd.admin(0) INFO: Configuration file successfully saved > (pfappserver::Base::Model::Config::rewriteConfig) > Jun 03 17:24:03 httpd.admin(0) INFO: Configuration file successfully saved > (pfappserver::Base::Model::Config::commit) > Jun 03 17:24:03 httpd.admin(0) INFO: Configuration file successfully saved > (pfappserver::Base::Controller::Crud::Config::_commitChanges) > > ===== > > Class table is populated and mysql is running. > > I have added a violation definition to violations.conf, which does show up in > the web interface, but not the class table. Changes to existing violation > definitions do get into the class table. > > Should I be concerned with these errors? > > Thank you for your time, > > Tim Palmer -- [email protected] :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) ------------------------------------------------------------------------------ How ServiceNow helps IT people transform IT departments: 1. A cloud service to automate IT design, transition and operations 2. Dashboards that offer high-level views of enterprise services 3. A single system of record for all IT processes http://p.sf.net/sfu/servicenow-d2d-j _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
