Issue libmysqlclient.so.18: no version information available

[MicheleB]

Every Monday morning I get this error message by email:

Cron <root@mydomain> /usr/local/psa/libexec/modules/watchdog/cp/send-report weekly

/usr/sbin/sendmail: /usr/lib64/mysql/libmysqlclient.so.18: no version information available (required by /usr/sbin/sendmail)
/usr/lib64/plesk-9.0/sendmail/postdrop: /usr/lib64/mysql/libmysqlclient.so.18: no version information available (required by /usr/lib64/plesk-9.0/sendmail/postdrop)

How can I fix it?

 

[sebgonzes]

Do you have mysql-devel package installed?

 

[MicheleB]

Apparently not, I've tried to search with "Plesk Components" but I can't find "mysql-devel".


Do I need to install it?

 

[sebgonzes]

Try to install it and review if your problem is solved

 

[sbotto]

Hi! I'm having the exact same issue, but mysql-devel is installed:

Package cl-MySQL-meta-devel-5.7.33-1.el7.cloudlinux.x86_64 already installed and latest version

I'm running CloudLinux 7.9, with kernel 4.18.0-147.8.1.el7h.lve.1.x86_64.

I hope someone could point me in the right direction!

 

[IgorG]

First, check that the versions of MySQL and /usr/lib64/mysql/libmysqlclient.so.18 match. For example:

# plesk db "select version();"
+----------------+
| version()      |
+----------------+
| 5.7.29-cll-lve |
+----------------+

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

As you can see there is an outdated MySQL client library. You have to update it.

Open the /etc/yum.repos.d/cl-mysql.repo file.

Under [mysqclient] section change the line from

enabled=0

To

enabled=1

Verify that repository for [mysqclient] is enabled:

# yum repolist enabled | grep mysqlclient
mysqclient/7/x86_64            mysqlclient                                     7

Remove the mysqlclient18 package:

# yum remove mysqlclient18

Install the mysqlclient18-compat package:

# yum install mysqlclient18-compat

 

[sbotto]

Great, that did the trick! Thank you so much!

 

[sbotto]

Hi! Even though this removed the warning and stopped it from being sent after every cron run, it ended up breaking postfix. The following error was cleared only after I rolled back the steps suggested by IgorG:

postfix: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory

This was a severe error that prevented postfix from starting, leaving the mail service unusable, while what I was trying to fix didn't cause any perceivable issue.

Be warned of this before proceeding with the suggested fix.