Re: Can't connect to MySQL using SSL

I´ve the same problem...
but I use MySQL ODBC 5.1 Driver and Mysql server 5 over Windows 2003 server

I create certificates how to...
http://dev.mysql.com/doc/refman/5.0/en/secure-create-certs.html

and see the forum mysql in:
http://forums.mysql.com/read.php?35,39354,49575#msg-49575

but not work...
WHAT IS THE TIP!!!!
thanks... 
malco



Santo Leto wrote:
> 
> 
> 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.
>     
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Can%27t-connect-to-MySQL-using-SSL-tf4363968.html#a13656349
Sent from the MySQL - ODBC mailing list archive at Nabble.com.


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]