MySQL Instance Creation Fails with MariaDB 10.0.32

Article ID: MSQL0020 An instance creation operation fails if the MySQL server has MariaDB 10.0.32 installed.

Symptom

A MySQL instance creation operation fails with the following error in the MySqlBrowseAgent.log file:

12429 308d 10/23 05:27:47 140037726736624 MySqlBrowseAgent::DoBrowse() - MySql Server : mysqlappvm1_3317, sa user: abc sock/port: /mariaDB/mariadb-10.0.32-linux-x86_64/data/mysql.sock
12429 308d 10/23 05:27:47 140037726736624 MySqlBrowseAgent::DoBrowse() - Starting here
12429 308d 10/23 05:27:47 140037726736624 GetMySqlInfoExt::sslConnect() -  Getting ssl params
12429 308d 10/23 05:27:47 140037726736624 GetMySqlInfoExt::Init() - MySqlInterface::LoadAndInitialize() failed:Malformed packet Failed to execute mysql_real_connect
12429 308d 10/23 05:27:47 140037726736624 MySqlBrowseAgent::DoBrowse() - Cannot Initialize GetMySqlInfo Object
12429 308d 10/23 05:27:47 140037726736624 Main() - DoBrowse() failed
12429 308d 10/23 05:27:47 140037726736624 MySqlBrowseAgent::~MySqlBrowseAgent() - Removing [/opt/commvault/Base/Temp/galaxy_bkp_mycnf_1508750867_1508750867.cnf]
12702 319e 10/23 05:37:01 ### skipFS::SetFSCacheEnabled(667) - FSType cache is enabled

 

Cause

The libmysqlclient.so file that is packaged with the MariaDB software is not compatible with MySQL.

Resolution

To resolve this problem, use one of the following methods:

  • If the SA user password is of the old hash method, then do the following:
    1. Set the old_password parameter to 0.
    2. Update the SA user password with the new hash method.
    3. Create the instance again.
  • To the CommServe computer, add the sLibPath additional setting as shown in the following table, and then create the instance again.

For instructions about adding additional settings from the CommCell Console, see the Adding or Modifying and Additional Setting topic in the Commvault documentation.

Additional setting Value
Name sLibPath
Category MySQL
Type STRING
Value

The absolute path of the libmysqlclient.so file

Example:

/usr/lib64/libmysqlclient.so.18