Hi Andy,
What is the version of the external MySQL database you are using?
It looks like a possible compatibility issue.
Your database does not consider 0 to be equal to "0000-00-00 00:00:00” for a
datetime field.
--
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 22, 2015, at 9:16 , Andy A <[email protected]> wrote:
> Hi Louis,
>
> Because of the length of my email (lot of log details) the emails are not
> going through on the mailing list I think. So I have created a pastebin
> http://pastebin.com/cAXreXT7
> to detail the issues and bugs fixes that I did to move forward and where I am
> stuck at the moment.
>
> Thanks for your help.
>
> 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.conf
> from :
> log4perl.rootLogger = INFO, PFDHCPLISTENER
> to :
> log4perl.rootLogger = INFO, PFDHCPLISTENER
>
>
> You meant this right?
>
> Change the first line in conf/log.conf.d/pfdhcplistener.conf
> from :
> log4perl.rootLogger = INFO, PFDHCPLISTENER
> to :
> 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.conf
> from :
> 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
------------------------------------------------------------------------------
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
