User creation fail MySQL on distant database

[Timile]

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]

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]

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?

 

[cPRex]

Details on how to change the hostname can be found here:

Change Hostname | cPanel & WHM Documentation

This interface allows you to change your server's hostname.

docs.cpanel.net

If you are on a VPS server, you may need to contact your host to have them adjust the name on the parent server for you as well.

 

[Timile]

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.

 

[cPRex]

I'm glad you were able to get that working. Some of the cloud systems are a bit trickier to deal with hostname changes for sure.