我正在尝试设置mysqlnd_ms,以便它实现在从数据库上读取和在主数据库上写入的目的。但是,当httpd重新启动时,我会收到这个错误。
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysqlnd_ms.so' - /usr/lib64/php/modules/mysqlnd_ms.so: undefined symbol: mysqlnd_global_stats in Unknown on line 0
我正在运行一个AmazonEC2x64 AMI实例,并在一个新实例上运行了以下命令:
sudo yum update
sudo yum install -y gcc make gcc-c++
sudo yum install -y httpd24 php54
sudo yum install -y php54-devel php54-mysqlnd php54-mbstring
sudo pecl install mysqlnd_ms
php -m | grep mysql
我的php.ini包含以下添加:
mysqlnd_ms.enable=1
mysqlnd_ms.force_config_usage=1
mysqlnd_ms.config_file=/etc/mysqlnd_ms.ini
extension=mysqlnd_ms.so
mysqlnd_ms.ini文件包含以下内容:
{
"appname": {
"master": {
"master_0": {
"host": "1.2.3.4",
"db": "dbname",
"user": "dbuser",
"password": "dbpswd",
"socket" : "'/var'/lib'/mysql'/mysql.sock"
}
},
"slave": {
"slave_0": {
"host": "12.22.32.42",
"db": "dbname",
"user": "dbuser",
"password": "dbpswd",
"socket" : "'/var'/lib'/mysql'/mysql.sock"
}
}
}
}
要连接,我需要:
$mysqli = new mysqli("appname", "dbuser", "dbpswd", "schema");
执行以上操作会引发以下错误:
ERROR: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
Mysqli、mysql和pdo都在服务器上启用。
如果我们直接将其更改为主机名,它会起作用:
$mysqli = new mysqli("1.2.3.4", "dbuser", "dbpswd", "schema");
如何使mysqlnd_ms正常工作?
问题解决了
要解决此问题:
- 拆除线路:
mysqlnd_ms.enable=1
mysqlnd_ms.force_config_usage=1
mysqlnd_ms.config_file=/etc/mysqlnd_ms_cfg.ini
extension=mysqlnd_ms.so
从php.ini文件
-
创建一个名为"/etc/php.d/mysqlnd_ms.ini"的新文件,并将这些行放在中
-
重新加载httpd