[Altec]

Yes, I'm able to connect from the shell prompt on the Linux server.

To verify that mysql ssl is working locally on the server, I:

1. used GRANT to REQUIRE SSL for a user

2. tried to connect locally using 'mysql –skip-ssl' (and got access denied, as expected)

3. tried to connect locally using 'mysql –ssl' (and got the mysql prompt, as expected)

But when I try to connect with SSL using SQLyog, the program freezes and never returns.

I was able to connect to a user that does *not* REQUIRE SSL using SQLyog so I think the problem is with SQLyog support for SSL.

I'm using port 1140 for mysql in case that matters.

[Altec]

I have the exact same problem.

Server:

Linux (Redhat AS3)

MySQL 4.0.20 (compiled with “–with-openssl” and “–with-vio”)

OpenSSL 0.9.7a

Client:

Windows 2000sp4

SQLYog 3.7 trial

NOTE: we're using a custom port number (not 3306)

Connecting without SSL works fine. But connecting with SSL causes SQLYog to freeze (have to end task to close SQLYog).

Problem occurs both with and without “use compression” option.

SSL is a “must-have” feature for us so we can't use SQLyog without it.

[Author]

Posts