Can't connect to MySQL using SSL

"Santo Leto" <[email protected]>
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <002c01c7ec77$05fa46a0$2c01a8c0@CAMERONNT055>
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
--------------
mysql  Ver 14.13 Distrib 5.1.20-beta, for Win32 (ia32)

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
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               5120
Uptime:                 22 hours 35 min 56 sec

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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.