In addition to my previous emails, here's the info from mysqldump for the
action table. Nothing unusual and looks alright.
mysqldump -upf -p --no-data pf action-- MySQL dump 10.13 Distrib 5.6.23, for
Linux (x86_64)---- Host: localhost Database: pf--
-------------------------------------------------------- Server version
5.6.23-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8
*/;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00'
*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
*/;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
*/;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;Warning: A partial
dump from a server that has GTIDs will by default include the GTIDs of all
transactions, even those that changed suppressed parts of the database. If you
don't want to restore GTIDs, pass --set-gtid-purged=OFF. To make a complete
dump, pass --all-databases --triggers --routines --events.SET
@MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;SET @@SESSION.SQL_LOG_BIN= 0;
---- GTID state at the beginning of the backup--
SET @@GLOBAL.GTID_PURGED='8bae3138-d6fe-11e4-8222-0050569312b9:1-10041';
---- Table structure for table `action`--
DROP TABLE IF EXISTS `action`;/*!40101 SET @saved_cs_client =
@@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE
TABLE `action` ( `vid` int(11) NOT NULL, `action` varchar(255) NOT NULL,
PRIMARY KEY (`vid`,`action`), CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`)
REFERENCES `class` (`vid`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB
DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client
*/;SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;/*!40103 SET
TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET
UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET
SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2015-04-22 13:32:19
So at the moment, I am stuck as I can't debug the action.pm code (not a PERL
expert)
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
