• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Resolved Upgrade to MariaDB 10.6

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.
 
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:
endoflife.date

MariaDB

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


Please check if the link in the mariadb.repo contains this (it works, I just checked it):
Code: 
https://mirror.mariadb.org/yum/10.6/centos8-amd64/
 
Last edited:
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
 
I think there is a typo in the repo file.
Can you post a screenshot of the output of this command?

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

Can you also post the output of this command?
Code: 
# yum repolist
 
I have no idea what I'm looking at. Can you please execute the commands as root on the command line?
 
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
 
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?
 
Did you install the devel 10.3 packages for some reason? If you don't need them, try to remove them.
 
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.
 
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.

Code: 
# yum remove --noautoremove mariadb-devel
 
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.
 
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.
 
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
 
Please stop posting in this thread. It's already solved, and the issue you posted has nothing to do with the original topic.
 
You must log in or register to reply here.

Similar threads

Jan Bludau
Issue Updating Debian 10 to 11
Replies
1
Views
740
Jan Bludau
Jan Bludau
B
Resolved MariaDB Upgrade 10.3 -> 10.6 not working
Replies
12
Views
2K
boosterfan
B
E
Question AlmaLinux 9 MariaDB 10.5 to 10.6 then after MariaDB 10.6 to 10.11
Replies
15
Views
3K
occinodo
O
D
Question How to update Maria DB from 10.3 to 10.5
Replies
1
Views
2K
Kaspar
K
brainforge
Resolved System updates have started failing.
Replies
2
Views
394
brainforge
brainforge
Back
Top