I'm trying to connect to my external MySQL Server v.8.0.21 with SSL enabled using JDBC connector to populate a select box in a Form.
To authenticate my user I've created a new user called joget ;
mysql> CREATE USER 'joget'@'ec2-54-215-231-212.us-west-1.compute.amazonaws.com' IDENTIFIED BY 'PASSWORD' REQUIRE SSL;
mysql> GRANT ALL PRIVILEGES ON example.* TO 'joget'@'ec2-54-215-231-212.us-west-1.compute.amazonaws.com';
mysql> FLUSH PRIVILEGES;
Caused by: java.sql.SQLException: Could not connect to address=(host=Server)(port=3306)(type=master) : RSA public key is not available client side (option serverRsaPublicKeyFile not set)
I really waste now a day googling around and found the following Troubleshoot which actually could solve the problem:)
Following the instruction, I've validated my Servers public_key and copy/store it under my App resources to provide the link for serverRSAPublicKey= /jw/web/app/..../public_key.pem and gave another try.
Hi,
I have a Cloud account,
I'm trying to connect to my external MySQL Server v.8.0.21 with SSL enabled using JDBC connector to populate a select box in a Form.
To authenticate my user I've created a new user called joget ;
and setup my jdbc binder as follow;
......and raised a ERROR;
Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Setting useSLL=false ; [ In this case I have to use a different User with non-SSL enabled]
Caused by: java.sql.SQLException: Could not connect to address=(host=Server)(port=3306)(type=master) : RSA public key is not available client side (option serverRsaPublicKeyFile not set)
I really waste now a day googling around and found the following Troubleshoot which actually could solve the problem:)
Following the instruction, I've validated my Servers public_key and copy/store it under my App resources to provide the link for serverRSAPublicKey= /jw/web/app/..../public_key.pem and gave another try.
Actually I've used many other combination's and don't know how to solve my connection problem.