SSL error for MSSQL monitoring

stator
stator
edited March 2022 in LPAR2RRD
After installing MS ODBC 18 connector and trying to connect to MSSQL 2014 DB I get this error ?
Do you know how to ignore SSL check ?

It's default instance.

$ rpm -q msodbcsql18 mssql-tools18
msodbcsql18-18.0.1.1-1.x86_64
mssql-tools18-18.0.1.1-1.x86_64

$ /home/lpar2rrd/lpar2rrd/load_sqlserver.sh
Image environment is set
Start XXXXXX Data Fetch
sqlserver-json2rrd.pl : push data to rrd, Mon Mar 28 15:28:36 CEST 2022
RRDp    version   : 1.4008
RRDtool version   : 1.4.8
sqlserver-json2rrd.pl : status , Mon Mar 28 15:28:36 CEST 2022
An error occured in lpar2rrd, check /home/lpar2rrd/lpar2rrd/logs/error.log-sqlserver and output of load_sqlserver.sh

$ tail -5 /home/lpar2rrd/lpar2rrd/logs/error.log-sqlserver

[unixODBC][Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed:self signed certificate] (SQL-08001)
[unixODBC][Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection (SQL-08001) [state was 08001 now 01S00]
[unixODBC][Microsoft][ODBC Driver 18 for SQL Server]Invalid connection string attribute (SQL-01S00) at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 374.
Use of uninitialized value $file in concatenation (.) or string at /home/lpar2rrd/lpar2rrd/bin/sqlserver-json2rrd.pl line 89.
Perf file for XXXXX doesn't exist  at /home/lpar2rrd/lpar2rrd/bin/sqlserver-json2rrd.pl line 93.

Comments

  • damerva
    damerva
    Hello,
    please apply this patch and then try connection test that is in the configuration form where you set up the monitoring and send us a screenshot of the output. Just to see if this small change fixes that.

    https://download.lpar2rrd.com/patch/7.34-2-3-g518c/sqlserver-apitest.pl.gz

    Gunzip it and copy to /home/lpar2rrd/lpar2rrd/bin (755, lpar2rrd owner)

    -rw-rw-r-- 1 lpar2rrd lpar2rrd 4414 Mar 29 09:35 sqlserver-apitest.pl

    If your web browser gunzips it automatically then just rename it: mv sqlserver-apitest.pl.gz sqlserver-apitest.pl

    Assure that file size is the same as on above example



  • stator
    stator
    Hello,

    I have applied the patch:

    # grep "DBI:ODBC:driver" /home/lpar2rrd/lpar2rrd/bin/sqlserver-apitest.pl
      my $dbh = DBI->connect("DBI:ODBC:driver=$_driver;Server=$_ip;database=$_database;Port=$_port;Encryption=True",
    # ll /home/lpar2rrd/lpar2rrd/bin/sqlserver-apitest.pl
    -rwxr-xr-x 1 lpar2rrd lpar2rrd 4414 Mar 29 10:07 /home/lpar2rrd/lpar2rrd/bin/sqlserver-apitest.pl

    But result is the same.



  • damerva
    damerva
    Hello,
    please contact us at support@lpar2rrd.com for further testing

  • stator
    stator
    For anyone reading this in the future problem was that ODBC Driver 18 for SQL Server had some braking changes:

    https://techcommunity.microsoft.com/t5/sql-server-blog/odbc-driver-18-0-for-sql-server-released/ba-p/3169228

    I was provided private patch for this.


  • damerva
    damerva
    These changes will be accounted for in the upcoming LPAR2RRD version 7.40
    In the meantime you can use these patches.


    This patch is for connection test:
    https://download.lpar2rrd.com/patch/7.34-5-16-gedc59/sqlserver-apitest.pl.gz

    Gunzip it and copy to /home/lpar2rrd/lpar2rrd/bin (755, lpar2rrd owner)

    -rw-rw-r-- 1 lpar2rrd lpar2rrd 4355 Mar 30 15:51 bin/sqlserver-apitest.pl

    If your web browser gunzips it automatically then just rename it: mv sqlserver-apitest.pl.gz sqlserver-apitest.pl


    This patch is for data collection:
    https://download.lpar2rrd.com/patch/7.34-5-16-gedc59/sqlserver-db2json.pl.gz

    Gunzip it and copy to /home/lpar2rrd/lpar2rrd/bin (755, lpar2rrd owner)

    -rw-rw-r-- 1 lpar2rrd lpar2rrd 23128 Mar 30 15:59 bin/sqlserver-db2json.pl

    If your web browser gunzips it automatically then just rename it: mv sqlserver-db2json.pl.gz sqlserver-db2json.pl
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Categories

In this Discussion