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

[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

 

[cPRex]

Could you submit a ticket to our team so we can check this directly?

 

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

Launch an AWS™ AMI™ Instance | cPanel & WHM Documentation

This document provides the steps to use the Amazon Web Services™ (AWS) cloud service and the cPanel & WHM Amazon Machine Image™ (AMI) to build a production hosting environment.

docs.cpanel.net

and success. mysql run smoothly. cpanel working very well.

so, aws is safe, but gcp installation fail.

update:
Sat Jan 29 01:11:44 WIB 2022 UTC0700

thank you very much

 

[cPRex]

I'm doing some testing on my end now, but can you confirm that you're using the details outlined here?

How to Install cPanel & WHM on Google Compute Engine™ Through The Google Marketplace | cPanel & WHM Documentation

This document explains how to install a cPanel & WHM instance on the Google Compute Engine™ service.

docs.cpanel.net

 

[cPRex]

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.

 

[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

 

[andrew.n]

and is it running?

 

[kodeslogic]

@ahmadrusli
Share the output of

systemctl status mysqld

 

[ahmadrusli]

and is it running?

no, it's not running. i though mysql not well installed from the beginning.

 

[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.

 

[kodeslogic]

I would suggest opening a support ticket to cPanel Team or contact to one of the System Administration Services providers to help you with your problem.

 

[ahmadrusli]

I would suggest opening a support ticket to cPanel Team or contact to one of the System Administration Services providers to help you with your problem.

thank you i will consider it.

 

[ahmadrusli]

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.

my apologize, is there any update the image for gcp updated?
yesterday i deploy new server but failed, mysql still not running.
i think the image not update yet.
it is been 2 days i delayed my 2 projects waiting for this fixes.

thank you very much for your help.

 

[ahmadrusli]

hi all

good news. i create a support ticket. they answer very fast. and my problem solved. cpanel give super attentions for their customers. this company and the products are worth and recommended!

for now, we can see image on gpc still not fixed.

and for temporary solution for new fresh instance on gcp (probably alibaba cloud):

1. always install with guide:

How to Install cPanel & WHM on Google Compute Engine™ Through The Google Marketplace

2. we will see the mysql not running. then run this solution based support team answers:

MySQL GPG keys expired, preventing installation/upgrade of MySQL packages from the official repository.

2.1 Run:

/scripts/autorepair mysql_gpg_key

2.2 Run:

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

2.3 Then, install MySQL :

yum install mysql-server


Now we can see MySQL run properly. and we ready to continue our work.

Thank you for all of you have been kind to help

 

[cPRex]

I'm glad our support team was able to help with that!