Okay
  Public Ticket #1807921
SSL Connection
Closed

Comments

  • carolefabrics started the conversation
    December 4, 2018 at 3:56pm

    We are trying to connect to an AWS website that has a secure connection using the "Separate MySQL Connection" tab in the settings menu. I am able to connect to other databases just fine but I can't connect to this Amazon one because it requires a SSL connection. There is not an option in the settings to configure the connection for SSL.

  •  471
    Isidora replied
    December 4, 2018 at 4:55pm

    Hi carolefabrics,
    Thank you for your purchase.

    It looks like that your local cert file is on different path. You can take a look on this link  few solutions how to set that. Also you can find more information on this link.

    Like it is said in the link  HTTPS requires exchanging and verify the SSL cert which protects the URL so if you hit an HTTPS URL you will receive an error because you aren't handling the security translation.

    In file wp-content/plugins/wpdatatables/source/class.wdttools.php around line 170 you will find this line of codes

    curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
curl_setopt($ch, CURLOPT_USERAGENT, $agent);
curl_setopt($ch, CURLOPT_REFERER, site_url());

    Probably you will need to add the certification there and everything should work fine.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables