ODBC Poller logic, how many for monitoring around 20 DB with Template Oracle by ODBC

[jurgen16]

Hello,

How much ODBC pollers should have for monitoring around 20 DB's because I am reaching this trigger: Utilization of ODBC poller processes over 75%, when 2 of them goes down. In that case the trigger is raised and I am receiving from all DB's the trigger "Failed to fetch info...

[Ace]

Hello,

For my odbc discovery use case I've been using calculated item prototypes with the value being the LLD macros from the odbc discovery rule. However calculated item cannot have the item type TEXT, and I need one of those as well.

A solution I found was to first receive...

[solaireofastora]

How can the trigger Oracle Database '{#DBNAME}': Open status in mount mode work if, when the database is in the mounted status, the session cannot log in to the database? All items (including Oracle Database '{#DBNAME}': Open status item ) receive the following error:

Cannot connect to...

[Alfonsomarinu]

Hello

I'm trying to make an item with ODBC Monitoring with a MariaDB server on the cloud with SSL connections configured for security. I followed all the steps in in the Manual,(With the exception of the compiled part since it was downloaded not, compiled) and created my DSN with all the...

[thiomed]

Hello everyone, hope you doing good,
I'm new in monitoring and i start using zabbix, i found it usefull and i want to monitor microsoft sql server using zabbix but whene i add the MSSQL BY ODBC themplate i didn't get any information my server, and everything is configured right i'v trying a week...

[JSERRAHIMA]

Hello,

I'm trying to connect from zabbix to Oracle DB and i follow other post like : https://www.zabbix.com/forum/zabbix-...ring-oracle-db, or external blogs like https://sudonull.com/post/110401-Mon...ODBC-in-Zabbix but i can't get isql working....

[clauclauds]

I install ODBC to monitoring Oracle Database via Zabbix, but I got error :



I did everything on tutorial, here's my config :

/etc/odbcinst.ini :

[OracleDriver]
Description=Oracle ODBC driver for Oracle 11g
Driver=/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1

...

[Ozcan]

Hi,

Currently I created odbc items to check some sql results and triggers. Almost all of them works well and brings data. But here comes the tricky part :
-I started with 2 items first and it was all good ,then another 3 query items came and 2 of them worked well, but last one brings...

[maand]

Hi,
I have extended the official Template DB MSSQL by ODBC to discover agent jobs and triggers for failed jobs with the same structure as the rest of the template and are also going to extend it with discover backups.

Is this something that i can send to Zabbix team somehow to see...

[ideschamps]

Hi,

We are running v5.02 of Zabbix server and Zabbix Proxy. All working good. We now want to monitor our SQL 2017 server which only has Integrated Authentication available and not SQL login/auth. I have followed all the instructions here https://git.zabbix.com/projects/ZBX/...odbc/READ...

[hAh0L13]

Приветствую

Возникла необходимость считать количество новых данных в одной из таблиц MySQL на удаленном сервере. Для этого используется запрос

SELECT count(*) FROM <database>.<table> WHERE datetime_local >= DATE_SUB(NOW(), INTERVAL 1 HOUR) AND datetime_local < n

...

[gvacanti]

I have updated Zabbix to version 3.4 and Ubuntu 18.04. I have a number of database items that have stopped working. In the logs I read

zabbix_server[17362]: error reason for "PC CR3 wet bench:db.odbc.select[ch1,sxro-environment]" changed: Cannot connect to ODBC DSN:[SQL_ERROR]:...

[rburkholder]

I am trying to run the following query from a database monitor item in Zabbix. The query returns the last run date of the specified job as a unix timestamp. The database monitor item keeps becoming unsupported with the following error "cannot fetch row:[SQL_ERROR]:[22003][0][[Microsoft][ODBC Driver...

[arbes]

Zabbix item become unsupported as "Received value [something] is not suitable for value type [Numeric (float)]"

Item type: Database monitor
SQL Query: SELECT 1 FROM DUAL
Type of information: Numeric(float)

Database is Oracle, ODBC driver 12....

[lassi.autio]

I am trying to make ODBC monitoring to remote server's Oracle. However this needs updates to environment variables LD_LIBRARY_PATH and PATH. I updated ~/.profile but I get "Cannot connect to ODBC DSN:[SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver...