Server Upgraded to 8.3. cPanel can't connect.
Hello,
We upgraded our server (GoDaddy hosted) and during the process it seems to have upgraded MySQL to 8.3. When I try to use cPanel, it's basically not able to see/connect to MySQL at all.
I have verified through the terminal on WHM that MySQL is running and the version is 8.3. It shows my database and users.
OS: AlmaLinux v8.9.0
cPanel Version: 116.0.11
PHP Version:
Symptoms on cPanel:
-When I try to access phpMyAdmin it just goes in a reconnect loop.
-When I access MySQL Databases: "The MySQL server is currently offline." and adminbin Cpanel/cpmysql/DBCACHE: exit 255"
-Remote MySQL: "Error: adminbin Cpanel/cpmysql/LISTHOSTS: exit 255"
Symptoms on WHM:
-Edit SQL Configuration: "A fatal error or timeout occurred while processing this directive."
(XID db7562) The system failed to load the module “Cpanel::Database::MySQL::MySQL83” because of an error: Can't locate Cpanel/Database/MySQL/MySQL83.pm in @INC (you may need to install the Cpanel::Database::MySQL::MySQL83 module) (@INC contains: /usr/local/cpanel /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux /usr/local/cpanel/3rdparty/perl/536/cpanel-lib /usr/local/cpanel/3rdparty/perl/536/lib/x86_64-linux /usr/local/cpanel/3rdparty/perl/536/lib /opt/cpanel/perl5/536/site_lib/x86_64-linux /opt/cpanel/perl5/536/site_lib) at (eval 71) line 1.
BEGIN failed--compilation aborted at (eval 71) line 1.
at /usr/local/cpanel/Cpanel/LoadModule.pm line 77.
Cpanel::LoadModule::load_perl_module("Cpanel::Database::MySQL::MySQL83") called at /usr/local/cpanel/Cpanel/Database.pm line 37
Cpanel::Database::__ANON__() called at /usr/local/cpanel/Cpanel/Database.pm line 40
Cpanel::Database::new("Cpanel::Database") called at /usr/local/cpanel/Cpanel/MysqlUtils/MyCnf/SQLConfig.pm line 69
Cpanel::MysqlUtils::MyCnf::SQLConfig::__ANON__() called at /usr/local/cpanel/Cpanel/MysqlUtils/MyCnf/SQLConfig.pm line 560
Cpanel::MysqlUtils::MyCnf::SQLConfig::get_settings("mysql", 8.3) called at whostmgr/bin/whostmgr7.pl line 1572
main::wh_sql_config("wh-sql-config") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 364
Whostmgr::Dispatch::_do_call("wh-sql-config", HASH(0x21272a8), HASH(0x2127668)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 176
Whostmgr::Dispatch::dispatch("wh-sql-config", 1, ARRAY(0x21274a0)) called at whostmgr/bin/whostmgr7.pl line 247
-Manage MySQL Profiles: Validate is checked but if I try to activate:
Activation failed for “localhost” during step “Validating profile” because of an error: (XID jfaj2g) Unable to connect to the MySQL host “localhost”. Connection failed with error: Access denied for user 'root'@'localhost' (using password: YES)
-Tweak Settings:
undef error - Cpanel::Exception::ModuleLoadError/(XID chmz93) The system failed to load the module “Cpanel::Database::MySQL::MySQL83” because of an error: Can't locate Cpanel/Database/MySQL/MySQL83.pm in @INC (you may need to install the Cpanel::Database::MySQL::MySQL83 module) (@INC contains: /usr/local/cpanel /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux /usr/local/cpanel/3rdparty/perl/536/cpanel-lib /usr/local/cpanel/3rdparty/perl/536/lib/x86_64-linux /usr/local/cpanel/3rdparty/perl/536/lib /opt/cpanel/perl5/536/site_lib/x86_64-linux /opt/cpanel/perl5/536/site_lib) at (eval 18) line 1. BEGIN failed--compilation aborted at (eval 18) line 1. at /usr/local/cpanel/Cpanel/LoadModule.pm line 77. Cpanel::LoadModule::load_perl_module("Cpanel::Database::MySQL::MySQL83") called at /usr/local/cpanel/Cpanel/Database.pm line 37 Cpanel::Database::__ANON__() called at /usr/local/cpanel/Cpanel/Database.pm line 40 Cpanel::Database::new("Cpanel::Database") called at /usr/local/cpanel/Cpanel/DB/Prefix.pm line 36 Cpanel::DB::Prefix::get_prefix_length() called at /usr/local/cpanel/Whostmgr/TweakSettings/Main.pm line 2529 Whostmgr::TweakSettings::Main::__ANON__() called at (eval 8) line 67 eval {...} called at (eval 8) line 67 eval {...} called at (eval 8) line 61 eval {...} called at (eval 8) line 61 eval {...} called at (eval 8) line 1 Cpanel::Template::Shared::__ANON__(Template::Context=HASH(0x37fa7c8)) called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Document.pm line 165 eval {...} called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Document.pm line 163 Template::Document::process(Template::Document=HASH(0x38d88c8), Template::Context=HASH(0x37fa7c8)) called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Context.pm line 352 eval {...} called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Context.pm line 322 Template::Context::process(Template::Context=HASH(0x37fa7c8), "_gentweakpage.tmpl", undef, "localize me!") called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Context.pm line 410 Template::Context::include(Template::Context=HASH(0x37fa7c8), "_gentweakpage.tmpl") called at (eval 7) line 10 eval {...} called at (eval 7) line 1 Cpanel::Template::Shared::__ANON__(Template::Context=HASH(0x37fa7c8)) called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Document.pm line 165 eval {...} called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Document.pm line 163 Template::Document::process(Template::Document=HASH(0x3817f08), Template::Context=HASH(0x37fa7c8)) called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Context.pm line 352 eval {...} called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Context.pm line 322 Template::Context::process(Template::Context=HASH(0x37fa7c8), Template::Document=HASH(0x3817f08)) called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Service.pm line 94 eval {...} called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template/Service.pm line 91 Template::Service::process(Template::Service=HASH(0x37f8e60), "tweaksettings.tmpl", HASH(0x37f8230)) called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/Template.pm line 66 Template::process(Template=HASH(0x37f8ab8), "tweaksettings.tmpl", HASH(0x37f8230)) called at /usr/local/cpanel/Cpanel/Template.pm line 473 Cpanel::Template::process_template("whostmgr", HASH(0x37f8230), HASH(0x37f84a0)) called at whostmgr/bin/whostmgr2.pl line 4135 main::tweaksettings("tweaksettings") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 364 Whostmgr::Dispatch::_do_call("tweaksettings", HASH(0x3455a18), HASH(0x343d598)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 176 Whostmgr::Dispatch::dispatch("tweaksettings", 1, ARRAY(0x343c698)) called at whostmgr/bin/whostmgr2.pl line 938
I have looked everyone and I definitely do not have a MySQL83.pm file but I have one named MySQL.pm. I have tried changing the password for the root user as well.
-
Hey there! Can you let me know what update you performed on the machine? cPanel doesn't yet provide support for MySQL 8.3, so it would be helpful to know what work was performed.
Can you post the output of the following command so we can see that?
rpm -qa | grep -i mysql-community
0 -
I am not sure what updates were officially done or if, when the server migrated, it was even functional as I forgot to check that issue. Our WP site is pulling the info from the database on the search but we use a WP plugin called WP-All Import and it can't even change the data.
The output is:
mysql-community-client-plugins-8.3.0-1.el8.x86_64
mysql-community-icu-data-files-8.3.0-1.el8.x86_64
mysql-community-libs-8.3.0-1.el8.x86_64
mysql-community-server-8.3.0-1.el8.x86_64
mysql-community-common-8.3.0-1.el8.x86_64
mysql-community-client-8.3.0-1.el8.x86_64
mysql-community-devel-8.3.0-1.el8.x86_64I didn't see the forum rules and FAQ earlier so here is the additional info I was supposed to post previously.
cpanel_and_whm: 11.116.0.11
operating_system_name: almalinux
operating_system_version: 80 -
Thanks for the additional details. Unfortunately I don't have any good news on this one for you, as it's not possible for a server to get into this state using cPanel tools. MySQL would have been manually upgraded beyond what cPanel supports, which is why you're seeing these errors in the interface.
At this point it would be best to work with your hosting provider or a system administrator to see if you could create a backup of the existing databases, manually downgrade MySQL to a supported version (8.0), and then restore the databases.
0
Please sign in to leave a comment.
Comments
3 comments