You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
/usr/local/pf/addons/upgrade/do-upgrade.sh
root@deb-cluster03:~# /usr/local/pf/addons/upgrade/do-upgrade.sh
[...]
Running /usr/local/pf/addons/upgrade/to-14.1-crypt-at-rest.pl
[Mon Jan 6 16:08:58 2025] to-14.1-crypt-at-rest.pl: Ambiguous use of %{pf::UnifiedApi::Controller::Config::System::_get_dns_servers} resolved to %pf::UnifiedApi::Controller::Config::System::_get_dns_servers at /usr/local/pf/lib/pf/services/manager/netdata.pm line 73.
unable to connect to database: Can't connect to server on '100.64.0.1' (115) at /usr/local/pf/lib/pf/dal.pm line 69.
root@deb-cluster03:~#
root@deb-cluster03:~#
root@deb-cluster03:~# systemctl status packetfence-mariadb.service
● packetfence-mariadb.service - PacketFence MariaDB instance
Loaded: loaded (/lib/systemd/system/packetfence-mariadb.service; enabled; preset: enabled)
Active: active (running) since Mon 2025-01-06 15:52:17 EST; 27min ago
Main PID: 78721 (pf-mariadb)
Status: "Taking your SQL requests now..."
Tasks: 22 (limit: 9474)
Memory: 327.4M
CPU: 14.767s
CGroup: /packetfence.slice/packetfence-base.slice/packetfence-mariadb.service
├─78721 pf-mariadb
├─79033 /bin/sh /usr/bin/mysqld_safe --defaults-file=/usr/local/pf/var/conf/mariadb.conf
├─79320 /usr/sbin/mariadbd --defaults-file=/usr/local/pf/var/conf/mariadb.conf --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --wsrep_on=ON --wsrep_provider=/usr/>
└─79321 logger -t mysqld -p daemon error
Jan 06 16:06:53 deb-cluster03 packetfence[78721]: pf-mariadb(78721) ERROR: [1736197613.02536] Failed to connect to config service for namespace resource::cluster_hosts(DEFAULT), retrying (pfconfig::cache>
Jan 06 16:06:53 deb-cluster03 pf-mariadb[78721]: Connected to config service successfully for namespace resource::cluster_hosts(DEFAULT)[1736197613.02536] Failed to connect to config service for namespac>
Jan 06 16:06:53 deb-cluster03 packetfence[78721]: pf-mariadb(78721) ERROR: [1736197613.12784] Failed to connect to config service for namespace resource::cluster_hosts(DEFAULT), retrying (pfconfig::cache>
Jan 06 16:06:53 deb-cluster03 pf-mariadb[78721]: Connected to config service successfully for namespace resource::cluster_hosts(DEFAULT)[1736197613.12784] Failed to connect to config service for namespac>
Jan 06 16:06:53 deb-cluster03 pf-mariadb[78721]: Connected to config service successfully for namespace resource::cluster_hosts(DEFAULT)[1736197613.23031] Failed to connect to config service for namespac>
Jan 06 16:06:53 deb-cluster03 packetfence[78721]: pf-mariadb(78721) ERROR: [1736197613.23031] Failed to connect to config service for namespace resource::cluster_hosts(DEFAULT), retrying (pfconfig::cache>
Jan 06 16:06:53 deb-cluster03 packetfence[78721]: pf-mariadb(78721) ERROR: [1736197613.33302] Failed to connect to config service for namespace resource::cluster_hosts(DEFAULT), retrying (pfconfig::cache>
Jan 06 16:06:53 deb-cluster03 pf-mariadb[78721]: Connected to config service successfully for namespace resource::cluster_hosts(DEFAULT)[1736197613.33302] Failed to connect to config service for namespac>
Jan 06 16:06:53 deb-cluster03 packetfence[78721]: pf-mariadb(78721) ERROR: [1736197613.43586] Failed to connect to config service for namespace resource::cluster_hosts(DEFAULT), retrying (pfconfig::cache>
Jan 06 16:06:53 deb-cluster03 pf-mariadb[78721]: Connected to config service successfully for namespace resource::cluster_hosts(DEFAULT)[1736197613.43586] Failed to connect to config service for namespac>
lines 1-24/24 (END)
root@deb-cluster03:~#
root@deb-cluster03:~#
root@deb-cluster03:~# systemctl status packetfence-proxysql.service
○ packetfence-proxysql.service - PacketFence ProxySQL Load Balancer for connecting to clustered databases
Loaded: loaded (/lib/systemd/system/packetfence-proxysql.service; enabled; preset: enabled)
Active: inactive (dead)
Jan 06 15:45:53 deb-cluster03 proxysql-docker-wrapper[21477]: 2025-01-06 15:45:53 [INFO] Received LOAD MYSQL QUERY RULES TO RUNTIME command
Jan 06 15:45:53 deb-cluster03 proxysql-docker-wrapper[21477]: 2025-01-06 15:45:53 [INFO] Computed checksum for 'LOAD MYSQL QUERY RULES TO RUNTIME' was '0x18F0CAAB4B33927E', with epoch '1736196353'
Jan 06 15:45:55 deb-cluster03 systemd[1]: Stopping packetfence-proxysql.service - PacketFence ProxySQL Load Balancer for connecting to clustered databases...
Jan 06 15:45:55 deb-cluster03 proxysql-docker-wrapper[21477]: 2025-01-06 15:45:55 ProxySQL_GloVars.cpp:20:term_handler(): [WARNING] Received TERM signal: shutdown in progress...
Jan 06 15:45:55 deb-cluster03 bash[77418]: proxysql
Jan 06 15:45:55 deb-cluster03 bash[77460]: Error response from daemon: No such container: proxysql
Jan 06 15:45:55 deb-cluster03 bash[77417]: Stopped
Jan 06 15:45:55 deb-cluster03 systemd[1]: packetfence-proxysql.service: Deactivated successfully.
Jan 06 15:45:55 deb-cluster03 systemd[1]: Stopped packetfence-proxysql.service - PacketFence ProxySQL Load Balancer for connecting to clustered databases.
Jan 06 15:45:55 deb-cluster03 systemd[1]: packetfence-proxysql.service: Consumed 1.546s CPU time.
root@deb-cluster03:~#
root@deb-cluster03:~#
To Reproduce
Steps to reproduce the behavior:
Do a cluster upgrade on 14.0 to 14.1 : /usr/local/pf/addons/upgrade/do-upgrade.sh
See error
The text was updated successfully, but these errors were encountered:
---------------------------------------------------------------------------------
You need to input the PF version that comes before 14.1. This will replace X.X in the upgrade-X.X-X.Y.sql filename. Only input the minor version (ex: 11.2): 14.0
=================================================================================
Database pf runs version 14.1
Found upgrade path:
---------------------------------------------------------------------------------
Deleting content of keyed table
=================================================================================
Starting the upgrade of the configuration from 14.0.0
---------------------------------------------------------------------------------
Running /usr/local/pf/addons/upgrade/to-14.1-adds-domain-multi-machine-account-support.pl
---------------------------------------------------------------------------------
Running /usr/local/pf/addons/upgrade/to-14.1-convert-ciscoWLC-switch-types.pl
All done
---------------------------------------------------------------------------------
Running /usr/local/pf/addons/upgrade/to-14.1-convert-switch-types.pl
Nothing to be done
---------------------------------------------------------------------------------
Running /usr/local/pf/addons/upgrade/to-14.1-firewallsso.pl
=================================================================================
Checking for any .dpkg-dist files to process
---------------------------------------------------------------------------------
Handling .dpkg-dist conf/switches.conf.dpkg-dist
Downloading https://raw.githubusercontent.com/inverse-inc/packetfence/372135d9ef9df529b438d32eb048b75e508e0921/conf/switches.conf.example
Moving conf/switches.conf.dpkg-dist -> conf/switches.conf and creating backup file conf/switches.conf.upgrade-backup
Attempting a dry-run of the patch on conf/switches.conf
checking file conf/switches.conf
Hunk #2 FAILED at 30.
1 out of 2 hunks FAILED
Patching conf/switches.conf failed. Y
root@deb-cluster03:~# /usr/local/pf/addons/upgrade/to-14.1-crypt-at-rest.pl
pf::UnifiedApi::Controller::Config::AdminRoles
pf::UnifiedApi::Controller::Config::Bases
pf::UnifiedApi::Controller::Config::BillingTiers
pf::UnifiedApi::Controller::Config::Clouds
pf::UnifiedApi::Controller::Config::ConnectionProfiles
pf::UnifiedApi::Controller::Config::Connectors
pf::UnifiedApi::Controller::Config::Domains
pf::UnifiedApi::Controller::Config::EventHandlers
pf::UnifiedApi::Controller::Config::EventLoggers
pf::UnifiedApi::Controller::Config::FilterEngines::DHCPFilters
unable to connect to database: Can't connect to server on '100.64.0.1' (115) at /usr/local/pf/lib/pf/dal.pm line 69.
Describe the bug
/usr/local/pf/addons/upgrade/do-upgrade.sh
To Reproduce
Steps to reproduce the behavior:
The text was updated successfully, but these errors were encountered: