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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Aug 19, 2013
  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.
     
    #3 musti19, Aug 19, 2013
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Aug 19, 2013
  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.
     
    #5 musti19, Aug 19, 2013
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Aug 19, 2013
  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?
     
    #7 musti19, Aug 19, 2013
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelMichael, Aug 19, 2013
  9. celiac101

    celiac101 Well-Known Member

    Joined:
    Dec 19, 2012
    Messages:
    63
    Likes Received:
    1
    Trophy Points:
    8
    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:
    43,711
    Likes Received:
    1,794
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 cPanelMichael, Aug 20, 2013
  11. celiac101

    celiac101 Well-Known Member

    Joined:
    Dec 19, 2012
    Messages:
    63
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #12 cPanelMichael, Aug 20, 2013
  13. celiac101

    celiac101 Well-Known Member

    Joined:
    Dec 19, 2012
    Messages:
    63
    Likes Received:
    1
    Trophy Points:
    8
    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:
    43,711
    Likes Received:
    1,794
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #14 cPanelMichael, Aug 20, 2013
  15. celiac101

    celiac101 Well-Known Member

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #16 cPanelMichael, Aug 20, 2013
  17. celiac101

    celiac101 Well-Known Member

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #18 cPanelMichael, Aug 20, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - cPanel Update error
  1. Bdzzld

    update_db_cache errors after update to cPanel 70

    Bdzzld, May 30, 2018, in forum: Database Discussion
    Replies:
    6
    Views:
    109
    cPanelMichael
    Jun 6, 2018
  2. mariusfv

    cPanel update error - “/usr/local/cpanel/scripts/migrate_local_ini_to_ph p_ini”

    mariusfv, Mar 29, 2018, in forum: EasyApache
    Replies:
    7
    Views:
    352
    cPanelMichael
    Apr 9, 2018
  3. tornadochaser

    Error Trying to Update cPanel

    tornadochaser, Nov 14, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    250
    cPanelMichael
    Nov 20, 2017
  4. Erjen

    Update cPanel 66.0.26 - 550 error Please turn on SMTP Authentication

    Erjen, Oct 18, 2017, in forum: E-mail Discussion
    Replies:
    2
    Views:
    1,176
    Erjen
    Oct 25, 2017
  5. swbrains

    After update to cPanel 66, error 255 in fetchzone_records

    swbrains, Sep 4, 2017, in forum: cPanel Developers
    Replies:
    3
    Views:
    513
    cPanelMichael
    Sep 6, 2017

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.
    Accept Learn More...
    Dismiss Notice