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:
    108
    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?
     
    #1 musti19, Aug 18, 2013
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    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.
     
    #2 cPanelMichael, Aug 19, 2013
  3. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    108
    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.
     
    #3 musti19, Aug 19, 2013
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    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.
     
    #4 cPanelMichael, Aug 19, 2013
  5. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    108
    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.
     
    #5 musti19, Aug 19, 2013
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    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.
     
    #6 cPanelMichael, Aug 19, 2013
  7. musti19

    musti19 Well-Known Member

    Joined:
    Jan 20, 2013
    Messages:
    108
    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?
     
    #7 musti19, Aug 19, 2013
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    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.
     
    #8 cPanelMichael, Aug 19, 2013
  9. celiac101

    celiac101 Active Member

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    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.
     
    #10 cPanelMichael, Aug 20, 2013
  11. celiac101

    celiac101 Active Member

    Joined:
    Dec 19, 2012
    Messages:
    44
    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:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    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.
     
    #12 cPanelMichael, Aug 20, 2013
  13. celiac101

    celiac101 Active Member

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


     
    #13 celiac101, Aug 20, 2013
  14. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    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.
     
    #14 cPanelMichael, Aug 20, 2013
  15. celiac101

    celiac101 Active Member

    Joined:
    Dec 19, 2012
    Messages:
    44
    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
     
    #15 celiac101, Aug 20, 2013
  16. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    Thank you.
     
    #16 cPanelMichael, Aug 20, 2013
  17. celiac101

    celiac101 Active Member

    Joined:
    Dec 19, 2012
    Messages:
    44
    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)
     
    #17 celiac101, Aug 20, 2013
  18. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    /scripts/upcp

    Thank you.
     
    #18 cPanelMichael, Aug 20, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - cPanel Update error
  1. Nirjonadda

    SOLVED update_db_cache errors during update to cPanel 62

    Nirjonadda, Jan 6, 2017, in forum: General Discussion
    Replies:
    6
    Views:
    487
    cPanelMichael
    Jan 20, 2017
  2. Adrianne

    Cron job error with /usr/local/cpanel/scripts/update_db_cache

    Adrianne, Apr 21, 2016, in forum: General Discussion
    Replies:
    3
    Views:
    880
    cPanelMichael
    Apr 25, 2016
  3. Guillaume Pilotte-Patry

    cPanel Update & OpenSSL

    Guillaume Pilotte-Patry, Aug 3, 2017, in forum: Security
    Replies:
    5
    Views:
    127
    cPanelMichael
    Aug 7, 2017
  4. Petar

    Engintron not working after cPanel updates

    Petar, Jul 28, 2017, in forum: EasyApache
    Replies:
    6
    Views:
    109
    cPanelMichael
    Jul 28, 2017
  5. dstana

    Can't Update cPanel Themes

    dstana, Jul 19, 2017, in forum: User Experience
    Replies:
    2
    Views:
    122
    cPanelMichael
    Jul 20, 2017

Share This Page