User creation fail MySQL on distant database

Timile

Member
Aug 17, 2021
7
0
1
Canada
cPanel Access Level
Root Administrator
Hi,

First time posting here but I'm running out of idea right now.

I'm using WHM & cPanel on a Google Cloud instance and my database (MySQL) is on a MySQL instance on Google Cloud.

I've connected on a VPC the two server, MySQL profile successfully connected to the DB and DB creation via cPanel is perfectly working.

But, for user creation each time, on all users I'm getting this error: The request failed. (Error ID: weduup) Ask your hosting provider to research this error in cPanel & WHM’s main error log.

But in fact, when I go directly on the MySQL instance via Google Cloud, the users have been added but cPanel still indicate 0 users and do not permit to add users to database.

Can someone help me?
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,027
313
cPanel Access Level
Root Administrator
Hey there! It would be good to get the additional details from the cPanel error log at /usr/local/cpanel/logs/error_log as that would show the exact issue the machine is running into. Can you check that file to see if there are additional errors listed there?
 

Timile

Member
Aug 17, 2021
7
0
1
Canada
cPanel Access Level
Root Administrator
Hi!

I've finally found the specific error:
Cpanel::Exception/(XID 59xz2c) Error from MySQL query :(XID 4uxen7) The system received an error from the “MySQL” database “mysql”: 1470 (String 'whm-cpanel1-vm.northamerica-northeast1-a.c.no-specify.internal' is too long for host name (should be no longer than 60)):at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 102.

Look like my host name is too long but this is not my host name at all, this is the default one who've been automatically used when I've installed WHM. How do I manage that?
 

Timile

Member
Aug 17, 2021
7
0
1
Canada
cPanel Access Level
Root Administrator
For the records:
Finally found why the hostname cannot be updated. It was Google Cloud Platform fault. GCP force update the hostname for a way too long hostname causing me so much trouble. After building a brand new Compute engine with custom hostname, WHM finally accept the hostname.