使用Laravel通过SSL进行MySQL连接 [英] MySQL connection over SSL with Laravel
问题描述
我在Laravel应用程序中通过ssl连接到我的数据库时遇到问题.我的配置如下:
I have a problem connecting to my database over ssl in a Laravel application. My config is as follows:
'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => true,
'engine' => null,
'sslmode' => 'require',
'options' => array(
PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false,
PDO::MYSQL_ATTR_SSL_KEY => '/certs/client-key.pem',
PDO::MYSQL_ATTR_SSL_CERT => '/certs/client-cert.pem',
PDO::MYSQL_ATTR_SSL_CA => '/certs/ca.pem',
),
],
DB_CONNECTION=mysql
DB_HOST=xxx.xxx.xxx.xxx
DB_PORT=3306
DB_DATABASE=db_name
DB_USERNAME=db_user
DB_PASSWORD=xxxx
这些设置在MySQL服务器上给我以下错误.
These setting give me the following error on the MySQL server.
2018-10-30T09:18:25.403712Z 71 [Note] Access denied for user 'user'@'xxx.xxx.xxx.xxx' (using password: YES)
通过mysql-client，它可以在客户端服务器上完美运行.
Through mysql-client it works perfectly from the client server.
mysql -u user -p -h xxx.xxx.xxx.xxx --ssl-ca=/certs/ca.pem --ssl-cert=/certs/client-cert.pem --ssl-key=/certs/client-key.pem
与上述命令连接时，在客户端执行的\ s命令输出.
Output of `\s' command performed on the client while connected with the above command.
mysql Ver 15.1 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Connection id: 16
Current database: database
Current user: user@xxx.xxx.xxx.xxx
SSL: Cipher in use is DHE-RSA-AES256-SHA
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MySQL
Server version: 5.7.24-0ubuntu0.18.10.1 (Ubuntu)
Protocol version: 10
Connection: 167.99.215.179 via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8mb4
Conn. characterset: utf8mb4
TCP port: 3306
Uptime: 23 min 29 sec
Threads: 2 Questions: 38 Slow queries: 0 Opens: 135 Flush tables: 1 Open tables: 128 Queries per second avg: 0.026
--------------
应用程序基于php:7.2.11-fpm映像在docker容器中运行.并配置了以下php扩展名.
The application runs inside a docker container based on the php:7.2.11-fpm image. And is configured with the following php extensions.
RUN docker-php-ext-install bcmath zip pdo_mysql json tokenizer
MySQL版本:
Server version: 5.7.24-0ubuntu0.18.10.1 (Ubuntu)
PHP版本:
PHP 7.2.11 (cli) (built: Oct 16 2018 00:46:29) ( NTS )
PDO版本:
PDO
PDO support => enabled
PDO drivers => sqlite, mysql
pdo_mysql
PDO Driver for MySQL => enabled
Client API version => mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387
OpenSSL版本:
OpenSSL version:
openssl
OpenSSL support => enabled
OpenSSL Library Version => OpenSSL 1.1.0f 25 May 2017
OpenSSL Header Version => OpenSSL 1.1.0f 25 May 2017
Openssl default config => /usr/lib/ssl/openssl.cnf
Directive => Local Value => Master Value
openssl.cafile => no value => no value
openssl.capath => no value => no value
对此有何想法?这让我忙了几个小时...
Any thoughts on this? This is keeping me busy for hours...
推荐答案
我终于解决了这个问题.上面的配置实际上很好.我直接在Docker容器中工作.由于某种原因，配置保留在缓存中.
I finally solved the issue. The config above is actually good. I was working in the docker container directly. For some reason the config kept in cache.
以下命令没有清除配置缓存:
Following commands did not clear the config cache:
php artisan config:clear
php artisan config:cache
php artisan cache:clear
当我创建一个新用户以连接数据库以测试某些东西时，我注意到了这一点.我用新的配置重建了容器，现在一切正常.
I noticed this when I created a new user to connect with the database to test something. I rebuild the container with the new config and everything works perfectly now.
这篇关于使用Laravel通过SSL进行MySQL连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
