subject:"\[PacketFence\-users\] Installing with separate database server"

Re: [PacketFence-users] Installing with separate database server

2016-02-29 Thread Morris, Andi

Hi,
I've no idea why, but a rebuild of the server fixed this. Cheers for your help.

Cheers,
Andi

-Original Message-
From: James Rouzier [mailto:jrouz...@inverse.ca] 
Sent: 26 February 2016 15:15
To: packetfence-users@lists.sourceforge.net
Subject: Re: [PacketFence-users] Installing with separate database server

It seems that you have multiple p0f services running.

Kill them manually for now and try to restart.
Let me know if that helps

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 9:58 AM, Morris, Andi wrote:
> Hi James,
> Yes, thanks, I've done that. Apologies my last email was terribly formatted 
> somehow.
>
> I still cannot start the services due to this kill error. I may just rebuild 
> the server and see if I can work out exactly when this starts to happen.
>
> Cheers,
> Andi
>
> -Original Message-
> From: James Rouzier [mailto:jrouz...@inverse.ca]
> Sent: 26 February 2016 14:57
> To: packetfence-users@lists.sourceforge.net
> Subject: Re: [PacketFence-users] Installing with separate database 
> server
>
> 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  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(1

Re: [PacketFence-users] Installing with separate database server

2016-02-26 Thread James Rouzier

It seems that you have multiple p0f services running.

Kill them manually for now and try to restart.
Let me know if that helps

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 9:58 AM, Morris, Andi wrote:
> Hi James,
> Yes, thanks, I've done that. Apologies my last email was terribly formatted 
> somehow.
>
> I still cannot start the services due to this kill error. I may just rebuild 
> the server and see if I can work out exactly when this starts to happen.
>
> Cheers,
> Andi
>
> -Original Message-
> From: James Rouzier [mailto:jrouz...@inverse.ca]
> Sent: 26 February 2016 14:57
> To: packetfence-users@lists.sourceforge.net
> Subject: Re: [PacketFence-users] Installing with separate database server
>
> 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  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_

Re: [PacketFence-users] Installing with separate database server

2016-02-26 Thread Morris, Andi

Hi James,
Yes, thanks, I've done that. Apologies my last email was terribly formatted 
somehow.

I still cannot start the services due to this kill error. I may just rebuild 
the server and see if I can work out exactly when this starts to happen.

Cheers,
Andi

-Original Message-
From: James Rouzier [mailto:jrouz...@inverse.ca] 
Sent: 26 February 2016 14:57
To: packetfence-users@lists.sourceforge.net
Subject: Re: [PacketFence-users] Installing with separate database server

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  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

Re: [PacketFence-users] Installing with separate database server

2016-02-26 Thread James Rouzier

O: 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 mai

Re: [PacketFence-users] Installing with separate database server

2016-02-26 Thread Morris, Andi

Actually, this appears to be ingrained with the install (CentOS 6.7) as putting 
the two database references back also displays this message. I'm not sure how 
the services started ok when I first installed the server and ran through the 
wizard.

-Original Message-
From: Morris, Andi [mailto:amor...@cardiffmet.ac.uk] 
Sent: 26 February 2016 12:18
To: packetfence-users@lists.sourceforge.net
Subject: Re: [PacketFence-users] Installing with separate database server

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  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

Re: [PacketFence-users] Installing with separate database server

2016-02-26 Thread Morris, Andi

 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=/4140
> ___
> PacketFence-users mailing list
> PacketFence-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
> --
> 
> Site24x7 APM Insight: Get

Re: [PacketFence-users] Installing with separate database server

2016-02-25 Thread Louis Munro



> On Feb 25, 2016, at 10:49 , Morris, Andi  wrote:
> 
> So for the actual packetfence server I just install as the complete package, 
> but just ignore/disable the local mysql installation?

That’s what I have been doing for a while now.
It’s the safe choice, making sure you pull in all dependencies.


Regards,
--
Louis Munro
lmu...@inverse.ca  ::  www.inverse.ca 
+1.514.447.4918 x125  :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence 
(www.packetfence.org)--
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=/4140___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] Installing with separate database server

2016-02-25 Thread Fabrice Durand

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=/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=/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=/4140
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] Installing with separate database server

2016-02-25 Thread Morris, Andi

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=/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=/4140
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] Installing with separate database server

2016-02-25 Thread Fabrice Durand

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"  
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]


--
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=/4140
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

[PacketFence-users] Installing with separate database server

2016-02-25 Thread Morris, Andi

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]
--
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=/4140___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] Installing with separate database server

Re: [PacketFence-users] Installing with separate database server

Re: [PacketFence-users] Installing with separate database server

Re: [PacketFence-users] Installing with separate database server

Re: [PacketFence-users] Installing with separate database server

Re: [PacketFence-users] Installing with separate database server

Re: [PacketFence-users] Installing with separate database server

Re: [PacketFence-users] Installing with separate database server

Re: [PacketFence-users] Installing with separate database server

Re: [PacketFence-users] Installing with separate database server

[PacketFence-users] Installing with separate database server

11 matches

Site Navigation

Mail list logo

Footer information