MSS

[rafik151]

At first I want to say hello to everyone - it's my first post on this forum.

I have problem with MSSQL monitoring. I'm using docker version of zabbix 5.4.3. I've modified image, so I have msodcbsql17 installed - as you can see below:

root@9c03da6807f8:/var/lib/zabbix# apt list --installed
Listing... Done
adduser/focal,now 3.118ubuntu2 all [installed]
apt/focal-updates,now 2.0.6 amd64 [installed]
base-files/now 11ubuntu5.3 amd64 [installed,upgradable to: 11ubuntu5.4]
base-passwd/focal,now 3.5.47 amd64 [installed]
bash/focal-updates,now 5.0-6ubuntu1.1 amd64 [installed]
bsdutils/focal-updates,now 1:2.34-0.1ubuntu9.1 amd64 [installed]
bzip2/focal,now 1.0.8-2 amd64 [installed]
ca-certificates/now 20210119~20.04.1 all [installed,upgradable to: 20210119~20.04.2]
coreutils/focal,now 8.30-3ubuntu2 amd64 [installed]
curl/focal-updates,focal-security,now 7.68.0-1ubuntu2.7 amd64 [installed]
dash/focal,now 0.5.10.2-6 amd64 [installed]
debconf/focal,now 1.5.73 all [installed]
debianutils/focal,now 4.9.1 amd64 [installed]
diffutils/focal,now 1:3.7-3 amd64 [installed]
dirmngr/focal-updates,now 2.2.19-3ubuntu2.1 amd64 [installed,automatic]
dpkg/focal,now 1.19.7ubuntu3 amd64 [installed]
e2fsprogs/focal,now 1.45.5-2ubuntu1 amd64 [installed]
fdisk/focal-updates,now 2.34-0.1ubuntu9.1 amd64 [installed]
findutils/focal,now 4.7.0-1ubuntu1 amd64 [installed]
fping/focal,now 4.2-1 amd64 [installed]
gcc-10-base/focal-updates,focal-security,now 10.3.0-1ubuntu1~20.04 amd64 [installed]
gnupg-l10n/focal-updates,now 2.2.19-3ubuntu2.1 all [installed,automatic]
gnupg-utils/focal-updates,now 2.2.19-3ubuntu2.1 amd64 [installed,automatic]
gnupg/focal-updates,now 2.2.19-3ubuntu2.1 all [installed,automatic]
gpg-agent/focal-updates,now 2.2.19-3ubuntu2.1 amd64 [installed,automatic]
gpg-wks-client/focal-updates,now 2.2.19-3ubuntu2.1 amd64 [installed,automatic]
gpg-wks-server/focal-updates,now 2.2.19-3ubuntu2.1 amd64 [installed,automatic]
gpg/focal-updates,now 2.2.19-3ubuntu2.1 amd64 [installed]
gpgconf/focal-updates,now 2.2.19-3ubuntu2.1 amd64 [installed,automatic]
gpgsm/focal-updates,now 2.2.19-3ubuntu2.1 amd64 [installed,automatic]
gpgv/focal-updates,now 2.2.19-3ubuntu2.1 amd64 [installed]
grep/focal,now 3.4-1 amd64 [installed]
gzip/focal,now 1.10-0ubuntu4 amd64 [installed]
hostname/focal,now 3.23 amd64 [installed]
init-system-helpers/focal,now 1.57 all [installed]
iputils-ping/focal,now 3:20190709-3 amd64 [installed]
libacl1/focal,now 2.2.53-6 amd64 [installed]
libapt-pkg6.0/focal-updates,now 2.0.6 amd64 [installed]
libasn1-8-heimdal/focal,now 7.7.0+dfsg-1ubuntu1 amd64 [installed,automatic]
libassuan0/focal,now 2.5.3-7ubuntu2 amd64 [installed,automatic]
libattr1/focal,now 1:2.4.48-5 amd64 [installed]
libaudit-common/focal,now 1:2.8.5-2ubuntu6 all [installed]
libaudit1/focal,now 1:2.8.5-2ubuntu6 amd64 [installed]
libblkid1/focal-updates,now 2.34-0.1ubuntu9.1 amd64 [installed]
libbrotli1/focal-updates,focal-security,now 1.0.7-6ubuntu0.1 amd64 [installed,automatic]
libbsd0/focal,now 0.10.0-1 amd64 [installed,automatic]
libbz2-1.0/focal,now 1.0.8-2 amd64 [installed]
libc-bin/focal-updates,now 2.31-0ubuntu9.2 amd64 [installed]
libc6/focal-updates,now 2.31-0ubuntu9.2 amd64 [installed]
libcap-ng0/focal,now 0.7.9-2.1build1 amd64 [installed]
libcap2-bin/focal,now 1:2.32-1 amd64 [installed,automatic]
libcap2/focal,now 1:2.32-1 amd64 [installed,automatic]
libcom-err2/focal,now 1.45.5-2ubuntu1 amd64 [installed]
libcrypt1/focal,now 1:4.4.10-10ubuntu4 amd64 [installed]
libcurl4/focal-updates,focal-security,now 7.68.0-1ubuntu2.7 amd64 [installed]
libdb5.3/focal,now 5.3.28+dfsg1-0.6ubuntu2 amd64 [installed]
libdebconfclient0/focal,now 0.251ubuntu1 amd64 [installed]
libedit2/focal,now 3.1-20191231-1 amd64 [installed,automatic]
libevent-2.1-7/focal,now 2.1.11-stable-1 amd64 [installed]
libext2fs2/focal,now 1.45.5-2ubuntu1 amd64 [installed]
libfdisk1/focal-updates,now 2.34-0.1ubuntu9.1 amd64 [installed]
libffi7/focal,now 3.3-4 amd64 [installed]
libgcc-s1/focal-updates,focal-security,now 10.3.0-1ubuntu1~20.04 amd64 [installed]
libgcrypt20/focal,now 1.8.5-5ubuntu1 amd64 [installed,upgradable to: 1.8.5-5ubuntu1.1]
libgdbm-compat4/focal,now 1.18.1-5 amd64 [installed,automatic]
libgdbm6/focal,now 1.18.1-5 amd64 [installed,automatic]
libgmp10/focal,now 2:6.2.0+dfsg-4 amd64 [installed]
libgnutls30/now 3.6.13-2ubuntu1.3 amd64 [installed,upgradable to: 3.6.13-2ubuntu1.6]
libgpg-error0/focal,now 1.37-1 amd64 [installed]
libgssapi-krb5-2/focal-updates,focal-security,now 1.17-6ubuntu4.1 amd64 [installed,automatic]
libgssapi3-heimdal/focal,now 7.7.0+dfsg-1ubuntu1 amd64 [installed,automatic]
libhcrypto4-heimdal/focal,now 7.7.0+dfsg-1ubuntu1 amd64 [installed,automatic]
libheimbase1-heimdal/focal,now 7.7.0+dfsg-1ubuntu1 amd64 [installed,automatic]
libheimntlm0-heimdal/focal,now 7.7.0+dfsg-1ubuntu1 amd64 [installed,automatic]
libhogweed5/focal-updates,focal-security,now 3.5.1+really3.5.1-2ubuntu0.2 amd64 [installed]
libhx509-5-heimdal/focal,now 7.7.0+dfsg-1ubuntu1 amd64 [installed,automatic]
libicu66/focal,now 66.1-2ubuntu2 amd64 [installed,automatic]
libidn2-0/focal,now 2.2.0-2 amd64 [installed]
libk5crypto3/focal-updates,focal-security,now 1.17-6ubuntu4.1 amd64 [installed,automatic]
libkeyutils1/focal,now 1.6-6ubuntu1 amd64 [installed,automatic]
libkrb5-26-heimdal/focal,now 7.7.0+dfsg-1ubuntu1 amd64 [installed,automatic]
libkrb5-3/focal-updates,focal-security,now 1.17-6ubuntu4.1 amd64 [installed,automatic]
libkrb5support0/focal-updates,focal-security,now 1.17-6ubuntu4.1 amd64 [installed,automatic]
libksba8/focal,now 1.3.5-2 amd64 [installed,automatic]
libldap-2.4-2/focal-updates,now 2.4.49+dfsg-2ubuntu1.8 amd64 [installed,automatic]
libldap-common/focal-updates,now 2.4.49+dfsg-2ubuntu1.8 all [installed,automatic]
libltdl7/focal,now 2.4.6-14 amd64 [installed,automatic]
liblz4-1/focal-updates,focal-security,now 1.9.2-2ubuntu0.20.04.1 amd64 [installed]
liblzma5/focal-updates,now 5.2.4-1ubuntu1 amd64 [installed]
libmount1/focal-updates,now 2.34-0.1ubuntu9.1 amd64 [installed]
libmysqlclient21/now 8.0.26-0ubuntu0.20.04.2 amd64 [installed,upgradable to: 8.0.27-0ubuntu0.20.04.1]
libncurses6/focal,now 6.2-0ubuntu2 amd64 [installed]
libncursesw6/focal,now 6.2-0ubuntu2 amd64 [installed]
libnettle7/focal-updates,focal-security,now 3.5.1+really3.5.1-2ubuntu0.2 amd64 [installed]
libnghttp2-14/focal,now 1.40.0-1build1 amd64 [installed,automatic]
libnpth0/focal,now 1.6-1 amd64 [installed,automatic]
libodbc1/focal,now 2.3.6-0.1build1 amd64 [installed,upgradable to: 2.3.7]
libopenipmi0/focal,now 2.0.27-0ubuntu2 amd64 [installed]
libp11-kit0/focal-updates,focal-security,now 0.23.20-1ubuntu0.1 amd64 [installed]
libpam-modules-bin/now 1.3.1-5ubuntu4.2 amd64 [installed,upgradable to: 1.3.1-5ubuntu4.3]
libpam-modules/now 1.3.1-5ubuntu4.2 amd64 [installed,upgradable to: 1.3.1-5ubuntu4.3]
libpam-runtime/now 1.3.1-5ubuntu4.2 all [installed,upgradable to: 1.3.1-5ubuntu4.3]
libpam0g/now 1.3.1-5ubuntu4.2 amd64 [installed,upgradable to: 1.3.1-5ubuntu4.3]
libpci3/focal-updates,now 1:3.6.4-1ubuntu0.20.04.1 amd64 [installed,automatic]
libpcre2-8-0/focal,now 10.34-7 amd64 [installed]
libpcre3/focal,now 2:8.39-12build1 amd64 [installed]
libperl5.30/focal-updates,focal-security,now 5.30.0-9ubuntu0.2 amd64 [installed,automatic]
libprocps8/now 2:3.3.16-1ubuntu2.2 amd64 [installed,upgradable to: 2:3.3.16-1ubuntu2.3]
libpsl5/focal,now 0.21.0-1ubuntu1 amd64 [installed,automatic]
libreadline8/focal,now 8.0-4 amd64 [installed,automatic]
libroken18-heimdal/focal,now 7.7.0+dfsg-1ubuntu1 amd64 [installed,automatic]
librtmp1/focal,now 2.4+20151223.gitfa8646d.1-2build1 amd64 [installed,automatic]
libsasl2-2/focal,now 2.1.27+dfsg-2 amd64 [installed,automatic]
libsasl2-modules-db/focal,now 2.1.27+dfsg-2 amd64 [installed,automatic]
libseccomp2/focal-updates,now 2.5.1-1ubuntu1~20.04.1 amd64 [installed]
libselinux1/focal,now 3.0-1build2 amd64 [installed]
libsemanage-common/focal,now 3.0-1build2 all [installed]
libsemanage1/focal,now 3.0-1build2 amd64 [installed]
libsensors-config/focal,now 1:3.6.0-2ubuntu1 all [installed,automatic]
libsensors5/focal,now 1:3.6.0-2ubuntu1 amd64 [installed,automatic]
libsepol1/focal,now 3.0-1 amd64 [installed]
libsmartcols1/focal-updates,now 2.34-0.1ubuntu9.1 amd64 [installed]
libsnmp-base/focal-updates,focal-security,now 5.8+dfsg-2ubuntu2.3 all [installed,automatic]
libsnmp35/focal-updates,focal-security,now 5.8+dfsg-2ubuntu2.3 amd64 [installed]
libsqlite3-0/focal-updates,focal-security,now 3.31.1-4ubuntu0.2 amd64 [installed,automatic]
libss2/focal,now 1.45.5-2ubuntu1 amd64 [installed]
libssh-4/now 0.9.3-2ubuntu2.1 amd64 [installed,upgradable to: 0.9.3-2ubuntu2.2]
libssl1.1/now 1.1.1f-1ubuntu2.4 amd64 [installed,upgradable to: 1.1.1f-1ubuntu2.8]
libstdc++6/focal-updates,focal-security,now 10.3.0-1ubuntu1~20.04 amd64 [installed]
libsystemd0/focal-security,now 245.4-4ubuntu3.11 amd64 [installed,upgradable to: 245.4-4ubuntu3.13]
libtasn1-6/focal,now 4.16.0-2 amd64 [installed]
libtinfo6/focal,now 6.2-0ubuntu2 amd64 [installed]
libudev1/focal-security,now 245.4-4ubuntu3.11 amd64 [installed,upgradable to: 245.4-4ubuntu3.13]
libunistring2/focal,now 0.9.10-2 amd64 [installed]
libuuid1/focal-updates,now 2.34-0.1ubuntu9.1 amd64 [installed]
libwind0-heimdal/focal,now 7.7.0+dfsg-1ubuntu1 amd64 [installed,automatic]
libwrap0/focal,now 7.6.q-30 amd64 [installed,automatic]
libxml2/focal-updates,focal-security,now 2.9.10+dfsg-5ubuntu0.20.04.1 amd64 [installed]
libzstd1/focal-updates,focal-security,now 1.4.4+dfsg-3ubuntu0.1 amd64 [installed]
login/now 1:4.8.1-1ubuntu5.20.04 amd64 [installed,upgradable to: 1:4.8.1-1ubuntu5.20.04.1]
logsave/focal,now 1.45.5-2ubuntu1 amd64 [installed]
lsb-base/focal,now 11.1.0ubuntu2 all [installed]
mawk/focal,now 1.3.4.20200120-2 amd64 [installed]
mount/focal-updates,now 2.34-0.1ubuntu9.1 amd64 [installed]
msodbcsql17/focal,now 17.8.1.1-1 amd64 [installed]
mysql-client-8.0/now 8.0.26-0ubuntu0.20.04.2 amd64 [installed,upgradable to: 8.0.27-0ubuntu0.20.04.1]
mysql-client-core-8.0/now 8.0.26-0ubuntu0.20.04.2 amd64 [installed,upgradable to: 8.0.27-0ubuntu0.20.04.1]
mysql-client/now 8.0.26-0ubuntu0.20.04.2 all [installed,upgradable to: 8.0.27-0ubuntu0.20.04.1]
mysql-common/focal,now 5.8+1.0.5ubuntu2 all [installed,automatic]
ncurses-base/focal,now 6.2-0ubuntu2 all [installed]
ncurses-bin/focal,now 6.2-0ubuntu2 amd64 [installed]
netbase/focal,now 6.1 all [installed,automatic]
odbcinst1debian2/focal,now 2.3.6-0.1build1 amd64 [installed,upgradable to: 2.3.7]
odbcinst/focal,now 2.3.6-0.1build1 amd64 [installed,upgradable to: 2.3.7]
openssl/now 1.1.1f-1ubuntu2.4 amd64 [installed,upgradable to: 1.1.1f-1ubuntu2.8]
passwd/now 1:4.8.1-1ubuntu5.20.04 amd64 [installed,upgradable to: 1:4.8.1-1ubuntu5.20.04.1]
patch/focal,now 2.7.6-6 amd64 [installed,automatic]
pci.ids/focal,now 0.0~2020.03.20-1 all [installed,automatic]
perl-base/focal-updates,focal-security,now 5.30.0-9ubuntu0.2 amd64 [installed]
perl-modules-5.30/focal-updates,focal-security,now 5.30.0-9ubuntu0.2 all [installed,automatic]
perl/focal-updates,focal-security,now 5.30.0-9ubuntu0.2 amd64 [installed,automatic]
pinentry-curses/focal,now 1.1.0-3build1 amd64 [installed,automatic]
procps/now 2:3.3.16-1ubuntu2.2 amd64 [installed,upgradable to: 2:3.3.16-1ubuntu2.3]
readline-common/focal,now 8.0-4 all [installed,automatic]
sed/focal,now 4.7-1 amd64 [installed]
sensible-utils/focal,now 0.0.12+nmu1 all [installed]
smistrip/focal,now 0.4.8+dfsg2-16 all [installed,automatic]
snmp-mibs-downloader/focal,now 1.2 all [installed]
sysvinit-utils/focal,now 2.96-2.1ubuntu1 amd64 [installed]
tar/focal-updates,focal-security,now 1.30+dfsg-7ubuntu0.20.04.1 amd64 [installed]
tini/focal,now 0.18.0-1 amd64 [installed]
traceroute/focal,now 1:2.1.0-2 amd64 [installed]
tzdata/now 2021a-0ubuntu0.20.04 all [installed,upgradable to: 2021a-2ubuntu0.20.04]
ubuntu-keyring/focal-updates,now 2020.02.11.4 all [installed]
unixodbc/focal,now 2.3.6-0.1build1 amd64 [installed,upgradable to: 2.3.7]
util-linux/focal-updates,now 2.34-0.1ubuntu9.1 amd64 [installed]
wget/focal,now 1.20.3-1ubuntu1 amd64 [installed,automatic]
zlib1g/focal-updates,now 1:1.2.11.dfsg-2ubuntu1.2 amd64 [installed]

I've downloaded template from https://www.zabbix.com/integrations/mssql
Configured my host with all the necessary macros (same DSN created in ODBC Data Source Administrator):



And the only item working is "MSSQL: Service's TCP port state"...

In Discovery rules I have this error: Cannot connect to ODBC DSN: [SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]

What can be a problem?

[niveastn]

Hello there! Welcome to the forum!

First, did you configure these files: /etc/odbc.ini and /etc/odbcinst.ini?

If not, maybe this link can help you: https://www.zabbix.com/documentation...unixodbc_mssql

What this error means: it cannot find the dsn (the "title" you give to your database configuration block) on /etc/odbc.ini
Two reasons for that: the dsn you configured in the item is different of the one in the file. Or, the configuration is simply not there.
If you did not set up, use the link above, and test wil "isql <dns>"

Hope I could help

[rafik151]

Hello niveastn!

Thank you very much for your reply.
Configuring odbc.ini solved the problem, thank you!

But there is always something. Now, when I am able to communicate from zabbix to my MSSQL, I've got a problem with template.
I have such an error in most items:

Preprocessing failed for: [{"object_name":"MSSQL$SQLEXPRESS:Access Methods","counter_name":"AU cleanup batches/sec","instan...
1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Databases' && @.counter_name=='Transactions/sec' && @.instance_name=='ServerManager')].cntr_value.first()": no data matches the specified path

MSSQL Server - 14.0.1000.169
ODBC Driver 17 for SQL Server (on server site) - 2017.175.01.01
ODBC Driver 17 for SQL Server (on Zabbix site) - 17.8.so.1.1

I have no problem with connection using isql.

Can it be caused by version mismatch? Template documenation says that it was tested on 2017 and 2019 SQL. If so, have you got any proven template that you can recommend?

[cyber]

This error says, that it cannot find data where preprocessing tells it to search...compare the original data to preprocessing rules and adjust, if needed. It can be as simple as something being in upper case instead of lower ... Or maybe such metric is not there at all...