Zabbix monitoring a service / app connection to a database

[TheTIGuy]

Good Morning Everyone!

Any ideas are welcome here! Does anyone have any idears on ensuring my connection from my app to database is working? These apps are running as a service on different servers but all reaching back to a sql server. Any help would be appreciated! I am also fairly new to Zabbix!

[cyber]

There is "ping" item for most used sql DB-s available in agent2. mysql.ping, mssql.ping, oracle.ping,pgsql.ping

https://www.zabbix.com/documentation/7.0/en/manual/config/items/itemtypes/zabbix_agent/zabbix_agent2

[TheTIGuy]

There is "ping" item for most used sql DB-s available in agent2. mysql.ping, mssql.ping, oracle.ping,pgsql.ping
https://www.zabbix.com/documentation.../zabbix_agent2

cyber, thank you for responding! I understand I can ping the DB. The biggest issue is we have app's built using services to connect. I need to ensure the service has access to the DB more or less. I would really prefer to write and delete a table / row on the db through the service.

[Manuel Deschambault]

Do you have an API that these apps use to transact with the Database? If so, you can regularly send a bogus command (I often use the famed 'get version') and both see if it responds, and how long it takes.

I basically wrote a shell script (I use bash but any shell script will do) adding a UserParameter, where I do:

1. get parameter of the service to test (passed via an argument to the UserParameter)
2. get timestamp
3. call api with curl command
4. get timestamp
5. parse curl output to confirm proper response
6. Return time to execute (delta between two timestamp) and status of service

This allow my Zabbix to keep track of all my web services and also their response time