Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    110
    Likes Received:
    1
    Trophy Points:
    18
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,896
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    110
    Likes Received:
    1
    Trophy Points:
    18
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,896
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    110
    Likes Received:
    1
    Trophy Points:
    18
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,896
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    110
    Likes Received:
    1
    Trophy Points:
    18
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,896
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. celiac101

    celiac101 Well-Known Member

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

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,896
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  11. celiac101

    celiac101 Well-Known Member

    Joined:
    Dec 19, 2012
    Messages:
    73
    Likes Received:
    1
    Trophy Points:
    8
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,896
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  13. celiac101

    celiac101 Well-Known Member

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


     
  14. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,896
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  15. celiac101

    celiac101 Well-Known Member

    Joined:
    Dec 19, 2012
    Messages:
    73
    Likes Received:
    1
    Trophy Points:
    8
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,896
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes, update the value in /var/cpanel/cpanel.config and then try updating cPanel again.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  17. celiac101

    celiac101 Well-Known Member

    Joined:
    Dec 19, 2012
    Messages:
    73
    Likes Received:
    1
    Trophy Points:
    8
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,896
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    It looks like that resolved the issue. Note that if you want to update cPanel, you must run:

    /scripts/upcp

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice