Collapse

Announcement

Collapse

test

test
See more
See less

Database Connectivity Issue

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Connectivity Issue

    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.

    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'@'%'
    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.


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