upgrading to v.58 fails due to SQL.

July 13, 2016 18:42

I read 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.

0

cPanelMichael

July 19, 2016 19:10

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.

0

LoadFactor

July 19, 2016 20:10

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

0

LoadFactor

July 19, 2016 20:36

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

0

cPanelMichael

July 20, 2016 16:19

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.

0

LoadFactor

July 21, 2016 14:03

This is what I get

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

0

LoadFactor

July 22, 2016 14:16

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?

0

Peter Grahn a.k.a Lite

July 22, 2016 20:10

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

0

Peter Grahn a.k.a Lite

July 22, 2016 20:12

[root@amiga ~]# /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.

0

Peter Grahn a.k.a Lite

July 22, 2016 20:21

Uninstalled My SQL Governor: /usr/share/lve/dbgovernor/mysqlgovernor.py --delete After that, the server went ahead and installed .58

0

cPanelMichael

July 25, 2016 23:03

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.

0

cPanelMichael

July 26, 2016 15:27

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 [LIST]

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.

0

upgrading to v.58 fails due to SQL.

Comments

Didn't find what you were looking for?