Hello Doc, Thanks for the reply.
I've double (triple ...) checked for iptables / other firewall and network phenomena and can't find any. I can access the remote db via a mysql client on the PF server with no problems. There doesn't seem to be a network or connection problem. This is the production server being set up (on a KVM virtual machine) ; on the 'development' (aka 'play') server PF had no difficulty accessing a local mysql server instance. I've done a Debian adaptation for PF (most of our infrastructure is Debian based) and suspect that there is a snarl somewhere in the lower level Perl modules. It's only a suspicion, but there seem to be no network issues. Getting the Perl modules into a correct config has been a major issue - I've had to juggle the modules available from the Debian repos with those only available on CPAN, play with versions, etc. Don't know for sure, but I've grown leery (if not punchy) over modules issues. Thanks again for the suggestion ; have a fine weekend. Best wishes, Chris Ps. A suggestion to the Inverse gurus here : a comprehensive list of required Perl modules (in their native Perl designations - e.g. Foo::Bar::Bas) would go a long way towards clarifying the (murky) modules situation. Why not take CPAN as a centre of gravity and list things out as they exist there ? Accompanying each listed module with a minimum version number might not be a bad idea either. On Thu 9.Dec'10 at 21:15:14 -0500, Doc Phillips wrote: > 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 ------------------------------------------------------------------------------ Oracle to DB2 Conversion Guide: Learn learn about native support for PL/SQL, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, data movement tools, best practices and more. http://p.sf.net/sfu/oracle-sfdev2dev _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
