Try upgrading to 4.0.6 :-)
--
Louis Munro
lmu...@inverse.ca :: www.inverse.ca
+1.514.447.4918 *125 :: +1 (866) 353-6153
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
On 2013-09-05, at 15:40 , Fletcher Haynes <fhay...@willamette.edu> wrote:
> Just to be sure, here is my output from the commands you had Dave run:
> root@packetfence-1:/usr/local/pf# dpkg -s packetfence | egrep -i
> 'package:|status:|version:'
> Package: packetfence
> Status: install ok installed
> Version: 4.0.5-2
> root@packetfence-1:/usr/local/pf# grep HTTPHEADER
> /usr/local/pf/raddb/packetfence.pm
> $curl->setopt(CURLOPT_HTTPHEADER, ['Content-Type: text/xml;
> charset=UTF-8']);
>
>
> On Thu, Sep 5, 2013 at 12:36 PM, Fletcher Haynes <fhay...@willamette.edu>
> wrote:
> This is 4.0.5-2. I did find that bug report and verified that the change made
> to fix it (adding proper headers, I believe it was) is present in the code.
>
>
> On Thu, Sep 5, 2013 at 12:36 PM, Fletcher Haynes <fhay...@willamette.edu>
> wrote:
> Here is the output:
> mysql> show status like 'threads_created';
> +-----------------+-------+
> | Variable_name | Value |
> +-----------------+-------+
> | Threads_created | 269 |
> +-----------------+-------+
> 1 row in set (0.00 sec)
>
> mysql> show status like 'connections';
> +---------------+-------+
> | Variable_name | Value |
> +---------------+-------+
> | Connections | 1493 |
> +---------------+-------+
> 1 row in set (0.00 sec)
>
> In accordance with MySQLTuner, I changed thread_cache_size to 400 (what it is
> currently at), and still had the problem
>
>
> On Thu, Sep 5, 2013 at 12:23 PM, Louis Munro <lmu...@inverse.ca> wrote:
> Actually,
> Just show us
> mysql> show status like 'threads_created';
>
> In addition to
> mysql> show status like 'connections';
>
> That will give us a better picture of the issue.
> Regards,
> --
> Louis Munro
> lmu...@inverse.ca :: www.inverse.ca
> +1.514.447.4918 *125 :: +1 (866) 353-6153
> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
> (www.packetfence.org)
>
> On 2013-09-05, at 15:19 , Louis Munro <lmu...@inverse.ca> wrote:
>
>> Hi Fletcher,
>>
>> 8 could still be too low to make any significant difference.
>>
>> What is the output of the following two commands?
>>
>> mysql> show status like 'connections';
>>
>> mysql> show status like 'threads_created';
>>
>>
>> Regards,
>> --
>> Louis Munro
>> lmu...@inverse.ca :: www.inverse.ca
>> +1.514.447.4918 *125 :: +1 (866) 353-6153
>> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
>> (www.packetfence.org)
>>
>> On 2013-09-05, at 12:09 , Fletcher Haynes <fhay...@willamette.edu> wrote:
>>
>>> Hi Louis and Ludovic,
>>>
>>> I set it to 8 yesterday and still had the issue. I had also run MySQL
>>> primer and followed its recommendations, but will run MySQL Tuner and see
>>> what it says.
>>>
>>> Thank you!
>>>
>>>
>>> On Thu, Sep 5, 2013 at 9:01 AM, Louis Munro <lmu...@inverse.ca> wrote:
>>> Hi Fletcher.
>>>
>>> In mysql, what is the value of thread_cache_size?
>>>
>>> If it is 0, try setting it to 4 (to begin with).
>>>
>>> Regards,
>>> --
>>> Louis Munro
>>> lmu...@inverse.ca :: www.inverse.ca
>>> +1.514.447.4918 *125 :: +1 (866) 353-6153
>>> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
>>> (www.packetfence.org)
>>>
>>> On 2013-09-05, at 10:04 , Fletcher Haynes <fhay...@willamette.edu> wrote:
>>>
>>>> Not to hijack Dave's thread, but I started having this issue again two
>>>> days ago. Except this time, I am not getting any DB handle errors. This is
>>>> all I see in radius.log:
>>>> Wed Sep 4 20:54:22 2013 : Error: Discarding duplicate request from client
>>>> 158.104.249.7 port 32768 - ID: 82 due to unfinished request 10895
>>>>
>>>> I see a lot of these, then it handles a few more requests and then dies.
>>>> From what I can tell, this indicates a slow backend DB, but I have it
>>>> running on a separate VM with 4GB of RAM and 4 cores. MySQL spikes 100%
>>>> regularly on one CPU, memory is about 70% used. I"ve done all the MySQL
>>>> Tuning changes in the Admin guide. At this point, I've had to pull our PF
>>>> from production, as it isn't stable enough.
>>>>
>>>> I have two core dumps from freeradius from when it crashes, but I haven't
>>>> been able to get anything useful out of them. Would anyone be interested
>>>> in seeing those? I am going to see if I can compile FR from source with
>>>> --enable-developer so I can more useful info in gdb. I might also switch
>>>> to RHEL and see if that has anything to do with it.
>>>>
>>>>
>>>> On Thu, Sep 5, 2013 at 6:11 AM, Louis Munro <lmu...@inverse.ca> wrote:
>>>> Hi Dave,
>>>> Have you checked for errors in logs/webservices_errors_log and
>>>> logs/webservices_access_log ?
>>>>
>>>> The packetfence module of FreeRADIUS calls on this webservice. The issue
>>>> could be related to that.
>>>>
>>>> Regards,
>>>> --
>>>> Louis Munro
>>>> lmu...@inverse.ca :: www.inverse.ca
>>>> +1.514.447.4918 *125 :: +1 (866) 353-6153
>>>> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
>>>> (www.packetfence.org)
>>>>
>>>> On 2013-09-04, at 13:07 , Derek Wuelfrath <dwuelfr...@inverse.ca> wrote:
>>>>
>>>>>> Debug is probably the only way you'll get an answer.
>>>>>>
>>>>>> radiusd -X -d /usr/local/pf/raddb > /usr/local/pf/logs/radius.log 2>&1
>>>>>
>>>>> Running FreeRADIUS in debug mode will remove the "multithreading" support
>>>>> which is almost all of the time the cause of the crash (not that
>>>>> multithreading is buggy in FreeRADIUS but it is contributing to crashing).
>>>>>
>>>>> That can certainly help you but that may also "prevent" your FreeRADIUS
>>>>> from crashing.
>>>>>
>>>>> Derek
>>>>>
>>>>> --
>>>>> Derek Wuelfrath
>>>>> dwuelfr...@inverse.ca :: +1.514.447.4918 (x110) :: www.inverse.ca
>>>>> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
>>>>> (www.packetfence.org)
>>>>>
>>>>> On 2013-09-04, at 6:41 AM, Jason Frisvold <xenoph...@godshell.com> wrote:
>>>>>
>>>>>> Bulanda, Dave G wrote:
>>>>>>> Louis,
>>>>>>>
>>>>>>> Radius is still stopping. I have an external NMS monitor for the process
>>>>>>> and alert and then restart the service pfcmd service radius restart (As
>>>>>>> it is still leaving a pid file.) At least this is minimizing the impact
>>>>>>> on my users, but I would like to resolve this.
>>>>>>>
>>>>>>> What other places/logs can I check?
>>>>>>
>>>>>> Well... Not sure if you're going to like this, but I would recommend
>>>>>> running radiusd with the -X flag and redirecting output to a log file.
>>>>>> This puts radiusd into debug mode and will provide significantly more
>>>>>> information on what's happening. From the log you provided, it appears
>>>>>> that radiusd is just stopping with no log entry indicating what
>>>>>> happened. Debug is probably the only way you'll get an answer.
>>>>>>
>>>>>> radiusd -X -d /usr/local/pf/raddb > /usr/local/pf/logs/radius.log 2>&1
>>>>>>
>>>>>> This does run in the foreground, though, so you'll have to keep a
>>>>>> session open. I suggest using the screen command for this so a timeout
>>>>>> doesn't kill your session.
>>>>>>
>>>>>>> Thank you again for all the help,
>>>>>>>
>>>>>>> David Bulanda
>>>>>>
>>>>>>
>>>>>> --
>>>>>> ---------------------------
>>>>>> Jason 'XenoPhage' Frisvold
>>>>>> xenoph...@godshell.com
>>>>>> ---------------------------
>>>>>>
>>>>>> "Any sufficiently advanced magic is indistinguishable from technology.\"
>>>>>> - Niven's Inverse of Clarke's Third Law
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
>>>>>> Discover the easy way to master current and previous Microsoft
>>>>>> technologies
>>>>>> and advance your career. Get an incredible 1,500+ hours of step-by-step
>>>>>> tutorial videos with LearnDevNow. Subscribe today and save!
>>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
>>>>>> _______________________________________________
>>>>>> PacketFence-users mailing list
>>>>>> PacketFence-users@lists.sourceforge.net
>>>>>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
>>>>> Discover the easy way to master current and previous Microsoft
>>>>> technologies
>>>>> and advance your career. Get an incredible 1,500+ hours of step-by-step
>>>>> tutorial videos with LearnDevNow. Subscribe today and save!
>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
>>>>> _______________________________________________
>>>>> PacketFence-users mailing list
>>>>> PacketFence-users@lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
>>>> Discover the easy way to master current and previous Microsoft technologies
>>>> and advance your career. Get an incredible 1,500+ hours of step-by-step
>>>> tutorial videos with LearnDevNow. Subscribe today and save!
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
>>>> _______________________________________________
>>>> PacketFence-users mailing list
>>>> PacketFence-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Fletcher Haynes <fhay...@willamette.edu>
>>>> Systems Administrator/Network Services Consultant
>>>> Willamette Integrated Technology Services
>>>> Willamette University, Salem, OR
>>>> Phone: 503.370.6016
>>>> ------------------------------------------------------------------------------
>>>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
>>>> Discover the easy way to master current and previous Microsoft technologies
>>>> and advance your career. Get an incredible 1,500+ hours of step-by-step
>>>> tutorial videos with LearnDevNow. Subscribe today and save!
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk_______________________________________________
>>>>
>>>> PacketFence-users mailing list
>>>> PacketFence-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
>>> Discover the easy way to master current and previous Microsoft technologies
>>> and advance your career. Get an incredible 1,500+ hours of step-by-step
>>> tutorial videos with LearnDevNow. Subscribe today and save!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> PacketFence-users mailing list
>>> PacketFence-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>>>
>>>
>>>
>>>
>>> --
>>> Fletcher Haynes <fhay...@willamette.edu>
>>> Systems Administrator/Network Services Consultant
>>> Willamette Integrated Technology Services
>>> Willamette University, Salem, OR
>>> Phone: 503.370.6016
>>> ------------------------------------------------------------------------------
>>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
>>> Discover the easy way to master current and previous Microsoft technologies
>>> and advance your career. Get an incredible 1,500+ hours of step-by-step
>>> tutorial videos with LearnDevNow. Subscribe today and save!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk_______________________________________________
>>> PacketFence-users mailing list
>>> PacketFence-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>>
>> ------------------------------------------------------------------------------
>> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
>> Discover the easy way to master current and previous Microsoft technologies
>> and advance your career. Get an incredible 1,500+ hours of step-by-step
>> tutorial videos with LearnDevNow. Subscribe today and save!
>> http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk_______________________________________________
>> PacketFence-users mailing list
>> PacketFence-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
> ------------------------------------------------------------------------------
> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
> Discover the easy way to master current and previous Microsoft technologies
> and advance your career. Get an incredible 1,500+ hours of step-by-step
> tutorial videos with LearnDevNow. Subscribe today and save!
> http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
> _______________________________________________
> PacketFence-users mailing list
> PacketFence-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
>
> --
> Fletcher Haynes <fhay...@willamette.edu>
> Systems Administrator/Network Services Consultant
> Willamette Integrated Technology Services
> Willamette University, Salem, OR
> Phone: 503.370.6016
>
>
>
> --
> Fletcher Haynes <fhay...@willamette.edu>
> Systems Administrator/Network Services Consultant
> Willamette Integrated Technology Services
> Willamette University, Salem, OR
> Phone: 503.370.6016
>
>
>
> --
> Fletcher Haynes <fhay...@willamette.edu>
> Systems Administrator/Network Services Consultant
> Willamette Integrated Technology Services
> Willamette University, Salem, OR
> Phone: 503.370.6016
> ------------------------------------------------------------------------------
> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
> Discover the easy way to master current and previous Microsoft technologies
> and advance your career. Get an incredible 1,500+ hours of step-by-step
> tutorial videos with LearnDevNow. Subscribe today and save!
> http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk_______________________________________________
> PacketFence-users mailing list
> PacketFence-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
