[google-cloud-sql-discuss] Re: Cannot connect to Cloud SQL via SSL from PHP

Today I tested this new constant on PDO configuration on PHP 7.0.18 and is working fine to me.

El jueves, 18 de febrero de 2016, 12:25:08 (UTC+1), 小川純平 escribió:

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#34478690

I'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 ??

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/cf42803a-e0ba-4855-b3c2-ff6fbb72be37%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.