Can't create database users on (almost) fresh WHM installation

[nikolay3131]

Hello,

I tried the WHM+Cpanel and its very good, wanted to move my current website from the inferior cyberpanel to cpanel.

I did:
Create a new VM in google cloud
Deploy cPanel instance
Install litespeed plugin
Attach and mount old VM disk
Change VM IP to the one old VM used

Snip of error log:


Cpanel::Mysql::updateprivs(Cpanel::Mysql=HASH(0x3408bb8), "sp_wp_vpk7g") called at /usr/local/cpanel/Cpanel/Mysql.pm line 264
Cpanel::Mysql::create_db(Cpanel::Mysql=HASH(0x3408bb8), "sp_wp_vpk7g") called at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 139
Cpanel::Admin::Base::DB::__ANON__(Cpanel::Async::FlockFile::Handle=ARRAY(0x33ea278)) called at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 146
eval {...} called at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 146
Cpanel::Admin::Base::DB::CREATE_DATABASE(Cpanel::Admin::Modules::Cpanel::mysql=HASH(0x2b65198), "sp_wp_vpk7g") called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 731
eval {...} called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 730
Cpanel::Admin::Base::run("Cpanel::Admin::Modules::Cpanel::mysql", "username", undef, "uid", 1005, "function", "CREATE_DATABASE", "args", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 143
eval {...} called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 129
Cpanel::AdminBin::Server::Backend::run_admin_module("perl_module", "Cpanel::Admin::Modules::Cpanel::mysql", "uid", 1005, "args", ARRAY(0x2ae3490), "function", "CREATE_DATABASE", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 222
Cpanel::AdminBin::Server::_request_handler(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae34a8), undef) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 123
Cpanel::AdminBin::Server::__ANON__() called at /usr/local/cpanel/Cpanel/Try.pm line 193
eval {...} called at /usr/local/cpanel/Cpanel/Try.pm line 193
Cpanel::Try::try(CODE(0x2ae31c0), "Cpanel::Exception::ProcessNotRunning", CODE(0x2ae3238)) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 126
Cpanel::AdminBin::Server::handle_cpwrapd_request(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae2ef0)) called at /usr/local/cpanel/Cpanel/Server.pm line 2455
Cpanel::Server::handle_cpwrapd_connection(Cpanel::Server=HASH(0x28efe60)) called at cpsrvd.pl line 1883
cpanel::cpsrvd::_handle_unix_socket_connection("handle_cpwrapd_connection") called at cpsrvd.pl line 1125
cpanel::cpsrvd::script() called at cpsrvd.pl line 436
[2022-08-24 20:21:58 +0000] info [cpwrapd] Creating MySQL virtual user sp_wp_7zhpt for user sp
[2022-08-24 20:21:58 +0000] warn [cpwrapd] Error from MySQL query: (XID syj38n) The system received an error from the “MySQL” database “mysql”: 1470 (String 'cpanel-1-vm.europe-central2-a.c.superplants-sheets-api.internal' is too long for host name (should be no longer than 60)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 363.
Cpanel::Mysql::Basic::_has_error_handler(Cpanel::Mysql=HASH(0x312de08), Cpanel::Exception::Database::Error=HASH(0x3525fe0)) called at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 251
Cpanel::Mysql::Basic::sendmysql(Cpanel::Mysql=HASH(0x312de08), "CREATE USER 'sp_wp_7zhpt'\@'cpanel-1-vm.europe-central2-a.c.su"...) called at /usr/local/cpanel/Cpanel/Mysql/Passwd.pm line 159
Cpanel::Mysql::Passwd::passwduser(Cpanel::Mysql=HASH(0x312de08), __CPANEL_HIDDEN__, __CPANEL_HIDDEN__) called at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 102
Cpanel::Admin::Base::DB::CREATE_USER(Cpanel::Admin::Modules::Cpanel::mysql=HASH(0x2b65080), "sp_wp_7zhpt", "?7Z~3y3LK0l^13ya") called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 731
eval {...} called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 730
Cpanel::Admin::Base::run("Cpanel::Admin::Modules::Cpanel::mysql", "username", undef, "uid", 1005, "function", "CREATE_USER", "args", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 143
eval {...} called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 129
Cpanel::AdminBin::Server::Backend::run_admin_module("perl_module", "Cpanel::Admin::Modules::Cpanel::mysql", "uid", 1005, "args", ARRAY(0x2ae3628), "function", "CREATE_USER", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 222
Cpanel::AdminBin::Server::_request_handler(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae34a8), undef) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 123
Cpanel::AdminBin::Server::__ANON__() called at /usr/local/cpanel/Cpanel/Try.pm line 193
eval {...} called at /usr/local/cpanel/Cpanel/Try.pm line 193
Cpanel::Try::try(CODE(0x2ae31c0), "Cpanel::Exception::ProcessNotRunning", CODE(0x2ae3238)) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 126
Cpanel::AdminBin::Server::handle_cpwrapd_request(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae2ef0)) called at /usr/local/cpanel/Cpanel/Server.pm line 2455
Cpanel::Server::handle_cpwrapd_connection(Cpanel::Server=HASH(0x28efe60)) called at cpsrvd.pl line 1883
cpanel::cpsrvd::_handle_unix_socket_connection("handle_cpwrapd_connection") called at cpsrvd.pl line 1125
cpanel::cpsrvd::script() called at cpsrvd.pl line 436
[2022-08-24 20:21:58 +0000] warn [cpwrapd] GRANT statement “CREATE USER 'sp_wp_7zhpt'@'cpanel-1-vm.europe-central2-a.c.superplants-sheets-api.internal' IDENTIFIED BY '?7Z~3y3LK0l^13ya';” failed: at /usr/local/cpanel/Cpanel/Mysql/Passwd.pm line 159.
Cpanel::Mysql::Passwd::passwduser(Cpanel::Mysql=HASH(0x312de08), __CPANEL_HIDDEN__, __CPANEL_HIDDEN__) called at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 102
Cpanel::Admin::Base::DB::CREATE_USER(Cpanel::Admin::Modules::Cpanel::mysql=HASH(0x2b65080), "sp_wp_7zhpt", "?7Z~3y3LK0l^13ya") called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 731
eval {...} called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 730
Cpanel::Admin::Base::run("Cpanel::Admin::Modules::Cpanel::mysql", "username", undef, "uid", 1005, "function", "CREATE_USER", "args", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 143
eval {...} called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 129
Cpanel::AdminBin::Server::Backend::run_admin_module("perl_module", "Cpanel::Admin::Modules::Cpanel::mysql", "uid", 1005, "args", ARRAY(0x2ae3628), "function", "CREATE_USER", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 222
Cpanel::AdminBin::Server::_request_handler(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae34a8), undef) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 123
Cpanel::AdminBin::Server::__ANON__() called at /usr/local/cpanel/Cpanel/Try.pm line 193
eval {...} called at /usr/local/cpanel/Cpanel/Try.pm line 193
Cpanel::Try::try(CODE(0x2ae31c0), "Cpanel::Exception::ProcessNotRunning", CODE(0x2ae3238)) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 126
Cpanel::AdminBin::Server::handle_cpwrapd_request(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae2ef0)) called at /usr/local/cpanel/Cpanel/Server.pm line 2455
Cpanel::Server::handle_cpwrapd_connection(Cpanel::Server=HASH(0x28efe60)) called at cpsrvd.pl line 1883
cpanel::cpsrvd::_handle_unix_socket_connection("handle_cpwrapd_connection") called at cpsrvd.pl line 1125
cpanel::cpsrvd::script() called at cpsrvd.pl line 436
[2022-08-24 20:21:58 +0000] warn [cpwrapd] Error from MySQL query: (XID e5atg7) The system received an error from the “MySQL” database “mysql”: 1470 (String 'cpanel-1-vm.europe-central2-a.c.superplants-sheets-api.internal' is too long for host name (should be no longer than 60)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 363.
Cpanel::Mysql::Basic::_has_error_handler(Cpanel::Mysql=HASH(0x312de08), Cpanel::Exception::Database::Error=HASH(0x3525f80)) called at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 251
Cpanel::Mysql::Basic::sendmysql(Cpanel::Mysql=HASH(0x312de08), "GRANT USAGE ON *.* TO 'sp_wp_7zhpt'\@'localhost','sp_wp_7zhpt'"...) called at /usr/local/cpanel/Cpanel/Mysql/Passwd.pm line 159
Cpanel::Mysql::Passwd::passwduser(Cpanel::Mysql=HASH(0x312de08), __CPANEL_HIDDEN__, __CPANEL_HIDDEN__) called at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 102
Cpanel::Admin::Base::DB::CREATE_USER(Cpanel::Admin::Modules::Cpanel::mysql=HASH(0x2b65080), "sp_wp_7zhpt", "?7Z~3y3LK0l^13ya") called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 731
eval {...} called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 730
Cpanel::Admin::Base::run("Cpanel::Admin::Modules::Cpanel::mysql", "username", undef, "uid", 1005, "function", "CREATE_USER", "args", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 143
eval {...} called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 129
Cpanel::AdminBin::Server::Backend::run_admin_module("perl_module", "Cpanel::Admin::Modules::Cpanel::mysql", "uid", 1005, "args", ARRAY(0x2ae3628), "function", "CREATE_USER", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 222
Cpanel::AdminBin::Server::_request_handler(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae34a8), undef) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 123
Cpanel::AdminBin::Server::__ANON__() called at /usr/local/cpanel/Cpanel/Try.pm line 193
eval {...} called at /usr/local/cpanel/Cpanel/Try.pm line 193
Cpanel::Try::try(CODE(0x2ae31c0), "Cpanel::Exception::ProcessNotRunning", CODE(0x2ae3238)) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 126
Cpanel::AdminBin::Server::handle_cpwrapd_request(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae2ef0)) called at /usr/local/cpanel/Cpanel/Server.pm line 2455
Cpanel::Server::handle_cpwrapd_connection(Cpanel::Server=HASH(0x28efe60)) called at cpsrvd.pl line 1883
cpanel::cpsrvd::_handle_unix_socket_connection("handle_cpwrapd_connection") called at cpsrvd.pl line 1125
cpanel::cpsrvd::script() called at cpsrvd.pl line 436
[2022-08-24 20:21:58 +0000] warn [cpwrapd] GRANT statement “GRANT USAGE ON *.* TO 'sp_wp_7zhpt'@'localhost','sp_wp_7zhpt'@'cpanel-1-vm.europe-central2-a.c.superplants-sheets-api.internal','sp_wp_7zhpt'@'10.186.0.8','sp_wp_7zhpt'@'34.118.54.212';” failed: at /usr/local/cpanel/Cpanel/Mysql/Passwd.pm line 159.
Cpanel::Mysql::Passwd::passwduser(Cpanel::Mysql=HASH(0x312de08), __CPANEL_HIDDEN__, __CPANEL_HIDDEN__) called at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 102
Cpanel::Admin::Base::DB::CREATE_USER(Cpanel::Admin::Modules::Cpanel::mysql=HASH(0x2b65080), "sp_wp_7zhpt", "?7Z~3y3LK0l^13ya") called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 731
eval {...} called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 730
Cpanel::Admin::Base::run("Cpanel::Admin::Modules::Cpanel::mysql", "username", undef, "uid", 1005, "function", "CREATE_USER", "args", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 143
eval {...} called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm line 129
Cpanel::AdminBin::Server::Backend::run_admin_module("perl_module", "Cpanel::Admin::Modules::Cpanel::mysql", "uid", 1005, "args", ARRAY(0x2ae3628), "function", "CREATE_USER", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 222
Cpanel::AdminBin::Server::_request_handler(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae34a8), undef) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 123
Cpanel::AdminBin::Server::__ANON__() called at /usr/local/cpanel/Cpanel/Try.pm line 193
eval {...} called at /usr/local/cpanel/Cpanel/Try.pm line 193
Cpanel::Try::try(CODE(0x2ae31c0), "Cpanel::Exception::ProcessNotRunning", CODE(0x2ae3238)) called at /usr/local/cpanel/Cpanel/AdminBin/Server.pm line 126
Cpanel::AdminBin::Server::handle_cpwrapd_request(Cpanel::AdminBin::Server=HASH(0x2ae3070), HASH(0x2ae2ef0)) called at /usr/local/cpanel/Cpanel/Server.pm line 2455
Cpanel::Server::handle_cpwrapd_connection(Cpanel::Server=HASH(0x28efe60)) called at cpsrvd.pl line 1883
cpanel::cpsrvd::_handle_unix_socket_connection("handle_cpwrapd_connection") called at cpsrvd.pl line 1125
cpanel::cpsrvd::script() called at cpsrvd.pl line 436
[2022-08-24 20:21:58 +0000] info [cpwrapd] ERROR in Mysql query XID e5atg7) The system received an error from the “MySQL” database “mysql”: 1470 (String 'cpanel-1-vm.europe-central2-a.c.superplants-sheets-api.internal' is too long for host name (should be no longer than 60)):
Cpanel::Exception/(XID fgp98q) Error from MySQL query XID e5atg7) The system received an error from the “MySQL” database “mysql”: 1470 (String 'cpanel-1-vm.europe-central2-a.c.superplants-sheets-api.internal' is too long for host name (should be no longer than 60)):
at /usr/local/cpanel/Cpanel/Admin/Base/DB.pm line 103.
Cpanel::Admin::Base::DB::CREATE_USER(Cpanel::Admin::Modules::Cpanel::mysql=HASH(0x2b65080), "sp_wp_7zhpt", "?7Z~3y3LK0l^13ya") called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 731
eval {...} called at /usr/local/cpanel/Cpanel/Admin/Base.pm line 730
Cpanel::Admin::Base::run("Cpanel::Admin::Modules::Cpanel::mysql", "username", undef, "uid", 1005, "function", "CREATE_USER", "args", ...) called at /usr/local/cpanel/Cpanel/AdminBin/Server/Backend.pm


Help please, Thanks

 

[kodeslogic]

From the shared logs it seems like the current hostname cpanel-1-vm.europe-central2-a.c.superplants-sheets-api.internal is causing the issue. You must use a fully-qualified domain name (FQDN) that uniquely identifies the server (for example, hostname.example.com or hostname.example.co.uk

 

[cPRex]

Hey there! Can you change the server's hostname to something shorter and see if that gets things working?

Update: I see @kodeslogic posted now too!