Monitoraggio di Microsoft SQL Server con Nagios - Revision history

Gabriele.vivinetto: /* Monitoraggio del risultato di query */

2016-04-06T10:37:02Z

Monitoraggio del risultato di query

← Older revision		Revision as of 10:37, 6 April 2016
Line 71:		Line 71:
	host_name galarchive		host_name galarchive
	service_description CUSTOM-SQL-CHECK		service_description CUSTOM-SQL-CHECK
	check_command check-mssql-query!nagios!secretpasword!backup_results!"SELECT ReturnCode from backup_results~~","~~0"		check_command check-mssql-query!nagios!secretpasword!backup_results!SELECT ReturnCode from backup_results!0
	}		}

Gabriele.vivinetto: /* Monitoraggio del risultato di query */

2016-04-06T10:30:37Z

Monitoraggio del risultato di query

← Older revision		Revision as of 10:30, 6 April 2016
Line 49:		Line 49:
	* Installare lo script:		* Installare lo script:
	sudo mkdir -p /usr/local/lib/nagios/plugins/		sudo mkdir -p /usr/local/lib/nagios/plugins/
	sudo wget "https://exchange.nagios.org/components/com_mtree/attachment.php?link_id=497&cf_id=24" -O /usr/local/lib/nagios/plugins/~~check_mssql-query~~		sudo wget "https://exchange.nagios.org/components/com_mtree/attachment.php?link_id=497&cf_id=24" -O /usr/local/lib/nagios/plugins/check_mssql_query
	sudo chmod -+x /usr/local/lib/nagios/plugins/~~check_mssql-query~~		sudo chmod -+x /usr/local/lib/nagios/plugins/check_mssql_query

	* Definire il check command (attenzione, utilizzare l'FQDN o l'IP, non basta il nome host al check):		* Definire il check command (attenzione, utilizzare l'FQDN o l'IP, non basta il nome host al check):

Gabriele.vivinetto: /* Monitoraggio del risultato di query */

2016-04-06T10:26:01Z

Monitoraggio del risultato di query

← Older revision		Revision as of 10:26, 6 April 2016
Line 46:		Line 46:
	* Installare prerequisiti:		* Installare prerequisiti:
	sudo apt-get install php5-sybase		sudo apt-get install php5-sybase

			* Installare lo script:
			sudo mkdir -p /usr/local/lib/nagios/plugins/
			sudo wget "https://exchange.nagios.org/components/com_mtree/attachment.php?link_id=497&cf_id=24" -O /usr/local/lib/nagios/plugins/check_mssql-query
			sudo chmod -+x /usr/local/lib/nagios/plugins/check_mssql-query

	* Definire il check command (attenzione, utilizzare l'FQDN o l'IP, non basta il nome host al check):		* Definire il check command (attenzione, utilizzare l'FQDN o l'IP, non basta il nome host al check):
Line 54:		Line 59:
	define command {		define command {
	command_name check-mssql-query		command_name check-mssql-query
	command_line ~~$USER1$~~/check_mssql -H $HOSTADDRESS$ -U $ARG1$ -P $ARG2$ -d		command_line /usr/local/lib/nagios/plugins/check_mssql-query -H $HOSTADDRESS$ --username $ARG1$ --password $ARG2$ --database $ARG3$ --query "$ARG4$" --result "$ARG5$"
	$ARG3$ -r "$ARG4$" -q "$ARG5$"		}
	}

	</pre>		</pre>

Line 68:		Line 71:
	host_name galarchive		host_name galarchive
	service_description CUSTOM-SQL-CHECK		service_description CUSTOM-SQL-CHECK
	check_command check-mssql-query!nagios!secretpasword!~~AdDataGal!1~~!SELECT ~~SIGN(OraMinuti-2)*-1 FROM JadiFeed_Scheduler WHERE Tipo='$' AND Modulo='IMMISSION'~~		check_command check-mssql-query!nagios!secretpasword!backup_results!"SELECT ReturnCode from backup_results","0"
	}		}

Gabriele.vivinetto: /* Monitoraggio del risultato di query */

2016-03-30T17:57:44Z

Monitoraggio del risultato di query

← Older revision		Revision as of 17:57, 30 March 2016
Line 43:		Line 43:

	=Monitoraggio del risultato di query=		=Monitoraggio del risultato di query=
	~~{{Stub}}~~

	* Installare prerequisiti:		* Installare prerequisiti:
Line 75:		Line 74:

	==Riferimenti==		==Riferimenti==
	*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/details check_mssql - Nagios Exchange]
	*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/details check_mssql - Nagios Exchange]		*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/details check_mssql - Nagios Exchange]

	[[Category: Published]]		[[Category: Published]]

Gabriele.vivinetto: /* Monitoraggio del risultato di query */

2016-03-30T17:55:25Z

Monitoraggio del risultato di query

← Older revision		Revision as of 17:55, 30 March 2016
Line 45:		Line 45:
	{{Stub}}		{{Stub}}

	* ~~Vedi [https~~:~~//exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/details check_mssql - Nagios Exchange]~~		* Installare prerequisiti:
	* Requires PHP-~~mssql support, usually in the form of a package named "~~php5-sybase~~" or similar.~~		sudo apt-get install php5-sybase

			* Definire il check command (attenzione, utilizzare l'FQDN o l'IP, non basta il nome host al check):

	<pre>		<pre>
Line 58:		Line 60:

	</pre>		</pre>

			* Definire il service da testare:

	<pre>		<pre>
Line 64:		Line 68:
	use generic-service		use generic-service
	host_name galarchive		host_name galarchive
	service_description ~~ADIJED~~-~~ADIFEED~~-~~IMMISSION~~		service_description CUSTOM-SQL-CHECK
	~~#check_command check-mssql-query!nagios!secretpassword!AdDataGal!0!SELECT OraMinuti FROM JadiFeed_Scheduler WHERE Tipo='$' AND Modulo='IMMISSION'~~
	check_command check-mssql-query!nagios!secretpasword!AdDataGal!1!SELECT SIGN(OraMinuti-2)*-1 FROM JadiFeed_Scheduler WHERE Tipo='$' AND Modulo='IMMISSION'		check_command check-mssql-query!nagios!secretpasword!AdDataGal!1!SELECT SIGN(OraMinuti-2)*-1 FROM JadiFeed_Scheduler WHERE Tipo='$' AND Modulo='IMMISSION'
	}		}
Line 73:		Line 76:
	==Riferimenti==		==Riferimenti==
	*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/details check_mssql - Nagios Exchange]		*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/details check_mssql - Nagios Exchange]
			*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/details check_mssql - Nagios Exchange]

			[[Category: Published]]

Gabriele.vivinetto at 16:21, 17 March 2016

2016-03-17T16:21:55Z

← Older revision		Revision as of 16:21, 17 March 2016
Line 41:		Line 41:
	==Riferimenti==		==Riferimenti==
	*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/Check-MSSQL-Database-Stats/details Check MSSQL Database Stats - Nagios Exchange]		*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/Check-MSSQL-Database-Stats/details Check MSSQL Database Stats - Nagios Exchange]

			=Monitoraggio del risultato di query=
			{{Stub}}

			* Vedi [https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/details check_mssql - Nagios Exchange]
			* Requires PHP-mssql support, usually in the form of a package named "php5-sybase" or similar.

			<pre>
			# Check MS SQL SERVER QUERY RESULT
			# check_mssql_server!username!password!database!query!result
			define command {
			command_name check-mssql-query
			command_line $USER1$/check_mssql -H $HOSTADDRESS$ -U $ARG1$ -P $ARG2$ -d
			$ARG3$ -r "$ARG4$" -q "$ARG5$"
			}

			</pre>

			<pre>

			define service{
			use generic-service
			host_name galarchive
			service_description ADIJED-ADIFEED-IMMISSION
			#check_command check-mssql-query!nagios!secretpassword!AdDataGal!0!SELECT OraMinuti FROM JadiFeed_Scheduler WHERE Tipo='$' AND Modulo='IMMISSION'
			check_command check-mssql-query!nagios!secretpasword!AdDataGal!1!SELECT SIGN(OraMinuti-2)*-1 FROM JadiFeed_Scheduler WHERE Tipo='$' AND Modulo='IMMISSION'
			}

			</pre>

			==Riferimenti==
			*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/check_mssql/details check_mssql - Nagios Exchange]

Gabriele.vivinetto: Created page with "=Monitoraggio Connessione= * Installare i requisiti sudo apt-get install python-pymssql * Installare il plugin sudo mkdir -p /usr/local/lib/nagios/plugins sudo wget -O /u..."

2016-03-17T15:54:42Z

Created page with "=Monitoraggio Connessione= * Installare i requisiti sudo apt-get install python-pymssql * Installare il plugin sudo mkdir -p /usr/local/lib/nagios/plugins sudo wget -O /u..."

New page

=Monitoraggio Connessione=

* Installare i requisiti
sudo apt-get install python-pymssql

* Installare il plugin
sudo mkdir -p /usr/local/lib/nagios/plugins
sudo wget -O /usr/local/lib/nagios/plugins/check_mssql_server https://raw.githubusercontent.com/NagiosEnterprises/check_mssql_collection/master/check_mssql_server.py
sudo chmod +x /usr/local/lib/nagios/plugins/check_mssql_server

* Creare un utente SQL con privilegi minimi, ad esempio
username: nagios
password: secretpassword

* Testare il plugin
/usr/local/lib/nagios/plugins/check_mssql_database -H marte -U nagios -P secretpassword

OK: Time to connect was 0.00274610519409s|time=0.00274610519409s;;;;

* Definire il check command:

<pre>
# Check MS SQL SERVER Connection
# check_mssql_server!username!password
define command {
command_name check-mssql-server
command_line /usr/local/lib/nagios/plugins/check_mssql_server -H $HOSTADDRESS$ -U $ARG1$ -P $ARG2$ --time2connect
}
</pre>

* Definire il service check come:
<pre>
define service{
use generic-service
host_name myhost
service_description MSSQL
check_command check-mssql-server!nagios!secretpassword
}

</pre>
==Riferimenti==
*[https://exchange.nagios.org/directory/Plugins/Databases/SQLServer/Check-MSSQL-Database-Stats/details Check MSSQL Database Stats - Nagios Exchange]