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.

cPanel Update error , Reason MySQL 5.1 conflicts 5.5 howto solve?

Discussion in 'General Discussion' started by musti19, Aug 18, 2013.

  1. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello,
    my cPanel system cant update to 11.38.2.2 from 11.38.1(15),
    because i get the error:
    Code:
    [20130818.214312]   MySQL51-client-5.1.70-1.cp1136.x86_64.rpm already downloaded
    [20130818.214313]   MySQL51-devel-5.1.70-1.cp1136.x86_64.rpm already downloaded
    [20130818.214313]   MySQL51-shared-5.1.70-1.cp1136.x86_64.rpm already downloaded
    [20130818.214313]   MySQL51-test-5.1.70-1.cp1136.x86_64.rpm already downloaded
    [20130818.214313]   MySQL51-server-5.1.70-1.cp1136.x86_64.rpm already downloaded
    [20130818.214313]   All files Staged
    [20130818.214313]   Testing if the newly downloaded RPMS can be installed without conflict
    [20130818.214313]   Testing RPM transaction
    [20130818.214314]       file /usr/bin/mysql from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130818.214314]       file /usr/bin/mysql_waitpid from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130818.214314]       file /usr/bin/mysqlaccess from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130818.214314]       file /usr/bin/mysqladmin from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130818.214314]       file /usr/bin/mysqlbinlog from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130818.214314]       file /usr/bin/mysqlcheck from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130818.214314]       file /usr/bin/mysqldump from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130818.214314]       file /usr/bin/mysqlimport from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130818.214314]       file /usr/bin/mysqlshow from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130818.214314]       file /usr/bin/mysqlslap from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    how can i solve this?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Check to see which version of MySQL is installed on your system:

    Code:
    mysql -V
    rpm -qa|grep MySQL
    It looks like you may have MySQL 5.1 and MySQL 5.5 RPMs installed. Have you manually upgraded MySQL or modified it for third-party installations? Assuming that MySQL 5.1 should not be installed, you can run the following command:

    Code:
    /scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled
    Then, run:

    Code:
    /usr/local/cpanel/scripts/check_cpanel_rpms
    Thank you.
     
  3. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    rpm -qa|grep MySQL:
    Code:
    MySQL55-shared-5.5.32-1.cp1136.x86_64
    MySQL55-client-5.5.32-1.cp1136.x86_64
    cpanel-perl-514-MySQL-Diff-0.43-1.cp1136.x86_64
    MySQL55-server-5.5.32-1.cp1136.x86_64
    MySQL55-devel-5.5.32-1.cp1136.x86_64
    MySQL55-test-5.5.32-1.cp1136.x86_64
    No i have not installed mysql manually.

    After the command:
    Code:
    /scripts/update_local_rpm_versions --edit target_settings.MySQL51 uninstalled
    and
    Code:
    /usr/local/cpanel/scripts/check_cpanel_rpms
    get this output:
    Code:
    [20130819.144406]   The following RPMs are unneeded on your system and should be                                   uninstalled:
    [20130819.144406]   MySQL55-client.5.5.32-1.cp1136
    [20130819.144406]   MySQL55-devel.5.5.32-1.cp1136
    [20130819.144406]   MySQL55-server.5.5.32-1.cp1136
    [20130819.144406]   MySQL55-shared.5.5.32-1.cp1136
    [20130819.144406]   MySQL55-test.5.5.32-1.cp1136
    
    Does it mean, to uninstall running mysql 5.5 ?
    I stopped the command via CTRL+C fastly.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Please post the output of the following commands:

    Code:
    mysql -V
    Also, did you upgrade to MySQL version 5.5 in the past? Did you use the "WHM Home » Software » MySQL Upgrade" interface? If so, this command will ensure the RPM check script detects it as installed:

    Code:
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
    Thank you.
     
  5. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    mysql -V
    Code:
    mysql  Ver 14.14 Distrib 5.5.32, for Linux (x86_64) using readline 5.1
    No, I installed cPanel 10 days ago on Centos 6.4 and have not upgraded it.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Please run this command:

    Code:
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
    Then run:

    Code:
    /usr/local/cpanel/scripts/check_cpanel_rpms
    Also, have you upgraded to cPanel version 11.38 yet, or are you still using cPanel version 11.36?

    Thank you.
     
  7. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    actually im using 11.38.1 (build 15) and tried to update to 11.38.2.2.
    Because of this problem,it was not possible.
    I entered the commands, i get this output:


    Code:
    [20130819.171613]   Problems were detected with cPanel-provided files which are RPM controlled.
    [20130819.171613]   If you did not make these changes intentionally, you can correct them by running:
    
    [20130819.171613]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
    [20130819.171613]   The following RPMs are missing from your system:
    [20130819.171613]   MySQL51-client.5.1.70-1.cp1136
    [20130819.171613]   MySQL51-devel.5.1.70-1.cp1136
    [20130819.171613]   MySQL51-server.5.1.70-1.cp1136
    [20130819.171613]   MySQL51-shared.5.1.70-1.cp1136
    [20130819.171613]   MySQL51-test.5.1.70-1.cp1136
    But my system have already mysql 5.5 and dont need 5.1, this command want to install 5.1?
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you open a support ticket so we can take a closer look? You can submit a ticket via:

    Submit A Ticket

    Please post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
  9. celiac101

    celiac101 Active Member

    Joined:
    Dec 19, 2012
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Website Owner
    I am having the exact same issue...please post a fix here ASAP.
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Please open a support ticket and provide us with the ticket number if the previous solutions listed here have not resolved the issue.

    Thank you.
     
  11. celiac101

    celiac101 Active Member

    Joined:
    Dec 19, 2012
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Website Owner
    None of the fixes posted here work, any other ideas besides opening a ticket? Here is part of the log:


    An error was detected which prevented updatenow from completing normally.
    Please review the enclosed log for further details

    Code:
    [20130819.230643]   Testing if the newly downloaded RPMS can be installed without conflict
    [20130819.230643]   Testing RPM transaction
    [20130819.230644]       file /usr/bin/mysql from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130819.230644]       file /usr/bin/mysql_waitpid from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130819.230644]       file /usr/bin/mysqlaccess from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
    [20130819.230644]       file /usr/bin/mysqladmin from install of MySQL51-client-5.1.70-1.cp1136.x86_64 conflicts with file from package MySQL55-client-5.5.32-1.cp1136.x86_64
     
    #11 celiac101, Aug 20, 2013
    Last edited by a moderator: Aug 20, 2013
  12. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You can check to make sure the version of MySQL you have installed is configured in the /var/cpanel/cpanel.config file. EX:

    Code:
    grep -i mysql-version /var/cpanel/cpanel.config
    Otherwise, opening a ticket is the best option because it allows us to access your system directly to investigate.

    Thank you.
     
  13. celiac101

    celiac101 Active Member

    Joined:
    Dec 19, 2012
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Website Owner
    That command yielded: mysql-version=5.1


     
  14. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Edit the file using a text editor such as "vi" and change the value to:

    mysql-version=5.5

    Note that this assumes you already installed MySQL version 5.5 on the system.

    Thank you.
     
  15. celiac101

    celiac101 Active Member

    Joined:
    Dec 19, 2012
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Website Owner
    Thank you, to be sure I ran:
    # mysql -V
    mysql Ver 14.14 Distrib 5.5.32, for Linux (x86_64) using readline 5.1

    so I assume I need to do what you ask?
    Scott
     
  16. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  17. celiac101

    celiac101 Active Member

    Joined:
    Dec 19, 2012
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Website Owner
    It appears this fixed the issue. After updating /var/cpanel/cpanel.config
    mysql-version=5.1
    to
    mysql-version=5.5

    I ran these three commands, which all seemed to complete without errors:
    /scripts/update_local_rpm_versions --edit target_settings.MySQL55 installed
    /usr/local/cpanel/scripts/check_cpanel_rpms
    /usr/local/cpanel/scripts/check_cpanel_rpms --fix

    However, I did not get an email notification from the system that cpanel updated, which I normally get (but again, I also didn't get a failure notice, which is what I got when I ran the above commands)
     
  18. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page