James,
Yes, you are right. I now got packetfence-5.0.0-1.el6.noarch
I think DB upgrades need to be part of automatic package upgrades. I got
yum to do it automatically for me - but the DB ends up being left behind.
Thanks for your help debugging this one.
Boris.
On Thu, Apr 16, 2015 at 11:56 AM, James Rouzier <[email protected]> wrote:
> Boris It looks like you did not upgrade your database when you updated
> packetfence.
>
> James [email protected] :: +1.514.755.3630 :: http://www.inverse.ca
> Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
> (http://www.packetfence.org)
>
> On 2015-04-16 11:51 AM, Boris Epstein wrote:
>
> OK, here is the latest from packetfence.log
>
> Apr 16 11:50:14 httpd.aaa(10816) INFO: port security is not enabled
> (pf::Switch::Cisco::Catalyst_2960::isStaticPortSecurityEnabled)
> Apr 16 11:50:14 httpd.aaa(10816) INFO: [00:25:64:40:e3:61] handling radius
> autz request: from switch_ip => (192.168.48.101), connection_type =>
> WIRED_MAC_AUTH,switch_mac => (Unknown), mac => [00:25:64:40:e3:61], port =>
> 10121, username => "00256440e361" (pf::radius::authorize)
> Apr 16 11:50:14 httpd.aaa(10816) WARN: database query failed with: Unknown
> column 'machine_account' in 'field list' (errno: 1054), will try again
> (pf::db::db_query_execute)
> Apr 16 11:50:14 httpd.aaa(10816) WARN: database query failed with: Unknown
> column 'machine_account' in 'field list' (errno: 1054), will try again
> (pf::db::db_query_execute)
> Apr 16 11:50:14 httpd.aaa(10816) WARN: database query failed with: Unknown
> column 'machine_account' in 'field list' (errno: 1054), will try again
> (pf::db::db_query_execute)
> Apr 16 11:50:14 httpd.aaa(10816) ERROR: Database issue: We tried 3 times
> to serve query node_attributes_sql called from pf::node::node_attributes
> and we failed. Is the database running? (pf::db::db_query_execute)
> Apr 16 11:50:14 httpd.aaa(10816) WARN: database query failed with: Unknown
> column 'machine_account' in 'field list' (errno: 1054), will try again
> (pf::db::db_query_execute)
> Apr 16 11:50:14 httpd.aaa(10816) WARN: database query failed with: Unknown
> column 'machine_account' in 'field list' (errno: 1054), will try again
> (pf::db::db_query_execute)
> Apr 16 11:50:14 httpd.aaa(10816) WARN: database query failed with: Unknown
> column 'machine_account' in 'field list' (errno: 1054), will try again
> (pf::db::db_query_execute)
> Apr 16 11:50:14 httpd.aaa(10816) ERROR: Database issue: We tried 3 times
> to serve query node_attributes_sql called from pf::node::node_attributes
> and we failed. Is the database running? (pf::db::db_query_execute)
> Apr 16 11:50:14 httpd.aaa(10816) ERROR: radius authorize failed with
> error: Can't use string ("0") as a HASH ref while "strict refs" in use at
> /usr/local/pf/lib/pf/vlan.pm line 311.
> (pf::api::radius_authorize)
>
> Generated as I plugged a device into a RADIUS-controlled Cisco Catalyst
> 3750 switch.
>
> Any idea what this may indicate?
>
> Cheers,
>
> Boris.
>
>
> On Thu, Apr 16, 2015 at 11:38 AM, Boris Epstein <[email protected]>
> wrote:
>
>> James,
>>
>> Thanks!
>>
>> Based on the admin GUI and ps output the httpd.webservices process is
>> running. What should I look at next?
>>
>> Boris.
>>
>> On Thu, Apr 16, 2015 at 11:28 AM, James Rouzier <[email protected]>
>> wrote:
>>
>>> Boris this is an issue where radius cannot communicate with the
>>> httpd.webservices.
>>> Can you make sure that is running first!
>>>
>>> James [email protected] :: +1.514.755.3630 ::
>>> http://www.inverse.ca
>>> Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
>>> (http://www.packetfence.org)
>>>
>>> On 2015-04-16 11:23 AM, Boris Epstein wrote:
>>>
>>> OK, the best I can tell so far is it comes out of this module:
>>>
>>> http://wiki.freeradius.org/modules/Rlm_perl
>>>
>>> The investigation is ongoing... Stand by for more updates.
>>>
>>> Boris.
>>>
>>> On Tue, Apr 14, 2015 at 10:51 AM, Boris Epstein <[email protected]>
>>> wrote:
>>>
>>>> Hello listmates,
>>>>
>>>> I just got the following in my RADIUS log on my PF server:
>>>>
>>>> Tue Apr 14 10:48:00 2015 : Auth: Login OK: [00256440e361] (from client
>>>> 192.168.48.101 port 50119 cli 00-25-64-40-E3-61)
>>>> Tue Apr 14 10:48:00 2015 : Error: rlm_perl: No or invalid reply in RPC
>>>> communication with server. Check server side logs for details.
>>>>
>>>> Does anybody know how to interpret this?
>>>>
>>>> Thanks.
>>>>
>>>> Boris.
>>>>
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> 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
>>> exerciseshttp://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
>>> [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
> exerciseshttp://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
> [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
