James,
Thanks!
This makes sense, on one hand; on another hand if you have your server on a
regular auto-update schedule that comes in as being highly disruptive as
all of a sudden your PF updates and then stops working.
I guess for now I will just take it off the auto-update schedule by
disabling the PF repository.
One thing seemingly not mentioned in the upgrade documentation is the newly
changed password handling schema. Here is the discussion on that:
http://www.mail-archive.com/packetfence-users%40lists.sourceforge.net/msg08390.html
Cheers,
Boris.
On Fri, Apr 17, 2015 at 11:02 AM, James Rouzier <jrouz...@inverse.ca> wrote:
> Boris,
>
> We do not update automatically the database schema or configuration for
> the following reasons.
>
> * PacketFence does not store the MySQL root password database user in our
> configurations.
> * The PacketFence database user does not have the permission to add and
> alter tables.
> * This may break custom code/database schema's
> * Upgrade a database can take a long time if you have a huge database it
> makes it harder to plan downtime.
> * New features and/or bugs fixes require changes in configuration that
> cannot be determined.
>
> This is why we advise to always read the upgrade guide before upgrading
> PacketFence.
>
> https://github.com/inverse-inc/packetfence/blob/packetfence-5.0.0/UPGRADE.asciidoc
>
>
>
>
> James rouzierjrouz...@inverse.ca :: +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 1:29 PM, Boris Epstein wrote:
>
> 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 <jrouz...@inverse.ca>
> wrote:
>
>> Boris It looks like you did not upgrade your database when you updated
>> packetfence.
>>
>> James rouzierjrouz...@inverse.ca :: +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 <borepst...@gmail.com>
>> 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 <jrouz...@inverse.ca>
>>> wrote:
>>>
>>>> Boris this is an issue where radius cannot communicate with the
>>>> httpd.webservices.
>>>> Can you make sure that is running first!
>>>>
>>>> James rouzierjrouz...@inverse.ca :: +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 <borepst...@gmail.com>
>>>> 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
>>>> listPacketFence-users@lists.sourceforge.nethttps://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
>>>> PacketFence-users@lists.sourceforge.net
>>>> 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
>> listPacketFence-users@lists.sourceforge.nethttps://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
>> PacketFence-users@lists.sourceforge.net
>> 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
> listPacketFence-users@lists.sourceforge.nethttps://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
> PacketFence-users@lists.sourceforge.net
> 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
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
