Database Monitoring With Zabbix

[tammyt]

Hello

I have quite a challenge and hope someone can help me

We have to monitor the requests received by our system, from a Mysql database, BUT, it has to bring more than one line

Example:

ID:....
Status:...
Message:....
Source:...
(this is how the data gets in the db)

How can I bring all this data to Zabbix, as, by default, it gets only one line and one row?

Peace (:

[GPegel]

As mentioned in the documentation: The query must return one value only.

To be able to extract all the data you have to create multiple items. One item for each field. So in your case 4 items with a query.

And you need to install ODBC to connect to the database.

please check this document: https://www.zabbix.com/documentation...es/odbc_checks

[tammyt]

Thanks for your answe, @GPegel!

I had a look at this document, and we use odbc monitoring for a lot of items here.
Was just thinking if it was not possible with an external script. Maybe shell (the only language I know )

There is a way to do it in zabbix besides the classic way?

Thanks (:

[GPegel]

What about this idea: in shell create a query that parses the output to a file and let Zabbix read that file as known as Log File monitoring?

[SBO]

Or you can use zabbix_sender to send the data to your zabbix server..

https://www.zabbix.com/documentation/3.2/manpages/zabbix_sender