Resolved Upgrading to Plesk 18.0.45

[Franco]

Server operating system version

CentOS 7.9

Plesk version and microupdate number

18.0.44 #3

Hello,

I am currently running Plesk 18.0.44 #3 and the automatic upgrade to 18.0.45 failed due to the wrong or obsolete MariaDB repository. I am on CentOS 7.9 and my MariaDB version is 10.1.
I have seen a few discussions on the topic of upgrading MariaDB, but I remain confused on what to do. Shall I run this procedure https://support.plesk.com/hc/en-us/articles/213367429 or this one instead  How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux? (manual method for CentOS)?

My MariaDB current repo looks like this:

name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1


Can you please help?

Thanks!

 

[IgorG]

On my personal Plesk server, I see:

# plesk version
Product version: Plesk Obsidian 18.0.45.2
     OS version: CentOS 7.9.2009 x86_64
     Build date: 2022/07/22 09:00

# mysql -V
mysql  Ver 15.1 Distrib 10.2.44-MariaDB, for Linux (x86_64) using readline 5.1

# cat /etc/yum.repos.d/MariaDB.repo
# MariaDB 10.2 CentOS repository list - created 2018-09-18 06:32 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.2/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

 

[syazov]

Hello Franco,​

you can try to disable obsoleted mariadb repo with `yum-config-manager --disable mariadb` and then perform upgrade of plesk.

 

[Maarten.]

baseurl = http://yum.mariadb.org/10.1/centos7-amd64

This MariaDB version is no longer supported; that's why the URL points to an empty repository:

MariaDB

Check end-of-life, release policy and support schedule for MariaDB.

endoflife.date

I suggest that you perform the upgrade to at least MariaDB 10.5 using the support article you mentioned. It's an easy upgrade.

At the end of the upgrade, run # plesk repair db to correct the date and time fields in the database.

 

[Franco]

Hi syazov, I could upgrade Plesk by disabling the repo, as per you suggestion, thanks.
Now, maartenv, which of the 2 articles I mentioned shall I follow, please? They seem radically different.

Best,

Franco

 

[Maarten.]

Now, maartenv, which of the 2 articles I mentioned shall I follow, please? They seem radically different.

Best,

Franco

This article:

 How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?

Applicable to: Plesk for Linux Question How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.X on Linux? Answer This article provides instructions for upgrading MySQL 5.5 to 5.6/5.7 and Mari...

support.plesk.com

 

[Franco]

Hi maartenv,
I managed to run the upgrade to mariadb 10.6, successfully, by the look of it. However, I had 2 moments of "panic":

1. The upgrade would not run ("nothing to upgrade") which was due to the fact that I had to disable the mariadb in yum earlier on. After fixing that the upgrade run successfully.

2. The mariadb server would not start, but I quickly found it was due to this: https://support.plesk.com/hc/en-us/...-on-TCP-IP-port-Got-error-22-Invalid-argument

Thanks a lot!

Franco