问题描述
centos 7.6系统。www/html里页面打不开。
- 查看httpd和mariadb状态,都是active
systemctl status httpd
systemctl status mariadb
但是状态一览,有异常
- mariadb
Status: "Taking your SQL requests now..."
- httpd
Status: "Total requests: 1; Current requests/sec: 0; Current traffic: 0 B/sec"
- 查看httpd的错误日志文件
cd /var/log/httpd
tail error_log
- 报错,主要 Headers and client library minor version mismatch
[Tue Jun 23 13:57:03.584917 2020] [:error] [pid 26888] [client 111.22.178.34:42143] PHP Warning: mysqli_connect(): Headers and client library minor version mismatch. Headers:50564 Library:100144 in /var/www/html/ocsreports/require/function_commun.php on line 161, referer: http://175.24.84.82/ocsreports/index.php?function=admin_info
解决方法
- 查看php client版本,版本不一致
php -i|grep Client
IMAP c-Client Version => 2007f
Client API version => 10.1.44-MariaDB
Client API library version => 10.1.44-MariaDB
Client API header version => 5.5.64-MariaDB
Client API version => 10.1.44-MariaDB
Soap Client => enabled
- 删除php-mysql,安装php-mysqlnd
yum remove php-mysql
yum install php-mysqlnd
- 重启服务
systemctl restart httpd
systemctl restart mysqld
- 再次查看,此时版本一致
php -i|grep Client
IMAP c-Client Version => 2007f
Client API version => mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
Client API library version => mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
Client API version => mysqlnd 5.0.10 - 20111026 - $Id: e707c415db32080b3752b232487a435ee0372157 $
Soap Client => enabled
推荐使用php-mysqlnd。而不是php-mysql,php-mysql从PHP5起已经被废弃,并别从PHP7开始已经被移除。