X-Git-Url: https://git.tokkee.org/?a=blobdiff_plain;ds=sidebyside;f=plugins%2Fcheck_pgsql.c;h=2dce0b35d2ef533f254fec2f1f93ccc48b618a26;hb=6f53b99720ebe05d801f814fda823ef7c885f869;hp=4c8662bab7029d4bfa5335beea63a074dfbcd351;hpb=0c3386274ef5002dffc20337ef02407f24d7400c;p=nagiosplug.git diff --git a/plugins/check_pgsql.c b/plugins/check_pgsql.c index 4c8662b..2dce0b3 100644 --- a/plugins/check_pgsql.c +++ b/plugins/check_pgsql.c @@ -23,62 +23,18 @@ * *****************************************************************************/ -const char *progname = "check_pgsql" -#define REVISION "$Revision$" -#define COPYRIGHT "1999-2001" -#define AUTHOR "Karl DeBisschop" -#define EMAIL "kdebisschop@users.sourceforge.net" -#define SUMMARY "Tests to see if a PostgreSQL DBMS is accepting connections.\n" - -#define OPTIONS "\ -\[-c critical_time] [-w warning_time] [-t timeout] [-H host]\n\ - [-P port] [-d database] [-l logname] [-p password]" - -#define LONGOPTIONS "\ - -c, --critical=INTEGER\n\ - Exit STATE_CRITICAL if connection time exceeds threshold (default: %d)\n\ - -w, --warning=INTEGER\n\ - Exit STATE_WARNING if connection time exceeds threshold (default: %d)\n\ - -t, --timeout=INTEGER\n\ - Terminate test if timeout limit is exceeded (default: %d)\n\ - -H, --hostname=STRING\n\ - Name or numeric IP address of machine running backend\n\ - -P, --port=INTEGER\n\ - Port running backend (default: %s)\n\ - -d, --database=STRING\n\ - Database to check (default: %s)\n\ - -l, --logname = STRING\n\ - Login name of user\n\ - -p, --password = STRING\n\ - Password (BIG SECURITY ISSUE)\n" - -#define DESCRIPTION "All parameters are optional.\n\ -\n\ -This plugin tests a PostgreSQL DBMS to determine whether it is active and\n\ -accepting queries. In its current operation, it simply connects to the\n\ -specified database, and then disconnects. If no database is specified, it\n\ -connects to the template1 database, which is present in every functioning \n\ -PostgreSQL DBMS.\n\ -\n\ -The plugin will connect to a local postmaster if no host is specified. To\n\ -connect to a remote host, be sure that the remote postmaster accepts TCP/IP\n\ -connections (start the postmaster with the -i option).\n\ -\n\ -Typically, the nagios user (unless the --logname option is used) should be\n\ -able to connect to the database without a password. The plugin can also send\n\ -a password, but no effort is made to obsure or encrypt the password.\n" - #define DEFAULT_DB "template1" #define DEFAULT_HOST "127.0.0.1" -#define DEFAULT_PORT "5432" -#define DEFAULT_WARN 2 -#define DEFAULT_CRIT 8 -#define DEFAULT_TIMEOUT 30 + +enum { + DEFAULT_PORT = 5432, + DEFAULT_WARN = 2, + DEFAULT_CRIT = 8 +}; #include "config.h" #include "common.h" #include "utils.h" -#include #include int process_arguments (int, char **); @@ -90,7 +46,7 @@ int is_pg_logname (char *); char *pghost = NULL; /* host name of the backend server */ char *pgport = NULL; /* port of the backend server */ -char default_port[4] = DEFAULT_PORT; +int default_port = DEFAULT_PORT; char *pgoptions = NULL; char *pgtty = NULL; char dbName[NAMEDATALEN] = DEFAULT_DB; @@ -101,6 +57,11 @@ int tcrit = DEFAULT_CRIT; PGconn *conn; /*PGresult *res;*/ + +const char *progname = "check_pgsql"; +const char *revision = "$Revision$"; +const char *copyright = "1999-2003"; +const char *email = "nagiosplug-devel@lists.sourceforge.net"; /****************************************************************************** @@ -156,6 +117,76 @@ Please note that all tags must be lowercase to use the DocBook XML DTD. Functions -@@ ******************************************************************************/ + + + + +void +print_help (void) +{ + char *myport; + + asprintf (&myport, "%d", DEFAULT_PORT); + + print_revision (progname, revision); + + printf (_(COPYRIGHT), copyright, email); + + printf (_("Test whether a PostgreSQL DBMS is accepting connections.\n\n")); + + print_usage (); + + printf (_(UT_HELP_VRSN)); + + printf (_(UT_HOST_PORT), 'P', myport); + + printf (_(UT_IPv46)); + + printf (S_("\ + -d, --database=STRING\n\ + Database to check (default: %s)\n\ + -l, --logname = STRING\n\ + Login name of user\n\ + -p, --password = STRING\n\ + Password (BIG SECURITY ISSUE)\n"), DEFAULT_DB); + + printf (_(UT_WARN_CRIT)); + + printf (_(UT_TIMEOUT), DEFAULT_SOCKET_TIMEOUT); + + printf (_(UT_VERBOSE)); + + printf (S_("\nAll parameters are optional.\n\ +\n\ +This plugin tests a PostgreSQL DBMS to determine whether it is active and\n\ +accepting queries. In its current operation, it simply connects to the\n\ +specified database, and then disconnects. If no database is specified, it\n\ +connects to the template1 database, which is present in every functioning \n\ +PostgreSQL DBMS.\n")); + printf (S_("\n\ +The plugin will connect to a local postmaster if no host is specified. To\n\ +connect to a remote host, be sure that the remote postmaster accepts TCP/IP\n\ +connections (start the postmaster with the -i option).\n")); + printf (S_("\n\ +Typically, the nagios user (unless the --logname option is used) should be\n\ +able to connect to the database without a password. The plugin can also send\n\ +a password, but no effort is made to obsure or encrypt the password.\n")); + + support (); +} + +void +print_usage (void) +{ + printf (S_("\ +Usage:\n %s [-H ] [-P ] [-c ] [-w ]\n\ + [-t ]"), progname); + printf (S_("[-d ] [-l ] [-p ]\n")); + printf (S_("\ + %s (-h | --help) for detailed help\n\ + %s (-V | --version) for version information\n"), + progname, progname); +} int main (int argc, char **argv) @@ -175,7 +206,7 @@ main (int argc, char **argv) /* Set signal handling and alarm */ if (signal (SIGALRM, timeout_alarm_handler) == SIG_ERR) { - printf ("Cannot catch SIGALRM"); + printf (_("Cannot catch SIGALRM")); return STATE_UNKNOWN; } alarm (timeout_interval); @@ -189,64 +220,37 @@ main (int argc, char **argv) /* check to see that the backend connection was successfully made */ if (PQstatus (conn) == CONNECTION_BAD) { - printf ("PGSQL: CRITICAL - no connection to '%s' (%s).\n", dbName, + printf (_("PGSQL: CRITICAL - no connection to '%s' (%s).\n"), dbName, PQerrorMessage (conn)); PQfinish (conn); return STATE_CRITICAL; } else if (elapsed_time > tcrit) { PQfinish (conn); - printf ("PGSQL: CRITICAL - database %s (%d sec.)\n", dbName, + printf (_("PGSQL: CRITICAL - database %s (%d sec.)\n"), dbName, elapsed_time); return STATE_CRITICAL; } else if (elapsed_time > twarn) { PQfinish (conn); - printf ("PGSQL: WARNING - database %s (%d sec.)\n", dbName, elapsed_time); + printf (_("PGSQL: WARNING - database %s (%d sec.)\n"), dbName, elapsed_time); return STATE_WARNING; } else { PQfinish (conn); - printf ("PGSQL: ok - database %s (%d sec.)\n", dbName, elapsed_time); + printf (_("PGSQL: ok - database %s (%d sec.)\n"), dbName, elapsed_time); return STATE_OK; } } - -void -print_help (void) -{ - print_revision (progname, REVISION); - printf - ("Copyright (c) %s %s <%s>\n\n%s\n", - COPYRIGHT, AUTHOR, EMAIL, SUMMARY); - print_usage (); - printf - ("\nOptions:\n" LONGOPTIONS "\n" DESCRIPTION "\n", - DEFAULT_WARN, DEFAULT_CRIT, DEFAULT_TIMEOUT, DEFAULT_PORT, DEFAULT_DB); - support (); -} - -void -print_usage (void) -{ - printf ("Usage:\n" " %s %s\n" - " %s (-h | --help) for detailed help\n" - " %s (-V | --version) for version information\n", - progname, OPTIONS, progname, progname); -} - - - /* process command-line arguments */ int process_arguments (int argc, char **argv) { int c; -#ifdef HAVE_GETOPT_H int option_index = 0; static struct option long_options[] = { {"help", no_argument, 0, 'h'}, @@ -262,61 +266,57 @@ process_arguments (int argc, char **argv) {"database", required_argument, 0, 'd'}, {0, 0, 0, 0} }; -#endif while (1) { -#ifdef HAVE_GETOPT_H c = getopt_long (argc, argv, "hVt:c:w:H:P:d:l:p:a:", long_options, &option_index); -#else - c = getopt (argc, argv, "hVt:c:w:H:P:d:l:p:a:"); -#endif + if (c == EOF) break; switch (c) { case '?': /* usage */ - usage3 ("Unknown argument", optopt); + usage3 (_("Unknown argument"), optopt); case 'h': /* help */ print_help (); exit (STATE_OK); case 'V': /* version */ - print_revision (progname, REVISION); + print_revision (progname, revision); exit (STATE_OK); case 't': /* timeout period */ if (!is_integer (optarg)) - usage2 ("Timeout Interval must be an integer", optarg); + usage2 (_("Timeout Interval must be an integer"), optarg); timeout_interval = atoi (optarg); break; case 'c': /* critical time threshold */ if (!is_integer (optarg)) - usage2 ("Invalid critical threshold", optarg); + usage2 (_("Invalid critical threshold"), optarg); tcrit = atoi (optarg); break; case 'w': /* warning time threshold */ if (!is_integer (optarg)) - usage2 ("Invalid critical threshold", optarg); + usage2 (_("Invalid critical threshold"), optarg); twarn = atoi (optarg); break; case 'H': /* host */ if (!is_host (optarg)) - usage2 ("You gave an invalid host name", optarg); + usage2 (_("You gave an invalid host name"), optarg); pghost = optarg; break; case 'P': /* port */ if (!is_integer (optarg)) - usage2 ("Port must be an integer", optarg); + usage2 (_("Port must be an integer"), optarg); pgport = optarg; break; case 'd': /* database name */ if (!is_pg_dbname (optarg)) - usage2 ("Database name is not valid", optarg); + usage2 (_("Database name is not valid"), optarg); strncpy (dbName, optarg, NAMEDATALEN - 1); dbName[NAMEDATALEN - 1] = 0; break; case 'l': /* login name */ if (!is_pg_logname (optarg)) - usage2 ("user name is not valid", optarg); + usage2 (_("user name is not valid"), optarg); pguser = optarg; break; case 'p': /* authentication password */