Trying to figure out how I can configure a secure MySQL Remote SSL connection....the plugin admin doest seem to allow that option. I have all my certs and keys....just nowhere to enter them
Yes I've got the connection working, now I want to secure it with SSL.
Normally, for example in MySQL Workbench, if you have a remote database up and running on say Google Cloud and want to do SSL you create a Client ID, secret key and server CA on the server, supply them to the client and add them to the client connection parameters.
As the plugin doesn't have these fields, I'm wondering how to accomplish this to keep the connection secure.
You'd need to place the certificate in a 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:
Trying to figure out how I can configure a secure MySQL Remote SSL connection....the plugin admin doest seem to allow that option. I have all my certs and keys....just nowhere to enter them
Any direction is appreciated
Hello Rob.
Thank you for your purchase.
You should be able to enter the connection details under "Separate DB Connection" tab:
When you say you have nowhere to enter your credentials, what do you mean? Can you share some screenshots with us?
Best regards.
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
Thanks for the reply Aleksandar,
Yes I've got the connection working, now I want to secure it with SSL.
Normally, for example in MySQL Workbench, if you have a remote database up and running on say Google Cloud and want to do SSL you create a Client ID, secret key and server CA on the server, supply them to the client and add them to the client connection parameters.
As the plugin doesn't have these fields, I'm wondering how to accomplish this to keep the connection secure.
I see Rob.
We don't have those settings built-in the plugin.
You'd need to place the certificate in a 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:
Probably you will need to add the certification there and everything should work fine.
Please let me know if this helps.
Best regards.
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