Discover Centmin Mod today
Register Now

Beta Branch allow MariaDB 10.3 MySQL to be default optionally

Discussion in 'Centmin Mod Github Commits' started by eva2000, May 29, 2018.

  1. eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    6:12 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    allow MariaDB 10.3 MySQL to be default optionally

    Via setting new MARIADB_INSTALLTENTHREE='y' variable in persistent config file you can create before initial Centmin Mod installation at /etc/centminmod/custom_config.inc you can override the default MariaDB major version branch installed MariaDB 10.1 with MariaDB 10.3. This is initial prep work for further testing.

    Continue reading...


    123.09beta01 branch
     
  2. eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    6:12 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    MariaDB 10.3 upgrade routine has been added for testing. So this update is for optionally setting MariaDB 10.3 as initial install default for testing. You can do that by setting the above outlined variable MARIADB_INSTALLTENTHREE='y' in persistent config file /etc/centminmod/custom_config.inc BEFORE initial install. Example
    Code (Text):
    mkdir -p /etc/centminmod/
    touch /etc/centminmod/custom_config.inc
    echo "MARIADB_INSTALLTENTHREE='y'" >> /etc/centminmod/custom_config.inc
    cat /etc/centminmod/custom_config.inc
    yum -y update; curl -O https://centminmod.com/betainstaller.sh && chmod 0700 betainstaller.sh && bash betainstaller.sh
    
     
  3. Tracy Perry

    Tracy Perry Active Member

    276
    115
    43
    Aug 24, 2014
    Texas
    Ratings:
    +205
    Local Time:
    3:12 PM
    1.21.6
    MariaDB 10.3.36
    Was 10.2 determined to be stable.... because I can't upgrade my 10.1 to 10.2, which is required to do to upgrade to 10.3.
    I get a placeholder notice. ;)

    EDIT:
    found how to enable it... but was it determined to be without issues?
     
    Last edited: Jun 19, 2018
  4. eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    6:12 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    without issue is relative.. i haven't had issues but because i don't know if folks will, hence it's disabled by default until folks report otherwise
     
  5. Tracy Perry

    Tracy Perry Active Member

    276
    115
    43
    Aug 24, 2014
    Texas
    Ratings:
    +205
    Local Time:
    3:12 PM
    1.21.6
    MariaDB 10.3.36
    So far so good for me... IPS is now warning of this in their ACP.

    Screen Shot 2018-06-18 at 8.42.04 PM.png

    So as wondering if 10.2 is reporting as 5.5.5 to them even though it has 5.6 & 5.7 features in it (which are probably what they are referring to).
     
  6. eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    6:12 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    maybe check the IPS php code segment that reports version detection ?
     
  7. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    11:12 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    I think 10.2 should be reported as 5.6 ...

    Please report back if you solve that issue @Tracy Perry

    Thank you
     
  8. Tracy Perry

    Tracy Perry Active Member

    276
    115
    43
    Aug 24, 2014
    Texas
    Ratings:
    +205
    Local Time:
    3:12 PM
    1.21.6
    MariaDB 10.3.36
    That's what I'm thinking also... got a feeling it's in IPS code - which is not surprising honestly as they seem to forget there are other solutions than Oracle out there.
     
  9. pamamolf

    pamamolf Premium Member Premium Member

    4,068
    427
    83
    May 31, 2014
    Ratings:
    +832
    Local Time:
    11:12 PM
    Nginx-1.25.x
    MariaDB 10.3.x
    Maybe a support ticket will clarify that...
     
  10. JoeDer

    JoeDer Member

    82
    19
    8
    Feb 22, 2015
    Ratings:
    +48
    Local Time:
    11:12 PM
    Nginx 1.21.x
    MariaDB 10.3.x
    IPS released a patch for this issue:
    Code:
    Images too large in posts; Infinite redirect on some profiles; "Force Anonymous Logins" not working correctly; Incorrect warning about MySQL version in AdminCP; Broken ACP member search; Issue submitting Calendar events
     
  11. Tracy Perry

    Tracy Perry Active Member

    276
    115
    43
    Aug 24, 2014
    Texas
    Ratings:
    +205
    Local Time:
    3:12 PM
    1.21.6
    MariaDB 10.3.36
    Got a reply from the IPS developers and they were aware of the issue and will have it patched soon.
     
  12. CarpCharacin

    CarpCharacin Member

    267
    21
    18
    Oct 13, 2016
    Salt Lake City
    Ratings:
    +34
    Local Time:
    2:12 PM
    1.15.x
    MariaDB 10.1
    So how do I upgrade to MariaDB 10.3? I'm on 10.1.32 now.
     
  13. eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    6:12 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    still in testing phase so your mileage may vary you need to update to 10.2 first then to 10.3 using with persistent config file enabled flags for 10.2 and 10.3 for test vps only
     
  14. CarpCharacin

    CarpCharacin Member

    267
    21
    18
    Oct 13, 2016
    Salt Lake City
    Ratings:
    +34
    Local Time:
    2:12 PM
    1.15.x
    MariaDB 10.1
    I tried to upgrade to 10.2 via menu option 11, but it says that it's a placeholder?

    Edit, I figured out how to enable it.
     
    Last edited: Feb 9, 2019
  15. CarpCharacin

    CarpCharacin Member

    267
    21
    18
    Oct 13, 2016
    Salt Lake City
    Ratings:
    +34
    Local Time:
    2:12 PM
    1.15.x
    MariaDB 10.1
    MariaDB 10.3 reports as MySQL 5.5.5 in XF 2.0:
    xfserver.PNG
    Shouldn't it be reported as 5.6 or 5.7?
     
  16. eva2000

    eva2000 Administrator Staff Member

    53,488
    12,130
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,671
    Local Time:
    6:12 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yeah it's a known fact with way MariaDB exposes version details to PHP so just ignore