upgrading to v.58 fails due to SQL.

[Peter Grahn a.k.a Lite]

Hi

I read 58 Release Notes - Documentation - cPanel Documentation in regards to SQL and that upgrade would fail and it does. Servers are running MariaDB10.0 with SQL Governor. So what do I turn off in order to upgrade to V58?

Yours.

Peter

 

[cPanelMichael]

I read 58 Release Notes - Documentation - cPanel Documentation in regards to SQL and that upgrade would fail and it does. Servers are running MariaDB10.0 with SQL Governor. So what do I turn off in order to upgrade to V58?

Hello,

MySQL/MariaDB updates are handled separately with the MySQL Governor application:

CloudLinux - MySQL Governor

I'm also not seeing the specific reference to this in the cPanel 58 release notes. Could you let us know the specific failure message you received when attempting to update cPanel?

Thank you.

 

[cPanelMichael]

Hello Peter Grahn a.k.a Lite,

Is the update to cPanel 58 still failing on this system? If so, were you able to determine the specific error message?

Thank you.

 

[LoadFactor]

I am getting package conflict errors like this. the messages are:

[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/debug/libdaemon_example.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/libdaemon_example.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/debug/mypluglib.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/mypluglib.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/debug/mysql_no_login.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/mysql_no_login.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/debug/qa_auth_client.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/qa_auth_client.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/debug/qa_auth_interface.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/qa_auth_interface.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/debug/qa_auth_server.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/qa_auth_server.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/debug/semisync_master.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/semisync_master.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/debug/semisync_slave.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/semisync_slave.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/debug/validate_password.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/lib64/mysql/plugin/validate_password.so from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/sbin/mysqld from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/sbin/mysqld-debug from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/share/mysql/mysql.server from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64
[2016-07-19 00:35:25 -0400] file /usr/share/mysql/mysql_system_tables_data.sql from install of MySQL56-server-5.6.30-1.cp1156.x86_64 conflicts with file from package cl-MySQL56-server-5.6.30-1.el7.cloudlinux.x86_64

 

[LoadFactor]

FWIW I'm also getting regular "Altered RPMs found" warnings for these packages.

The system detected problems with the following cPanel-provided files that the RPM controls:
RPM
Status
Additional Information
MySQL56-client-5.6.30-1.cp1156
Missing
MySQL56-devel-5.6.30-1.cp1156
Missing
MySQL56-server-5.6.30-1.cp1156
Missing
MySQL56-shared-5.6.30-1.cp1156
Missing
MySQL56-test-5.6.30-1.cp1156
Missing
compat-MySQL50-shared-5.0.96-4.cp1136
Missing
compat-MySQL51-shared-5.1.73-1.cp1150
Missing

 

[cPanelMichael]

Hello,

CloudLinux with the MySQL Governor plugin uses it's own RPMs. It looks like you have the cPanel MySQL RPMs and the CloudLinux MySQL RPMs managed as local RPMs. Please post the output from the following command so we can see if this is a flaw in how Cloud Linux manages the RPMs:

cat /var/cpanel/rpm.versions.d/cloudlinux.versions

Note that you should be able to run the following commands to successfully update cPanel if you are using CloudLinux with MySQL Governor:

/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL50 unmanaged
/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL51 unmanaged
/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL55 unmanaged
/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL56 unmanaged
/scripts/upcp

Thank you.

 

[LoadFactor]

This is what I get

---
file_format:
  version: 2
target_settings:
  MySQL50: unmanaged
  MySQL51: unmanaged
  MySQL55: unmanaged
  MySQL56: unmanaged
  MariaDB100: unmanaged
  MariaDB101 unmanaged

 

[LoadFactor]

Also, running

/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL50 unmanaged

Gives me this error:

[2016-07-22 10:13:48 -0400] E Unable to load /var/cpanel/rpm.versions.d/cloudlinux.versions: Syck parser (line 11, column -1): syntax error at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/x86_64-linux-64int/YAML/Syck.pm line 133, <$fh> line 1.

Presumably this makes this a CloudLinux issue?

 

[Peter Grahn a.k.a Lite]

Late reply, sorry. Here's the output.

[2016-07-22 22:05:30 +0200] All files Staged
[2016-07-22 22:05:30 +0200] Testing if the newly downloaded RPMS can be installed without conflict
[2016-07-22 22:05:30 +0200] Testing RPM transaction
[2016-07-22 22:05:34 +0200] error: Failed dependencies:
[2016-07-22 22:05:34 +0200] mysql-server is needed by cpanel-roundcubemail-1.1.4-5.cp1158.noarch
[2016-07-22 22:05:34 +0200] W Exit Code: 209
[2016-07-22 22:05:34 +0200] ***** FATAL: Test install failed: error: Failed dependencies:
[2016-07-22 22:05:34 +0200] mysql-server is needed by cpanel-roundcubemail-1.1.4-5.cp1158.noarch
[2016-07-22 22:05:34 +0200] The Administrator will be notified to review this output when this script completes
[2016-07-22 22:05:34 +0200] ***** FATAL: Error testing if the RPMs will install: Test install failed: error: Failed dependencies:
[2016-07-22 22:05:34 +0200] mysql-server is needed by cpanel-roundcubemail-1.1.4-5.cp1158.noarch
[2016-07-22 22:05:34 +0200] see https://go.cpanel.net/rpmcheckfailed for more information
[2016-07-22 22:05:34 +0200] The Administrator will be notified to review this output when this script completes
=> Log closed Fri Jul 22 22:05:34 2016
[2016-07-22 22:05:34 +0200] E Running `/usr/local/cpanel/scripts/updatenow --upcp --log=/var/cpanel/updatelogs/update.1469217755.log` failed, exited with code 1 (signal = 0)
=> Log closed Fri Jul 22 22:05:34 2016

 

[Peter Grahn a.k.a Lite]

[[email protected] ~]# /usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL50 unmanaged
[2016-07-22 22:11:52 +0200] E Unable to load /var/cpanel/rpm.versions.d/cloudlinux.versions: Syck parser (line 11, column -1): syntax error at /usr/local/cpanel/3rdparty/perl/522/lib64/perl5/cpanel_lib/x86_64-linux-64int/YAML/Syck.pm line 133, <$fh> line 1.

 

[Peter Grahn a.k.a Lite]

Uninstalled My SQL Governor:

/usr/share/lve/dbgovernor/mysqlgovernor.py --delete

After that, the server went ahead and installed .58

 

[cPanelMichael]

Hello,

The issue stems from invalid syntax in the following file:

/var/cpanel/rpm.versions.d/cloudlinux.versions

Per the output in your previous response, the last line of this file is:

 MariaDB101 unmanaged

You can correct this by updating the line to include a colon:

MariaDB101: unmanaged

We've seen multiple reports of this issue. I've contacted CloudLinux directly to determine if this is a bug with how their software implements this file, and I'll update this thread with more information as it becomes available.

Thank you.

 

[cPanelMichael]

Hello,

CloudLinux has released a new version of MySQL Governor to correct this problem:

MySQL Governor updated

Per this blog post:

Changelog:
governor-mysql 1.1-17

• force reinstall cloudlinux.versions on update;
• fixed error in cloudlinux.version file for cPanel.

To update run:

$ yum update governor-mysql

$ service db_governor restart

Thank you.