Connection to MSSQL is ok but there are no graphs

stator
stator
in LPAR2RRD
Hello,

Connection to MSSQL DB is ok and everything is OK



But I can't see any graphs


Do you have any ideas ?

LPAR2RRD 7.40

Comments

  • stator
    stator
    I have found an error:
    [Microsoft][ODBC Driver 18 for SQL Server]Connecting to a mirrored SQL Server instance using the MultiSubnetFailover connection option is not supported.

    I guess this means I am out of luck 
  • Pavel
    Pavel
    we will follow it up next week, MS SQL developer is not available this week
  • damerva
    damerva
    Try to apply the patch below and let it run for a while. The affected Instance should collect data, but keep an eye on other SQL Server Instances also and make sure they did not stop collecting data. If they stop and you need them more than this one then reapply the backup.

    let us know how it went, this will help us determine next steps


    1. backup your  /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl

    2. apply this patch:

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

    -rw-rw-r-- 1 lpar2rrd lpar2rrd 23104 Apr 14 08:57 sqlserver-db2json.pl

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

    Assure that file size is the same as on above example
  • stator
    stator
    Hello I have applied the patch. 
    It did not break currently working MSSQL connections / graphs.
    I do not see any errors on "Health status" for this database but I still do not see any graphs 

    # updatedb
    # locate hoebpsql
    /home/lpar2rrd/lpar2rrd/data/SQLServer/hoebpsql
    /home/lpar2rrd/lpar2rrd/data/SQLServer/hoebpsql/Configuration
    /home/lpar2rrd/lpar2rrd/data/SQLServer/hoebpsql/iostats
    /home/lpar2rrd/lpar2rrd/data/SQLServer/hoebpsql/Configuration/arc.json
    #


    ERROR(s) in place of the graphs

    /home/lpar2rrd/lpar2rrd/data/SQLServer/hoebpsql/Cluster/Counters/counters.rrd does not exist /home/lpar2rrd/lpar2rrd/bin/detail-graph-cgi.pl:39390
  • damerva
    damerva
    Try this patch, wait for at least 15 minutes, check a few graphs and send us output of the command below.

    command:
    tail /home/lpar2rrd/lpar2rrd/logs/error.log-sqlserver

    patch:
    https://download.lpar2rrd.com/patch/7.40-2-3-ged4e/sqlserver-db2json.pl.gz

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

    -rw-rw-r-- 1 lpar2rrd lpar2rrd 23127 Apr 19 12:57 sqlserver-db2json.pl

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

    Assure that file size is the same as on above example


  • stator
    stator
    Hello,

    I have applied the patch and waited more then 60 min. Graphs did not appeared.
    Here is output of /home/lpar2rrd/lpar2rrd/logs/error.log-sqlserver

    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 402.
    [unixODBC][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot open database "iBankingRetail" requested by the login. The login failed. (SQL-42000) [state was 42000 now 28000]
    [unixODBC][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user 'lpar2rrd'. (SQL-28000) at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 375.
    Can't use string ("err") as a HASH ref while "strict refs" in use at /home/lpar2rrd/lpar2rrd/bin/sqlserver-db2json.pl line 133.
    Use of uninitialized value $file in concatenation (.) or string at /home/lpar2rrd/lpar2rrd/bin/sqlserver-json2rrd.pl line 89.
    Perf file for hoebpsql doesn't exist  at /home/lpar2rrd/lpar2rrd/bin/sqlserver-json2rrd.pl line 93.

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