jeudi 23 juin 2016

Unable to connect to Google SQL over SSL

I created a fresh instance of google sql with mysql 5.7. I also had to create a client certificate as well as reset the root password to something known and secure.

If I disable "Only allow secure connections" and I log in from the cli then I can connect with the password.

mysql -uroot -p -h x.x.x.x

But, i like secure connections. So connecting via ssl (enabling ssl connections and using the downloaded certs) is unable to connect.

mysql -uroot -h x.x.x.x --ssl-ca=server-ca.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem

with this error

mysql: [ERROR] SSL error: Unable to get certificate from 'client-cert.pem' ERROR 2026 (HY000): SSL connection error: Unable to get certificate

If I try and connect via ssl in mysql administrator, I get this error:

no sql for you

The certs were created by the google console and am trying to connect how the example command tells me to connect. So I cannot for the life of me figure out why I cannot connect.

Aucun commentaire:

Enregistrer un commentaire