search

inverse-inc / packetfence

PacketFence is a fully supported, trusted, Free and Open Source network access control (NAC) solution. Boasting an impressive feature set including a captive-portal for registration and remediation, centralized wired and wireless management, powerful BYOD management options, 802.1X support, layer-2 isolation of problematic devices; PacketFence can be used to effectively secure networks small to very large heterogeneous networks.
https://packetfence.org
GNU General Public License v2.0
1.35k stars 284 forks source link

Upgrade from 7.4.0 to 7.4.9 failed #3188

Closed satkunas closed 6 years ago

satkunas commented 6 years ago

Upgrade Summary

I'm attempting to upgrade from 7.3.9 -> 7.4.0 -> 7.4.9

I'm following the upgrade guide at: https://github.com/inverse-inc/packetfence/blob/devel/UPGRADE.asciidoc#upgrading-from-a-version-prior-to-7-4-0

7.3.9 -> 7.4.0:

No issues

7.4.0 to 7.4.9:

Upon upgrade completion I'm getting a failed service start, with the following error:

Checking configuration sanity...
FATAL - person user id "admin" must exist - please reinitialize your database
FATAL - person user id "default" must exist - please reinitialize your database
FATAL - The PacketFence database schema version '7.3.9' does not match the current installed version '7.4.9'

Upgrade Process

yum update packetfence --enablerepo=packetfence-devel

[snipped]

Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : perl-Lingua-EN-Nums2Words-1.16-1.1.noarch                                                                                                                                                      1/21 
  Installing : perl-Lingua-EN-Inflexion-0.001006-1.1.noarch                                                                                                                                                   2/21 
  Updating   : packetfence-pfcmd-suid-7.4.9-0.201804250751.el7.x86_64                                                                                                                                         3/21 
  Installing : fingerbank-collector-1.0.0-55.1.x86_64                                                                                                                                                         4/21 
fingerbank:x:990:pf
fingerbank:x:992:990::/usr/local/fingerbank:/sbin/nologin
  Updating   : fingerbank-4.0.0-17.1.noarch                                                                                                                                                                   5/21 
DBIx::Class::Schema::Versioned::_on_connect(): Versions out of sync. This is 4.0, your database contains version 3.1, please call upgrade on your Schema. at db/upgrade.pl line 37
DBIx::Class::Schema::Versioned::upgrade_single_step(): DB version (3.1) is lower than the schema version (4.0). Attempting upgrade.
Finished running 4.0.0 configuration migration
  Installing : perl-Pod-Markdown-2.002-1.el7.noarch                                                                                                                                                           6/21 
  Installing : fping-4.0-4.1.x86_64                                                                                                                                                                           7/21 
  Installing : perl-EV-4.22-3.1.x86_64                                                                                                                                                                        8/21 
  Installing : perl-IO-Socket-IP-0.39-1.1.noarch                                                                                                                                                              9/21 
  Installing : perl-Mojolicious-7.57-7.1.noarch                                                                                                                                                              10/21 
  Installing : perl-MojoX-Log-Log4perl-0.11-1.1.noarch                                                                                                                                                       11/21 
  Updating   : packetfence-config-7.4.9-0.201804250751.el7.noarch                                                                                                                                            12/21 
Adding PacketFence config startup script
  Installing : etcd-3.2.15-1.el7.x86_64                                                                                                                                                                      13/21 
  Installing : netdata-1.10.0-12.1.x86_64                                                                                                                                                                    14/21 
  Updating   : perl-Net-Nessus-REST-0.7.0-2.1.noarch                                                                                                                                                         15/21 
Warning: mariadb.service changed on disk. Run 'systemctl daemon-reload' to reload units.
Removed symlink /etc/systemd/system/packetfence-base.target.wants/packetfence-redis-cache.service.
Removed symlink /etc/systemd/system/packetfence-base.target.wants/packetfence-config.service.
Failed to execute operation: No such file or directory
  Updating   : packetfence-7.4.9-0.201804250751.el7.noarch                                                                                                                                                   16/21 
Couldn't require pf::services::manager::dhcpd : Bareword "pf::config::is_omapi_configured" not allowed while "strict subs" in use at /usr/local/pf/lib/pf/services/manager/dhcpd.pm line 233.
Compilation failed in require at (eval 1052) line 2.
 at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 32.
Couldn't require pf::api::unifiedapiclient : Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
Compilation failed in require at (eval 1530) line 2.
 at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 32.
Couldn't require pf::provisioner::mobileiron : Attempt to reload pf/api/unifiedapiclient.pm aborted.
Compilation failed in require at /usr/local/pf/lib/pf/dhcp/api.pm line 30.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/dhcp/api.pm line 30.
Compilation failed in require at /usr/local/pf/lib/pf/ip4log.pm line 36.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/ip4log.pm line 36.
Compilation failed in require at /usr/local/pf/lib/pf/provisioner/mobileiron.pm line 24.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/provisioner/mobileiron.pm line 24.
Compilation failed in require at (eval 1648) line 2.
 at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 32.
Couldn't require pf::provisioner::opswat : Attempt to reload pf/ip4log.pm aborted.
Compilation failed in require at /usr/local/pf/lib/pf/provisioner/opswat.pm line 24.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/provisioner/opswat.pm line 24.
Compilation failed in require at (eval 1755) line 2.
 at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 32.
Couldn't require pf::provisioner::sentinelone : Attempt to reload pf/ip4log.pm aborted.
Compilation failed in require at /usr/local/pf/lib/pf/enforcement.pm line 58.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/enforcement.pm line 58.
Compilation failed in require at /usr/local/pf/lib/pf/provisioner/sentinelone.pm line 27.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/provisioner/sentinelone.pm line 27.
Compilation failed in require at (eval 1758) line 2.
 at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 32.
Couldn't require pf::provisioner::sepm : Attempt to reload pf/ip4log.pm aborted.
Compilation failed in require at /usr/local/pf/lib/pf/provisioner/sepm.pm line 24.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/provisioner/sepm.pm line 24.
Compilation failed in require at (eval 1968) line 2.
 at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 32.
Couldn't require pf::services::manager::iptables : Attempt to reload pf/ip4log.pm aborted.
Compilation failed in require at /usr/local/pf/lib/pf/scan.pm line 36.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/scan.pm line 36.
Compilation failed in require at /usr/local/pf/lib/pf/factory/scan.pm line 26.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/factory/scan.pm line 26.
Compilation failed in require at /usr/local/pf/lib/pf/Connection/Profile.pm line 31.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/Connection/Profile.pm line 31.
Compilation failed in require at /usr/local/pf/lib/pf/Connection/ProfileFactory.pm line 25.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/Connection/ProfileFactory.pm line 25.
Compilation failed in require at /usr/local/pf/lib/pf/node.pm line 94.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/node.pm line 94.
Compilation failed in require at /usr/local/pf/lib/pf/action.pm line 25.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/action.pm line 25.
Compilation failed in require at /usr/local/pf/lib/pf/class.pm line 32.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/class.pm line 32.
Compilation failed in require at /usr/local/pf/lib/pf/violation_config.pm line 21.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/violation_config.pm line 21.
Compilation failed in require at /usr/local/pf/lib/pf/violation.pm line 32.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/violation.pm line 32.
Compilation failed in require at /usr/local/pf/lib/pf/iptables.pm line 58.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/iptables.pm line 58.
Compilation failed in require at /usr/local/pf/lib/pf/services/manager/iptables.pm line 21.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/services/manager/iptables.pm line 21.
Compilation failed in require at (eval 1086) line 2.
 at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 32.
Couldn't require pf::services::manager::tc : Attempt to reload pf/iptables.pm aborted.
Compilation failed in require at /usr/local/pf/lib/pf/services/manager/tc.pm line 30.
BEGIN failed--compilation aborted at /usr/local/pf/lib/pf/services/manager/tc.pm line 30.
Compilation failed in require at (eval 2141) line 2.
 at /usr/share/perl5/vendor_perl/Module/Pluggable.pm line 32.
service|command
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
api-frontend|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
carbon-cache|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
carbon-relay|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
collectd|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
etcd|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
fingerbank-collector|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
haproxy-db|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
haproxy-portal|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
httpd.aaa|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
httpd.admin|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
httpd.collector|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
httpd.dispatcher|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
httpd.graphite|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
httpd.parking|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
httpd.portal|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
httpd.proxy|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
httpd.webservices|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
keepalived|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
netdata|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
p0f|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfbandwidthd|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfdetect|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfdhcp|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfdhcplistener|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfdns|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pffilter|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfipset|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfmon|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfperl-api|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfqueue|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfsetvlan|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfsso|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
pfstats|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
radiusd-acct|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
radiusd-auth|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
radsniff|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
redis_ntlm_cache|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
redis_queue|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
routes|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
snmptrapd|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
statsd|Service enabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
winbindd|Service disabled
Callback for pthread_atfork() died (ignored): Trying to store a value in resource::unified_api_system_user at /usr/local/pf/lib/pf/api/unifiedapiclient.pm line 53.
Restarting journald to enable persistent logging
Setting packetfence.target as the default systemd target.
Restarting rsyslogd
make: Circular conf/ssl/server.key <- conf/ssl/server.key dependency dropped.
make: Circular conf/ssl/server.crt <- conf/ssl/server.crt dependency dropped.
make: Circular conf/ssl/server.pem <- conf/ssl/server.pem dependency dropped.
make: `conf/ssl/server.pem' is up to date.
Disabling httpd startup script
Disabling redis startup script
Disabling netdata startup script
DH already exists, won't touch it!
pf.conf already exists, won't touch it!
Disabling SELinux...
setenforce: SELinux is disabled
net.ipv4.ip_forward = 1
Starting PacketFence Administration GUI...
FirewallD is not running
Created symlink from /etc/systemd/system/packetfence-base.target.wants/packetfence-redis-cache.service to /usr/lib/systemd/system/packetfence-redis-cache.service.
Created symlink from /etc/systemd/system/packetfence-base.target.wants/packetfence-config.service to /usr/lib/systemd/system/packetfence-config.service.
Removed symlink /etc/systemd/system/packetfence.target.wants/packetfence-iptables.service.
Created symlink from /etc/systemd/system/packetfence-base.target.wants/packetfence-routes.service to /usr/lib/systemd/system/packetfence-routes.service.
Created symlink from /etc/systemd/system/packetfence.target.wants/packetfence-iptables.service to /usr/lib/systemd/system/packetfence-iptables.service.
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-7.3.9-0.201801110000.el7.noarch                                                                                                                                                   17/21 
  Cleanup    : packetfence-pfcmd-suid-7.3.9-0.201801110000.el7.x86_64                                                                                                                                        18/21 
  Cleanup    : perl-Net-Nessus-REST-0.2-4.1.noarch                                                                                                                                                           19/21 
  Cleanup    : packetfence-config-7.3.9-0.201801110000.el7.noarch                                                                                                                                            20/21 
  Cleanup    : fingerbank-3.1.1-2.1.noarch                                                                                                                                                                   21/21 
  Verifying  : perl-Mojolicious-7.57-7.1.noarch                                                                                                                                                               1/21 
  Verifying  : perl-Lingua-EN-Inflexion-0.001006-1.1.noarch                                                                                                                                                   2/21 
  Verifying  : perl-MojoX-Log-Log4perl-0.11-1.1.noarch                                                                                                                                                        3/21 
  Verifying  : perl-Net-Nessus-REST-0.7.0-2.1.noarch                                                                                                                                                          4/21 
  Verifying  : netdata-1.10.0-12.1.x86_64                                                                                                                                                                     5/21 
  Verifying  : etcd-3.2.15-1.el7.x86_64                                                                                                                                                                       6/21 
  Verifying  : fingerbank-4.0.0-17.1.noarch                                                                                                                                                                   7/21 
  Verifying  : packetfence-config-7.4.9-0.201804250751.el7.noarch                                                                                                                                             8/21 
  Verifying  : perl-IO-Socket-IP-0.39-1.1.noarch                                                                                                                                                              9/21 
  Verifying  : perl-EV-4.22-3.1.x86_64                                                                                                                                                                       10/21 
  Verifying  : fping-4.0-4.1.x86_64                                                                                                                                                                          11/21 
  Verifying  : perl-Pod-Markdown-2.002-1.el7.noarch                                                                                                                                                          12/21 
  Verifying  : fingerbank-collector-1.0.0-55.1.x86_64                                                                                                                                                        13/21 
  Verifying  : packetfence-7.4.9-0.201804250751.el7.noarch                                                                                                                                                   14/21 
  Verifying  : perl-Lingua-EN-Nums2Words-1.16-1.1.noarch                                                                                                                                                     15/21 
  Verifying  : packetfence-pfcmd-suid-7.4.9-0.201804250751.el7.x86_64                                                                                                                                        16/21 
  Verifying  : packetfence-7.3.9-0.201801110000.el7.noarch                                                                                                                                                   17/21 
  Verifying  : perl-Net-Nessus-REST-0.2-4.1.noarch                                                                                                                                                           18/21 
  Verifying  : packetfence-config-7.3.9-0.201801110000.el7.noarch                                                                                                                                            19/21 
  Verifying  : packetfence-pfcmd-suid-7.3.9-0.201801110000.el7.x86_64                                                                                                                                        20/21 
  Verifying  : fingerbank-3.1.1-2.1.noarch                                                                                                                                                                   21/21 

Dependency Installed:
  etcd.x86_64 0:3.2.15-1.el7             fingerbank-collector.x86_64 0:1.0.0-55.1       fping.x86_64 0:4.0-4.1                      netdata.x86_64 0:1.10.0-12.1              perl-EV.x86_64 0:4.22-3.1         
  perl-IO-Socket-IP.noarch 0:0.39-1.1    perl-Lingua-EN-Inflexion.noarch 0:0.001006-1.1 perl-Lingua-EN-Nums2Words.noarch 0:1.16-1.1 perl-MojoX-Log-Log4perl.noarch 0:0.11-1.1 perl-Mojolicious.noarch 0:7.57-7.1
  perl-Pod-Markdown.noarch 0:2.002-1.el7

Updated:
  packetfence.noarch 0:7.4.9-0.201804250751.el7                                                                                                                                                                    

Dependency Updated:
  fingerbank.noarch 0:4.0.0-17.1        packetfence-config.noarch 0:7.4.9-0.201804250751.el7        packetfence-pfcmd-suid.x86_64 0:7.4.9-0.201804250751.el7        perl-Net-Nessus-REST.noarch 0:0.7.0-2.1       

Complete!
sh /usr/local/pf/addons/dev-helpers/centos-chroot/install-packages-from-spec.sh 

[snipped]

Updated:
  net-snmp.x86_64 1:5.7.2-28.el7_4.1                                                                    net-snmp-perl.x86_64 1:5.7.2-28.el7_4.1                                                                   

Dependency Updated:
  net-snmp-agent-libs.x86_64 1:5.7.2-28.el7_4.1                            net-snmp-devel.x86_64 1:5.7.2-28.el7_4.1                            net-snmp-libs.x86_64 1:5.7.2-28.el7_4.1                           

Complete!
mysql -u root -p pf -v < /usr/local/pf/db/upgrade-7.3.0-7.4.0.sql

SET @MAJOR_VERSION = 7
SET @MINOR_VERSION = 4
SET @SUBMINOR_VERSION = 0

SET @PREV_MAJOR_VERSION = 7
SET @PREV_MINOR_VERSION = 3
SET @PREV_SUBMINOR_VERSION = 0

[snipped]
systemctl daemon-reload
vi conf/currently-at 
/usr/local/pf/addons/upgrade/to-8.0-authentication-conf.pl

There are no realms to adjust which means no changes are necessary. 
/usr/local/pf/addons/upgrade/to-8.0-fingerbank-db-data.pl

Completed migration of the Fingerbank device names in the node table 
mysql -u root -p pf -v < /usr/local/pf/db/upgrade-X.X.X-X.Y.Z.sql

SET @MAJOR_VERSION = 7
SET @MINOR_VERSION = 4
SET @SUBMINOR_VERSION = 9

SET @PREV_MAJOR_VERSION = 7
SET @PREV_MINOR_VERSION = 4
SET @PREV_SUBMINOR_VERSION = 0

[snipped]
vi conf/currently-at 
bin/pfcmd configreload hard
bin/pfcmd pfconfig reload
bin/pfcmd service pf start

service|command
Created symlink from /etc/systemd/system/packetfence-base.target.wants/packetfence-haproxy-portal.service to /usr/lib/systemd/system/packetfence-haproxy-portal.service.
Job for packetfence-haproxy-portal.service failed because the control process exited with error code. See "systemctl status packetfence-haproxy-portal.service" and "journalctl -xe" for details.
haproxy-portal|not started
httpd.admin|already started
Checking configuration sanity...
FATAL - person user id "admin" must exist - please reinitialize your database
FATAL - person user id "default" must exist - please reinitialize your database
FATAL - The PacketFence database schema version '7.3.9' does not match the current installed version '7.4.9'
Please refer to the UPGRADE guide on how to complete an upgrade of PacketFence
julsemaan commented 6 years ago

I may be going with the obvious thing, but just to make sure, did you follow the 8.0 upgrade instructions in the upgrade guide that is in devel ?

satkunas commented 6 years ago

@julsemaan I was applying the upgrade-* scripts to a non-used database (pf). My config is currently using an alternative mysql database name (pf_test74).

I've since renamed to databases and updated mysql directives in pf.conf and pfconfig.conf.

I'm currently using 7.3.9. Upgrading with /usr/local/pf/db/upgrade-7.3.0-7.4.0.sql produces a SUBVERSION_MINOR mismatch. What should I do in the case of upgrading from 7.3.9 to 7.4.0?

Should I assume that I'm running 7.4.0 and update upgrade-X.X.X-X.Y.Z.sql to read?:

SET @PREV_MAJOR_VERSION = 7;
SET @PREV_MINOR_VERSION = 3;
SET @PREV_SUBMINOR_VERSION = 9;

in order to force 7.3.9 to 7.4.9?

julsemaan commented 6 years ago

When you're testing, I would suggest you only upgrade stable to devel, never devel to devel

You're going to shoot yourself in the foot doing so

If you want to test the upgrade, install 7.4 then upgrade it to 8.0 (7.4.9)