MariaDB Downgrading Mariadb

Itworx4me · Nov 15, 2021

Is it possible to downgrade Mariadb from 10.3.31 to 5.5? If so, How does one go about it?

Thanks,
Shannon

buik · Nov 15, 2021

Downgrading MariaDB is not supported. The only reliable way to downgrade is to restore from a full backup made before upgrading, and start the old version of MariaDB.

Some people have reported successfully downgrading, but there are many possible things that can go wrong, and downgrading is not tested in any way by the MariaDB developers.
Click to expand...

https://mariadb.com/kb/en/downgrading-between-major-versions-of-mariadb/

eva2000 · Nov 15, 2021

Yeah it's not advised. Why you want to downgrade that far to MariaDB 5.5 ?

Itworx4me · Nov 15, 2021

eva2000 said: ↑

Yeah it's not advised. Why you want to downgrade that far to MariaDB 5.5 ?
Click to expand...

I am trying to get a vBulletin 3.8.0 site back up and running so I can upgrade it. Host upgraded software and the site stop working. So I have test server that I am trying to get the site to load on. I am close to getting it up.

eva2000 · Nov 15, 2021

If you have vB 3.8 site's SQL dump file, you can just import it into MariaDB 10.3 server. The other way though haven't tried it in a while is to disable MariaDB 10.3 default install in Centmin Mod 123.09beta01 so it goes back to MariaDB 5.5 default install (not sure if it works but you can try)

on new fresh CentOS 7 VPS server, set in persistent config file /etc/centminmod/custom_config.inc BEFORE Centmin Mod initial install and override centmin.sh defaults for
Code (Text):
MARIADB_INSTALLTENTWO='n'   # MariaDB 10.2 YUM default install if set to yes
MARIADB_INSTALLTENTHREE='y' # MariaDB 10.3 YUM default install if set to yes
MARIADB_INSTALLTENFOUR='n'  # MariaDB 10.4 YUM default install if set to yes
to change MARIADB_INSTALLTENTHREE='n'
Code (Text):
MARIADB_INSTALLTENTWO='n'   # MariaDB 10.2 YUM default install if set to yes
MARIADB_INSTALLTENTHREE='n' # MariaDB 10.3 YUM default install if set to yes
MARIADB_INSTALLTENFOUR='n'  # MariaDB 10.4 YUM default install if set to yes
Then do normal default install which is PHP 5.6 based
Code (Text):
yum -y update; curl -O https://centminmod.com/betainstaller.sh && chmod 0700 betainstaller.sh && bash betainstaller.sh
or specifically
Code (Text):
yum -y update; curl -O https://centminmod.com/betainstaller56.sh && chmod 0700 betainstaller.56sh && bash betainstaller56.sh
Though if you need PHP 5.5 default not sure it that works anymore you'd use
Code (Text):
yum -y update; curl -O https://centminmod.com/betainstaller55.sh && chmod 0700 betainstaller55.sh && bash betainstaller55.sh

Itworx4me · Nov 16, 2021

@eva2000 I am getting closer on getting this to work correctly. The admin area functions perfectly but when I access the front end I get a error 520. Any ideas? Here is the link to the site http://bullockcars.com/

Thanks,
Itworx4me

eva2000 · Nov 16, 2021

Cloudflare 520 error https://support.cloudflare.com/hc/e...roubleshooting-Cloudflare-5XX-errors#520error

Error 520: web server returns an unknown error
Error 520 occurs when the origin server returns an empty, unknown, or unexpected response to Cloudflare.

Resolution

A quick workaround while further investigating 520 errors is to either grey cloud the DNS record in the Cloudflare DNS app or temporarily pause Cloudflare.

Contact your hosting provider or site administrator and request a review of your origin web server error logs for crashes and to check for these common causes:

Origin web server application crashes

Cloudflare IPs not allowed at your origin

Headers exceeding 16 KB (typically due to too many cookies)

An empty response from the origin web server that lacks an HTTP status code or response body

Missing response headers or origin web server not returning proper HTTP error responses

520 errors are prevalent with certain PHP applications that crash the origin web server.

If 520 errors continue after contacting your hosting provider or site administrator, provide the following information to Cloudflare Support:

Full URL(s) of the resource requested when the error occurred

Cloudflare cf-ray from the 520 error message

Output from http://www.example.com/cdn-cgi/trace (replace www.example.com with your hostname and domain where the 520 error occurred)

Two HAR files:

one with Cloudflare enabled on your website, and

the other with Cloudflare temporarily disabled.

Click to expand...

I'd check the site with Cloudflare orange proxy disabled first to see what issues you have on backend.

Itworx4me · Nov 17, 2021

@eva2000 If I didn't do anything with Nginx domain config for vBulletin 3.8.0 would this be causing the issue? Or will it run with a stock Nginx config?

eva2000 · Nov 17, 2021

Itworx4me said: ↑

@eva2000 If I didn't do anything with Nginx domain config for vBulletin 3.8.0 would this be causing the issue? Or will it run with a stock Nginx config?
Click to expand...

vBulletin needs it's own Nginx rules to work, if you don't have any set then yes will have issues.

Itworx4me · Nov 17, 2021

eva2000 said: ↑

vBulletin needs it's own Nginx rules to work, if you don't have any set then yes will have issues.
Click to expand...

I kinda figured that was the case. Wish someone had the Nginx rules for 3.8.0 series to make this easier. lol

Thanks @eva2000 for your help

Itworx4me

eva2000 · Nov 17, 2021

some start clues in https://community.centminmod.com/threads/7252/

JoeDer · Apr 25, 2022

I think MariaDB 10.1 has been removed from: Index of /yum/ (mariadb.org)
Can this be fixed?

Code (Text):

* Installing MariaDB via CentOS Yum Repo
*************************************************
MariaDB 10.1 Repo setup...

setup /var/log/mysqld.log
chown: invalid user: ‘mysql:mysql’
-rw-------. 1 root root 0 Apr 25 07:48 /var/log/mysqld.log

rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

Check for existing mariadb packages

Check for existing mariadb-libs package
yum -y remove mariadb-libs
Loaded plugins: fastestmirror, priorities, versionlock
Resolving Dependencies
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be erased
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 1:net-snmp-agent-libs-5.7.2-49.el7_9.2.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 1:net-snmp-5.7.2-49.el7_9.2.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 1:net-snmp-agent-libs-5.7.2-49.el7_9.2.x86_64
--> Processing Dependency: mysql-libs for package: 1:net-snmp-5.7.2-49.el7_9.2.x86_64
--> Running transaction check
---> Package net-snmp.x86_64 1:5.7.2-49.el7_9.2 will be erased
--> Processing Dependency: net-snmp = 1:5.7.2-49.el7_9.2 for package: 1:net-snmp-devel-5.7.2-49.el7_9.2.x86_64
---> Package net-snmp-agent-libs.x86_64 1:5.7.2-49.el7_9.2 will be erased
--> Processing Dependency: libnetsnmpagent.so.31()(64bit) for package: cyrus-imapd-2.4.17-15.el7.x86_64
--> Processing Dependency: libnetsnmpmibs.so.31()(64bit) for package: cyrus-imapd-2.4.17-15.el7.x86_64
---> Package perl-DBD-MySQL.x86_64 0:4.023-6.el7 will be erased
--> Processing Dependency: perl(DBD::mysql) >= 1 for package: mytop-1.7-10.b737f60.el7.noarch
--> Running transaction check
---> Package cyrus-imapd.x86_64 0:2.4.17-15.el7 will be erased
---> Package mytop.noarch 0:1.7-10.b737f60.el7 will be erased
---> Package net-snmp-devel.x86_64 1:5.7.2-49.el7_9.2 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
 Package                 Arch       Version                  Repository    Size
================================================================================
Removing:
 mariadb-libs            x86_64     1:5.5.68-1.el7           @base        4.4 M
Removing for dependencies:
 cyrus-imapd             x86_64     2.4.17-15.el7            @base         57 M
 mytop                   noarch     1.7-10.b737f60.el7       @epel         68 k
 net-snmp                x86_64     1:5.7.2-49.el7_9.2       @updates     850 k
 net-snmp-agent-libs     x86_64     1:5.7.2-49.el7_9.2       @updates     2.1 M
 net-snmp-devel          x86_64     1:5.7.2-49.el7_9.2       @updates     734 k
 perl-DBD-MySQL          x86_64     4.023-6.el7              @base        323 k

Transaction Summary
================================================================================
Remove  1 Package (+6 Dependent packages)

Installed size: 66 M
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Erasing    : 1:net-snmp-devel-5.7.2-49.el7_9.2.x86_64                     1/7
  Erasing    : mytop-1.7-10.b737f60.el7.noarch                              2/7
  Erasing    : 1:net-snmp-5.7.2-49.el7_9.2.x86_64                           3/7
  Erasing    : perl-DBD-MySQL-4.023-6.el7.x86_64                            4/7
  Erasing    : cyrus-imapd-2.4.17-15.el7.x86_64                             5/7
  Erasing    : 1:net-snmp-agent-libs-5.7.2-49.el7_9.2.x86_64                6/7
  Erasing    : 1:mariadb-libs-5.5.68-1.el7.x86_64                           7/7
warning: file /etc/my.cnf: remove failed: No such file or directory
  Verifying  : cyrus-imapd-2.4.17-15.el7.x86_64                             1/7
  Verifying  : 1:net-snmp-5.7.2-49.el7_9.2.x86_64                           2/7
  Verifying  : 1:mariadb-libs-5.5.68-1.el7.x86_64                           3/7
  Verifying  : 1:net-snmp-devel-5.7.2-49.el7_9.2.x86_64                     4/7
  Verifying  : perl-DBD-MySQL-4.023-6.el7.x86_64                            5/7
  Verifying  : mytop-1.7-10.b737f60.el7.noarch                              6/7
  Verifying  : 1:net-snmp-agent-libs-5.7.2-49.el7_9.2.x86_64                7/7

Removed:
  mariadb-libs.x86_64 1:5.5.68-1.el7

Dependency Removed:
  cyrus-imapd.x86_64 0:2.4.17-15.el7
  mytop.noarch 0:1.7-10.b737f60.el7
  net-snmp.x86_64 1:5.7.2-49.el7_9.2
  net-snmp-agent-libs.x86_64 1:5.7.2-49.el7_9.2
  net-snmp-devel.x86_64 1:5.7.2-49.el7_9.2
  perl-DBD-MySQL.x86_64 0:4.023-6.el7

Complete!

Check for existing MySQL-shared-compat

          __  __               _         ____   ____    _   ___     _
         |  \/  |  __ _  _ __ (_)  __ _ |  _ \ | __ )  / | / _ \   / |
         | |\/| | / _` || '__|| | / _` || | | ||  _ \  | || | | |  | |
         | |  | || (_| || |   | || (_| || |_| || |_) | | || |_| |_ | |
         |_|  |_| \__,_||_|   |_| \__,_||____/ |____/  |_| \___/(_)|_|

          __   __                   ___              _          _  _
          \ \ / /_   _  _ __ ___   |_ _| _ __   ___ | |_  __ _ | || |
           \ V /| | | || '_ ` _ \   | | | '_ \ / __|| __|/ _` || || |
            | | | |_| || | | | | |  | | | | | |\__ \| |_| (_| || || |
            |_|  \__,_||_| |_| |_| |___||_| |_||___/ \__|\__,_||_||_|

MariaDB 10.1 YUM install...
                                ____         _
                               / ___|   ___ | |_
                               \___ \  / _ \| __|
                                ___) ||  __/| |_
                               |____/  \___| \__|

            __     _            __                                  __
           / /___ | |_  ___    / /_ __ ___   _   _     ___  _ __   / _|
          / // _ \| __|/ __|  / /| '_ ` _ \ | | | |   / __|| '_ \ | |_
         / /|  __/| |_| (__  / / | | | | | || |_| | _| (__ | | | ||  _|
        /_/  \___| \__|\___|/_/  |_| |_| |_| \__, |(_)\___||_| |_||_|
                                             |___/

Copying MariaDB my-mdb10-min.cnf file to /etc/my.cnf

time yum -q -y --disableplugin=fastestmirror,downloadonly --disablerepo=epel --disablerepo=rpmforge --disableplugin=priorities install perl-DBI
http://yum.mariadb.org/10.1/centos7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
To address this issue please refer to the below wiki article

https://wiki.centos.org/yum-errors

If above article doesn't help to resolve this issue please use https://bugs.centos.org/.



 One of the configured repositories failed (MariaDB),
 and yum doesn't have enough cached data to continue. At this point the only
 safe thing yum can do is fail. There are a few ways to work "fix" this:

     1. Contact the upstream for the repository and get them to fix the problem.

     2. Reconfigure the baseurl/etc. for the repository, to point to a working
        upstream. This is most often useful if you are using a newer
        distribution release than is supported by the repository (and the
        packages for the previous distribution release still work).

     3. Run the command with the repository temporarily disabled
            yum --disablerepo=mariadb ...

     4. Disable the repository permanently, so yum won't use it by default. Yum
        will then just ignore the repository until you permanently enable it
        again or use --enablerepo for temporary usage:

            yum-config-manager --disable mariadb
        or
            subscription-manager repos --disable=mariadb

     5. Configure the failing repository to be skipped, if it is unavailable.
        Note that yum will try to contact the repo. when it runs most commands,
        so will have to try and fail each time (and thus. yum will be be much
        slower). If it is a very temporary problem though, this is often a nice
        compromise:

            yum-config-manager --save --setopt=mariadb.skip_if_unavailable=true

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

real    0m3.855s
user    0m0.234s
sys     0m0.020s

buik · Apr 25, 2022

JoeDer said: ↑

I think MariaDB 10.1 has been removed from: Index of /yum/ (mariadb.org)
Can this be fixed?
Click to expand...

Probably not.
MariaDB 10.1 is end of life since October 17 2020.
Apparently they removed the installation files from the servers partly because of this.
You could upgrade to a new version of MariaDB.

JoeDer · Apr 26, 2022

buik said: ↑

Probably not.
MariaDB 10.1 is end of life since October 17 2020.
Apparently they removed the installation files from the servers partly because of this.
You could upgrade to a new version of MariaDB.
Click to expand...

Yeah, you're right, also PHP 5.6 7.0 7.1 7.2 and 7.3 are flaged as EOL but there are downloads links and can be installed. I want MariaDB 10.1 for some tests only and this thread explain how can set it for installation. I had a CMM installation with MariaDB 10.1 before 1 month but it seems removed from their repos. If can replaced this repo it will be fine.

eva2000 · Apr 26, 2022

Yeah looks like MariaDB 10.1 is gone, maybe there's some mirrors with it still or something?

edit: okay there are MariaDB archives for MariaDB 10.1.48 https://archive.mariadb.org/mariadb-10.1.48/yum/

For CentOS 7 64bit https://archive.mariadb.org/mariadb-10.1.48/yum/centos7-amd64/

So for /etc/yum.repos.d/mariadb.repo repo file instead of
Code (Text):
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
this might work
Code (Text):
[mariadb]
name = MariaDB
baseurl = https://archive.mariadb.org/mariadb-10.1.48/yum/centos7-amd64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

eva2000 · Apr 26, 2022

eva2000 said: ↑

For CentOS 7 64bit https://archive.mariadb.org/mariadb-10.1.48/yum/centos7-amd64/
Click to expand...

FYI, just updated 123.09beta01 with this change for MariaDB 10.1 routines to use archive repo URL just to maintain the MariaDB 5.5 to 10.1 upgrade process for older installs

Log in / Register

Forums

Want to subscribe to topics you're interested in?

MariaDB Downgrading Mariadb

Itworx4me Active Member

buik “The best traveler is one without a camera.”

eva2000 Administrator Staff Member

Itworx4me Active Member

eva2000 Administrator Staff Member

Itworx4me Active Member

eva2000 Administrator Staff Member

Itworx4me Active Member

eva2000 Administrator Staff Member

Itworx4me Active Member

eva2000 Administrator Staff Member

JoeDer Member

buik “The best traveler is one without a camera.”

JoeDer Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Want to subscribe to topics you're interested in?

MariaDB Downgrading Mariadb

Itworx4me Active Member

buik “The best traveler is one without a camera.”

eva2000 Administrator Staff Member

Itworx4me Active Member

eva2000 Administrator Staff Member

Itworx4me Active Member

eva2000 Administrator Staff Member

Itworx4me Active Member

eva2000 Administrator Staff Member

Itworx4me Active Member

eva2000 Administrator Staff Member

JoeDer Member

buik “The best traveler is one without a camera.”

JoeDer Member

eva2000 Administrator Staff Member

eva2000 Administrator Staff Member

.