ISP Config 3.2.5

Discussion in 'General' started by troggie, Jul 21, 2021.

  1. troggie

    troggie New Member

    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?
     
  2. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    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.
     
  3. troggie

    troggie New Member

    From the mariaDB website.
     
  4. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    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.
     
    troggie likes this.
  5. troggie

    troggie New Member

    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.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

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

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  8. troggie

    troggie New Member

    Thank you @till.
     
  9. troggie

    troggie New Member

    100% sorry about this and thank you again for your assistance.
     

Share This Page