monitor MSSQL by Zabbix agent 2 error Get job status
monitor MSSQL by Zabbix agent 2 error Get job status
Error Failed to execute handler: failed to execute handler: failed to query: mssql: Invalid column name 'Enabled'.
zabbix server version 7.0.10
zabbix Agent 2 vesion 7.0.0.2400
Zabbix host config
Templates
- MSSQL by Zabbix agent 2
- Windows by Zabbix agent
macros
{$MSSQL.HOST} XXXXDBWS01
{$MSSQL.URI} sqlserver://XXXXDBWS01.xxxxx.co.th:1433
{$MSSQL.USER} xxxxxxxxxxxxxx
{$MSSQL.PASSWORD} xxxxxxxxxxxxxx
Agent Log
2025/05/19 21:30:33.370159 Zabbix Agent 2 stopped. (7.0.0)
2025/05/19 21:33:12.180516 Starting Zabbix Agent 2 (7.0.0)
2025/05/19 21:33:12.183163 OpenSSL library (OpenSSL 3.0.11 19 Sep 2023) initialized
2025/05/19 21:33:12.183163 using configuration file: C:\Program Files\Zabbix Agent 2\zabbix_agent2.conf
2025/05/19 21:33:12.183737 using plugin 'Agent' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.183737 using plugin 'Ceph' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.183737 using plugin 'Cpu' (built-in) providing following interfaces: exporter, collector, runner
2025/05/19 21:33:12.183737 using plugin 'DNS' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.184253 using plugin 'File' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.184253 using plugin 'Log' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.184253 using plugin 'MQTT' (built-in) providing following interfaces: watcher, configurator
2025/05/19 21:33:12.184400 using plugin 'MSSQL' (C:\Program Files\Zabbix Agent 2\zabbix-agent2-plugin-mssql.exe) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184400 using plugin 'Memcached' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184400 using plugin 'Memory' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.184400 using plugin 'Modbus' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.184400 using plugin 'MongoDB' (C:\Program Files\Zabbix Agent 2\zabbix-agent2-plugin-mongodb.exe) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184400 using plugin 'Mysql' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184942 using plugin 'NetIf' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.184942 using plugin 'Oracle' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184942 using plugin 'PostgreSQL' (C:\Program Files\Zabbix Agent 2\zabbix-agent2-plugin-postgresql.exe) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.185491 using plugin 'Proc' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.185491 using plugin 'Redis' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.185491 using plugin 'Registry' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.185491 using plugin 'Smart' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.185491 using plugin 'Sw' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.185491 using plugin 'Swap' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186028 using plugin 'SystemRun' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186028 using plugin 'TCP' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186028 using plugin 'UDP' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186028 using plugin 'Uname' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186028 using plugin 'Uptime' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186028 using plugin 'Users' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186028 using plugin 'VFSDir' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186565 using plugin 'VMemory' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186565 using plugin 'VfsFs' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186565 using plugin 'WebCertificate' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186565 using plugin 'WebPage' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186565 using plugin 'WindowsEventlog' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186565 lowering the plugin WindowsPerfInstance capacity to 1 as the configured capacity 1000 exceeds limits
2025/05/19 21:33:12.186565 using plugin 'WindowsPerfInstance' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.187082 using plugin 'WindowsPerfMon' (built-in) providing following interfaces: exporter, collector, runner
2025/05/19 21:33:12.187113 using plugin 'WindowsServices' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.187113 using plugin 'Wmi' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.187113 using plugin 'ZabbixAsync' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.187113 using plugin 'ZabbixStats' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.187113 lowering the plugin ZabbixSync capacity to 1 as the configured capacity 1000 exceeds limits
2025/05/19 21:33:12.187113 using plugin 'ZabbixSync' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.723837 Plugin communication protocol version is 6.4.0
2025/05/19 21:33:12.724371 Zabbix Agent2 hostname: [XXXXXDBWS01]
2025/05/19 21:33:13.741203 [101] cannot connect to [127.0.0.1:10051]: dial tcp :0->127.0.0.1:10051: connectex: No connection could be made because the target machine actively refused it.
2025/05/19 21:33:13.741203 [101] active check configuration update from host [XXXXDBWS01] started to fail
2025/05/19 21:33:13.742759 [101] cannot connect to [127.0.0.1:10051]: dial tcp :0->127.0.0.1:10051: connectex: No connection could be made because the target machine actively refused it.
2025/05/19 21:33:13.742759 [101] sending of heartbeat message for [XXXXDBWS01]] started to fail
2025/05/19 21:33:36.592503 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593036 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593036 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593036 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593036 [MSSQL] Creating new connection to "ssqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593545 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593545 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593545 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593545 [MSSQL] Creating new connection to "ssqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/20 09:19:44.988659 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th:1433", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
Error Failed to execute handler: failed to execute handler: failed to query: mssql: Invalid column name 'Enabled'.
zabbix server version 7.0.10
zabbix Agent 2 vesion 7.0.0.2400
Zabbix host config
Templates
- MSSQL by Zabbix agent 2
- Windows by Zabbix agent
macros
{$MSSQL.HOST} XXXXDBWS01
{$MSSQL.URI} sqlserver://XXXXDBWS01.xxxxx.co.th:1433
{$MSSQL.USER} xxxxxxxxxxxxxx
{$MSSQL.PASSWORD} xxxxxxxxxxxxxx
Agent Log
2025/05/19 21:30:33.370159 Zabbix Agent 2 stopped. (7.0.0)
2025/05/19 21:33:12.180516 Starting Zabbix Agent 2 (7.0.0)
2025/05/19 21:33:12.183163 OpenSSL library (OpenSSL 3.0.11 19 Sep 2023) initialized
2025/05/19 21:33:12.183163 using configuration file: C:\Program Files\Zabbix Agent 2\zabbix_agent2.conf
2025/05/19 21:33:12.183737 using plugin 'Agent' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.183737 using plugin 'Ceph' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.183737 using plugin 'Cpu' (built-in) providing following interfaces: exporter, collector, runner
2025/05/19 21:33:12.183737 using plugin 'DNS' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.184253 using plugin 'File' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.184253 using plugin 'Log' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.184253 using plugin 'MQTT' (built-in) providing following interfaces: watcher, configurator
2025/05/19 21:33:12.184400 using plugin 'MSSQL' (C:\Program Files\Zabbix Agent 2\zabbix-agent2-plugin-mssql.exe) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184400 using plugin 'Memcached' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184400 using plugin 'Memory' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.184400 using plugin 'Modbus' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.184400 using plugin 'MongoDB' (C:\Program Files\Zabbix Agent 2\zabbix-agent2-plugin-mongodb.exe) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184400 using plugin 'Mysql' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184942 using plugin 'NetIf' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.184942 using plugin 'Oracle' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.184942 using plugin 'PostgreSQL' (C:\Program Files\Zabbix Agent 2\zabbix-agent2-plugin-postgresql.exe) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.185491 using plugin 'Proc' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.185491 using plugin 'Redis' (built-in) providing following interfaces: exporter, runner, configurator
2025/05/19 21:33:12.185491 using plugin 'Registry' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.185491 using plugin 'Smart' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.185491 using plugin 'Sw' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.185491 using plugin 'Swap' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186028 using plugin 'SystemRun' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186028 using plugin 'TCP' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186028 using plugin 'UDP' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186028 using plugin 'Uname' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186028 using plugin 'Uptime' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186028 using plugin 'Users' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186028 using plugin 'VFSDir' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186565 using plugin 'VMemory' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186565 using plugin 'VfsFs' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.186565 using plugin 'WebCertificate' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186565 using plugin 'WebPage' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186565 using plugin 'WindowsEventlog' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.186565 lowering the plugin WindowsPerfInstance capacity to 1 as the configured capacity 1000 exceeds limits
2025/05/19 21:33:12.186565 using plugin 'WindowsPerfInstance' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.187082 using plugin 'WindowsPerfMon' (built-in) providing following interfaces: exporter, collector, runner
2025/05/19 21:33:12.187113 using plugin 'WindowsServices' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.187113 using plugin 'Wmi' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.187113 using plugin 'ZabbixAsync' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.187113 using plugin 'ZabbixStats' (built-in) providing following interfaces: exporter, configurator
2025/05/19 21:33:12.187113 lowering the plugin ZabbixSync capacity to 1 as the configured capacity 1000 exceeds limits
2025/05/19 21:33:12.187113 using plugin 'ZabbixSync' (built-in) providing following interfaces: exporter
2025/05/19 21:33:12.723837 Plugin communication protocol version is 6.4.0
2025/05/19 21:33:12.724371 Zabbix Agent2 hostname: [XXXXXDBWS01]
2025/05/19 21:33:13.741203 [101] cannot connect to [127.0.0.1:10051]: dial tcp :0->127.0.0.1:10051: connectex: No connection could be made because the target machine actively refused it.
2025/05/19 21:33:13.741203 [101] active check configuration update from host [XXXXDBWS01] started to fail
2025/05/19 21:33:13.742759 [101] cannot connect to [127.0.0.1:10051]: dial tcp :0->127.0.0.1:10051: connectex: No connection could be made because the target machine actively refused it.
2025/05/19 21:33:13.742759 [101] sending of heartbeat message for [XXXXDBWS01]] started to fail
2025/05/19 21:33:36.592503 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593036 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593036 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593036 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593036 [MSSQL] Creating new connection to "ssqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593545 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593545 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593545 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/19 21:33:36.593545 [MSSQL] Creating new connection to "ssqlserver://XXXXDBWS01.xxxxx.co.th", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""
2025/05/20 09:19:44.988659 [MSSQL] Creating new connection to "sqlserver://XXXXDBWS01.xxxxx.co.th:1433", with user "zabbixmonit" to database "", with CA certificate "", trust server certificate "", host name in certificate "" encrypt "", TLS min version ""