Hey Chris, Make sure the machine where your DB is running is not blocked by a firewall, software or hardware.
>From what it sounds like you have two machines, 1 is the DB and the other is the PF box. See if you can telnet from the PF box to the DB on the mysql port. Not sure if this will help but it's always good to double check. Cheers On Tue, Dec 7, 2010 at 10:19 AM, cg <[email protected]> wrote: > 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 > -- *D. Phillips*
------------------------------------------------------------------------------
_______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
