Hi Yves, all!
Yves Goergen wrote:
On 21.05.2006 00:16 (+0100), Yves Goergen wrote:
Hello,
I'm using MySQL Query Browser on Windows XP to connect to a remote MySQL
4.0 and 5.0 database server, both on Linux. In Query Browser, I can
check the options "Use SSL if available" but how do I know if it is
available and used? I couldn't find any SQL command to show me the
encryption status of connections. What use has an option "SSL if you
can" if I can't find out whether it actually does SSL or not... I simply
require it to do and to not connect at all if it can't.
So do I see this right that MySQL Query Browser for Windows does *not*
support SSL and keeps me confused about whether it does? I really think
this is a bug that needs to be fixed, either way. Remove that SSL button
or make it work. When I see a feature, I expect it to work. But
definitely not to not work *and* not tell me so.
It seems you are mistaken about what is needed for SSL communication.
In order to use SSL, you first need both a server and a client that
include this feature. As you are running a distributed system, server
and client on different platforms, you can easily get into the situation
that only one of them does support it.
From your description, it seems that your Query Browser can use SSL.
But on some platforms, the addition of SSL into the published binaries
was quite a recent change - around 5.0.20, AFAIR, please check the
announcement mails (or the "News" section in the manual).
So unless you built your own server binaries, it is quite likely that
your 4.0 server does not support SSL, and for 5.0 it depends on the
exact version.
To find out whether your server(s) support(s) or not, you need to check
the corresponding variables. All this is described in the manual,
section "5.9.7. Using Secure Connections":
http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html
[[...]]
HTH,
Joerg Bruehe
--
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
