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 Rouzier
jrouz...@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
<mailto:jrouz...@inverse.ca>> wrote:
Boris It looks like you did not upgrade your database when you
updated packetfence.
James Rouzier
jrouz...@inverse.ca <mailto:jrouz...@inverse.ca> ::+1.514.755.3630
<tel:%2B1.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 <http://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 <mailto: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 <mailto: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 Rouzier
jrouz...@inverse.ca <mailto:jrouz...@inverse.ca> ::+1.514.755.3630
<tel:%2B1.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 <mailto: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
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
<mailto: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
<mailto: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
<mailto: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
<mailto: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
------------------------------------------------------------------------------
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
