Devart Forums

Hi i have an app that uses dbExpress unidirectional connection. Now i need to migrate this DB from MySQLv4 server to MySQLv5 server with enabled SSL. I have downloaded trial version of secure bridge but cant find a sample of using TScSSLClient component.
I guess i need to use that component to connect to the server and connect dbExpress TSQL Connection to TScSSLClient somehow.
Can you please tell me if this is possible and eventualy give me some sample or code how can i config this?

thanks

Hello,

For the time being dbExpress driver for MySQL doesn't support establishing SSL connections. We will add this functionality in one of the next dbExpress driver for MySQL builds. You can establish SSH connections using dbExpress driver for MySQL and SecureBridge instead of SSL connections. For this, you should perform the following steps:
1. Configure your SSH server to listen to a port allowed for remote connections and run the SSH server. You can find an SSH server implementation in SecureBridge demos.
2. Add TScSSHChannel and TScSSHClient components to your client application to make an SSH client, and setup port forwarding from a local port to your MySQL server through the port listened by the SSH server. As an example, see the SSHClient demo of SecureBridge.
3. Setup your TSQLConnection to connect to the localhost on the port that you used for port forwarding.
Also, you can use MyDAC that supports establishing SSH and SSL connections using SecureBridge. For more information about MyDAC, please refer to http://www.devart.com/mydac

Hi,
thanks for the answers.

do you have any estimate release date for dbExpress driver with ssl support(weeks, months, years)?

As we are working on MacOS support for all our dbExpress drivers now, we cannot provide the exact time when the dbExpress driver for MySQL version with SSL support will be available. We will add SSL support to dbExpress driver for MySQL approximately in a month or two.

Any more accurate news regarding this?

We have added SSL support to dbExpress driver for MySQL. This functionality will be included in the next dbExpress driver for MySQL build.