Resolved Upgrade to MariaDB 10.6

[Gene Steinberg]

MariaDB 0.0 B/s | 0 B 00:00


Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Empty mirrorlist and no basepath specified!


Either way.

 

[Maarten]

The reason we/Plesk recommend MariaDB 10.6 is because it's an LTS version (Long Term Support). That means it will receive updates till Jul 2026:

MariaDB

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

endoflife.date

Please check if the link in the mariadb.repo contains this (it works, I just checked it):

https://mirror.mariadb.org/yum/10.6/centos8-amd64/

 

[Gene Steinberg]

MariaDB 0.0 B/s | 0 B 00:00


Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Empty mirrorlist and no basepath specified!


[root@server ~]# MariaDB 0.0 B/s | 0 B 00:00


-bash: MariaDB: command not found


-bash: 0: command not found

 

[Maarten]

I think there is a typo in the repo file.
Can you post a screenshot of the output of this command?

# cat -vet /etc/yum.repos.d/MariaDB.repo

Can you also post the output of this command?

# yum repolist

 

[Gene Steinberg]

Doesn't see the file, but it IS in there.

 

[Maarten]

I have no idea what I'm looking at. Can you please execute the commands as root on the command line?

 

[Gene Steinberg]

I executed the command, and it returned me to the prompt without any result.

The screenshot posted is the index of that folder in which the file is placed.

/etc/yum.repos.d/MariaDB.repo

 

[Gene Steinberg]

Got it to work:

[mariadb]$

name = MariaDB$

baseurl = Index of https://mirror.mariadb.org/yum/10.6/centos8-amd64/$

gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB$

enabled=1$

module_hotfixes=1$

But I still get the same errors with the original base url and the one above.

 

[Gene Steinberg]

If done this install before on other servers and never encountered any trouble. Just this one.

 

[Gene Steinberg]

I used the MariaDB.repo file text from the Plesk instructions, changing 10.4 to 10.6.

Got this:

[root@server ~]# yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common

MariaDB 441 kB/s | 658 kB 00:01

AlmaLinux 8 - BaseOS 65 MB/s | 4.0 MB 00:00

AlmaLinux 8 - AppStream 85 MB/s | 11 MB 00:00

AlmaLinux 8 - Extras 241 kB/s | 19 kB 00:00

AlmaLinux 8 - PowerTools 51 MB/s | 3.0 MB 00:00

Extra Packages for Enterprise Linux 8 - x86_64 87 MB/s | 13 MB 00:00

Extra Packages for Enterprise Linux Modular 8 - 27 MB/s | 733 kB 00:00

PLESK_18_0_50 extras 1.4 MB/s | 157 kB 00:00

PHP 7.4 393 kB/s | 20 kB 00:00

PHP 8.0 379 kB/s | 19 kB 00:00

PHP 8.1 376 kB/s | 19 kB 00:00

PHP 8.2 369 kB/s | 19 kB 00:00

grafana extension repository 175 kB/s | 134 kB 00:00

panel-migrator extension repository 493 kB/s | 34 kB 00:00

site-import extension repository 527 kB/s | 34 kB 00:00

Error:

Problem: problem with installed package mariadb-devel-3:10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64

- package mariadb-devel-3:10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64 conflicts with mysql-devel provided by MariaDB-devel-10.6.10-1.el8.x86_64

- problem with installed package mariadb-connector-c-devel-3.1.11-2.el8_3.x86_64

- package mariadb-devel-3:10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64 conflicts with mysql-devel provided by MariaDB-devel-10.6.11-1.el8.x86_64

- package mariadb-devel-3:10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64 conflicts with mysql-devel provided by MariaDB-devel-10.6.12-1.el8.x86_64

- package mariadb-connector-c-devel-3.1.11-2.el8_3.x86_64 requires mariadb-connector-c = 3.1.11-2.el8_3, but none of the providers can be installed

- package MariaDB-shared-10.6.12-1.el8.x86_64 obsoletes mariadb-connector-c provided by mariadb-connector-c-3.1.11-2.el8_3.x86_64

- package MariaDB-shared-10.6.12-1.el8.x86_64 obsoletes mariadb-connector-c provided by mariadb-connector-c-3.1.11-2.el8_3.i686

- cannot install the best candidate for the job

(try to add '--allowerasing' to command line to replace conflicting packages or '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

I assume that it's protesting the version installed and requires one of the command line changes to make this so?

Which one?

 

[Maarten]

Did you install the devel 10.3 packages for some reason? If you don't need them, try to remove them.

 

[Gene Steinberg]

I am reluctant to try anything that might impact the server. It’s newly minted. The only things I’ve done outside of Plesk updates and extensions are to install MySQL Tuner and this.

 

[Maarten]

If you use the noautoremove option, nothing can go wrong. Yum will only remove the package itself, not the dependencies. You don't need devel-packages on a production server.

# yum remove --noautoremove mariadb-devel

 

[Gene Steinberg]

Thanks all. We're good now.

Next: Can I get some advice on setting up MySQL Tuner and making the appropriate changes to my.cnf?

I'll be happy to send the report to anyone who can render a bit of advice.

 

[Maarten]

Good to hear that you managed to upgrade to MariaDB 10.6!

As for the follow-up question, can you please start a new thread?

 

[Gene Steinberg]

I will. How much of the MySQL Tuner report should I post?

 

[Maarten]

Running the tuner on a recently started mariadb process is meaningless; it needs a few days to gather the stats, so wait a few days before posting your findings. Only the recommendations of the report will be enough.

 

[Gene Steinberg]

Thanks.

 

[Gene Steinberg]

One more thing:

Is there a fix for this error in the backup log?

Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol. mysqldump: Got error: 1045: "Access denied for user 'admin'@'127.0.0.1' (using password: YES)" when trying to connect

 

[Maarten]

Please stop posting in this thread. It's already solved, and the issue you posted has nothing to do with the original topic.