You would also need to update the database configuration in conf/pfconfig.conf
James Rouzier jrouz...@inverse.ca :: +1.514.447.4918 (x115) :: http://www.inverse.ca Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence (http://www.packetfence.org) On 2016-02-26 7:13 AM, Morris, Andi wrote: > 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:fdur...@inverse.ca] > Sent: 25 February 2016 16:03 > To: packetfence-users@lists.sourceforge.net > 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" > <amor...@cardiffmet.ac.uk> 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:fdur...@inverse.ca] >> Sent: 25 February 2016 15:29 >> To: packetfence-users@lists.sourceforge.net >> 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 >> pf@172.20.20.1 IDENTIFIED BY packetfence; GRANT DROP ON pf.radius_nas >> TO pf@172.20.20.1 IDENTIFIED BY packetfence; GRANT ALL PRIVILEGES ON >> pf_graphite.* TO pf@172.20.20.1 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" >> <amor...@cardiffmet.ac.uk> 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 >> PacketFence-users@lists.sourceforge.net >> 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 >> PacketFence-users@lists.sourceforge.net >> 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 > PacketFence-users@lists.sourceforge.net > 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 > PacketFence-users@lists.sourceforge.net > 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 PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users