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
SSL connection to MySQL server (dbExpress and ScSSLClient)?
-
AndreyZ
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
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
-
AndreyZ
-
AndreyZ