Hi all I have upgraded to MariaDB 10.6.3 on ubuntu 18.04 When I run the upgrade to 3.2.5 I get the following error: The root password in the file is correct as I can connect to the mysql client with it. Do you have any suggestions?
This worked prior to upgrading mariadb? Did it work after upgrading mariadb, prior to updating ISPConfig? What versions did you upgrade from? My first thought is downgrade mariadb to a supported version (https://packages.ubuntu.com/bionic/mariadb-server). As for making 10.6.3 work, I have not experience there, it looks like none of my servers are that version; I'd start with searching for that error and changes in newer mariadb which cause it.
Yes, if your database files have updated to a newer format, you probably can't just install the older package versions, you probably need to restore a backup from before the mariadb upgrade. I suppose if the new mariadb is up and healthy, and if you have newer data that has changed since your pe-upgrade backups, I'd sure give dump/restore a shot as well. Ie. dump your databases in the newer mariadb, move all of /var/lib/mysql out of the way and install the old mariadb version, then see if you can import your db dumps.
I made a huge mistake of not backing up. I had a backup of the full VM the night before. All systems are working perfectly with the new version, it's just the upgrade script. So I think I will have to wait till the script supports MariaDB 10.6.3 Thank you so much for your assistance.
If ISPConfig still works, then the issue is probably not in the ISPConfig update script. What's more likely that the new MariaDB version somehow blocks access via root user through TCP connection, maybe they allow only cli connections now. You should check the permissions of the MariaDB root user and fix it so that TCP connections are possible again.
Btw. Such issues are the reason why we are using the MariaDB version from the Linux distributions and not from the MariaDB website. If you want to have a stable system, I'll highly recommend sticking to our install guides.
