In the Separate DB Connection tab under the Settings, there is no setting to specify SSL connection for my MySQL 8 database. Is there any other way to specify SSL connection to the DB?
Thank you, Aleksandar. I will give it a try. Question though, setting this will restrict all of my MySQL DB connections to use SSL globally, right? If so, is there a way to specify between using SSL and non-SSL? In our current environment of wpDataTables DB connections to MySQL, we still have a mix of using SSL and non-SSL for the various tables.
In the Separate DB Connection tab under the Settings, there is no setting to specify SSL connection for my MySQL 8 database. Is there any other way to specify SSL connection to the DB?
Hello te9dj3
If you're using MySQL, you should add mysqli_set_ssl after mysqli_connect in this file:
wp-content/plugins/wpdatatables/source/class.sql.php on line 47
You can read more about this on stack overflow.
For other SQL engines, you should use PDO extension, so if it's SQL, you can take a look on this link.
And if you're using POSTGRESQL, you can take a look here.
I hope that helps.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you, Aleksandar. I will give it a try. Question though, setting this will restrict all of my MySQL DB connections to use SSL globally, right? If so, is there a way to specify between using SSL and non-SSL? In our current environment of wpDataTables DB connections to MySQL, we still have a mix of using SSL and non-SSL for the various tables.
Hi te9dj3,
Aleksandar is out of office today and I will answer you.
Yes, you will need to check is database contain SSL parameter like you can find here https://stackoverflow.com/questions/37317242/how-to-know-if-connection-to-database-is-using-ssl-or-not
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
Thanks for all your help, guys. We're all set now!
Hi te9dj3
I'm glad to hear the issue is resolved.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables