I believe I see our issue. Looking at the Upgrade document. The upgrade from
4.3 - 4.4 did not indicate that there is a SQL step. This should be corrected
in the UPGRADE doc.
Would there be any harm doing this at version 4.7?
Thanks
Dan Nelson
From: Dan Nelson
Sent: Tuesday, April 21, 2015 3:05 PM
To: [email protected]
Subject: Errors upgrading from 4.7 to 5.0
I am seeing similar errors as others on the forum. SQL IP_History table
missing. Here is my report.
First error during installing using yum update packetfence
--enablerepo=packetfence
...
Updating : packetfence-5.0.0-1.el6.noarch
60/63
Message from syslogd@fennel2 at Apr 21 13:52:49 ...
packetfence: FATAL - Can't use an undefined value as a HASH reference at
/usr/local/pf/lib/pfconfig/cached_array.pm line 108.#012
Message from syslogd@fennel2 at Apr 21 13:52:49 ...
packetfence: FATAL - Can't use an undefined value as a HASH reference at
/usr/local/pf/lib/pfconfig/cached_array.pm line 108.#012Compilation failed in
require at /usr/local/pf/lib/pf/config.pm line 841.#012
warning: /usr/local/pf/conf/adminroles.conf created as
/usr/local/pf/conf/adminroles.conf.rpmnew
warning: /usr/local/pf/conf/violations.conf created as
/usr/local/pf/conf/violations.conf.rpmnew
Enabling mysqld startup script
DH already exists, won't touch it!
pf.conf already exists, won't touch it!
Disabling SELinux...
setenforce: SELinux is disabled
Starting Packetfence...
rm: cannot remove `/usr/local/pf/var/cache/configfiles': Directory not empty
Can't use an undefined value as a HASH reference at
/usr/local/pf/lib/pfconfig/cached_array.pm line 108.
Compilation failed in require at /usr/local/pf/lib/pf/config.pm line 841.
Starting PacketFence...Set name-type for VLAN subsystem. Should be visible in
/proc/net/vlan/config
Couldn't require pf::services::manager::httpd_admin : Can't use an undefined
value as a HASH reference at /usr/local/pf/lib/pfconfig/cached_array.pm line
108.
Compilation failed in require at /usr/local/pf/lib/pf/services/manager/httpd.pm
line 23.
BEGIN failed--compilation aborted at
/usr/local/pf/lib/pf/services/manager/httpd.pm line 23.
Compilation failed in require at /usr/share/perl5/vendor_perl/Module/Runtime.pm
line 317.
Compilation failed in require at (eval 1338) line 3.
at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 28
Couldn't require pf::services::manager::httpd_portal : Attempt to reload
pf/services/manager/httpd.pm aborted.
Compilation failed in require at /usr/share/perl5/vendor_perl/Module/Runtime.pm
line 317.
Compilation failed in require at (eval 1949) line 3.
at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 28
Couldn't require pf::services::manager::httpd_webservices : Attempt to reload
pf/services/manager/httpd.pm aborted.
Compilation failed in require at /usr/share/perl5/vendor_perl/Module/Runtime.pm
line 317.
Compilation failed in require at (eval 1953) line 3.
at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 28
Couldn't require pf::services::manager::httpd_proxy : Attempt to reload
pf/services/manager/httpd.pm aborted.
Compilation failed in require at /usr/share/perl5/vendor_perl/Module/Runtime.pm
line 317.
Compilation failed in require at (eval 1961) line 3.
at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 28
Couldn't require pf::services::manager::httpd_aaa : Attempt to reload
pf/services/manager/httpd.pm aborted.
Compilation failed in require at /usr/share/perl5/vendor_perl/Module/Runtime.pm
line 317.
Compilation failed in require at (eval 2047) line 3.
at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 28
module pf::cmd::pf::service cannot be loaded
Can't locate object method "name" via package
"pf::services::manager::httpd_portal" at /usr/local/pf/lib/pf/services.pm line
39.
Compilation failed in require at /usr/local/pf/lib/pf/cmd/pf/service.pm line 56.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/cmd/pf/service.pm
line 56.
Compilation failed in require at /usr/share/perl5/Module/Load.pm line 27.
Can't locate pf/cmd/pf/service in @INC (@INC contains: /usr/local/pf/lib
/usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl
/usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at
/usr/share/perl5/Module/Load.pm line 27.
Usage:
pfcmd <command> [options]
Commands
cache | manage the cache subsystem
checkup | perform a sanity checkup and report any
problems
class | view violation classes
config | query, set, or get help on pf.conf
configuration paramaters
configfiles | push or pull configfiles into/from database
configreload | reload the configution
fingerprint | view DHCP Fingerprints
floatingnetworkdeviceconfig | query/modify floating network devices
configuration parameters
help | show help for pfcmd commands
ifoctetshistorymac | accounting history
ifoctetshistoryswitch | accounting history
ifoctetshistoryuser | accounting history
import | bulk import of information into the database
ipmachistory | IP/MAC history
locationhistorymac | Switch/Port history
locationhistoryswitch | Switch/Port history
networkconfig | query/modify network configuration
parameters
portalprofileconfig | query/modify portal profile configuration
parameters
reload | rebuild fingerprint or violations tables
without restart
service | start/stop/restart and get PF daemon status
switchconfig | query/modify switches.conf configuration
parameters
version | output version information
violationconfig | query/modify violations.conf configuration
parameters
Please view "pfcmd help <command>" for details on each option
Installation complete
* Please fire up your Web browser and go to
https://@ip_packetfence:1443/configurator to complete your PacketFence
configuration.
* Please stop your iptables service if you don't have access to configurator.
Cleanup : packetfence-4.7.0-1.el6.noarch
61/63
Cleanup : packetfence-pfcmd-suid-4.5.1-1.el6.x86_64
62/63
Cleanup : packetfence-config-4.7.0-1.el6.noarch
63/63
...
Then when trying to upgrade SQL I get this
root@fennel2:/usr/local/pf[root@fennel2 pf]# mysql -u root -p pf -v <
db/upgrade-4.7.0-5.0.0.sql
Enter password:
--------------
CREATE TABLE keyed (
id VARCHAR(255),
value LONGBLOB,
PRIMARY KEY(id)
) ENGINE=InnoDB
--------------
--------------
RENAME TABLE temporary_password TO `password`
--------------
--------------
RENAME TABLE iplog_history TO iplog_archive
--------------
ERROR 1017 (HY000) at line 21: Can't find file: './pf/iplog_history.frm'
(errno: 2)
Then on reboot the webservice started but the admin password would not take.
Had to roll back snapshot to 4.7.
Thanks
Dan Nelson
------------------------------------------------------------------------------
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
