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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SOLVED UPCP Failure on a server with Mysql Disabled

Discussion in 'General Discussion' started by hicom, Nov 9, 2017.

Tags:
  1. hicom

    hicom Well-Known Member

    Joined:
    May 23, 2003
    Messages:
    279
    Likes Received:
    2
    Trophy Points:
    168
    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.

    Code:
    
    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 ?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    41,396
    Likes Received:
    1,606
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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?

    Code:
    cat /usr/local/cpanel/version
    /usr/local/cpanel/scripts/check_mysql
    
    Thank you.
     
  3. hicom

    hicom Well-Known Member

    Joined:
    May 23, 2003
    Messages:
    279
    Likes Received:
    2
    Trophy Points:
    168
    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.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    41,396
    Likes Received:
    1,606
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  5. NotNulled

    NotNulled Registered

    Joined:
    Nov 9, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Chile
    cPanel Access Level:
    DataCenter Provider
    Hi,

    The same problem here, this start with the 68 version, in my case with cpanel using an external mysql server:

    Code:
    [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:

    Code:
    [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
     
  6. Boyko Velkov

    Boyko Velkov Registered

    Joined:
    Nov 10, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Europe
    cPanel Access Level:
    Root Administrator
    Having the same issue, since 1 week. Please post the solution!
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    41,396
    Likes Received:
    1,606
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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:

    Code:
    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.
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    41,396
    Likes Received:
    1,606
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page