MySQL SSL connection not supported

[stefanproell]

Hello,

I would like to connect to my MySQL instance via a secure SSL channel.

Unfortunately, Arx seems not to support SSL secured connections. After entering the connection information for my MySQL instance, the user gets rejected, because the account enforces the use of SSL. I would need to provide the SSL settings as parameters to the JDBC connection String, which is not possible at the moment.

As a mitigation, I use an SSH tunnel, but I would prefer to simply connect via a secure MySQL connection directly. Are there any chances, that this will be implemented?

Cheers Stefan

[prasser]

Hi Stefan,

thanks for your interest in ARX!

It is true that this is currently not supported. Now that you have provided us with a feature request, support for SSL secured connections may be added in the future. However, it is definitely not a high-priority issue, as you are the first to ever request this functionality.

Have you considered contributing to the project? :)

Best Fabian

[stefanproell]

Hello Fabian, thanks for the quick feedback!

As a mini contribution for now, here is how I connect via SSH to a remote MySQL instance. Maybe it is useful for someone:

ssh -L <local port>:127.0.0.1:<remote port> -N example.org

So when the server runs MySQL on the default port 3306, I can create a tunnel like this from my machine, and transmit the data securely.

ssh -L 6033:127.0.0.1:3306 -N example.org

Now I can connect to the database with ARX like this:

[prasser]

Thanks!

[prasser]

I suggest leaving this open, until it is resolved. Thanks, Fabian

[rckrice]

I'd like to request SSL for PostgreSQL as well.