Unable to update Plesk Obsidian: mariadb-server >= 5.0.60 is needed by plesk-mysql-server-18.0.2-2.centos.7+p18.0.45.2+t220722.0939.noarch

Symptoms

• Plesk Obsidian update fails with:

  PLESK_ERROR: Fatal error during packages installation: [u'ERROR with transaction check vs depsolve:', 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server-18.0.2-2.centos.7+p18.0.45.2+t220722.0939.noarch']

• Mysql community edition is installed instead of MariaDB on the server

• It was previously upgraded from Plesk Onyx

Cause

Plesk Onyx and Plesk Obsidian do not support MySQL Community server after upgrade. Only new installation of Plesk with MySQL Community is supported.

Resolution

Warning: Create a full server snapshot/backup before applying the steps below!

1. Connect to the server via SSH

2. Remove the plesk-mysql-server package without affecting the dependencies:

   # rpm -e --nodeps plesk-mysql-server

3. Download plesk-mysql-server-community package as a replacement:

   # wget http://autoinstall.plesk.com/mysql-server-community/plesk-mysql-server-community-centos-7.rpm

4. Install it:

   # rpm -i plesk-mysql-server-community-centos-7.rpm

5. Re-run the Plesk update