Data360 Analyze

 View Only

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

    Posted 01-07-2021 13:46

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

    My current error: 

     



  • 2.  RE: How to connect to a mysql database using jdbc query and applying ssl files for Authentication

    Employee
    Posted 01-07-2021 16:15

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    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.



  • 3.  RE: How to connect to a mysql database using jdbc query and applying ssl files for Authentication

    Posted 01-08-2021 08: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



  • 4.  RE: How to connect to a mysql database using jdbc query and applying ssl files for Authentication

    Employee
    Posted 01-08-2021 09:48

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

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



  • 5.  RE: How to connect to a mysql database using jdbc query and applying ssl files for Authentication

    Posted 01-12-2021 12:41

    thanks you, any feedback on this



  • 6.  RE: How to connect to a mysql database using jdbc query and applying ssl files for Authentication

    Employee
    Posted 01-13-2021 09:40

    Adding Ticket ref #: 201979



  • 7.  RE: How to connect to a mysql database using jdbc query and applying ssl files for Authentication

    Posted 01-13-2021 11:12

    my current error: 

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