MySQL Instance Creation Fails on MariaDB 10.0.32 Server

Article ID: MSQL0020 An instance creation operation fails on MariaDB 10.0.32 server.

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 Commvault software is not compatible with MariaDB server.

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 client 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