MyConnection Server SQL SSL Support
MyConnection Server supports SSL connections to MySQL servers. SSL connections require a CA certificate and, optionally, a client certificate.
Certificate Authority (CA) certificate
This is used to authenticate the MySQL server - that is, to confirm that the client is connecting to an authorized MySQL server.
Your MySQL server's certificate will have been created using this CA certificate, and any client connecting to it needs a copy of it.
Client certificate
This is used to authenticate the client to the server.
Whether a client certificate is required is defined by the configuration of the MySQL server itself.
You should enter in the keystore boxes the name of the Java keystore which contains the certificates. The keystore should be placed in the
MyConnection Server installation directory.
If you have raw certificate files (usually ending .pem), you can create a Java keystore from them. To do so:
Open a DOS prompt window (Windows) or a Terminal session (Unix)
Ensure that 'keytool' is in your PATH. It is located in your Java VM's 'bin' directory.
You should be able to type 'keystore' at the command prompt and get a response.
Type keytool -import -alias mysqlServerCert -file certificate.pem -keystore truststore.keystore
This will create a keystore called truststore from the certificate certificate.pem. You will be prompted to choose a password.
If you have any problems, just contact us - we can help!