"cPanel & WHM update failure in upcp script" MySQL 5.7 Community Server yum issue
Just received my third email in a row on 3 different servers, all 3 having the exact same issue:
Any idea what's up with this? -Michael
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] ================================================================================
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Package Arch Version Repository Size
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] ================================================================================
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Updating:
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] mysql-community-client x86_64 5.7.37-1.el7 mysql57-community 25 M
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] mysql-community-common x86_64 5.7.37-1.el7 mysql57-community 311 k
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] mysql-community-devel x86_64 5.7.37-1.el7 mysql57-community 3.9 M
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] mysql-community-libs x86_64 5.7.37-1.el7 mysql57-community 2.4 M
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] mysql-community-libs-compat x86_64 5.7.37-1.el7 mysql57-community 1.2 M
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] mysql-community-server x86_64 5.7.37-1.el7 mysql57-community 174 M
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup]
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Transaction Summary
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] ================================================================================
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Upgrade 6 Packages
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup]
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Total download size: 207 M
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Downloading packages:
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] warning:
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.37-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Public key for mysql-community-common-5.7.37-1.el7.x86_64.rpm is not installed
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] --------------------------------------------------------------------------------
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Total 221 MB/s | 207 MB 00:00
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] Retrieving key from http://repo.mysql.com/RPM-GPG-KEY-mysql
[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] 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
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup]
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] (XID jtrfe8) "/usr/bin/yum" reported error code "1" when it ended:
[2022-01-18 00:54:14 +0000] [/usr/local/cpanel/scripts/rpmup] checkyum version 22.3 (excludes: bind-chroot)
[2022-01-18 00:54:14 +0000] E [/usr/local/cpanel/scripts/rpmup] The "/usr/local/cpanel/scripts/rpmup" command (process 19766) reported error number 1 when it ended.
Any idea what's up with this? -Michael
-
I just have the same issues on some server. 0 -
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 -
Exactly the same here... 0 -
Same here too. 0 -
Same problem here. Anything new info about this? 0 -
Same here! WHM's version is v100.0.5. -1 -
Unable to install and update. Same problem. 0 -
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 -
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 -
Thank you for your helo, Andrew! I am glad this is resolved. 0 -
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 you0 -
@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 - I'm glad to hear that's working well for you! 0 -
@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 -
@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 - 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 much0 -
Could you submit a ticket to our team so we can check this directly? 0 -
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 -
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 -
and is it running? 0 -
@ahmadrusli Share the output of systemctl status mysqld
0 -
and is it running?
no, it's not running. i though mysql not well installed from the beginning.0 -
@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 -
I would suggest opening a support ticket to providers to help you with your problem. 0
Please sign in to leave a comment.
Comments
34 comments