I had the same issue, it seems like MariaDB
has updated their site. For now you can just manually upgrade through
SSH. Since you're using Debian 12 (which is what I am using as well)
this is what I did to update mine:
Please note of the following:
Bash:
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /root/all-databases.sql
service mariadb stop
apt install apt-transport-https curl
curl -o /etc/apt/keyrings/mariadb-keyring.pgp 'https://mariadb.org/mariadb_release_signing_key.pgp'
cp -v -a /var/lib/mysql/ /var/lib/mysql_backup
curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=11.8
apt update
apt install mariadb-server
systemctl start mariadb.service
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
systemctl restart mariadb
plesk bin service_node --update local
plesk sbin packagemng -sdf
Please note of the following:
- This was all done under root.
- Each line is a new command.
- I made a snapshot of my VM before updating.
- The instructions was a mix from https://support.plesk.com/hc/en-us/articles/12388091703703-How-to-upgrade-MariaDB-on-Plesk-for-Linux and Download MariaDB Server - MariaDB.org
- Some steps out of order since I wanted to make sure I have backups.
- I've installed 11.8 instead of 11.4 (since the change logs note that Plesk supports 11.8 now I figured might as well jump to that version).