我想通过MySQLI函数与远程MySQL数据库连接。连接还需要SSL证书才能在此处访问。所以我的代码看起来像这样:
$db = array(
"host" => "host",
"user" => "user",
"password" => "password",
"dbName" => "dbName"
);
ini_set ('error_reporting', E_ALL);
ini_set ('display_errors', '1');
error_reporting (E_ALL|E_STRICT);
$connection = mysqli_init();
mysqli_options ($connection, MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);
$connection->ssl_set('/usr/local/certs/client-key.pem',
'/usr/local/certs/client-cert.pem', '/usr/local/certs/server-ca.pem', NULL, NULL);
$link = mysqli_real_connect ($connection, $db['host'],
$db['user'], $db['password'], $db['dbName'], 3306, NULL, MYSQLI_CLIENT_SSL);
if (!$link)
{
die ('Connect error (' . mysqli_connect_errno() . '): '
. mysqli_connect_error() . "n");
}
else
{
$response = $connection->query('SHOW TABLES;');
$this->output->writeln($response);
$connection->close();
}
然后我得到此错误:
PHP Warning: mysqli_real_connect(): Peer certificate CN=`[project
name]' did not match expected CN=`[IP address]`
我几天都在为这个错误而苦苦挣扎。我也100%确定我的证书和路径是正确的。如何修复并建立连接?
在我的情况下,我必须将MySQLI_OPT_SSL_VERIFY_SERVER_CERT设置为 false ,然后才能工作。
尝试以下内容:
mysqli_options ($connection, MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, false);
希望它有效,也有利于后来的读者。