php页面打不开 | PHP | Warning | mysqli_connect(): Headers and client library minor version mismatch.

问题描述

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开始已经被移除。