MySQL and SSL connection

david_labbe · Post by **david_labbe** » Wed 22 Mar 2006 19:59

JonKerry wrote:Hi David,

The version i am using is the most uptodate i can found and came with the win32 version of the mysql server. It is version 5.0.18 and the dll is about 1.34mb

Where did you get your dll from?

Many Thanks

Jon

Hi Jon,

if your dll is up to date, you might want to check if you haven't got another on your system that might be in the global path. I found that when that is the case, there is sometimes a bit of a confusion as to which one is actually used. Check /Windows/System32 and see if you haven't got an older libmysql.dll file. If so replace it. If not, there are various places where you can find it. For example, most WAMP (Windows+Apache+MySQL+Php) packages will have the required dll provided they were build for MySQL 5.0. I found Apache2Triad (http://http://apache2triad.net/ ) to be very good. I am sure you could find a download version that does not require you to install the package but lets you pick up the file.

With regards to the SSL connection with MySQL and the MyDAC VCL, I still cannot use it. If you find a way, please let me know.

Good luck.
________
Swed

JonKerry · Post by **JonKerry** » Wed 22 Mar 2006 23:24

I am now getting the same pas error that you where getting!!!

I am sure that myDAC is communicating with the server because the ssl accepts is increasing but it seems like a problem in the code of MyDAC that stops the connection.

How did you solve this?

Many Thanks

Jon

david_labbe · Post by **david_labbe** » Thu 23 Mar 2006 08:32

JonKerry wrote:I am now getting the same pas error that you where getting!!!

I am sure that myDAC is communicating with the server because the ssl accepts is increasing but it seems like a problem in the code of MyDAC that stops the connection.

How did you solve this?

Many Thanks

Jon

I still haven't managed to get it to work...
________
Oxygen Vaporizer

JonKerry · Post by **JonKerry** » Thu 23 Mar 2006 09:32

I have now sort of got it to work..however...

If you have the user on mysql with REQUIRE SSL within their permissions it is explicitly wanting an SSL connection, and for some reason myDAC will not connect.

I therefore started to look at the data stream on the port and noticed that when the option mpSSL was selected the data was not encrypted. I first thought that this was possibly somethig to do with my certs but i have tested them with Navicat and all works perfectly.

It would appear that myDAC doesn't actually encrypt, or if it does i have misconfigured it. It does compress for a standard MySQL user which looks similar to SSL in the data stream but is nowhere near as secure

I am now slightly in limbo as to what to do next, the server works and is wanting SSL, but myDAC just aint clicking!!!

david_labbe · Post by **david_labbe** » Thu 23 Mar 2006 14:06

JonKerry wrote:I have now sort of got it to work..however...

If you have the user on mysql with REQUIRE SSL within their permissions it is explicitly wanting an SSL connection, and for some reason myDAC will not connect.

I therefore started to look at the data stream on the port and noticed that when the option mpSSL was selected the data was not encrypted. I first thought that this was possibly somethig to do with my certs but i have tested them with Navicat and all works perfectly.

It would appear that myDAC doesn't actually encrypt, or if it does i have misconfigured it. It does compress for a standard MySQL user which looks similar to SSL in the data stream but is nowhere near as secure

I am now slightly in limbo as to what to do next, the server works and is wanting SSL, but myDAC just aint clicking!!!

same here. I also got the ssl to work with other client apps to test my certs and keys and got it to work fine. As far as MyDAC is concerned, I have the same issue as you. It just does not work when the user permission on MySQL is set with any forms of ssl (require ssl, or X509 ...

I also don't know any more what to do. I spent almost 2 weeks trying to understand what was going on and decided that I would look into it a bit later. The amount of frustration I had with that issue led me to look into somethig else for a while... just so that I could get a little bit of success with something... to compensate... lol.

I hope that corelab is going to look into it. I started a post ages ago about this and I still haven't gone anywhere. The delay in response is too long and I almost wonder if there is an interest in solving this issue. We seem to be the only one in the world using myDAC and ssl connection!!!
________
HONDA XL75

JonKerry · Post by **JonKerry** » Thu 23 Mar 2006 14:25

This may sound strange but I am quite glad that we do both have the same problem!!!

At least I know I am not going crazy.

It is now proof that there is something wrong with their software and hopefully they will do something about it.

I think for the time being I am just going to use the compress option, which although not encrypted doesn't just display the plain text. I am going to keep on their backs though to get this resolved. I was hoping to purchase the product but won't be until this is sorted.

david_labbe · Post by **david_labbe** » Thu 23 Mar 2006 16:15

JonKerry wrote:This may sound strange but I am quite glad that we do both have the same problem!!!

At least I know I am not going crazy.

Believe me! I was also glad to see someone else with the same pb! I had doubt about my sanity for a while!!! lol
________
MAC GAME

david_labbe · Post by **david_labbe** » Mon 27 Mar 2006 09:42

It seems that the topic has now moved to another place. Are you still interested in solving this issue?
________
Lamborghini cheetah