Tweet
Hi,
Today, there has been an issue discovered on the latest update of the cPanel where a minor release of MariaDB was updated to the system causing issue with the database connection to many applications. Our team has found below error in the cPanel logs.
The immediate fix for this issue would be downgrade the MariaDB built to last available minor release i.e., downgrade MariaDB version 10.3.26 to 10.3.25.
Hope this helps other guys there who are facing the same issue.
Today, there has been an issue discovered on the latest update of the cPanel where a minor release of MariaDB was updated to the system causing issue with the database connection to many applications. Our team has found below error in the cPanel logs.
Code:
Nov 04 05:08:46 Updated: MariaDB-compat-10.3.26-1.el7.centos.x86_64 Nov 04 05:08:46 Updated: MariaDB-common-10.3.26-1.el7.centos.x86_64 Nov 04 05:09:27 Updated: MariaDB-client-10.3.26-1.el7.centos.x86_64 Nov 04 05:09:43 Updated: MariaDB-server-10.3.26-1.el7.centos.x86_64 Nov 04 05:09:50 Updated: MariaDB-devel-10.3.26-1.el7.centos.x86_64 Nov 04 05:10:19 Updated: MariaDB-shared-10.3.26-1.el7.centos.x86_64
Code:
[2020-11-04 10:50:57 +0100] warn [cpmysql] Error (Invalid grant string: SET DEFAULT ROLE 0 FOR 'USER'@'localhost'
) while parsing grant: SET DEFAULT ROLE 0 FOR 'USER'@'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 956, <STDIN> line 1.
Cpanel::Mysql::__ANON__(__CPANEL_HIDDEN__...) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 118
Try::Tiny::try(CODE(0x30c0150), Try::Tiny::Catch=REF(0x314b328)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 957
Cpanel::Mysql::_get_dbuser_privileges_on_db(Cpanel::Mysql=HASH(0x2ed5510), "USER") called at /usr/local/cpanel/Cpanel/Mysql.pm line 1379
Cpanel::Mysql::_password_hashes(Cpanel::Mysql=HASH(0x2ed5510), ARRAY(0xd23618)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 528
Cpanel::Mysql::updateprivs(Cpanel::Mysql=HASH(0x2ed5510)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 1209
Cpanel::Mysql::dbcache(Cpanel::Mysql=HASH(0x2ed5510), "") called at bin/admin/Cpanel/cpmysql.pl line 388
Invalid grant string: SET DEFAULT ROLE 0 FOR 'USER'@'%'
Code:
Nov 04 11:06:03 Installed: MariaDB-common-10.3.25-1.el7.centos.x86_64 Nov 04 11:06:04 Installed: MariaDB-compat-10.3.25-1.el7.centos.x86_64 Nov 04 11:06:33 Installed: MariaDB-client-10.3.25-1.el7.centos.x86_64 Nov 04 11:06:40 Installed: MariaDB-server-10.3.25-1.el7.centos.x86_64 Nov 04 11:06:41 Installed: MariaDB-devel-10.3.25-1.el7.centos.x86_64 Nov 04 11:07:09 Installed: MariaDB-shared-10.3.25-1.el7.centos.x86_64