Resolving Issues When Onboarding SSL-Enabled MySQL Database Servers

Resolving Issues When Onboarding SSL-Enabled MySQL Database Servers

AlertError MessageConnections using insecure transport are prohibited while --require_secure_transport=ON




SolutionTo overcome this issue follow the steps given below:
  1. Execute the following query in the corresponding MySQL shell script:
  2. QuoteALTER USER '<user>'@'<host/Ip-address>' REQUIRE <tls_option>; [ tls_option: { SSL | X509 | CIPHER 'cipher' | ISSUER 'issuer' | SUBJECT 'subject' } ]
  3. 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.
  4. 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.

AlertError Messagejavax.net.ssl.SSLHandshakeException: java.security.cert.CertPathValidatorException: Path does not chain with any of the trust anchors

Reason: 
Possible causes include:
  1. Certificate is not added to Applications Manager
  2. Certificate is corrupt, invalid or expired 
Solution: To resolve this issue follow the steps given below: 
  1. Check if the certificate has been properly uploaded in Applications Manager and get a screenshot of it for further verification.
  2. Ensure that the certificate is valid.
  3. Re-upload the certificate, restart Applications Manager, and check if the issue has been resolved.
Info
If the issue still persists, reach out to our support team with the following details :
  1. Go to Settings → Tools → Manage certificates → List certificates and take a screenshot of the page.
  2. Clarify how the certificate was uploaded under the Trust certificate tab including selected options during the process.

                  New to ADSelfService Plus?