Thanks for your help Fabrice, OK, so this isn't working as it supposedly should.
I've setup the schema and granted the priveleges on the db server. After running through the configuration wizard on the main server I did a mysqldump and then imported that to the db server I can access the remote database by using mysql -u pf -p -h <db_server_ip> pf When connected to the database I can run show tables and see the pf tables In pf.conf I've changed the hostname to reflect the remote server ip When trying to start the packetfence and packetfence-config services I could see that there was a L2 connection error to the database. Packetfence.log pointed me to the fact the packetfence-config was still pointing to the localhost (where the mysqld service was stopped). I added the host to pfconfig.conf and the packetfence-config service now starts. However, the packetfence services do not. When trying to start these I see: Insecure dependency in kill while running with -T switch at /usr/local/pf/lib/pf/services/manager.pm line 544. Packetfence.log shows: Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x iptables returned -1 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: verifying process -1 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x iptables returned -1 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1391) INFO: pidof -x collectd returned 1966 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) WARN: Problem trying to run command: iptables -S | grep input-management-if called from manager::iptables::isAlive. Child exited with non-zero value 1 (pf::util::pf_run) Feb 26 11:59:24 pfcmd.pl(1391) INFO: verifying process 1966 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: removing stale pid file /usr/local/pf/var/run/iptables.pid (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1391) INFO: pidof -x collectd returned 1966 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1391) INFO: removing stale pid file /usr/local/pf/var/run/collectd.pid (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfqueue returned 1823 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: verifying process 1823 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfqueue returned 1823 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: removing stale pid file /usr/local/pf/var/run/pfqueue.pid (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfdhcplistener_eth1 returned 1857 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: verifying process 1857 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfdhcplistener_eth1 returned 1857 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: removing stale pid file /usr/local/pf/var/run/pfdhcplistener_eth1.pid (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfdhcplistener_eth2 returned 1871 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: verifying process 1871 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfdhcplistener_eth2 returned 1871 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: removing stale pid file /usr/local/pf/var/run/pfdhcplistener_eth2.pid (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1391) INFO: pidof -x dhcpd returned 1879 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1391) INFO: verifying process 1879 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1391) INFO: pidof -x dhcpd returned 1879 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1391) INFO: removing stale pid file /usr/local/pf/var/run/dhcpd.pid (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfdhcplistener_eth0 returned 1875 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: verifying process 1875 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfdhcplistener_eth0 returned 1875 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: removing stale pid file /usr/local/pf/var/run/pfdhcplistener_eth0.pid (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfmon returned 1893 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: verifying process 1893 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x pfmon returned 1893 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: removing stale pid file /usr/local/pf/var/run/pfmon.pid (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1391) INFO: pidof -x p0f returned 1923 1921 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x p0f returned 1923 1921 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1391) INFO: verifying process 1923 1921 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: verifying process 1923 1921 (pf::services::manager::removeStalePid) Feb 26 11:59:24 pfcmd.pl(1357) INFO: pidof -x p0f returned 1923 1921 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1391) INFO: pidof -x p0f returned 1923 1921 (pf::services::manager::pidFromFile) Feb 26 11:59:24 pfcmd.pl(1391) FATAL: Insecure dependency in kill while running with -T switch at /usr/local/pf/lib/pf/services/manager.pm line 544. (pf::services::manager::isAlive) Feb 26 11:59:24 pfcmd.pl(1357) FATAL: Insecure dependency in kill while running with -T switch at /usr/local/pf/lib/pf/services/manager.pm line 544. (pf::services::manager::isAlive) Feb 26 11:59:48 pfcmd.pl(1451) INFO: pidof -x p0f returned 1923 1921 (pf::services::manager::pidFromFile) Feb 26 11:59:48 pfcmd.pl(1451) INFO: verifying process 1923 1921 (pf::services::manager::removeStalePid) Feb 26 11:59:48 pfcmd.pl(1451) INFO: pidof -x p0f returned 1923 1921 (pf::services::manager::pidFromFile) Feb 26 11:59:48 pfcmd.pl(1451) FATAL: Insecure dependency in kill while running with -T switch at /usr/local/pf/lib/pf/services/manager.pm line 544. (pf::services::manager::isAlive) What am I doing wrong? Cheers, Andi -----Original Message----- From: Fabrice Durand [mailto:[email protected]] Sent: 25 February 2016 16:03 To: [email protected] Subject: Re: [PacketFence-users] Installing with separate database server Importance: Low Yes exactly, mysql is a dependency but disable it when the system start. Le Jeudi, Février 25, 2016 10:49 EST, "Morris, Andi" <[email protected]> a écrit: > Thanks Fabrice, > So for the actual packetfence server I just install as the complete package, > but just ignore/disable the local mysql installation? > > Cheers, > Andi > > -----Original Message----- > From: Fabrice Durand [mailto:[email protected]] > Sent: 25 February 2016 15:29 > To: [email protected] > Subject: Re: [PacketFence-users] Installing with separate database > server > Importance: Low > > Hello Andi, > > you just need to install a mysql server (mysql, mariadb, gallera-cluster > ...), import db/pf-schema.sql. > And: > > GRANT SELECT,INSERT,UPDATE,DELETE,EXECUTE,LOCK TABLES ON pf.* TO > [email protected] IDENTIFIED BY packetfence; GRANT DROP ON pf.radius_nas > TO [email protected] IDENTIFIED BY packetfence; GRANT ALL PRIVILEGES ON > pf_graphite.* TO [email protected] IDENTIFIED BY packetfence; > > 172.20.20.1 is your pf ip address. > And change the db information in pf.conf (ie pf.conf.default). > > Regards > Fabrice > > Le Jeudi, Février 25, 2016 08:15 EST, "Morris, Andi" > <[email protected]> a écrit: > > > Hi all. > > Just wondering what the best practice is for installing packetfence with a > > separate mysql database server. Do I need to install packetfence on the > > main server without the mysql elements? If so, what's the best way to do > > that so that I don't miss out a vital dependency when installing separate > > packages? > > > > For the database server itself, is it best to install mysql from the > > packetfence repository? If so, again what are the packages required for > > this to run? > > > > I'm aware of the schema scripts in /usr/local/pf/db and I've seen the > > command on this mailing list to set the necessary user permissions, is this > > info in any of the admin guides? > > > > Cheers, > > Andi > > ________________________________ > > > > [Cardiff Metropolitan University - 150 years of nurturing > > talent]<http://www.cardiffmet.ac.uk/cardiffmet150> > > > ---------------------------------------------------------------------- > -------- > Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + > Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor > end-to-end web transactions and take corrective actions now Troubleshoot > faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users > ---------------------------------------------------------------------- > -------- > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
