解决sphinx启动报错：sql_connect: failed to load libmysqlclient (or libmariadb)

问题

在centos 7 下载shpinx 3 后，启动./bin/indexer 或 ./bin/searchd 报错：

ERROR: index 'attr_node': sql_connect: failed to load libmysqlclient (or libmariadb) (DSN=mysql://apps:***@localhost:3306/phalapi).

 

解决方案

1、尝试添加软链接

# find / -name 'libmysqlclient*'

/usr/lib64/mysql/libmysqlclient.so.18
/usr/lib64/mysql/libmysqlclient.so.18.0.0

 

# ll /usr/lib64/mysql/libmysqlclient.so.18*

# ln -s /usr/lib64/mysql/libmysqlclient.so.18.0.0 /usr/lib/libmysqlclient.so

但是发现不行。

2、尝试添加环境变量

# vim /etc/ld.so.conf

export LD_LIBRARY_PATH=/usr/lib64/mysql:$LD_LIBRARY_PATH

source后再次执行启动脚本 也不行。