cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
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

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
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

Well-Known Member
Jul 12, 2013
59
8
133
cPanel Access Level
Root Administrator
I am getting package conflict errors like this. the messages are:

Code:
[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

Well-Known Member
Jul 12, 2013
59
8
133
cPanel Access Level
Root Administrator
FWIW I'm also getting regular "Altered RPMs found" warnings for these packages.
Code:
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

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
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:

Code:
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:

Code:
/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

Well-Known Member
Jul 12, 2013
59
8
133
cPanel Access Level
Root Administrator
This is what I get
Code:
---
file_format:
  version: 2
target_settings:
  MySQL50: unmanaged
  MySQL51: unmanaged
  MySQL55: unmanaged
  MySQL56: unmanaged
  MariaDB100: unmanaged
  MariaDB101 unmanaged
 

LoadFactor

Well-Known Member
Jul 12, 2013
59
8
133
cPanel Access Level
Root Administrator
Also, running
Code:
/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.MySQL50 unmanaged
Gives me this error:
Code:
[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?
 
Feb 29, 2016
14
0
1
Sweden
cPanel Access Level
Website Owner
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
 
Feb 29, 2016
14
0
1
Sweden
cPanel Access Level
Website Owner
[[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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
Hello,

The issue stems from invalid syntax in the following file:

Code:
/var/cpanel/rpm.versions.d/cloudlinux.versions
Per the output in your previous response, the last line of this file is:

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

Code:
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

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
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.