mysql_real_connect出错,如何修复“ mysqli :: real_connect（）：SSL操作失败”错误？

Environment:

Ubuntu 14.04, PHP 5.5.9, MYSQL 5.6.30

From time to time I get an error

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

Error message:

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

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.

Sample:

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 Cipher:

It fails on this line:

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

解决方案

It is problem with mysql version 5.6.30,

I have updated to 5.6.32 and now this error is not happening anymore.