Can't connect to MySQL using SSL

Hello List.

I've the same problem described in http://forums.mysql.com/read.php?37,169713,169713#msg-169713

Indeed, I've a running MySQL Server on Windows with SSL support (i.e. HAVE_OPENSSL = YES). I can connect with a ssl user using my certificates:

mysql --defaults-file="C:\Programmi\MySQL\mysql-5.1.20-beta-win32\my-small-ssl.ini" -P 5120 -ussl -p Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 39
Server version: 5.1.20-beta-community-nt-debug-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> \s

Connection id: 39
Current database:

Current user:           ssl@localhost
SSL:                    Cipher in use is DHE-RSA-AES256-SHA
Using delimiter:        ;
Server version:         5.1.20-beta-community-nt-debug-log MySQL Community Serve
r (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1

TCP port:               5120
Uptime:                 22 hours 35 min 56 sec

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Threads: 1 Questions: 224 Slow queries: 0 Opens: 101 Flush tables: 1 Open t ables: 1 Queries per second avg: 0.2

Also, I can connect using the API:

mysql_ssl_set
mysql_real_connect

The problem is when I try to connect using MyODBC 3.51.19 with the same parameters used with API and command line connections.

If I use the MyODBC GUI setup dialog:

SSL KEY:                                  C:\OpenSSL\client-key.pem
SSL CERTIFICATE:                    C:\OpenSSL\client-cert.pem
SSL CERTIFICATE AUTHORITY: C:\OpenSSL\ca-cert.pem
SSL CA PATH:                          C:\OpenSSL\
SSL CIPHER:                            DHE-RSA-AES256-SHA

the ODBC Manager gives me the following error:

Request returned with SQL_ERROR

Also, if I try to connect with ADO:

ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _

                 & "SERVER=localhost;" _
                 & "DATABASE=database1;" _
                 & "UID=ssl;" _
                 & "PWD=;" _
                 & "SSLCA=C:\OpenSSL\ca-cert.pem;" _
                 & "SSLCAPATH=C:\OpenSSL;" _
                 & "SSLCERT=C:\OpenSSL\client-cert.pem;" _
                 & "SSLCIPHER=DHE-RSA-AES256-SHA;" _
                 & "SSLKEY=C:\OpenSSL\client-key.pem;" _
                 & "PORT=5120;" _
                 & "OPTION=" & 2 + 3 + 8 + 32 + 2048 + 16384



a "SSL Connection Error" is returned.

Venu, Jim,
your help is much appreciated.

Thank you, Santo Leto.
    

Do you need more help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek