Databases

check_firebird.sh

Write a Review

Description:

check_firebird is a Nagios plugin to check a specific Firebird Servers.

check_firebird -u user -p password -H host -a action

Options:
-H/–host)
Host Name of the server
-u/–user)
User name for authentication on Tomcat Manager Application
-p/–password)
Password for authentication on Tomcat Manager Application
-d/–database)
Database
-a/–action)
Actions (connection, timesync, custom_query)
connection – Test connection
timesync – Verifies the connection between the server and the database
custom_query – Customized query. Required –query option
-q/–query)
SQL query returning a specified by –valype value
-v/–valtype)
Specifies the value returned
seconds – expects a value in seconds
-w/–warning and -c/–critical necessary.
days – expects a value in days
-w/–warning and -c/–critical necessary.
integer – expects a value integer
-w/–warning and -c/–critical necessary.
string – under construction
-e/–expected) Expect string

Current Version

0.03

Last Release Date

2014-09-20

Compatible With

  • Nagios 1.x
  • Nagios 2.x
  • Nagios 3.x
  • Nagios 4.x

Owner

Cleberson Borges

Website

https://github.com/clebersonborges/check_firebird/

License

GPL

Copy Page Link Recommend Contact Owner Login to Add to Favorites
Project Files
FileDescription
check_firebird.sh
Project Notes
Performs check in FirebirdSQL server. Checks connection to database Timing checks between FirebirdSQL server and local server time Allows the query of queries with customizable return in: integer or string or seconds or days Plugin development. If you want to help, go https://github.com/clebersonborges/check_firebird Examples (https://github.com/clebersonborges/check_firebird/wiki) Connection /usr/lib/nagios/plugins/check_firebird.sh -H localhost -u SYSDBA -p password -d database -a custom_query -a connection FIREBIRD_CONNECTION OK: DB "database" (host:localhost) successfully established. Timsesync /usr/lib/nagios/plugins/check_firebird.sh -H localhost -u SYSDBA -p password -d database -a custom_query -a timesync -w 1 -c 60 POSTGRES_TIMESYNC WARNING: Database: "database" (host:localhost) timediff=5 DB=2014-09-20 22:24:09.2150 Local=2014-09-20 22:24:14.1411262654 Custom query Integer /usr/lib/nagios/plugins/check_firebird.sh -H localhost -u SYSDBA -p password -d database -a custom_query --query "select count(*) from usuarios;" --valtype integer -w 5 -c 20 Seconds /usr/lib/nagios/plugins/check_firebird.sh -H localhost -u SYSDBA -p password -d database -a custom_query --query "select lastlogin from vw_entry_system;" --valtype seconds -w 30 -c 120 String /usr/lib/nagios/plugins/check_firebird.sh -H localhost -u SYSDBA -p password -d database -a custom_query --query "select * from users;" --valtype string -e "Golias"
Reviews (1) Add a Review
Very usefull plugin
by galaktionovs, May 31, 2015

Thanks to author, he helped me a lot.


Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Page Sections
Project Overview Project Files Project Notes Reviews
Project Stats
Rating
5 (2)
Favorites
0
Views
18,799