dongshi2588 2018-08-09 15:18
浏览 76

MariaDB和PHP的SSL错误

I got a problem. I am trying to create an SSL connection between my MariaDB database and my PHP code. At the moment of making the connection it works well to a certain extent, since in the PHP errors I start to get the following error: MySQL Server has gone away and the number of failed attempts and connection abortions increase drastically.

This is my code:

$this->connection = mysqli_init();

mysqli_options($this->connection, MYSQLI_OPT_SSL_VERIFY_SERVER_CERT, true);

$this->connection->ssl_set('/xxx/xxx/client-key.pem', '/xxx/xx/client-cert.pem', '/xx/xxx/ca-cert.pem', NULL, NULL);

if (!$this->connection->real_connect($this->host, $this->user_db, $this->password_db, $this->database, 3306, NULL, MYSQLI_CLIENT_SSL)) {
    $this->error_connect = $this->connection->connect_error;
    return false;
} else {
    $this->setCharset();
    return true;
}

What could be wrong with the server or my code?

  • 写回答

0条回答

    报告相同问题?

    悬赏问题

    • ¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
    • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
    • ¥15 绘制多分类任务的roc曲线时只画出了一类的roc,其它的auc显示为nan
    • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
    • ¥20 腾讯企业邮箱邮件可以恢复么
    • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
    • ¥15 错误 LNK2001 无法解析的外部符号
    • ¥50 安装pyaudiokits失败
    • ¥15 计组这些题应该咋做呀
    • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?