Skip to main content

Upgrading MySQL, ENOENT Error

Clint Decker
Trying to upgrade mysql from 5.1 to 5.5 then 5.6, but as soon as I start the upgrade, within a few seconds, it fails. This is the error I get.
Beginning MySQL upgrade... Running: /usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL41,MySQL50,MySQL51,MySQL55,MySQL56 --fix [20141016.025100] [20141016.025100] Problems were detected with cPanel-provided files which are RPM controlled. [20141016.025100] If you did not make these changes intentionally, you can correct them by running: [20141016.025100] [20141016.025100] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix [20141016.025100] The following RPMs are missing from your system: [20141016.025100] MySQL55-client-5.5.37-2.cp1136 [20141016.025100] MySQL55-devel-5.5.37-2.cp1136 [20141016.025100] MySQL55-server-5.5.37-2.cp1136 [20141016.025100] MySQL55-shared-5.5.37-2.cp1136 [20141016.025100] MySQL55-test-5.5.37-2.cp1136 [20141016.025100] compat-MySQL50-shared-5.0.96-4.cp1136 [20141016.025100] compat-MySQL51-shared-5.1.73-4.cp1136 [20141016.025101] Removing 0 broken rpms: [20141016.025101] rpm: no packages given for erase [20141016.025102] Downloading http://httpupdate.cpanel.net/RPM/11.36/centos/5/x86_64/rpm.md5 [20141016.025102] MySQL55-shared-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.025102] MySQL55-client-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.025102] MySQL55-server-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.025102] compat-MySQL50-shared-5.0.96-4.cp1136.x86_64.rpm already downloaded [20141016.025102] MySQL55-devel-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.025102] compat-MySQL51-shared-5.1.73-4.cp1136.x86_64.rpm already downloaded [20141016.025102] MySQL55-test-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.025102] Hooks system enabled [20141016.025102] Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed [20141016.025102] All required 'pre' hooks have been run [20141016.025102] No RPMS need to be uninstalled [20141016.025102] Installing new rpms: MySQL55-shared-5.5.37-2.cp1136.x86_64.rpm MySQL55-client-5.5.37-2.cp1136.x86_64.rpm MySQL55-server-5.5.37-2.cp1136.x86_64.rpm compat-MySQL50-shared-5.0.96-4.cp1136.x86_64.rpm MySQL55-devel-5.5.37-2.cp1136.x86_64.rpm compat-MySQL51-shared-5.1.73-4.cp1136.x86_64.rpm MySQL55-test-5.5.37-2.cp1136.x86_64.rpm [20141016.025103] error: Failed dependencies: [20141016.025103] MySQL conflicts with mysql-5.0.77-4.el5_6.6.i386 [20141016.025103] W Error Code: 7 [20141016.025103] E The following possible errors were detected while installing RPMs: [20141016.025103] E Failed dependencies [20141016.025103] The Administrator will be notified to review this output when this script completes [20141016.025103] Checking for and running RPM::Versions 'post' hooks for any RPMs just installed [20141016.025103] All required 'post' hooks have been run Failed while upgrading to 5.5...The subprocess reported the "ENOENT" (2) error when it ended....aborting! MySQL upgrade failed!

Comments

11 comments

Date Votes
  • 24x7server
    Hello, Can you please try to run /usr/local/cpanel/scripts/check_cpanel_rpms --fix command on your server and try again
    0
  • Clint Decker
    Same Error. Thanks for the quick reply :) This is what it said when I ran what you told me to:
    # /usr/local/cpanel/scripts/check_cpanel_rpms --fix [20141016.114745] [20141016.114745] Problems were detected with cPanel-provided files which are RPM controlled. [20141016.114745] If you did not make these changes intentionally, you can cor rect them by running: [20141016.114745] [20141016.114745] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix [20141016.114745] The following RPMs are missing from your system: [20141016.114745] MySQL55-client-5.5.37-2.cp1136 [20141016.114745] MySQL55-devel-5.5.37-2.cp1136 [20141016.114745] MySQL55-server-5.5.37-2.cp1136 [20141016.114745] MySQL55-shared-5.5.37-2.cp1136 [20141016.114745] MySQL55-test-5.5.37-2.cp1136 [20141016.114745] compat-MySQL50-shared-5.0.96-4.cp1136 [20141016.114745] compat-MySQL51-shared-5.1.73-4.cp1136 [20141016.114800] Removing 0 broken rpms: [20141016.114800] rpm: no packages given for erase [20141016.114801] Downloading [url=http://httpupdate.cpanel.net/RPM/11.36/centos/5/]Index of /RPM/11.36/centos/5/ x86_64/rpm.md5 [20141016.114802] MySQL55-shared-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.114802] MySQL55-client-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.114802] MySQL55-server-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.114802] compat-MySQL50-shared-5.0.96-4.cp1136.x86_64.rpm already dow nloaded [20141016.114802] MySQL55-devel-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.114802] compat-MySQL51-shared-5.1.73-4.cp1136.x86_64.rpm already dow nloaded [20141016.114802] MySQL55-test-5.5.37-2.cp1136.x86_64.rpm already downloaded [20141016.114803] Hooks system enabled [20141016.114803] Checking for and running RPM::Versions 'pre' hooks for any R PMs about to be installed warn [check_cpanel_rpms] program "/scripts/premysqlup" is not executable [20141016.114803] All required 'pre' hooks have been run [20141016.114803] No RPMS need to be uninstalled [20141016.114803] Installing new rpms: MySQL55-shared-5.5.37-2.cp1136.x86_64.r pm MySQL55-client-5.5.37-2.cp1136.x86_64.rpm MySQL55-server-5.5.37-2.cp1136.x86_ 64.rpm compat-MySQL50-shared-5.0.96-4.cp1136.x86_64.rpm MySQL55-devel-5.5.37-2.c p1136.x86_64.rpm compat-MySQL51-shared-5.1.73-4.cp1136.x86_64.rpm MySQL55-test-5 .5.37-2.cp1136.x86_64.rpm [20141016.114804] error: Failed dependencies: [20141016.114804] MySQL conflicts with mysql-5.0.77-4.el5_6.6.i386 [20141016.114804] W Error Code: 7 [20141016.114804] E The following possible errors were detected while installing RPMs: [20141016.114804] E Failed dependencies [20141016.114804] The Administrator will be notified to review this output whe n this script completes [20141016.114804] Checking for and running RPM::Versions 'post' hooks for any RPMs just installed warn [check_cpanel_rpms] program "/scripts/postmysqlinstall" is not executable warn [check_cpanel_rpms] program "/scripts/postmysqlup" is not executable [20141016.114804] All required 'post' hooks have been run
    Then this was the error on my mysql update:
    Beginning MySQL upgrade... Running: /usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL41,MySQL50,MySQL51,MySQL55,MySQL56 --fix [20141016.114825] [20141016.114825] Problems were detected with cPanel-provided files which are RPM controlled. [20141016.114825] If you did not make these changes intentionally, you can correct them by running: [20141016.114825] [20141016.114825] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix [20141016.114825] The following RPMs are missing from your system: [20141016.114825] MySQL55-client-5.5.37-2.cp1136 [20141016.114825] MySQL55-devel-5.5.37-2.cp1136 [20141016.114825] MySQL55-server-5.5.37-2.cp1136 [20141016.114825] MySQL55-shared-5.5.37-2.cp1136 [20141016.114825] MySQL55-test-5.5.37-2.cp1136 [20141016.114825] compat-MySQL50-shared-5.0.96-4.cp1136 [20141016.114825] compat-MySQL51-shared-5.1.73-4.cp1136 [20141016.114826] Removing 0 broken rpms: [20141016.114826] rpm: no packages given for erase [20141016.114827] Downloading
    0
  • cPanelMichael
    Hello :) Could you let us know which version of cPanel is installed on your system? Also, please post the output from the following command:
    grep mysql-version /var/cpanel/cpanel.config
    Thank you.
    0
  • Clint Decker
    # grep mysql-version /var/cpanel/cpanel.config mysql-version=5.5 WHM 11.44.1 (build 18)
    0
  • cPanelMichael
    Try removing the old RPM with a command such as:
    rpm -e --justdb --nodeps mysql-5.0.77-4.el5_6.6.i386
    Then, check to see if the MySQL upgrade completes successfully. Thank you.
    0
  • Clint Decker
    Thanks, That did the trick!! Thank you.
    0
  • cPanelMichael
    I am happy to see the issue is now resolved. Thank you for updating us with the outcome.
    0
  • Peoplespaces
    I am getting the same error and the fixes do not work. cpanel ver WHM 11.44.1 (build 18). Trying to upgrade to 5.5 and also even though the upgrade failes in WHM I get this grep mysql-version /var/cpanel/cpanel.config mysql-version=5.5 Running rpm -e --justdb --nodeps mysql-5.0.77-4.el5_6.6.i386
    20141101.074622] The following RPMs are missing from your system: [20141101.074622] MySQL55-client-5.5.37-2.cp1136 [20141101.074622] MySQL55-devel-5.5.37-2.cp1136 [20141101.074622] MySQL55-server-5.5.37-2.cp1136 [20141101.074622] MySQL55-shared-5.5.37-2.cp1136 [20141101.074622] MySQL55-test-5.5.37-2.cp1136 [20141101.074622] compat-MySQL50-shared-5.0.96-4.cp1136 [20141101.074622] compat-MySQL51-shared-5.1.73-4.cp1136 [20141101.074633] Removing 0 broken rpms: [20141101.074633] rpm: no packages given for erase [20141101.074634] Downloading
    0
  • Peoplespaces
    Fixed. Ran your command with the proper MySQL conflict. thanks
    0
  • farazjk
    ]Try removing the old RPM with a command such as:
    rpm -e --justdb --nodeps mysql-5.0.77-4.el5_6.6.i386
    Then, check to see if the MySQL upgrade completes successfully. Thank you.

    Sorry for the stupid question but where do I run this code in the Cp. Thanks Faraz
    0
  • cPanelMichael
    ]Sorry for the stupid question but where do I run this code in the Cp. Thanks

    You can access your server via SSH as root using the instructions found here: SSH/Shell Access Note that since you are not familiar with SSH, it might be a good idea to consult with a qualified system administrator to assist you, or to open a support ticket with us so we can take a closer look. Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post