Cannot connect to Cloud SQL instance using SSL and mysql

176 views
Skip to first unread message

kj

unread,
Nov 19, 2014, 3:29:38 PM11/19/14
to google-a...@googlegroups.com
I set up SSL on the Cloud SQL instance following these instructions: https://cloud.google.com/sql/docs/instances#ssl

However when I try to connect using the command line I get this error:

ERROR 2026 (HY000): SSL connection error: ASN: bad other signature confirmation

I tried using the 5.5 and 5.6 mysql commands - I get the same error with both.

Has anyone successfully connected to their sql instance with SSL?

kj

unread,
Nov 19, 2014, 3:34:18 PM11/19/14
to google-a...@googlegroups.com
Oh I just figured it out. I had to leave off the ssl-ca param.

This fails:
mysql --ssl-ca=ca-cert.epm --ssl-cert=client-cert.pem --ssl-key=client-key.pem --host=[ip] --user=[user] --password

This works:
mysql --ssl-cert=client-cert.pem --ssl-key=client-key.pem  --host=[ip] --user=[user] --password
Reply all
Reply to author
Forward
0 new messages