We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

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

Comments

6 comments

  • Avatar
    Gerry Mullin

    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
  • Avatar
    David I Perez

    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
  • Avatar
    Gerry Mullin

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

    0
    Comment actions Permalink
  • Avatar
    David I Perez

    thanks you, any feedback on this

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Adding Ticket ref #: 201979

    0
    Comment actions Permalink
  • Avatar
    David I Perez

    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.