Can"t connect to MySQL using SSL
am 01.09.2007 11:03:54 von Santo Leto------=_NextPart_000_0029_01C7EC87.C92F9F70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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 =3D YES).
I can connect with a ssl user using my certificates:
mysql =
--defaults-file=3D"C:\Programmi\MySQL\mysql-5.1.20-beta-win3 2\my-small-ss=
l.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 =3D "DRIVER=3D{MySQL ODBC 3.51 Driver};" _
& "SERVER=3Dlocalhost;" _
& "DATABASE=3Ddatabase1;" _
& "UID=3Dssl;" _
& "PWD=3D;" _
& "SSLCA=3DC:\OpenSSL\ca-cert.pem;" _
& "SSLCAPATH=3DC:\OpenSSL;" _
& "SSLCERT=3DC:\OpenSSL\client-cert.pem;" _
& "SSLCIPHER=3DDHE-RSA-AES256-SHA;" _
& "SSLKEY=3DC:\OpenSSL\client-key.pem;" _
& "PORT=3D5120;" _
& "OPTION=3D" & 2 + 3 + 8 + 32 + 2048 + 16384
a "SSL Connection Error" is returned.
Venu, Jim,
your help is much appreciated.
Thank you, Santo Leto.
=20
------=_NextPart_000_0029_01C7EC87.C92F9F70--