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

ahmadrusli

Member
Jan 24, 2022
10
1
1
Indonesia
cPanel Access Level
Root Administrator
@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?

Code:
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):
Code:
The MySQL/MariaDB server is not currently running. If this is not intentional, you may experience problems with your upgrade.
i tried:
Code:
grep mysql /var/cpanel/cpanel.config
the results:
Code:
mysql-host=localhost
mysql-version=5.7
usemysqloldpass=0
i tried to Upgrade to Latest Version, the results:
Code:
----------------------------------------------------------------------------------------------------
=> 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
 

Attachments

ahmadrusli

Member
Jan 24, 2022
10
1
1
Indonesia
cPanel Access Level
Root Administrator
Could you submit a ticket to our team so we can check this directly?
For AWS, i just create instance based official cpanel documentation:

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

Attachments

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
10,360
1,631
363
cPanel Access Level
Root Administrator

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
10,360
1,631
363
cPanel Access Level
Root Administrator
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.
 
  • Like
Reactions: ahmadrusli

ahmadrusli

Member
Jan 24, 2022
10
1
1
Indonesia
cPanel Access Level
Root Administrator
I just installed fresh. and still error (please see the attachment):

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

Attachments

kodeslogic

Well-Known Member
PartnerNOC
Apr 26, 2020
441
207
118
IN
cPanel Access Level
Root Administrator
@ahmadrusli
Share the output of

systemctl status mysqld
 

kodeslogic

Well-Known Member
PartnerNOC
Apr 26, 2020
441
207
118
IN
cPanel Access Level
Root Administrator

ahmadrusli

Member
Jan 24, 2022
10
1
1
Indonesia
cPanel Access Level
Root Administrator
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

Member
Jan 24, 2022
10
1
1
Indonesia
cPanel Access Level
Root Administrator
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 :)
 
  • Like
Reactions: andrew.n