Hi, I have the same problem as following question. Does anyone have idea to solve this problem?
http://stackoverflow.com/questions/34478265/ssl-self-signed-certifications-to-connect-with-mysql-with-php/34478690#34478690I'm using CakePHP and connecting from CentOS 6 (applied all updates via yum) on GCE.
According to the error message, Common Name of Cloud SQL certificate seems invalid.
Any solutions to fix Cloud SQL's certificate, or any workaround?
BTW I can connect using mysql client (5.1.x) from the same GCE instance
$ mysql -u dbname -p -h (Cloud SQL IPv4 address) notel --ssl-ca=/path/to/ca.pem --ssl-cert=/path/to/cert.pem --ssl-key=/path/to/key.pem
Following is full logs:
2016-02-18 19:41:44 Warning: Warning (2): PDO::__construct() [<a href='
http://php.net/pdo.construct'>pdo.construct</a>]: Peer certificate CN=`(CGP project name):(Cloud SQL instance name)' did not match expected CN=`(Cloud SQL instance IP)' in [/var/www/notel/data/lib/Cake/Mod
el/Datasource/Database/Mysql.php, line 175]
Trace:
PDO::__construct() - [internal], line ??
Mysql::connect() - CORE/Cake/Model/Datasource/Database/Mysql.php, line 175
DboSource::__construct() - CORE/Cake/Model/Datasource/DboSource.php, line 260
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 105
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3502
Model::schema() - CORE/Cake/Model/Model.php, line 1355
Model::_setAliasData() - CORE/Cake/Model/Model.php, line 1220
Model::set() - CORE/Cake/Model/Model.php, line 1183
Model::save() - CORE/Cake/Model/Model.php, line 1713
DatabaseSession::write() - CORE/Cake/Model/Datasource/Session/DatabaseSession.php, line 117
MySession::write() - CORE/Cake/Model/Datasource/Session/MySession.php, line 31
session_write_close - [internal], line ??
[main] - [internal], line ??
2016-02-18 19:41:44 Warning: Warning (2): PDO::__construct() [<a href='
http://php.net/pdo.construct'>pdo.construct</a>]: Cannot connect to MySQL by using SSL in [/var/www/notel/data/lib/Cake/Model/Datasource/Database/Mysql.php, line 175]
Trace:
PDO::__construct() - [internal], line ??
Mysql::connect() - CORE/Cake/Model/Datasource/Database/Mysql.php, line 175
DboSource::__construct() - CORE/Cake/Model/Datasource/DboSource.php, line 260
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 105
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3502
Model::schema() - CORE/Cake/Model/Model.php, line 1355
Model::_setAliasData() - CORE/Cake/Model/Model.php, line 1220
Model::set() - CORE/Cake/Model/Model.php, line 1183
Model::save() - CORE/Cake/Model/Model.php, line 1713
DatabaseSession::write() - CORE/Cake/Model/Datasource/Session/DatabaseSession.php, line 117
MySession::write() - CORE/Cake/Model/Datasource/Session/MySession.php, line 31
session_write_close - [internal], line ??
[main] - [internal], line ??
2016-02-18 19:41:44 Warning: Warning (2): PDO::__construct() [<a href='
http://php.net/pdo.construct'>pdo.construct</a>]: [2002] (trying to connect via tcp://(Cloud SQL instance IP):3306) in [/var/www/notel/data/lib/Cake/Model/Datasource/Database/M
ysql.php, line 175]
Trace:
PDO::__construct() - [internal], line ??
Mysql::connect() - CORE/Cake/Model/Datasource/Database/Mysql.php, line 175
DboSource::__construct() - CORE/Cake/Model/Datasource/DboSource.php, line 260
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 105
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3502
Model::schema() - CORE/Cake/Model/Model.php, line 1355
Model::_setAliasData() - CORE/Cake/Model/Model.php, line 1220
Model::set() - CORE/Cake/Model/Model.php, line 1183
Model::save() - CORE/Cake/Model/Model.php, line 1713
DatabaseSession::write() - CORE/Cake/Model/Datasource/Session/DatabaseSession.php, line 117
MySession::write() - CORE/Cake/Model/Datasource/Session/MySession.php, line 31
session_write_close - [internal], line ??
[main] - [internal], line ??