Author Topic: Fresh install has MariaDB error. How to resolve?  (Read 10501 times)

0 Members and 4 Guests are viewing this topic.

Offline
*
Fresh install has MariaDB error. How to resolve?
« on: August 15, 2022, 09:32:37 PM »
Hi,

I am trying to do a fresh install of CWP on a new server and I am getting the following error message. How can I resolve this error?

failure: repodata/repomd.xml from mariadb: [Errno 256] No more mirrors to try.
http://yum.mariadb.org/10.2/centos7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
sh: line 28: virt-what: command not found
sh: line 36: mysql: command not found
sh: line 46: /usr/local/bin/php: No such file or directory
grep: /etc/init.d/httpd: No such file or directory
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>500 Internal Server Error</title>
</head><body>
<h1>Internal Server Error</h1>
<p>The server encountered an internal error or
misconfiguration and was unable to complete
your request.</p>
<p>Please contact the server administrator at
 webmaster@error-reporting.control-webpanel.com to inform them of the time this error occurred,
 and the actions you performed just before this error.</p>
<p>More information about this error may be available
in the server error log.</p>
<p>Additionally, a 500 Internal Server Error
error was encountered while trying to use an ErrorDocument to handle the request.</p>
</body></html>
Please contact CWP support about this issue and include the last few lines from the error:
http://centos-webpanel.com/contact

Offline
*****
Re: Fresh install has MariaDB error. How to resolve?
« Reply #1 on: August 15, 2022, 10:46:42 PM »
Looks like something went wrong with the install.
Since it's fresh, do a fresh OS install, and then install CWP.

After it is running, then edit the mariadb.repo file to get the version MariaDB you want.

Offline
*
Re: Fresh install has MariaDB error. How to resolve?
« Reply #2 on: August 21, 2022, 10:48:52 PM »
I would say the the problem is that the link `http://yum.mariadb.org/10.2/centos7-amd64` is not available anymore.
I have the same problem.
So, what would be the correct repository to put there?

Offline
*****
Re: Fresh install has MariaDB error. How to resolve?
« Reply #3 on: August 21, 2022, 11:06:52 PM »
MariaDB 10.2 is EOL.

MariaDB 10.6 is the current long-term maintenance stable series of MariaDB.

--

For MariaDB on the old CentOS 7, you will need to change the /etc/yum.repos.d/mariadb.repo to:

# MariaDB 10.6 RedHat repository list
# https://mariadb.org/download/
[mariadb]
name = MariaDB
baseurl = https://mirror.rackspace.com/mariadb/yum/10.6/rhel7-amd64
gpgkey=https://mirror.rackspace.com/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

--

If you want a different OS or use 10.7.x, 10.8.x you can visit:

https://mariadb.org/download/?t=repo-config

Offline
*
Re: Fresh install has MariaDB error. How to resolve?
« Reply #4 on: August 21, 2022, 11:12:39 PM »
Thank you!

Offline
*
Re: Fresh install has MariaDB error. How to resolve?
« Reply #5 on: August 21, 2022, 11:19:45 PM »
The only error that I've got after update was:

Failed:
  MariaDB-server.x86_64 0:10.2.41-1.el7.centos                                                                          MariaDB-server.x86_64 0:10.6.9-1.el7.centos

How do I upgrade MariaDB-server manually to 10.6.9?

Offline
*****
Re: Fresh install has MariaDB error. How to resolve?
« Reply #6 on: August 21, 2022, 11:39:30 PM »
Try:

# MariaDB 10.6 CentOS repository list
# https://mariadb.org/download/
[mariadb]
name = MariaDB
baseurl = https://mirror.its.dal.ca/mariadb/yum/10.6/centos7-amd64
gpgkey=https://mirror.its.dal.ca/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1


Then run yum update

Offline
*
Re: Fresh install has MariaDB error. How to resolve?
« Reply #7 on: August 22, 2022, 12:27:08 AM »
The same result the package is available but the upgrade process is failed.

Offline
*
Re: Fresh install has MariaDB error. How to resolve?
« Reply #8 on: August 22, 2022, 12:28:47 AM »
This is the whole message:

Code: [Select]
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
MariaDB-server-10.6.9-1.el7.centos.x86_64.rpm                                                                                                                                                                         |  25 MB  00:00:02
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction

******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.2.41-1.el7.centos.x86_64) is installed.

Upgrading directly from MySQL 10.2 to MariaDB 10.6 may not
be safe in all cases.  A manual dump and restore using mysqldump is
recommended.  It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.

A manual upgrade is required.

- Ensure that you have a complete, working backup of your data and my.cnf
  files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages.  Usually this command will
  list the packages you should remove:
  rpm -qa | grep -i '^mysql-'

  You may choose to use 'rpm --nodeps -ev <package-name>' to remove
  the package which contains the mysqlclient shared library.  The
  library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program

This is a brief description of the upgrade process.  Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %pre(MariaDB-server-10.6.9-1.el7.centos.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server-10.6.9-1.el7.centos.x86_64
MariaDB-server-10.2.41-1.el7.centos.x86_64 was supposed to be removed but is not!
  Verifying  : MariaDB-server-10.2.41-1.el7.centos.x86_64                                                                                                                                                                                1/2
  Verifying  : MariaDB-server-10.6.9-1.el7.centos.x86_64                                                                                                                                                                                 2/2

Failed:
  MariaDB-server.x86_64 0:10.2.41-1.el7.centos                                                                          MariaDB-server.x86_64 0:10.6.9-1.el7.centos



Offline
*****
Re: Fresh install has MariaDB error. How to resolve?
« Reply #9 on: August 22, 2022, 12:34:46 AM »
Sounds like the server is way out of date.

Try:

# MariaDB 10.3 CentOS repository list
# https://mariadb.org/download/
[mariadb]
name = MariaDB
baseurl = https://mirror.its.dal.ca/mariadb/yum/10.3/centos7-amd64
gpgkey=https://mirror.its.dal.ca/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1


And then slowing go up to 10.6

Offline
*
Re: Fresh install has MariaDB error. How to resolve?
« Reply #10 on: August 22, 2022, 01:45:56 AM »
Code: [Select]
Error: MariaDB-client conflicts with MariaDB-server-10.3.36-1.el7.centos.x86_64
Error: galera-4 conflicts with galera-25.3.28-1.rhel7.el7.centos.x86_64
Error: galera-4 conflicts with galera-25.3.33-1.el7.centos.x86_64
Error: galera-4 conflicts with galera-25.3.32-1.el7.centos.x86_64
Error: galera-4 conflicts with galera-25.3.34-1.el7.centos.x86_64
Error: galera-4 conflicts with galera-25.3.12-2.el7.x86_64
Error: galera-4 conflicts with galera-25.3.31-1.el7.centos.x86_64
Error: galera-4 conflicts with galera-25.3.35-1.el7.centos.x86_64
Error: galera-4 conflicts with galera-25.3.30-1.el7.centos.x86_64
Error: Package: MariaDB-server-10.3.36-1.el7.centos.x86_64 (mariadb)
           Requires: galera
Error: galera-4 conflicts with galera-25.3.37-1.el7.centos.x86_64
Error: galera-4 conflicts with galera-25.3.29-1.rhel7.el7.centos.x86_64
Error: MariaDB-common conflicts with MariaDB-server-10.3.36-1.el7.centos.x86_64
 You could try using --skip-broken to work around the problem
** Found 4 pre-existing rpmdb problem(s), 'yum check' output follows:
MariaDB-client-10.6.9-1.el7.centos.x86_64 has installed conflicts MariaDB-server < ('0', '10.6.0', None): MariaDB-server-10.2.41-1.el7.centos.x86_64
MariaDB-common-10.6.9-1.el7.centos.x86_64 has installed conflicts MariaDB-server < ('0', '10.6.1', None): MariaDB-server-10.2.41-1.el7.centos.x86_64
MariaDB-server-10.2.41-1.el7.centos.x86_64 has missing requires of galera
cluebringer-v2.1.x-201310261831.noarch has missing requires of httpd


Offline
*****
Re: Fresh install has MariaDB error. How to resolve?
« Reply #11 on: August 22, 2022, 04:36:41 AM »
All I can says is WOW that server is out of date.

Client & server should have updated together.

Not to mention galera is Whole other issue.

Offline
*
Re: Fresh install has MariaDB error. How to resolve?
« Reply #12 on: August 22, 2022, 07:41:59 AM »
In case if I am switching back to 10.6 version. Everything updated correctly, but the server part I have to upgrade manually. I think the best way to fix that situation to make a manual update. But I don't know how to make if I have CWP. Probably someone can explain me what is the best way to migrate MariaDB server from 10.2 to 10.6?..

Offline
*
Re: Fresh install has MariaDB error. How to resolve?
« Reply #13 on: May 11, 2023, 09:54:08 PM »
Update CWP

ERROR !

Code: [Select]
failure: repodata/repomd.xml from mariadb: [Errno 256] No more mirrors to try.
http://yum.mariadb.org/10.2/centos7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found

I try editing:
Code: [Select]
/etc/yum.repos.d/mariadb.repo
Commenting (#) on the original lines and adding the new lines taken from the other web page:

https://www.liquidweb.com/kb/centos-7-upgrade-mariadb/


# MariaDB 10.2 CentOS repository list - created 2019-07-03 08:40 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
#enabled=1
#
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.6/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Offline
**
Re: Fresh install has MariaDB error. How to resolve?
« Reply #14 on: May 12, 2023, 09:56:29 AM »
The page:
https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4
explains how to upgrade MariaDB from 10.2 to 10.4.

The upgrade process from 10.2 to 10.6 is similar. Just replace 10.4 to 10.6 in the above instructions.