No announcement yet.

Database Connectivity Issue

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Connectivity 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.

    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
    [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/ line 956, <STDIN> line 1.
            Cpanel::Mysql::__ANON__(__CPANEL_HIDDEN__...) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/ line 118
            Try::Tiny::try(CODE(0x30c0150), Try::Tiny::Catch=REF(0x314b328)) called at /usr/local/cpanel/Cpanel/ line 957
            Cpanel::Mysql::_get_dbuser_privileges_on_db(Cpanel::Mysql=HASH(0x2ed5510), "USER") called at /usr/local/cpanel/Cpanel/ line 1379
            Cpanel::Mysql::_password_hashes(Cpanel::Mysql=HASH(0x2ed5510), ARRAY(0xd23618)) called at /usr/local/cpanel/Cpanel/ line 528
            Cpanel::Mysql::updateprivs(Cpanel::Mysql=HASH(0x2ed5510)) called at /usr/local/cpanel/Cpanel/ line 1209
            Cpanel::Mysql::dbcache(Cpanel::Mysql=HASH(0x2ed5510), "") called at bin/admin/Cpanel/ line 388
    Invalid grant string: SET DEFAULT ROLE 0 FOR 'USER'@'%'
    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.

    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
    Hope this helps other guys there who are facing the same issue.