upgrade MariaDB

[WISTFUL]

How can I upgrade from "MariaDB-server-10.0.28-1.el6.x86_64" to "MariaDB 10.2" ?

A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016122302
   - Web: hiawatha-10.4.0-f.1.mr.el6.x86_64
   - PHP: php54s-5.4.45-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.8 (Final) x86_64
   - Hostname: server.***.com
C. Services:
   1. MySQL: MariaDB-server-10.0.28-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php56u-cli-5.6.30-2.ius.el6.x86_64
        - Multiple:
          * php52m-5.2.17-102.mr.el6
          * php53m-5.3.29-1.ius.el6
          * php54m-5.4.45-1.ius.el6
          * php55m-5.5.38-1.ius.el6
          * php56m-5.6.29-1.ius.el6
          * php70m-7.0.14-1.ius.el6
          * php71m-7.1.5-1.ius.el6
      - Used: php56m-fpm
      - Multiple: enable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.4.0-f.1.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.43-2.el6.x86_64
     - Nginx: nginx-1.11.7-1.el6.ngx.x86_64
     - Apache: httpd-2.2.31-1.mr.el6.x86_64
       - PHP Type: php-fpm_event
       - Secondary PHP: off
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: bind
     - Bind: bind-9.9.7-1.mr.el6.x86_64
     - DJBDns: --uninstalled--
     - NSD: --uninstalled--
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el6.x86_64
      - smtp: none
      - spam: bogofilter-1.2.4-1.el6.x86_64
   7. Stats: webalizer

[MRatWork]

what's the reason to upgrade?.

[WISTFUL]

what's the reason to upgrade?.

JSON support:
https://mariadb.com/resources/blog/json-mariadb-102

[MRatWork]

Update dan run with:

Code: [Select]

yum clean all
yum update -y
sh /script/mariadb-upgrade


[WISTFUL]

Code: [Select]

Total download size: 109 M
Installed size: 461 M
Downloading Packages:
Setting up and reading Presto delta metadata
Processing delta metadata
Package(s) data still to download: 109 M
MariaDB-10.2.7-centos6-x86_64-server.rpm
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : MariaDB-server-10.2.7-1.el6.x86_64                           1/1
  Verifying  : MariaDB-server-10.2.7-1.el6.x86_64                           1/1

Installed:
  MariaDB-server.x86_64 0:10.2.7-1.el6

Complete!
sh: /script/restart-mysql: No such file or directory
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
FATAL ERROR: Upgrade failed
sh: /script/restart-mysql: No such file or directory
- End process...

* Note:
  - Format: /script/mariadb-upgrade [target-version]
    where [target-version] = 10.2 (by default)
After this error, my site is up but I can not run any script in SSH (sh: /script/fixweb: No such file or directory)

[MRatWork]

Try:

Code: [Select]

yum reinstall kloxomr7 -y
cd /
sh /script/mariadb-upgrade


[WISTFUL]

Code: [Select]

A. Control Panel:
   - Kloxo-MR: 7.0.0.c-2017080603
   - Web: hiawatha-10.6.0-f.1.mr.el6.x86_64
   - PHP: php54s - 5.4.45-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.9 (Final) x86_64
   - Hostname: server.***.com
C. Services:
   1. MySQL: MariaDB-server-10.2.7-1.el6.x86_64
   2. PHP:
      - Installed:
        - Branch: php56u-cli-5.6.31-1.ius.el6.x86_64
        - Multiple:
          * php52m - 5.2.17-102.mr.el6
          * php53m - 5.3.29-1.ius.el6
          * php54m - 5.4.45-1.ius.el6
          * php55m - 5.5.38-1.ius.el6
          * php56m - 5.6.29-1.ius.el6
          * php70m - 7.0.14-1.ius.el6
          * php71m - 7.1.5-1.ius.el6
      - Used: --PHP Branch--
      - Multiple: enable
   3. Web Used: apache
     - Hiawatha: hiawatha-10.6.0-f.1.mr.el6.x86_64
     - Lighttpd: lighttpd-1.4.45-1.el6.x86_64
     - Nginx: nginx-1.13.3-1.el6.ngx.x86_64
     - Apache: httpd-2.2.31-1.mr.el6.x86_64
       - PHP Type: php-fpm_event
       - Secondary PHP: off
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: bind
     - Bind: bind-9.9.9-1.mr.el6.x86_64
     - DJBDns: --uninstalled--
     - NSD: --uninstalled--
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.57.mr.el6.x86_64
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.20.mr.el6.x86_64
      - smtp: none
      - spam: bogofilter-1.2.4-1.el6.x86_64
   7. FTP: pure-ftpd
      - pure-ftpd: pure-ftpd-1.0.37-1.mr.el6.x86_64
   8. Stats: webalizer
      - webalizer: webalizer-2.23_08-1.mr.el6.x86_64
Also in phpMyAdmin I get white page with this content:

PHP 5.5+ is required.
Currently installed version is: 5.4.45

[MRatWork]

Run 'sh /script/fixlxphpexe; sh /script/restart'.

[WISTFUL]

Run 'sh /script/fixlxphpexe; sh /script/restart'.

Does not help ....

[WISTFUL]

Code: [Select]

php -v
PHP 5.6.31 (cli) (built: Jul  7 2017 08:13:13)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v6.1.0 (), Copyright (c) 2002-2017, by ionCube Ltd.

Code: [Select]

lxphp.exe -v
PHP 5.4.45 (cli) (built: Sep  4 2015 15:40:18)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies

[MRatWork]

Try 'sh /script/phpm-installer php56s -y; sh /script/fixlxphpexe php56s; sh /script/restart'

[WISTFUL]

All issues solved, thanks ...

[WISTFUL]

After above changes I get "Error 500 - Internal Server Error" in my default server domain. client's domains are good...

Code: [Select]

[Mon Aug 07 09:18:20 2017] [error] [client 000.000.000.000] (2)No such file or directory: FastCGI: failed to connect to server "/home/admin/domain.net/domain.net.0fake": connect() failed
[Mon Aug 07 09:18:20 2017] [error] [client 000.000.000.000] FastCGI: incomplete headers (0 bytes) received from server "/home/admin/domain.net/domain.net.0fake"

[MRatWork]

Try 'sh /script/cleanup'.

[WISTFUL]

Befor your suggestion, from "admin > Domains > domain.net > Web Features" I change "php56m" to "--PHP Used--" + run 'fixphp' and 'restart' and Issue solved...
Are every thing OK and normal?