Resolved MariaDB updates

[retro1]

Why does Plesk Onyx not update MariaDB from the included 5.5.52 to 5.5.54? It seems a worthwhile update:

MariaDB 5.5.53 is a maintenance release. It includes bugfixes and updates, including from MySQL 5.5.53.

• XtraDB updated to 5.5.52-38.3

• Fixes for the following security vulnerabilities:
  • CVE-2016-7440
  • CVE-2016-5584

MariaDB 5.5.54 is a maintenance release. It includes bugfixes and updates, including from MySQL 5.5.54.

• HeidiSQL updated to 9.4

• Fixes for the following security vulnerabilities:
  • CVE-2016-6664
  • CVE-2017-3238
  • CVE-2017-3243
  • CVE-2017-3244
  • CVE-2017-3258
  • CVE-2017-3265
  • CVE-2017-3291
  • CVE-2017-3312
  • CVE-2017-3317
  • CVE-2017-3318

Or, indeed, why is there not an option within the panel to install 10? Maybe something to be able to choose a version, akin to the PHP options.

When I followed the official guide to install MariaDB 10.1 on Centos 7, the installer decided it wanted to remove 600 Mb of Plesk and Apache files, and completely killed my server! On the plus side, it fixed another issue....

# mysql -v
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Why does this happen? It was fixed under MariaDB 10.1, but not much help when I had to reinstall the server!

This is what we are running:

mariadb-5.5.52-1.el7.x86_64
mariadb-server-5.5.52-1.el7.x86_64
mariadb-libs-5.5.52-1.el7.x86_64
sw-mariadb-client-1.0.0-centos7.16102516.x86_64

I noticed this thread mentions installing MariaDB before Plesk. Unfortunately, everything is set up for us on our server and the Plesk licence is included in our subscription - AFAIK, we don't have a key, which I assume is needed when starting from scratch.

Would it not make sense to be able to update MariaDB via Plesk panel? Or is this not possible?

I asked our hosting company if we could have an update for MariaDB when they do the reinstall. The less than helpful reply was "you'll get what comes with Plesk."

What are the benefits of MariaDB 10.1 over 5.5? Are there any issues with it? We will be mostly using it for Xenforo with several add-ons, plus MediaWiki.

 

[themew]

Huge speed and accuracy benefits going to MariaDB 10.1 over ancient 5.5. The update needs to happen at the server level preferably before Plesk is installed and after your OS is installed.

Plesk doesn't include MariaDB, it uses whatever you have installed on your server.

So, either start from the beginning and install your OS, then upgrade to MariaDB 10.1 and install Plesk or if you can't do this, based on the reply from your host, find another hosting company.
There are also dozens of tutorials online about how to upgrade 5.5 to 10.1 without destroying your server eg. > http://www.tecmint.com/upgrade-mariadb-5-5-to-10-centos-rhel-debian-ubuntu/

Absolutely unprofessional the way your host responded to your common query.

 

[retro1]

Huge speed and accuracy benefits going to MariaDB 10.1 over ancient 5.5. The update needs to happen at the server level preferably before Plesk is installed and after your OS is installed.

So, either start from the beginning and install your OS, then upgrade to MariaDB 10.1 and install Plesk or if you can't do this, based on the reply from your host, find another hosting company.
Absolutely unprofessional the way your host responded to your common query.

Thanks! Yeah, I wasn't enamoured with the response. Sadly not my choice as my friend pays for the server... I just help with tech.

Looking at my notes, I believe I used this Plesk guide last time... as I said, it completely killed Plesk, I was unable to log into the panel and my sites (albeit only a couple of test pages) stopped working! So a pre-install would have been handy.

 

[bulent]

If you have fresh install, my suggestion will be to reinstall it again, but with mariadb 10. To do that, follow the steps below:

1. Install clean Centos 7.1 (Core)
2. yum update
3. add Mariadb 10 repo to the repo list

$vim /etc/yum.repos.d/MariaDB10.repo

# MariaDB 10.0 CentOS repository list - created 2015-10-12 20:25 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

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

After this above proceed with Onyx install. It will be installed with mariadb 10 and you will not have any problem installing Magento 2

Just change 10.0 with 10.1

 

[retro1]

Just change 10.0 with 10.1

With respect, as I already stated, I cannot start from scratch - the system (including Plesk) is set up by my host. They refuse to install anything other than "default" MariaDB, which is apparently 5.5.52.

I looked at this guide (it's rather old) for doing an upgrade, but removing mysql removes the following dependencies:

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Removing:
mariadb x86_64 1:5.5.52-1.el7 @base 48 M
Removing for dependencies:
git x86_64 1.8.3.1-6.el7_2.1 @base 22 M
mariadb-server
x86_64 1:5.5.52-1.el7 @base 56 M
perl-Git noarch 1.8.3.1-6.el7_2.1 @base 57 k
plesk-base x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 25 k
plesk-completion
noarch 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 1.9 M
plesk-config-troubleshooter
x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 391 k
plesk-core x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 48 M
plesk-dovecot x86_64 2.2.26.0-centos7.16120817 @PLESK_17_0_17-dist 12 k
plesk-dovecot-imap-driver
x86_64 17.0.17-cos7.build1700161213.12 @PLESK_17_0_17-dist 417 k
plesk-git-http
x86_64 17.0.17-cos7.build1700161025.16 @PLESK_17_0_17-extras
6.1 k
plesk-l10n noarch 17.0.17-cos7.build1700170119.11 @PLESK_17_0_17-dist 58 M
plesk-mail-pc-driver
x86_64 17.0.17-cos7.build1700161215.15 @PLESK_17_0_17-dist 6.4 M
plesk-management-node
x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 0.0
plesk-modsecurity-configurator
noarch 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 45 k
plesk-mysql-server
x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 0.0
plesk-resctrl x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 81 k
plesk-roundcube
noarch 1.2.2-cos7.build1700161122.21 @PLESK_17_0_17-dist 16 M
plesk-service-node-utilities
x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 11 M
plesk-web-hosting
x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 173 k
plesk-wp-upgrade
noarch 1.0-71.16102516 @PLESK_17_0_17-dist 11 M
pp17.0.17-bootstrapper
x86_64 17.0.17-cos7.build1700161117.16 @PLESK_17_0_17-dist 730 k
psa-firewall x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 673 k
psa-health-monitor
noarch 17.0.17-cos7.build1700161026.16 @PLESK_17_0_17-dist 956
psa-horde noarch 5.2.11-cos7.build1700161026.16 @PLESK_17_0_17-dist 68 M
psa-imp noarch 6.2.15-cos7.build1700161026.16 @PLESK_17_0_17-dist 18 M
psa-ingo noarch 3.2.11-cos7.build1700161026.16 @PLESK_17_0_17-dist 4.5 M
psa-kronolith noarch 4.2.17-cos7.build1700161026.16 @PLESK_17_0_17-dist 8.9 M
psa-libpam-plesk
x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 196 k
psa-libxml-proxy
x86_64 2.7.8.1-centos7.16102516 @PLESK_17_0_17-dist 1.1 M
psa-locale-base-en-US
noarch 17.0.17-cos7.build1700161129.21 @PLESK_17_0_17-dist 1.1 M
psa-logrotate x86_64 3.8.2-cos7.build1700161025.16 @PLESK_17_0_17-dist 75 k
psa-mail-driver-common
x86_64 17.0.17-cos7.build1700170131.16 @PLESK_17_0_17-dist 2.2 M
psa-mnemo noarch 4.2.11-cos7.build1700161026.16 @PLESK_17_0_17-dist 3.3 M
psa-passwd noarch 5.0.5-cos7.build1700161026.16 @PLESK_17_0_17-dist 2.9 M
psa-php5-configurator
x86_64 1.7.0-cos7.build1700161026.16 @PLESK_17_0_17-dist 62 k
psa-phpfpm-configurator
x86_64 1.0.0-cos7.build1700161026.16 @PLESK_17_0_17-dist 138
psa-phpmyadmin
noarch 4.6.6-cos7.build1700170125.17 @PLESK_17_0_17-dist 32 M
psa-phppgadmin
noarch 5.1-cos7.build1700161025.16 @PLESK_17_0_17-dist 3.0 M
psa-proftpd x86_64 1.3.5b-cos7.build1700161026.16 @PLESK_17_0_17-dist 7.2 M
psa-pylibplesk
x86_64 17.0.17-cos7.build1700161208.17 @PLESK_17_0_17-dist 162 k
psa-turba noarch 4.2.15-cos7.build1700161026.16 @PLESK_17_0_17-dist 6.2 M
psa-updates noarch 17.0.17-cos7.build1700161025.16 @PLESK_17_0_17-dist 0.0
psa-vhost noarch 17.0.17-cos7.build1700161026.16 @PLESK_17_0_17-dist 304 k
psa-watchdog x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 2.9 M
psa-zendframework
noarch 1.12.17-cos7.build1700161025.16 @PLESK_17_0_17-dist 35 M

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

Installed size: 478 M
Is this ok [y/N]:

Will all those dependencies be missing when I then run the MariaDB installer? The server is running a live site, so I can't reinstall and I can't afford to potentially break Plesk (again)! I don't want to be left having to reapply every change I've made in Plesk panel, either. I might have to go with the option of changing host after all. Or change my hosting platform.

 

[themew]

Did you try the link in my post above which describes how to upgrade MariaDB 5.5 to 10? Should be quick and painless.

 

[retro1]

Did you try the link in my post above which describes how to upgrade MariaDB 5.5 to 10? Should be quick and painless.

The problem is, that guide isn't written with Plesk in mind. For example, the official guide says to stop Watchdog and "any other custom monitoring services that may resurrect MySQL daemon" (I'm not sure if I have any). Also, the list of dependencies is different:

What happens to all the actually removed dependencies afterwards? This list is a lot different!

================================================================================
 Package       Arch   Version                         Repository           Size
================================================================================
Removing:
 mariadb       x86_64 1:5.5.52-1.el7                  @base                48 M
Removing for dependencies:
 git           x86_64 1.8.3.1-6.el7_2.1               @base                22 M
 mariadb-server
               x86_64 1:5.5.52-1.el7                  @base                56 M
 perl-Git      noarch 1.8.3.1-6.el7_2.1               @base                57 k
 plesk-base    x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist  25 k
 plesk-completion
               noarch 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 1.9 M
 plesk-config-troubleshooter
               x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 391 k
 plesk-core    x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist  48 M
 plesk-dovecot x86_64 2.2.26.0-centos7.16120817       @PLESK_17_0_17-dist  12 k
 plesk-dovecot-imap-driver
               x86_64 17.0.17-cos7.build1700161213.12 @PLESK_17_0_17-dist 417 k
 plesk-git-http
               x86_64 17.0.17-cos7.build1700161025.16 @PLESK_17_0_17-extras
                                                                          6.1 k
 plesk-l10n    noarch 17.0.17-cos7.build1700170119.11 @PLESK_17_0_17-dist  58 M
 plesk-mail-pc-driver
               x86_64 17.0.17-cos7.build1700161215.15 @PLESK_17_0_17-dist 6.4 M
 plesk-management-node
               x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 0.0
 plesk-modsecurity-configurator
               noarch 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist  45 k
 plesk-mysql-server
               x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 0.0
 plesk-resctrl x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist  81 k
 plesk-roundcube
               noarch 1.2.2-cos7.build1700161122.21   @PLESK_17_0_17-dist  16 M
 plesk-service-node-utilities
               x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist  11 M
 plesk-web-hosting
               x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 173 k
 plesk-wp-upgrade
               noarch 1.0-71.16102516                 @PLESK_17_0_17-dist  11 M
 pp17.0.17-bootstrapper
               x86_64 17.0.17-cos7.build1700161117.16 @PLESK_17_0_17-dist 730 k
 psa-firewall  x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 673 k
 psa-health-monitor
               noarch 17.0.17-cos7.build1700161026.16 @PLESK_17_0_17-dist 956
 psa-horde     noarch 5.2.11-cos7.build1700161026.16  @PLESK_17_0_17-dist  68 M
 psa-imp       noarch 6.2.15-cos7.build1700161026.16  @PLESK_17_0_17-dist  18 M
 psa-ingo      noarch 3.2.11-cos7.build1700161026.16  @PLESK_17_0_17-dist 4.5 M
 psa-kronolith noarch 4.2.17-cos7.build1700161026.16  @PLESK_17_0_17-dist 8.9 M
 psa-libpam-plesk
               x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 196 k
 psa-libxml-proxy
               x86_64 2.7.8.1-centos7.16102516        @PLESK_17_0_17-dist 1.1 M
 psa-locale-base-en-US
               noarch 17.0.17-cos7.build1700161129.21 @PLESK_17_0_17-dist 1.1 M
 psa-logrotate x86_64 3.8.2-cos7.build1700161025.16   @PLESK_17_0_17-dist  75 k
 psa-mail-driver-common
               x86_64 17.0.17-cos7.build1700170131.16 @PLESK_17_0_17-dist 2.2 M
 psa-mnemo     noarch 4.2.11-cos7.build1700161026.16  @PLESK_17_0_17-dist 3.3 M
 psa-passwd    noarch 5.0.5-cos7.build1700161026.16   @PLESK_17_0_17-dist 2.9 M
 psa-php5-configurator
               x86_64 1.7.0-cos7.build1700161026.16   @PLESK_17_0_17-dist  62 k
 psa-phpfpm-configurator
               x86_64 1.0.0-cos7.build1700161026.16   @PLESK_17_0_17-dist 138
 psa-phpmyadmin
               noarch 4.6.6-cos7.build1700170125.17   @PLESK_17_0_17-dist  32 M
 psa-phppgadmin
               noarch 5.1-cos7.build1700161025.16     @PLESK_17_0_17-dist 3.0 M
 psa-proftpd   x86_64 1.3.5b-cos7.build1700161026.16  @PLESK_17_0_17-dist 7.2 M
 psa-pylibplesk
               x86_64 17.0.17-cos7.build1700161208.17 @PLESK_17_0_17-dist 162 k
 psa-turba     noarch 4.2.15-cos7.build1700161026.16  @PLESK_17_0_17-dist 6.2 M
 psa-updates   noarch 17.0.17-cos7.build1700161025.16 @PLESK_17_0_17-dist 0.0
 psa-vhost     noarch 17.0.17-cos7.build1700161026.16 @PLESK_17_0_17-dist 304 k
 psa-watchdog  x86_64 17.0.17-cos7.build1700161028.14 @PLESK_17_0_17-dist 2.9 M
 psa-zendframework
               noarch 1.12.17-cos7.build1700161025.16 @PLESK_17_0_17-dist  35 M

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

Installed size: 478 M
Is this ok [y/N]: