Okay
  Public Ticket #3299018
Connectivity
Closed

Comments

  • Haimo Grebenstein started the conversation

    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

  •  1,849
    Miloš replied

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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