Skip to main content

UPCP Failure on a server with Mysql Disabled

hicom
We have a server that has MySQL Disabled because we only use it or Web. Whenever UPCP runs, it fails with the following log (WHM v68.0.10): [2017-11-09 00:19:47 -0500] E [/usr/local/cpanel/scripts/check_mysql] The "/usr/local/cpanel/scripts/check_mysql" command (process 24725) reported error number 2 when it ended.
Update log preview: [2017-11-09 00:19:47 -0500] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] No local.ini. [2017-11-09 00:19:47 -0500] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] " done! [2017-11-09 00:19:47 -0500] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] Processing ea-php71 " [2017-11-09 00:19:47 -0500] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] No local.ini. [2017-11-09 00:19:47 -0500] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] " done! [2017-11-09 00:19:47 -0500] - Finished command `/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini --run --verbose` in 0.149 seconds [2017-11-09 00:19:47 -0500] 93% complete [2017-11-09 00:19:47 -0500] - Finished in 0.028 seconds [2017-11-09 00:19:47 -0500] Processing: Ensuring an "Active" MySQL profile is set [2017-11-09 00:19:47 -0500] - Processing command `/usr/local/cpanel/scripts/check_mysql` [2017-11-09 00:19:47 -0500] E [/usr/local/cpanel/scripts/check_mysql] The "/usr/local/cpanel/scripts/check_mysql" command (process 24725) reported error number 2 when it ended. [2017-11-09 00:19:47 -0500] The Administrator will be notified to review this output when this script completes [2017-11-09 00:19:47 -0500] - Finished command `/usr/local/cpanel/scripts/check_mysql` in 0.095 seconds [2017-11-09 00:19:47 -0500] 94% complete [2017-11-09 00:19:47 -0500] Processing: Checking CloudLinux installation [2017-11-09 00:19:47 -0500] - Processing command `/usr/local/cpanel/bin/cloudlinux_update` [2017-11-09 00:19:47 -0500] - Finished command `/usr/local/cpanel/bin/cloudlinux_update` in 0.058 seconds [2017-11-09 00:19:47 -0500] Processing: Updating plugins data cache [2017-11-09 00:19:47 -0500] - Processing command `/usr/local/cpanel/bin/refresh_plugin_cache` [2017-11-09 00:19:47 -0500] - Finished command `/usr/local/cpanel/bin/refresh_plugin_cache` in 0.150 seconds [2017-11-09 00:19:47 -0500] 95% complete => Log closed Thu Nov 9 00:19:47 2017 ---------------------------------------------------------------------------------------------------- => Log opened from cPanel Update (upcp) - Slave (23556) at Thu Nov 9 00:19:47 2017 [2017-11-09 00:19:47 -0500] E Post Maintenance ended, however it did not exit cleanly (256). Please check the logs for an indication of what happened
How can we make upcp upgrade without enabling mysql ?

Comments

7 comments

Date Votes
  • cPanelMichael
    Hello, I've been unable to reproduce this issue on a test server running cPanel version 68 after disabling MySQL via "WHM >> Service Manager". Have you taken any additional steps to disable MySQL on this system? Also, could you run the commands referenced below and let us know the output?
    cat /usr/local/cpanel/version /usr/local/cpanel/scripts/check_mysql
    Thank you.
    0
  • hicom
    We also have Remote MySQL server profile setup. When running the two commands: cat /usr/local/cpanel/version 11.68.0.10 /usr/local/cpanel/scripts/check_mysql Remote MySQL database servers are not supported.
    0
  • cPanelMichael
    Hello, Can you try running "/scripts/upcp --force" to see if the issue persists? If that doesn't help, could you open a support ticket using the link in my signature so we can take a closer look to see why the check_mysql script is exiting with error code 2 during the upcp process? Thank you.
    0
  • NotNulled
    Hi, The same problem here, this start with the 68 version, in my case with cpanel using an external mysql server:
    [2017-11-10 00:23:20 -0300] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] No local.ini. [2017-11-10 00:23:20 -0300] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] " done! [2017-11-10 00:23:20 -0300] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] Processing ea-php71 " [2017-11-10 00:23:20 -0300] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] No local.ini. [2017-11-10 00:23:20 -0300] [/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini] " done! [2017-11-10 00:23:20 -0300] - Finished command `/usr/local/cpanel/scripts/migrate_local_ini_to_php_ini --run --verbose` in 0.310 seconds [2017-11-10 00:23:20 -0300] 93% complete [2017-11-10 00:23:20 -0300] - Finished in 0.056 seconds [2017-11-10 00:23:20 -0300] Processing: Ensuring an "Active" MySQL profile is set [2017-11-10 00:23:20 -0300] - Processing command `/usr/local/cpanel/scripts/check_mysql` [2017-11-10 00:23:20 -0300] E [/usr/local/cpanel/scripts/check_mysql] The "/usr/local/cpanel/scripts/check_mysql" command (process 143622) reported error number 2 when it ended. [2017-11-10 00:23:20 -0300] The Administrator will be notified to review this output when this script completes [2017-11-10 00:23:20 -0300] - Finished command `/usr/local/cpanel/scripts/check_mysql` in 0.191 seconds [2017-11-10 00:23:20 -0300] 94% complete [2017-11-10 00:23:20 -0300] Processing: Checking CloudLinux installation [2017-11-10 00:23:20 -0300] - Processing command `/usr/local/cpanel/bin/cloudlinux_update` [2017-11-10 00:23:20 -0300] - Finished command `/usr/local/cpanel/bin/cloudlinux_update` in 0.319 seconds [2017-11-10 00:23:20 -0300] Processing: Updating plugins data cache [2017-11-10 00:23:20 -0300] - Processing command `/usr/local/cpanel/bin/refresh_plugin_cache` [2017-11-10 00:23:20 -0300] - Finished command `/usr/local/cpanel/bin/refresh_plugin_cache` in 0.075 seconds [2017-11-10 00:23:20 -0300] 95% complete => Log closed Fri Nov 10 00:23:20 2017 ---------------------------------------------------------------------------------------------------- => Log opened from cPanel Update (upcp) - Slave (139893) at Fri Nov 10 00:23:20 2017 [2017-11-10 00:23:20 -0300] E Post Maintenance ended, however it did not exit cleanly (256). Please check the logs for an indication of what happened
    The same result with the --force option:
    [2017-11-10 00:37:24 -0300] - Finished in 0.037 seconds [2017-11-10 00:37:24 -0300] Processing: Ensuring an "Active" MySQL profile is set [2017-11-10 00:37:24 -0300] - Processing command `/usr/local/cpanel/scripts/check_mysql` [2017-11-10 00:37:24 -0300] E [/usr/local/cpanel/scripts/check_mysql] The ""/usr/local/cpanel/scripts/check_mysql" command (process 155478) reported error number 2 when it ended. [2017-11-10 00:37:24 -0300] The Administrator will be notified to review this output when this script completes [2017-11-10 00:37:24 -0300] - Finished command `/usr/local/cpanel/scripts/check_mysql` in 0.142 seconds [2017-11-10 00:37:24 -0300] 94% complete [2017-11-10 00:37:24 -0300] Processing: Checking CloudLinux installation [2017-11-10 00:37:24 -0300] - Processing command `/usr/local/cpanel/bin/cloudlinux_update` [2017-11-10 00:37:24 -0300] - Finished command `/usr/local/cpanel/bin/cloudlinux_update` in 0.185 seconds [2017-11-10 00:37:24 -0300] Processing: Updating plugins data cache [2017-11-10 00:37:24 -0300] - Processing command `/usr/local/cpanel/bin/refresh_plugin_cache` [2017-11-10 00:37:24 -0300] - Finished command `/usr/local/cpanel/bin/refresh_plugin_cache` in 0.065 seconds [2017-11-10 00:37:24 -0300] 95% complete => Log closed Fri Nov 10 00:37:24 2017 ---------------------------------------------------------------------------------------------------- => Log opened from cPanel Update (upcp) - Slave (151855) at Fri Nov 10 00:37:24 2017 [2017-11-10 00:37:24 -0300] E Post Maintenance ended, however it did not exit cleanly (256). Please check the logs for an indication of what happened [2017-11-10 00:37:24 -0300] Polling updatenow to see if a newer version is available for upgrade => Log closed Fri Nov 10 00:37:24 2017 ---------------------------------------------------------------------------------------------------- => Log opened from /usr/local/cpanel/scripts/updatenow (155505) at Fri Nov 10 00:37:25 2017 [2017-11-10 00:37:25 -0300] Detected version '11.68.0.12' from version file. [2017-11-10 00:37:25 -0300] Running version '11.68.0.12' of updatenow. [2017-11-10 00:37:25 -0300] Target version set to '11.68.0.12' [2017-11-10 00:37:25 -0300] Up to date (11.68.0.12) => Log closed Fri Nov 10 00:37:25 2017 ---------------------------------------------------------------------------------------------------- => Log opened from cPanel Update (upcp) - Slave (151855) at Fri Nov 10 00:37:25 2017 [2017-11-10 00:37:26 -0300] 95% complete [2017-11-10 00:37:26 -0300] Running /usr/local/cpanel/scripts/postupcp => Log closed Fri Nov 10 00:37:35 2017
    0
  • Boyko Velkov
    Having the same issue, since 1 week. Please post the solution!
    0
  • cPanelMichael
    Hello, Internal case CPANEL-16858 is now open to address an issue where cPanel updates fail when MySQL is disabled due to /scripts/check_mysql exiting with status 2. I'll monitor this case and update this thread with more information as it becomes available. In the meantime, the temporary workaround is create the /var/cpanel/cpnat file with the following command:
    touch /var/cpanel/cpnat
    Once the next cPanel update completes successfully, you can remove this file (you'd need to do this anytime you update cPanel until the resolution is published). Thank you.
    0
  • cPanelMichael
    Hello, To update, this is fixed in cPanel version 68.0.21: Fixed case CPANEL-16858: maintenance: allow check_mysql to exit 2. The full cPanel version 68 change log is available at: 68 Change Log - Change Logs - cPanel Documentation Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post