Skip to main content

"cPanel & WHM update failure in upcp script" MySQL 5.7 Community Server yum issue

Comments

34 comments

  • Netg
    I just have the same issues on some server.
    0
  • swbrains
    I received the same email during tonight's update with the same update log contents as you; in particular, the same failure: [2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package. [2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Check that the correct key URLs are configured for this repository. [2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] [2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] [2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Failing package is: mysql-community-libs-compat-5.7.37-1.el7.x86_64 [2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] GPG Keys are configured as: http://repo.mysql.com/RPM-GPG-KEY-mysql
    0
  • rardark
    Exactly the same here...
    0
  • Lauris
    Same here too.
    0
  • daynight
    Same problem here. Anything new info about this?
    0
  • Petros
    Same here! WHM's version is v100.0.5.
    0
  • 0x4
    Unable to install and update. Same problem.
    0
  • andrew.n
    The GPG keys for the new release has been changed. See this for further info: Once adjusted, run the update once more: /usr/local/cpanel/scripts/upcp
    0
  • jsar
    Same problem here. I did what @andrew.n suggested and problem seems to be solved. To be more specific, I didn't update the gpgkey line in the /etc/yum.repos.d/. That's because this line seems to be a path to an internal file and not a url. Instead, I got the content of the file here:
    0
  • lbeachmike
    Thanks Andrew! It looks like cPanel added an autofixer for the gpgkey since your post - /scripts/autorepair mysql_gpg_key (found at the URL you provided) I ran that, then ran: /usr/local/cpanel/scripts/upcp Things seemed to go well.
    0
  • cPanelAnthony
    Thank you for your helo, Andrew! I am glad this is resolved.
    0
  • cPanelAnthony
    @mvandemar could you try the steps in this article?
    0
  • ahmadrusli
    I just installed using GCP. already successful logged whm with root. but mysql not running. error message: The MySQL/MariaDB server is not currently running. If this is not intentional, you may experience problems with your upgrade. i tried using ssh: mysql -v the results: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) i tried : /scripts/autorepair mysql_gpg_key result: autofix is done. i tried: /usr/local/cpanel/scripts/upcp result: [2022-01-24 21:51:05 +0700]
  • Evaluating if system can autoupgrade MySQL 5.5 to MySQL 5.7... [2022-01-24 21:51:05 +0700] [!] Unable to autoupgrade: "mysql-version" is not configured properly in /var/cpanel/cpanel.config [2022-01-24 21:51:05 +0700] E The install encountered a fatal error: (XID f2q7p9) The system failed to determine the "mysqld" version. => Log closed Mon Jan 24 21:51:05 2022 [2022-01-24 21:51:05 +0700] 17% complete [2022-01-24 21:51:05 +0700] E Running `/usr/local/cpanel/scripts/updatenow --upcp --log=/var/cpanel/updatelogs/update.3712.403315.1643031829.log` failed, exited with code 2 (signal = 0) => Log closed Mon Jan 24 21:51:05 2022

  • now, i can not start mysql. if i tried install again with GCP, i think the problem will the same. auto fixer must loaded before GCP deploy new instance? how can we do that? thank you
    0
  • cPRex Jurassic Moderator
    @ahmadrusli - can you check the cPanel install log to see if there are any errors there about MySQL? That is located at /var/log/cpanel-install.log and could help narrow down the issue.
    0
  • mvandemar
    @mvandemar could you try the steps in this article?
    0
  • cPRex Jurassic Moderator
    @mvandemar - I'm glad to hear that's working well for you!
    0
  • ahmadrusli
    @ahmadrusli - can you check the cPanel install log to see if there are any errors there about MySQL? That is located at /var/log/cpanel-install.log and could help narrow down the issue.

    yes, i will see it. but for now, when i Upgrade to Latest Version via whm. these are the error: ---------------------------------------------------------------------------------------------------- => Log opened from cPanel Update (upcp) - Slave (1768) at Wed Jan 26 20:07:18 2022 [2022-01-26 20:07:18 +0700] Detected cron=0 (manual flag passed on command line) [2022-01-26 20:07:19 +0700] Running Standardized hooks [2022-01-26 20:07:19 +0700] mtime on upcp is 1637001952 (Tue Nov 16 01:45:52 2021) ---------------------------------------------------------------------------------------------------- => Log opened from /usr/local/cpanel/scripts/updatenow (1770) at Wed Jan 26 20:07:20 2022 [2022-01-26 20:07:20 +0700] Running version '11.100.0.4' of updatenow. [2022-01-26 20:07:20 +0700] Retrieved public key from vendor: cpanel, category: release, url: https://securedownloads.cpanel.net/cPanelPublicKey.asc [2022-01-26 20:07:21 +0700] Retrieved public key from vendor: cpanel, category: development, url: https://securedownloads.cpanel.net/cPanelDevelopmentKey.asc [2022-01-26 20:07:21 +0700] Detected version '11.100.0.4' from version file. [2022-01-26 20:07:21 +0700] Target version set to '11.100.0.7' [2022-01-26 20:07:21 +0700] Switching to version 11.100.0.7 of updatenow to determine if we can reach that version without failure. [2022-01-26 20:07:21 +0700] Retrieving and staging /cpanelsync/11.100.0.7/cpanel/scripts/updatenow.static.bz2 [2022-01-26 20:07:21 +0700] Using mirror '69.73.140.17' for host 'httpupdate.cpanel.net'. [2022-01-26 20:07:22 +0700] Using mirror '103.163.139.122' for host 'httpupdate.cpanel.net'. [2022-01-26 20:07:22 +0700] Become an updatenow.static for version: 11.100.0.7 => Log closed Wed Jan 26 20:07:22 2022 ---------------------------------------------------------------------------------------------------- => Log opened from /usr/local/cpanel/scripts/updatenow.static-cpanelsync (1770) at Wed Jan 26 20:07:23 2022 [2022-01-26 20:07:23 +0700] Running version '11.100.0.7' of updatenow. [2022-01-26 20:07:23 +0700] Detected version '11.100.0.4' from version file. [2022-01-26 20:07:23 +0700] Target version set to '11.100.0.7' [2022-01-26 20:07:23 +0700] Checking license [2022-01-26 20:07:24 +0700] License file check complete [2022-01-26 20:07:24 +0700] glibc-2.17-325.el7_9.x86_64 [2022-01-26 20:07:24 +0700] Testing if rpm_is_working RPM is installed [2022-01-26 20:07:24 +0700] Testing if it's possible to install a simple RPM [2022-01-26 20:07:24 +0700] Preparing... ######################################## [2022-01-26 20:07:24 +0700] Updating / installing... [2022-01-26 20:07:24 +0700] rpm_is_working-1.0-0 ######################################## [2022-01-26 20:07:24 +0700]
  • Evaluating if system can autoupgrade MySQL 5.5 to MySQL 5.7... [2022-01-26 20:07:24 +0700] [!] Unable to autoupgrade: "mysql-version" is not configured properly in /var/cpanel/cpanel.config [2022-01-26 20:07:24 +0700] E The install encountered a fatal error: (XID qdp7wc) The system failed to determine the "mysqld" version. => Log closed Wed Jan 26 20:07:24 2022 [2022-01-26 20:07:24 +0700] E Running `/usr/local/cpanel/scripts/updatenow --upcp --log=/var/cpanel/updatelogs/update.1768.8962.1643202348.log` failed, exited with code 2 (signal = 0) => Log closed Wed Jan 26 20:07:24 2022

  • this is fresh installation, via gcp on 2022-01-24 (19:28:17) . i saw Change Log for 100.0.7 Entry: 2022-01-20 Fixed case CPANEL-39775: Update MySQL GPG Key url for 2022. i think this patch not work when i installed on 24 january 2022. so my mysql not working. but i just saw gcp change log Last updated today: 26/01/2022. hopefully this patch work in this update. but, is there any suggestion what i do for now? thank you very much.
    0
  • cPRex Jurassic Moderator
    @ahmadrusli - the error you're seeing is different than the GPG problem mentioned earlier in this thread. Can you send me the output of the following command run on your server? grep mysql /var/cpanel/cpanel.config
    That may give me more details about the issue.
    0
  • ahmadrusli
    @ahmadrusli - the error you're seeing is different than the GPG problem mentioned earlier in this thread. Can you send me the output of the following command run on your server? grep mysql /var/cpanel/cpanel.config
    That may give me more details about the issue.

    Hi, i almost gave up. i delete the instance, and create new instance again. about 33 minutes ago. hope mysql run smoothly after new installation like usual. but the problem still there. there are error message (on attachment: Capture1.PNG): The MySQL/MariaDB server is not currently running. If this is not intentional, you may experience problems with your upgrade.
    i tried: grep mysql /var/cpanel/cpanel.config
    the results: mysql-host=localhost mysql-version=5.7 usemysqloldpass=0
    i tried to Upgrade to Latest Version, the results: ---------------------------------------------------------------------------------------------------- => Log opened from cPanel Update (upcp) - Slave (1825) at Fri Jan 28 22:44:08 2022 [2022-01-28 22:44:08 +0700] Detected cron=0 (manual flag passed on command line) [2022-01-28 22:44:08 +0700] Running Standardized hooks [2022-01-28 22:44:08 +0700] mtime on upcp is 1637001952 (Tue Nov 16 01:45:52 2021) ---------------------------------------------------------------------------------------------------- => Log opened from /usr/local/cpanel/scripts/updatenow (1827) at Fri Jan 28 22:44:09 2022 [2022-01-28 22:44:09 +0700] Running version '11.100.0.4' of updatenow. [2022-01-28 22:44:09 +0700] Detected version '11.100.0.4' from version file. [2022-01-28 22:44:09 +0700] Target version set to '11.100.0.7' [2022-01-28 22:44:09 +0700] Switching to version 11.100.0.7 of updatenow to determine if we can reach that version without failure. [2022-01-28 22:44:09 +0700] Retrieving and staging /cpanelsync/11.100.0.7/cpanel/scripts/updatenow.static.bz2 [2022-01-28 22:44:09 +0700] Using mirror '103.163.139.122' for host 'httpupdate.cpanel.net'. [2022-01-28 22:44:09 +0700] Become an updatenow.static for version: 11.100.0.7 => Log closed Fri Jan 28 22:44:09 2022 ---------------------------------------------------------------------------------------------------- => Log opened from /usr/local/cpanel/scripts/updatenow.static-cpanelsync (1827) at Fri Jan 28 22:44:11 2022 [2022-01-28 22:44:11 +0700] Running version '11.100.0.7' of updatenow. [2022-01-28 22:44:11 +0700] Detected version '11.100.0.4' from version file. [2022-01-28 22:44:11 +0700] Target version set to '11.100.0.7' [2022-01-28 22:44:11 +0700] Checking license [2022-01-28 22:44:11 +0700] License file check complete [2022-01-28 22:44:11 +0700] glibc-2.17-325.el7_9.x86_64 [2022-01-28 22:44:11 +0700] Testing if rpm_is_working RPM is installed [2022-01-28 22:44:11 +0700] Testing if it's possible to install a simple RPM [2022-01-28 22:44:11 +0700] Preparing... ######################################## [2022-01-28 22:44:11 +0700] Updating / installing... [2022-01-28 22:44:11 +0700] rpm_is_working-1.0-0 ######################################## [2022-01-28 22:44:11 +0700]
  • Evaluating if system can autoupgrade MySQL 5.5 to MySQL 5.7... [2022-01-28 22:44:11 +0700] [!] Unable to autoupgrade: "mysql-version" is not configured properly in /var/cpanel/cpanel.config [2022-01-28 22:44:11 +0700] E The install encountered a fatal error: (XID zt5t8b) The system failed to determine the "mysqld" version. => Log closed Fri Jan 28 22:44:11 2022 [2022-01-28 22:44:11 +0700] E Running `/usr/local/cpanel/scripts/updatenow --upcp --log=/var/cpanel/updatelogs/update.1825.98833.1643383659.log` failed, exited with code 2 (signal = 0) => Log closed Fri Jan 28 22:44:11 2022

  • this is a fresh installation. it seems the autofix not applied. please, would you try install a new instance at gcp? you will get the same results as me. thank you very much
    0
  • cPRex Jurassic Moderator
    Could you submit a ticket to our team so we can check this directly?
    0
  • ahmadrusli
    Could you submit a ticket to our team so we can check this directly?

    For AWS, i just create instance based official cpanel documentation:
    0
  • cPRex Jurassic Moderator
    I'm doing some testing on my end now, but can you confirm that you're using the details outlined here?
    0
  • cPRex Jurassic Moderator
    Update - our team found that some images are not properly getting the autofixer applied. We've submitted new images to Google and Alibaba but they do take a few days to pass their verification checks. At this time it might take until late next week before the new images will be live, and I don't have a workaround available except to not use that service for the time being.
    0
  • ahmadrusli
    I just installed fresh. and still error (please see the attachment): The MySQL/MariaDB server is not currently running. If this is not intentional, you may experience problems with your upgrade.
    so, the images not updated yet? need more information please. thank you verymuch :)
    0
  • andrew.n
    and is it running?
    0
  • kodeslogic
    @ahmadrusli Share the output of systemctl status mysqld
    0
  • ahmadrusli
    and is it running?

    no, it's not running. i though mysql not well installed from the beginning.
    0
  • ahmadrusli
    @ahmadrusli Share the output of systemctl status mysqld

    i think the image on gcp not yet updated. this image supposed to be high priority.
    0
  • kodeslogic
    I would suggest opening a support ticket to providers to help you with your problem.
    0

Please sign in to leave a comment.