Greetings list, We are here moving our development installation of PF to its production environment (optimism is the keynote) in a KVM machine. To be ultra-cautious, because of past difficulties with Perl modules on a Debian machine, I've done a complete re-inventory of the necessary modules and everything seems to be there (necessary, I thought, when moving back from 'testing' to 'stable' - greater use of CPAN, rather than the Debian packaged modules, is necessary).
So far, the only issue I've come across is that the new PF installation seems to have difficulty accessing the mysql server. Previously, the mysql server had been installed on the local machine with no issues at all, now it is across the network and, at startup, is returning : -------------------------------- Dec 07 15:19:04 pfcmd(0) WARN: database query failed with: Column 'whitelisted_categories' cannot be null. (errno: 1048), will try again (pf::db::db_query_execute) Dec 07 15:19:04 pfcmd(0) WARN: database query failed with: Column 'whitelisted_categories' cannot be null. (errno: 1048), will try again (pf::db::db_query_execute) Dec 07 15:19:04 pfcmd(0) WARN: database query failed with: Column 'whitelisted_categories' cannot be null. (errno: 1048), will try again (pf::db::db_query_execute) Dec 07 15:19:04 pfcmd(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) -------------------------------- The database *is* running and I have no difficulty accessing it via the local mysql client. Can anyone comment / advise ? Thanks in advance. Chris ------------------------------------------------------------------------------ _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
