The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

upgrading to v.58 fails due to SQL.

Discussion in 'General Discussion' started by Peter Grahn a.k.a Lite, Jul 13, 2016.

Tags:
  1. Peter Grahn a.k.a Lite

    Joined:
    Feb 29, 2016
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Sweden
    cPanel Access Level:
    Website Owner
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  4. LoadFactor

    LoadFactor Member

    Joined:
    Jul 12, 2013
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    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
    
     
  5. LoadFactor

    LoadFactor Member

    Joined:
    Jul 12, 2013
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  7. LoadFactor

    LoadFactor Member

    Joined:
    Jul 12, 2013
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    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
    
     
  8. LoadFactor

    LoadFactor Member

    Joined:
    Jul 12, 2013
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
  9. Peter Grahn a.k.a Lite

    Joined:
    Feb 29, 2016
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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
     
  10. Peter Grahn a.k.a Lite

    Joined:
    Feb 29, 2016
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Sweden
    cPanel Access Level:
    Website Owner
    [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.
     
  11. Peter Grahn a.k.a Lite

    Joined:
    Feb 29, 2016
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Sweden
    cPanel Access Level:
    Website Owner
    Uninstalled My SQL Governor:

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

    After that, the server went ahead and installed .58
     
  12. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  13. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,852
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

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

    MySQL Governor updated

    Per this blog post:

    Thank you.
     
Loading...

Share This Page