Hi, I have trouble connecting to a sql server: I get the message : wpDataTables could not connect to mssql server. mssql said: There was a problem with your SQL connection - SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate] I can connect fine, though, from another server running wpdatables. The difference is versions. The working server is on Ubuntu 18.04 / PHP 7.4, the Server not working ist Ubuntu 20.04 / PHP 8.1. Is there a chance to configure not using encryption at all or using the "TrustServerCertificate" parameter in the connection string? Regards, Haimo
Hi, I have trouble connecting to a sql server:
I get the message : wpDataTables could not connect to mssql server. mssql said: There was a problem with your SQL connection - SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate]
I can connect fine, though, from another server running wpdatables. The difference is versions. The working server is on Ubuntu 18.04 / PHP 7.4, the Server not working ist Ubuntu 20.04 / PHP 8.1.
Is there a chance to configure not using encryption at all or using the "TrustServerCertificate" parameter in the connection string?
Regards, Haimo
Hi, Haimo.
Sorry for the waiting time.
We don't work on weekends so it adds two days to the waiting time.
we appreciate your patience.
There was another user before, i think they had this same error, i will share what they did as a fix, and let me know if this helps.
You can bypass the SSL by modifying the connection string to SQL Server in this plugin PHP file
.../wpdatatables/source/class.connection.php.
(for the SQL Server driver)
and adding no encryption and trusting server certificates (TrustServerCertificate = true; Encrypt = false).
.......
switch ($vendor) {
case (self::$MSSQL):
if (isset($driver) && $driver == 'sqlsrv') {
return new PDOSql($vendor, "$driver:Server=$host,$port;Database=$database; TrustServerCertificate=True; Encrypt=false", $user, $password);
}
..............
Let me know if that helps? Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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