Error in the /var/log/maillog after upgrading MySQL on Plesk on Cloudlinux server: /usr/lib64/mysqlclient/libmysqlclient.so.18: no version information available

Symptoms

• After upgrading MySQL on CloudLinux to MySQL 5.7 the following message messages can be found in the maillog file:

  CONFIG_TEXT: postalias: /usr/lib64/mysql/libmysqlclient.so.18: no version information available (required by postalias)

• Executing /usr/sbin/postconf result the following error message

  # /usr/sbin/postconf
  /usr/sbin/postconf: /usr/lib64/mysql/libmysqlclient.so.18: no version information available (required by /usr/sbin/postconf)

• It is not possible to create a Service Plan in WHMCS with the error like below:

  CONFIG_TEXT: Error code: 1002. Error message: mailmng-core failed: Fatal error: plesk::mail::postfix::PostfixConfigurationError(/usr/sbin/postmap: /usr/lib64/mysql/libmysqlclient.so.18: no version information available (required by /usr/sbin/postmap) postmap: fatal: error [-30986] seeking /var/spool/postfix/plesk/certs.db: Success )

• The following command is shown tat the mysqlclient18-5.5.2 is installed

  # rpm -qf /usr/lib64/mysql/libmysqlclient.so.18.0.0
  mysqlclient18-5.5.28-6.el7.cloudlinux.x86_64

Cause

Outdated MySQL client library

Resolution

1. Connect to the server via SSH

2. Ensure that [mysqlclient] repository is enabled in
   /etc/yum.repos.d/cl-mysql.repo and the below command displays similar output:

   # yum repolist enabled | grep mysqlclient
   Repository extras is listed more than once in the configuration
   mysqclient/7/x86_64 mysqlclient 7

3. Replace outdated mysqlclient18 with mysqlclient18-compat:

   # yum remove mysqlclient18
   # yum install mysqlclient18-compat