Resolving Issues When Onboarding SSL-Enabled MySQL Database Servers
Error Message: Connections using insecure transport are prohibited while --require_secure_transport=ON
Solution: To overcome this issue follow the steps given below:
- Execute the following query in the corresponding MySQL shell script:
ALTER USER '<user>'@'<host/Ip-address>' REQUIRE <tls_option>; [ tls_option: { SSL | X509 | CIPHER 'cipher' | ISSUER 'issuer' | SUBJECT 'subject' } ]- Add the client certificates along with their root certificates in AppManagerHome/working/cert/apm.keytore. Click here for the steps to import certificates in Applications Manager.
- Add the monitor by enabling 'SSL' option in Add New Monitor page. If the monitor has already been added, update the 'SSL' option in Edit Monitor page.
Error Message: javax.net.ssl.SSLHandshakeException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors
Reason:
Possible causes include:
- Certificate is not added to Applications Manager
- Certificate is corrupt, invalid or expired
Solution: To resolve this issue follow the steps given below:
- Check if the certificate has been properly uploaded in Applications Manager and get a screenshot of it for further verification.
- Ensure that the certificate is valid.
- Re-upload the certificate, restart Applications Manager, and check if the issue has been resolved.
If the issue still persists, reach out to our support team with the following details :
- Go to Settings → Tools → Manage certificates → List certificates and take a screenshot of the page.
- Clarify how the certificate was uploaded under the Trust certificate tab including selected options during the process.
New to ADSelfService Plus?