not defined in file libmysqlclient.so.18 with link time reference

本文涉及的产品
云数据库 RDS MySQL Serverless,0.5-2RCU 50GB
简介: [root@master conf]<span style="color:#3333ff"># /opt/php/sbin/php-fpm</span><br><p>/opt/php/sbin/php-fpm: relocation error: /opt/php/sbin/php-fpm: symbol mysql_server_init, version libmysqlclient_
[root@master conf] # /opt/php/sbin/php-fpm

/opt/php/sbin/php-fpm: relocation error: /opt/php/sbin/php-fpm: symbol mysql_server_init, version libmysqlclient_18

 not defined in file libmysqlclient.so.18 with link time reference


记录一下,没有找到解决办法。

欢迎留言。

1、如下不行:

自己一定要删除干净。


最近编译php的时候在加入mysql编译参数的时候报错,然后我就仔细的研究了下

基本情况
系统:CentOS-6.5
数据库:之前yum安装了mysql后来卸载掉,编译安装了mysql
php:我电脑里装了两个版本的php
一个是yum安装的 php-5.4.28
另一个是编译安装的 php-5.3.28

以下是各种报错

1
2
3
4
5
[root@localhost php-5.3]# php-fpm
[09-Jun-2014 15:37:41] NOTICE: PHP message: PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysql.so' - /usr/lib64/mysql/libmysqlclient.so.18: version `libmysqlclient_16' not found (required by /usr/lib64/php/modules/mysql.so) in Unknown on line 0
[09-Jun-2014 15:37:41] NOTICE: PHP message: PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysqli.so' - /usr/lib64/mysql/libmysqlclient.so.18: version `libmysqlclient_16' not found (required by /usr/lib64/php/modules/mysqli.so) in Unknown on line 0
[09-Jun-2014 15:37:41] NOTICE: PHP message: PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_mysql.so' - /usr/lib64/mysql/libmysqlclient.so.18: version `libmysqlclient_16' not found (required by /usr/lib64/php/modules/pdo_mysql.so) in Unknown on line 0
[root@localhost php-5.3]#
1
version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference
1
/usr/lib64/mysql/libmysqlclient.so.18: version `libmysqlclient_16' not found (required by /usr/lib64/php/modules/mysql.so) in Unknown on line 0

错误分析
是64位系统中 libmysqlclient 默认安装到了 /usr/lib64/mysql/ 目录下
如果此目录没有加入到 /etc/ld.so.conf里面,Linux就无法自动加载 /usr/lib64/mysql/ 里面的库文件
php编译时要去 /usr/lib64 和 /etc/ld.so.conf 所指定的目录下查找,却找不到 libmysqlclient 文件

解决方法一

1
ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18(mysql是编译安装的使用此行) ln -s /usr/lib64/mysql/libmysqlclient.so.18 /usr/lib64/libmysqlclient.so.18 (myslq非编译安装的使用此行)

解决方法二: 也可以把mysql库加入/etc/ld.so.conf.d里面

备注:
我两个php用的libmysqlclient版本不一样,我要经常切换
一个用 libmysqlclient.so.18.0.0
另一个 libmysqlclient.so.18.1.0



相关实践学习
基于CentOS快速搭建LAMP环境
本教程介绍如何搭建LAMP环境,其中LAMP分别代表Linux、Apache、MySQL和PHP。
全面了解阿里云能为你做什么
阿里云在全球各地部署高效节能的绿色数据中心,利用清洁计算为万物互联的新世界提供源源不断的能源动力,目前开服的区域包括中国(华北、华东、华南、香港)、新加坡、美国(美东、美西)、欧洲、中东、澳大利亚、日本。目前阿里云的产品涵盖弹性计算、数据库、存储与CDN、分析与搜索、云通信、网络、管理与监控、应用服务、互联网中间件、移动服务、视频服务等。通过本课程,来了解阿里云能够为你的业务带来哪些帮助 &nbsp; &nbsp; 相关的阿里云产品:云服务器ECS 云服务器 ECS(Elastic Compute Service)是一种弹性可伸缩的计算服务,助您降低 IT 成本,提升运维效率,使您更专注于核心业务创新。产品详情: https://www.aliyun.com/product/ecs
目录
相关文章
|
Ubuntu Unix Linux
成功解决ERROR: Unable to find the development tool `cc` in your path; please make sure that you have the
成功解决ERROR: Unable to find the development tool `cc` in your path; please make sure that you have the
成功解决ERROR: Unable to find the development tool `cc` in your path; please make sure that you have the
|
5月前
gdalinfo: error while loading shared libraries: libgdal.so.30: cannot open shared object file: No su
gdalinfo: error while loading shared libraries: libgdal.so.30: cannot open shared object file: No su
|
10月前
|
关系型数据库 MySQL Linux
error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or
error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or
symbol lookup error: /home/quantum6/build_libs/lib/libreadline.so.7: undefined symbol: UP
symbol lookup error: /home/quantum6/build_libs/lib/libreadline.so.7: undefined symbol: UP
97 0
error while loading shared libraries: xxx.so.0:cannot open shared object file: No such file or
error while loading shared libraries: xxx.so.0:cannot open shared object file: No such file or
87 0