如何修复"mysqli :: real_connect():SSL操作失败"错误? [英] How to fix "mysqli::real_connect(): SSL operation failed" error?

问题描述

环境: Ubuntu 14.04 ，PHP 5.5.9 ，MYSQL 5.6.30

Environment: Ubuntu 14.04, PHP 5.5.9, MYSQL 5.6.30

我有时会收到错误

mysqli::real_connect(): SSL操作失败，代码为1.OpenSSL

mysqli::real_connect(): SSL operation failed with code 1. OpenSSL

错误消息:

错误:1408F10B:SSL例程:SSL3_GET_RECORD:版本号错误

error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number

Front/nginx在一台服务器上，而mysql在另一台服务器上.

Front/nginx is on one server and mysql is on a different server.

错误不是连续的，它是随机发生的，并且我在错误日志中找到了这些错误消息，所以我无法真正进行完全调试.

The error is not continuous, it happens randomly and I find those error messages in error log so I cannot really do full debug.

示例:

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$this->objMySqli = mysqli_init();
mysqli_options ($this->objMySqli, MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);

$this->objMySqli->ssl_set($this->SslKey, $this->SslCertificate, $this->SslCACertificate, null, null);

$link = $this->objMySqli->real_connect($this->Server, $this->Username, $this->Password, $this->Database, $this->Port);      

if (!$link) {
    throw new QMySqliDatabaseException("Unable to connect to Database", -1, null);
}

SSL密码:

此行失败:

$link = $this->objMySqli->real_connect($this->Server, $this->Username, $this->Password, $this->Database, $this->Port);

推荐答案

mysql版本5.6.30有问题， 我已经更新到5.6.32，现在不再发生此错误.

It is problem with mysql version 5.6.30, I have updated to 5.6.32 and now this error is not happening anymore.

这篇关于如何修复"mysqli :: real_connect():SSL操作失败"错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！