In addition to IP not being assigned to the client. I noticed that I have lost
access to the admin. It's not accessible through the browser. With or without
IPtables turned on. I also see the following errors in packetfence.log
Apr 22 13:13:32 pfcmd.pl(17800) INFO: Hard expiring resource :
interfaces::management_network (pfconfig::manager::expire)Apr 22 13:13:33
pfcmd.pl(17800) WARN: database query failed with: Incorrect integer value:
'defaults' for column 'vid' at row 1 (errno: 1366), will try again
(pf::db::db_query_execute)Apr 22 13:13:33 pfcmd.pl(17800) WARN: database query
failed with: Incorrect integer value: 'defaults' for column 'vid' at row 1
(errno: 1366), will try again (pf::db::db_query_execute)Apr 22 13:13:33
pfcmd.pl(17800) WARN: database query failed with: Incorrect integer value:
'defaults' for column 'vid' at row 1 (errno: 1366), will try again
(pf::db::db_query_execute)Apr 22 13:13:33 pfcmd.pl(17800) ERROR: Database
issue: We tried 3 times to serve query class_add_sql called from
pf::class::class_add and we failed. Is the database running?
(pf::db::db_query_execute)Apr 22 13:13:33 pfcmd.pl(17800) WARN: database query
failed with: Incorrect integer value: 'defaults' for column 'vid' at row 1
(errno: 1366), will try again (pf::db::db_query_execute)Apr 22 13:13:33
pfcmd.pl(17800) WARN: database query failed with: Incorrect integer value:
'defaults' for column 'vid' at row 1 (errno: 1366), will try again
(pf::db::db_query_execute)Apr 22 13:13:33 pfcmd.pl(17800) WARN: database query
failed with: Incorrect integer value: 'defaults' for column 'vid' at row 1
(errno: 1366), will try again (pf::db::db_query_execute)Apr 22 13:13:33
pfcmd.pl(17800) ERROR: Database issue: We tried 3 times to serve query
action_add_sql called from pf::action::action_add and we failed. Is the
database running? (pf::db::db_query_execute)Apr 22 13:13:33 pfcmd.pl(17800)
WARN: database query failed with: Incorrect integer value: 'defaults' for
column 'vid' at row 1 (errno: 1366), will try again
(pf::db::db_query_execute)Apr 22 13:13:33 pfcmd.pl(17800) WARN: database query
failed with: Incorrect integer value: 'defaults' for column 'vid' at row 1
(errno: 1366), will try again (pf::db::db_query_execute)Apr 22 13:13:33
pfcmd.pl(17800) WARN: database query failed with: Incorrect integer value:
'defaults' for column 'vid' at row 1 (errno: 1366), will try again
(pf::db::db_query_execute)Apr 22 13:13:33 pfcmd.pl(17800) ERROR: Database
issue: We tried 3 times to serve query action_add_sql called from
pf::action::action_add and we failed. Is the database running?
(pf::db::db_query_execute)Apr 22 13:13:33 pfcmd.pl(17800) INFO: Memory
configuration is not valid anymore for key config::Pf in local cached_hash
(pfconfig::cached::is_valid)Apr 22 13:13:33 pfcmd.pl(17800) INFO: Daemon
memcached took 0.004 seconds to start.
(pf::services::manager::launchService)Apr 22 13:13:33 pfcmd.pl(17800) INFO:
Memory configuration is not valid anymore for key interfaces::internal_nets in
local cached_hash (pfconfig::cached::is_valid)Apr 22 13:13:33 pfcmd.pl(17800)
INFO: generating /usr/local/pf/var/conf/ssl-certificates.conf
(pf::services::manager::httpd::generateConfig)Apr 22 13:13:33 pfcmd.pl(17800)
INFO: generating /usr/local/pf/var/conf/captive-portal-common.conf
(pf::services::manager::httpd::generateConfig)Apr 22 13:13:42 pfcmd.pl(17800)
INFO: Daemon httpd.admin took 8.346 seconds to start.
(pf::services::manager::launchService)Apr 22 13:13:50 pfcmd.pl(17800) INFO:
Memory configuration is not valid anymore for key
interfaces::management_network in local cached_hash
(pfconfig::cached::is_valid)Apr 22 13:13:50 pfcmd.pl(17800) INFO: Memory
configuration is not valid anymore for key config::Network in local cached_hash
(pfconfig::cached::is_valid)Apr 22 13:13:53 pfcmd.pl(17800) INFO:
pf::services::manager, /usr/local/pf/lib/pf/services/manager.pm, 171
(pf::services::manager::dhcpd::generateConfig)Apr 22 13:13:53 pfcmd.pl(17800)
INFO: Memory configuration is not valid anymore for key interfaces::listen_ints
in local cached_hash (pfconfig::cached::is_valid)Apr 22 13:13:53
pfcmd.pl(17800) ERROR: requesting member ips for an undefined interface...
(pf::cluster::members_ips)
From: [email protected]
Date: Tue, 21 Apr 2015 14:54:31 -0400
To: [email protected]
Subject: Re: [PacketFence-users] Using remote MySQL host
Actually, This does look like a bug.
Give us a few hours, we are testing a fix.
In the meantime if you want to you could try this patch:
https://github.com/inverse-inc/packetfence/commit/be04b7ca372497e1e3e5d9f829e10b6e63cb8346.diff
I.e. run curl -o node.patch
https://github.com/inverse-inc/packetfence/commit/be04b7ca372497e1e3e5d9f829e10b6e63cb8346.diff
Save the patch somewhere, cd to /usr/local/pf and then run this:
# patch -p1 < patch.diff
Regards,
--Louis Munro
[email protected] :: 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)
On Apr 21, 2015, at 14:25 , Andy A <[email protected]> wrote:Change
the first line in conf/log.conf.d/pfdhcplistener.conffrom :log4perl.rootLogger
= INFO, PFDHCPLISTENERto : log4perl.rootLogger = INFO, PFDHCPLISTENER
You meant this right?
Change the first line in conf/log.conf.d/pfdhcplistener.conffrom
:log4perl.rootLogger = INFO, PFDHCPLISTENERto : log4perl.rootLogger = DEBUG,
PFDHCPLISTENER
From: [email protected]
Date: Tue, 21 Apr 2015 14:19:04 -0400
To: [email protected]
Subject: Re: [PacketFence-users] Using remote MySQL host
On Apr 21, 2015, at 14:11 , Andy A <[email protected]> wrote:Hi Louis.
PF version is 5.0
Here's the output that you requested.
That seems valid.
Try running pfdhcplistener with logging set to TRACE for two minutes.It should
give some output that will let us know what it is trying to add to the database.
Change the first line in conf/log.conf.d/pfdhcplistener.conffrom
:log4perl.rootLogger = INFO, PFDHCPLISTENER
to :
log4perl.rootLogger = INFO, PFDHCPLISTENER
Let it run for a few minutes and then grep all the TRACE and DEBUG lines in
/usr/local/pf/logs/pfdhcplistener.log.
Remember to reset your logging configuration at the end.
--
Louis Munro
[email protected] :: 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)
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own
process in accordance with the BPMN 2 standard Learn Process modeling best
practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________ PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
