Welcome to Centmin Mod Community
Become a Member

MariaDB Doing the Maria DB upgrade from 5.5 to 10.x

Discussion in 'Install & Upgrades or Pre-Install Questions' started by SneakyDave, Dec 10, 2015.

  1. SneakyDave

    SneakyDave Member

    68
    11
    8
    Jul 24, 2014
    Ratings:
    +16
    Local Time:
    11:09 PM
    1.0.15
    Hello...

    I'm upgrading centminmod (older updates) by following this page:
    Upgrade Centmin Mod - CentminMod.com LEMP Nginx web stack for CentOS

    I optionally selected to upgrade MariaDB from 5.5 to 10.x (Centmin options 11, then 3), and everything was working fine until it asked me if I had a root password to the database.

    While looking for that password, my putty session disconnected, so I went back into option 11, and sub-menu 3, to provide the root password, but it said that version 10.x was already detected.

    So I guess my question is, what was supposed to happen after the database was upgraded that required the root database password, and how can I perform those steps, if needed?

    Thanks in advance.
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,195
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    2:09 PM
    Nginx 1.13.x
    MariaDB 5.5
    Ah seems you are missing the steps outlined here centminmod/mariadb_upgrade10.inc at 123.08stable · centminmod/centminmod · GitHub

    Code:
    mysql_upgrade -u root -p
    mysql -u root -p -e "INSTALL SONAME 'metadata_lock_info';"
    mysql -u root -p -e "INSTALL SONAME 'query_cache_info';"
    mysql -u root -p -e "INSTALL SONAME 'query_response_time';"
    mysql -u root -p -e "SELECT * FROM mysql.plugin;"
    mysql -u root -p -e "SHOW PLUGINS;"
    mysql -u root -p -e "SHOW ENGINES;"
    sed -i 's/innodb_doublewrite = 1/#innodb_doublewrite = 1/g' /etc/my.cnf
    sed -i 's/innodb_doublewrite=1/#innodb_doublewrite=1/g' /etc/my.cnf
    service mysql restart
    yum -q -y install perl-DBD-MySQL
     
    • Like Like x 1
  3. SneakyDave

    SneakyDave Member

    68
    11
    8
    Jul 24, 2014
    Ratings:
    +16
    Local Time:
    11:09 PM
    1.0.15
    Graet! Thanks for that
     
  4. SneakyDave

    SneakyDave Member

    68
    11
    8
    Jul 24, 2014
    Ratings:
    +16
    Local Time:
    11:09 PM
    1.0.15
    That all seemed to work ok, but I'm getting this dreaded nginx error on restart.
    2015/12/10 03:10:40 [emerg] 26850#0: unknown directive "vhost_traffic_status_zone" in /usr/local/nginx/conf/vts_http.conf

    Searching through the site here, it seems it could have been a a bug back in June or August, but how can I fix that now? Just comment out that line in vts_http.conf?
     
  5. eva2000

    eva2000 Administrator Staff Member

    30,195
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    2:09 PM
    Nginx 1.13.x
    MariaDB 5.5
    if you upgraded from older version of centmin mod, just run centmin.sh menu option 4 to recompile nginx should setup the nginx traffic module properly
     
    • Like Like x 1
  6. SneakyDave

    SneakyDave Member

    68
    11
    8
    Jul 24, 2014
    Ratings:
    +16
    Local Time:
    11:09 PM
    1.0.15
    Thanks, yes, that fixed it. I thought i had already upgraded nginx, but I must not have.
     
    • Like Like x 1
  7. eva2000

    eva2000 Administrator Staff Member

    30,195
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    2:09 PM
    Nginx 1.13.x
    MariaDB 5.5
    thanks for the confirmation :D
     
    • Like Like x 1
  8. SneakyDave

    SneakyDave Member

    68
    11
    8
    Jul 24, 2014
    Ratings:
    +16
    Local Time:
    11:09 PM
    1.0.15
    ok, just a couple more questions and I think I'll have this upgrade complete.

    I'll dig around here some more and see if I can get them answered myself first.

    It appears that the PHP 5.5 version I installed has an open base_dir restriction, but it doesn't appear to be set in the /usr/local/lib/php.ini file. Is it somewhere else?

    When I restart php-fpm, I get errors about being unable to load the imagick.so dynamic library and the redis.so library. I did option 15 to install the Image Magick PHP extension, and upgraded nginx/php-fpm, so I'm not sure why I'm still getting these errors. I can't find the load modules anywhere on the server, so it isn't like they're in the wrong place.

    Also, I have a custom Codeigniter application that I know is going to have some fits with PHP 5.5 that I upgraded to. It appears that Zend or something else is caching some pages because when I try to troubleshoot the problem by simply putting some echos in places to see what's happening, those changes don't show up. Assuming it's a caching thing, can I turn that off per virtual domain?
     
    Last edited: Dec 10, 2015
  9. eva2000

    eva2000 Administrator Staff Member

    30,195
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    2:09 PM
    Nginx 1.13.x
    MariaDB 5.5
    For open_basedir messages read FAQ item 26 and if using Xenforo open_basedir section outlined at centminmod.com/nginx_configure_xenforo_seo_friendly_urls.html

    correct procedure if missing

    how did you upgrade centmin mod ? might have ran into similar errors as @Epic Internet Marketing at PHP upgrade centmin shortcut #5 doesn't prompt me for what version PHP | Centmin Mod Community
     
  10. SneakyDave

    SneakyDave Member

    68
    11
    8
    Jul 24, 2014
    Ratings:
    +16
    Local Time:
    11:09 PM
    1.0.15
    I just edited my previous post to include the last paragraph too, sorry. Didn't realize you were so quick on the answers tonight Eva! Please edit the title to suit if you need to.

    "How did I upgrade Centminmod?" I visited this page, but I couldn't tell you which version I upgraded from. I had to do this when my daily yum updates upgraded me to CentOS 7, and my centminmon version wasn't working correctly.
    Upgrade Centmin Mod - CentminMod.com LEMP Nginx web stack for CentOS

    Thanks for the basedir answer, I didn't realize it could be a php-fpm fastcgi parameter.
     
  11. eva2000

    eva2000 Administrator Staff Member

    30,195
    6,789
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,144
    Local Time:
    2:09 PM
    Nginx 1.13.x
    MariaDB 5.5
    • Like Like x 1