MySQL ODBC + SSL with only the SSL Cipher option?
- by sdek
Does anybody know how I can have an SSL encrypted connection over MySQL ODBC without the cert options?
So I asked my web host to setup a MySQL+SSL connection so that we can access our website's database via ODBC or MySQL Query Browser (or the likes). I am able to get an encrypted connection with the standard mysql client and MySQL Query Browser, but I can't get the ODBC connection to work. Looking for a little help...
The way they set it up is a little different from the way I have read about on the interweb. The host didn't setup a cert, or at least I don't think so - I don't need to specify any cert options in my connection. I just need to specify the ssl cipher. Here is how I connect with the mysql client:
mysql -h myhost.com -u myuser --ssl-cipher=3DES -p
That works to get an encrypted connection. At least I am pretty sure it works because when I run mysql> \s I get
SSL: Cipher in use is EDH-RSA-DES-CBC3-SHA
Also, when I put EDH-RSA-DES-CBC3-SHA into the SSL Cipher field of MySQL Query Browser (without specifying any other SSL options) it connects just fine.
But then when I try to do the same thing with my MySQL ODBC 3.5.1 and 5.1 I get a generic error. Here is the error from the 5.1 Driver.
Connection Failed: [HY000] [MySQL][ODBC 5.1 Driver]SSL connection error
