Good day,
I'm using the most recent devel snapshot ( 4.0.2-0.20130529.el6)
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
------------------------------------------------------------------------------
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
