Francis, First, thanks a bunch for your reply!
Ok, been playing with this all morning and no luck. My DBA-foo is very weak. :^) The class table is completely empty. Doing what you suggested didn't change that. I thought maybe I'd screwed something up during installation, so I manually backed up the data in the DB, dropped the DB, recreated it, and fed the schema file back into MySQL, then shoved the table data back into the DB (without creates, etc. to insure the schema was preserved). No joy. When I do as you suggested while tailing the log, I get screens-full of this: May 16 09:37:33 httpd.admin(0) WARN: database query failed with: Column 'auto_enable' cannot be null. (errno: 1048), will try again (pf::db::db_query_execute) May 16 09:37:33 httpd.admin(0) WARN: database query failed with: Column 'auto_enable' cannot be null. (errno: 1048), will try again (pf::db::db_query_execute) May 16 09:37:33 httpd.admin(0) WARN: database query failed with: Column 'auto_enable' cannot be null. (errno: 1048), will try again (pf::db::db_query_execute) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) May 16 09:37:33 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) I'm wondering if turning off foreign_key_checks in my.cnf (I think that can be done) wouldn't fix this. I had to do that to get the tables to load from the backup, but mysqlcheck says everything is good (not sure if it checks FK consistency, tho). I'm hesitating to do that for the moment simply because I'm not sure what sort of side-effects it would have to not have FK enforcement. Any ideas? I'm groping at this point :^). Thanks! Don ------------------------------------------------------------------------------ AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
