CraigDuTremble
I have installed the JAR file for MySQL and have the correct server path and username / password. However, I don't see a place to specify our SSL certificate in the connection. Has anyone encountered this issue?
Quote 0 0
Mark
Hi Craig,The SSL certificate path must be given as parameters in the command line used to run BayesiaLab.Here is a workflow to use SSL with MySQL and Java: (https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-using-ssl.html)The main steps are:1 - importing the certificate with the keytool.exe tool. You can find it, on Windows, in C:\Program Files\Bayesia\BayesiaLab\jre\bin2 - modifying the command line (or the shortcut) to add the following options to the JVM (Java Virtual Machine):-Djavax.net.ssl.keyStore=path_to_keystore_file-Djavax.net.ssl.keyStorePassword=password-Djavax.net.ssl.trustStore=path_to_truststore_file-Djavax.net.ssl.trustStorePassword=passwordSo the command line becomes (on Windows):[code:3m8dmoen]"C:\Program Files\Bayesia\BayesiaLab\jre\bin\javaw.exe" -Djavax.net.ssl.keyStore=path_to_keystore_file -Djavax.net.ssl.keyStorePassword=password -Djavax.net.ssl.trustStore=path_to_truststore_file -Djavax.net.ssl.trustStorePassword=password %BLAB_MEM% -jar "C:\Program Files\Bayesia\BayesiaLab\BayesiaLab.jar"[/code:3m8dmoen]3- running BayesiaLab and modifying the jdbc url to use SSL by adding some options:[code:3m8dmoen]jdbc:mysql://127.0.0.1:3306/sample?verifyServerCertificate=false&useSSL=true&requireSSL=true[/code:3m8dmoen](ref: http://www.razorsql.com/articles/mysql_ssl_jdbc.html)I hope this helps
Quote 0 0