Hi Dan,
I don’t see a problem in doing that.
If you look at the db/upgrade-4.3.0-4.4.0.sql script, it does very little
apart from creating a new table.
You may want to delete old entries or even truncate that locationlog table if
you are not using port-security.
It would make running that script faster.
As always, make a backup first.
Regards,
--
Louis Munro
[email protected] :: www.inverse.ca
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
On Apr 21, 2015, at 17:10 , Dan Nelson <[email protected]> wrote:
> 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
------------------------------------------------------------------------------
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
