Upgrading to 2026R1.1.1 fails during InnoDB Migration Script

[[email protected]]

I am trying to upgrade to 2026R1.1.1 but every time it fails with this error:

Code: Select all

==========================================
InnoDB Migration Script
Started: Fri Feb  6 01:11:17 PM CET 2026
==========================================

[2026-02-06 13:11:17] Checking MySQL connection...
[2026-02-06 13:11:17] ERROR: Cannot connect to MySQL server
[2026-02-06 13:11:17] Server: localhost:3306
[2026-02-06 13:11:17] User: root
WARNING: InnoDB migration failed or was skipped. Skipping schema_80002.sql update. SSO will not work until this is manually run.
To run manually, run the following command:
bash ./nagiosxi/basedir/scripts/migrate_tables_to_innodb.sh
Then run the following command:
mysql -h localhost -u root -p --database=nagiosxi --force < nagiosxi/nagiosxi-db/mods/mysql/schema_80002.sql
Then run the following command:
touch 'mysql.80002.updated'

* First time I took a VM snapshot and tried to upgrade, I was on 2024R1.3 . I tried upgrading through webUI but it failed.
* Second time I tried through CLI and I got the error above.
* Reverted to snapshot and tried upgrading version per version through the CLI. I managed to upgrade to 2026R1.1 without issue.
* Re-tried upgrading to 2026R1.1.1, this time from 2026R1.1 -> got error above again.

I followed the instruction to run

Code: Select all

bash ./nagiosxi/basedir/scripts/migrate_tables_to_innodb.sh

but got the same error.

[kg2857]

You need to resolve this first.
[2026-02-06 13:11:17] ERROR: Cannot connect to MySQL server

[[email protected]]

Thanks for your suggestion. I already looked at that but can't find a problem with MySQL. I can't find anything in logs, I can log in on MySQL, and since the other updates didn't have issues with MySQL I thought there might be a different issue.

[[email protected]]

Same issue occurred whenn upgrading to 2026R1.2 .

I tried to manually start the mysql cli, but it only worked without the `-P` parameter.
Since the error specifically mentioned `:3306` I tried editing the script `nagiosxi/basedir/scripts/migrate_tables_to_innodb.sh` and removed '-P $db_port' from line 59. That worked.

No idea if it's some strange config quirk in our setup or a bug but we worked around it and everything works now.