Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

to-14.1-crypt-at-rest.pl is failing #8469

Open
JeGoi opened this issue Jan 6, 2025 · 2 comments
Open

to-14.1-crypt-at-rest.pl is failing #8469

JeGoi opened this issue Jan 6, 2025 · 2 comments

Comments

@JeGoi
Copy link
Contributor

JeGoi commented Jan 6, 2025

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:

  1. Do a cluster upgrade on 14.0 to 14.1 : /usr/local/pf/addons/upgrade/do-upgrade.sh
  2. See error
@JeGoi
Copy link
Contributor Author

JeGoi commented Jan 8, 2025

Upgrade script is working without it:

---------------------------------------------------------------------------------
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

@JeGoi
Copy link
Contributor Author

JeGoi commented Jan 10, 2025

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.

So...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants