How to connect to a mysql database using jdbc query and applying ssl files for Authentication

Follow

David I Perez

• January 07, 2021 20:46

i have connected to mysql before but now i have never done so with ssl securty layer. 

My current error: 

 

0

• 

  Gerry Mullin

  • January 07, 2021 23:14

  I have no direct experience with this, but the first thing that comes to mind to try is to import your certificate (server-ca.pem) into Analyze's cacerts truststore. The help documentation advises how to do this here.

   

  Based on this link your DbUrl will probably look something like:

  jdbc:mysql://34.70.125.209:3306/sanctions?verifyServerCertificate=true&useSSL=true&requireSSL=true

   

  Hope this helps.

  0

  Comment actions Permalink
• 

  David I Perez

  • January 08, 2021 15:33

  New error nut also i was having trouble adding the ssl in said file. 

  

  

  dburl = jdbc:mysql://34.70.125.209:3306/sanctions?verifyServerCertificate=true&useSSL=true&requireSSL=true&serverSslCert=C:\Users\diperez\Downloads\PPF_Capital\Certs\server-ca.pem

  0

  Comment actions Permalink
• 

  Gerry Mullin

  • January 08, 2021 16:47

  We will open a support ticket for you soon and reach out to you.

  0

  Comment actions Permalink
• 

  David I Perez

  • January 12, 2021 19:41

  thanks you, any feedback on this

  0

  Comment actions Permalink
• 

  Adrian Williams

  • January 13, 2021 16:39

  Adding Ticket ref #: 201979

  0

  Comment actions Permalink
• 

  David I Perez

  • January 13, 2021 18:11

  my current error: 

  url: jdbc:mysql://34.70.125.209:3306/sanctions?verifyServerCertificate=true&useSSL=true&disableSslHostnameVerification=true&passwordCharacterEncoding=utf8

  

   

  0

  Comment actions Permalink

Please sign in to leave a comment.