Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB Downgrading Mariadb

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Itworx4me, Nov 15, 2021.

  1. Itworx4me

    Itworx4me Member

    246
    23
    18
    Mar 14, 2017
    Ratings:
    +40
    Local Time:
    7:56 PM
    Nginx 1.17.X
    MariaDB 10.3.X
    Is it possible to downgrade Mariadb from 10.3.31 to 5.5? If so, How does one go about it?


    Thanks,
    Shannon
     
  2. buik

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

    1,452
    394
    83
    Apr 29, 2016
    Flanders
    Ratings:
    +1,235
    Local Time:
    4:56 AM
  3. eva2000

    eva2000 Administrator Staff Member

    47,498
    10,769
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,742
    Local Time:
    1:56 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Yeah it's not advised. Why you want to downgrade that far to MariaDB 5.5 ?
     
  4. Itworx4me

    Itworx4me Member

    246
    23
    18
    Mar 14, 2017
    Ratings:
    +40
    Local Time:
    7:56 PM
    Nginx 1.17.X
    MariaDB 10.3.X
    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.
     
  5. eva2000

    eva2000 Administrator Staff Member

    47,498
    10,769
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,742
    Local Time:
    1:56 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    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
     
  6. Itworx4me

    Itworx4me Member

    246
    23
    18
    Mar 14, 2017
    Ratings:
    +40
    Local Time:
    7:56 PM
    Nginx 1.17.X
    MariaDB 10.3.X
    @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
     
  7. eva2000

    eva2000 Administrator Staff Member

    47,498
    10,769
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,742
    Local Time:
    1:56 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Cloudflare 520 error https://support.cloudflare.com/hc/e...roubleshooting-Cloudflare-5XX-errors#520error

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

    Itworx4me Member

    246
    23
    18
    Mar 14, 2017
    Ratings:
    +40
    Local Time:
    7:56 PM
    Nginx 1.17.X
    MariaDB 10.3.X
    @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?
     
  9. eva2000

    eva2000 Administrator Staff Member

    47,498
    10,769
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,742
    Local Time:
    1:56 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    vBulletin needs it's own Nginx rules to work, if you don't have any set then yes will have issues.
     
  10. Itworx4me

    Itworx4me Member

    246
    23
    18
    Mar 14, 2017
    Ratings:
    +40
    Local Time:
    7:56 PM
    Nginx 1.17.X
    MariaDB 10.3.X
    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
     
  11. eva2000

    eva2000 Administrator Staff Member

    47,498
    10,769
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,742
    Local Time:
    1:56 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x