How to create a database monitor item with api

[KBlasz]

Hello,

I am a bit stuck. i cant seem to find a way to create a database monitor item via the API.

I have working ODBC checks but i would like to automate the createtion with the API

This is the json code i am trying to use but no luck. i am just getting "data=incorrect...

[Sven]

Hi All!

I have an Oracle ODBC template (from the templates repository) which I use across a variety of Oracle 10, 11, 12 systems and all is well.

We had a network outage that caused one database on one server to go offline at approx. 07:22

The ODBC queries appear...

[Gadg3ts]

For the 'official' template that lives here
https://git.zabbix.com/projects/ZBX/...mysql_odbc.xml
I'm basically looking for the format of {$MYSQL.DSN}
I've tried it as
mysql:host=mysql or host=mysql
(the db server host is actually called "mysql")
as that...

[doum]

Hi,

I'm trying to monitor our Oracle DB with the template here https://share.zabbix.com/databases/o...late-oracle-db

I didn't understand at first, but a priori if I'm not mistaken the odbc monitoring is not done by the agent on the server, but directly by the zabbix...

[Derroy]

Hi Guys!
I've Zabbix-server version: 4.2.6, Debian 10 and I want a monitore data in database (MariaDB Ver 15.1 10.3.17) on remote server, so I used ODBC mysql. This is my configure:

1. I install unixodbc and unixodbc-dev
2. Set 2 file's odbc.ini and odbcinst.ini

...

[zaicnupagadi]

-THIS HAS BEEN SOLVED - SEE MY LAST UPDATE FOR WHAT WAS THE RESOLUTION.-

Hey,

I already monitor MS SQL and PostgreSQL with success, wanted to add MySQL.

My environmet looks like this:

UBUNTU: Linux version 4.15.0-48-generic (buildd@lgw01-amd64-036)...

[wentura]

Добрый день
Запрос в бызу данных db.odbc.discovery[DESCRIPTION,DSN] выдает строку формат ниже:
{"data":[{"{#TS_ISSUEID}":"359213"},{"{#TS_ISSUEID}":"35921 6"},{"{#TS_ISSUEID}":"360787"}]}...

[hAh0L13]

Приветствую

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

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

...

[BlackCrystal]

i wanto create an odbc discovery for a host ( not template ). on my host i have 2 databases named sample and info. should i replace dsn with for example info?
i mean if i write my sql sever zabbix agen is going to execute that on which database?
or dsn is completly sth else?

[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]:...

[nova]

[root@SqlRun ~]# isql -v zabbix
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit ...

[hutknansen]

Hi everyone,

i just tried to monitor an SQL query on a Zabbix agent monitored host with ODBC and noticed the error in Zabbix Server "Could not find DSN".

So i tried to put the ODBC configuration on the server and the error message changed to "Can't connect...

[ITguru]

Hi guys

I need your help. I am trying to monitor an Oracle database.
My Zabbix (3.0.7) is running on Ubuntu 14.04.

Thats what I already did:
- I installed "unixODBC" and the "Oracle Instant Client" on my server.
- I configured /etc/odbc.ini...

[lebriquet]

После апгрейда с 3.0.4 на 3.2 все ODBC-проверки (Oracle) стали возвращать...

[git2sbd]

Hi dears,

I try to connect in informix database by ODBC.

I installed e configured the client of Informix and profile's (Root and Zabbix)
but the following error ocurred:

Cannot connect to ODBC DSN:[SQL_ERROR]:[HY000][-11041][[unixODBC][Informix][Informix...