Percona NRPE Install (MySQL) - Revision history

Sstrutt: /* Percona Repository */ Updated

2019-03-15T08:57:46Z

Percona Repository: Updated

← Older revision		Revision as of 08:57, 15 March 2019
Line 5:		Line 5:
	If you don't have it available already, you'll need to add the Percona repository (if it is you should have the following file - <code>/etc/apt/sources.list.d/percona-release.list</code>		If you don't have it available already, you'll need to add the Percona repository (if it is you should have the following file - <code>/etc/apt/sources.list.d/percona-release.list</code>
	# Download appropriate pagckage		# Download appropriate pagckage
	#* <code> wget https://repo.percona.com/apt/percona-~~release_0.1-4~~.$(lsb_release -sc)_all.deb </code>		#* <code> wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb </code>
	# Install package		# Install package
	#* <code> dpkg -i percona-~~release_0.1-4~~.$(lsb_release -sc)_all.deb </code>		#* <code> dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb </code>
			# Enable the repository
			#* <code>percona-release setup ps80</code>
	# Update cache		# Update cache
	#* <code> apt-get update </code>		#* <code> apt-get update </code>

Sstrutt: /* Plugin Setup */ Updated

2016-12-02T09:26:46Z

Plugin Setup: Updated

← Older revision		Revision as of 09:26, 2 December 2016
Line 22:		Line 22:

	== Plugin Setup ==		== Plugin Setup ==
			Change the user/pass used in the example below
	# Append checks to NRPE config file (see below - change user/pass as required)		# Append checks to NRPE config file (see below - change user/pass as required)
	#* <code> vi /usr/local/nagios/etc/nrpe.cfg </code>		#* <code> vi /usr/local/nagios/etc/nrpe.cfg </code>
Line 29:		Line 30:
	#* <code> mysql -u root -p </code>		#* <code> mysql -u root -p </code>
	#* <code> GRANT SELECT, PROCESS, SUPER ON . to 'nagios'@'localhost' IDENTIFIED BY 'nagios123'; </code>		#* <code> GRANT SELECT, PROCESS, SUPER ON . to 'nagios'@'localhost' IDENTIFIED BY 'nagios123'; </code>
			# Create credentials config file for checks to use
			#* <code> vi /etc/nagios/mysql.cnf </code>
			#* Add the following lines
			#* <code> [client] </code>
			#* <code> user = nagios </code>
			#* <code> password = nagios123 </code>
			# Change owner and permissions of credentials config file
			#* <code> chown root:nagios /etc/nagios/mysql.cnf </code>
			#* <code> chmod 640 /etc/nagios/mysql.cnf </code>

	<pre>		<pre>
	# MySQL checks		# Example MySQL checks
	~~command[check_mysql]=/usr/lib64/nagios/plugins/check_mysql -u nagios -p nagios123~~		command[check_mysql_status]=/usr/lib64/nagios/plugins/pmp-check-mysql-status $ARG1$
	command[check_mysql_status]=/usr/lib64/nagios/plugins/pmp-check-mysql-status ~~-l nagios -p nagios123~~ $ARG1$		command[check_mysql_processlist]=/usr/lib64/nagios/plugins/pmp-check-mysql-processlist
	command[check_mysql_processlist]=/usr/lib64/nagios/plugins/pmp-check-mysql-processlist ~~-l nagios -p nagios123~~		command[check_mysql_innodb]=/usr/lib64/nagios/plugins/pmp-check-mysql-innodb -C $ARG1$
	command[check_mysql_innodb]=/usr/lib64/nagios/plugins/pmp-check-mysql-innodb ~~-l nagios -p nagios123~~ -C $ARG1$		command[check_mysql_status_uptime]=/usr/lib64/nagios/plugins/pmp-check-mysql-status x Uptime -C '<' -w $ARG1$ -c $ARG2$
	command[check_mysql_status_uptime]=/usr/lib64/nagios/plugins/pmp-check-mysql-status ~~-l nagios -p nagios123 -~~x Uptime -C '<' -w $ARG1$ -c $ARG2$		command[check_mysql_status_connx]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -x Threads_connected -o / -y max_connections -T pct -w $ARG1$ -c $ARG2$
	command[check_mysql_status_connx]=/usr/lib64/nagios/plugins/pmp-check-mysql-status ~~-l nagios -p nagios123~~ -x Threads_connected -o / -y max_connections -T pct -w $ARG1$ -c $ARG2$		command[check_mysql_status_threadrun]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -x Threads_running -w $ARG1$ -c $ARG2$
	command[check_mysql_status_threadrun]=/usr/lib64/nagios/plugins/pmp-check-mysql-status ~~-l nagios -p nagios123~~ -x Threads_running -w $ARG1$ -c $ARG2$		command[check_mysql_slave_running]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-running
	command[check_mysql_slave_running]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-running ~~-l nagios -p nagios123~~		command[check_mysql_slave_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay
	command[check_mysql_slave_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay ~~-l nagios -p nagios123~~
	</pre>		</pre>

Sstrutt: Added Ubuntu install

2016-12-01T17:48:00Z

Added Ubuntu install

@@ Line 1: / Line 1: @@
-Instructions on installed the Percona NRPE plugin in order to be able to monitor a MySQL server from Nagios. See the following page form more info - https://www.percona.com/doc/percona-monitoring-plugins/1.0/nagios/index.html
+Instructions on installed the Percona NRPE plugin in order to be able to monitor a MySQL server from Nagios. See the following page for more info - https://www.percona.com/doc/percona-monitoring-plugins/1.1/nagios/index.html
 # Add the Percona repository
 #* <code> yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm </code>
 # Install the Percona NRPE Nagios plugins
 #* <code>  yum install percona-nagios-plugins percona-toolkit</code>
 # Append checks to NRPE config file (see below - change user/pass as required)
 #* <code> vi /usr/local/nagios/etc/nrpe.cfg </code>
@@ Line 46: / Line 63: @@
 [[Category:Nagios]]
 [[Category:NRPE]]

Sstrutt: Added NRPE category

2016-11-30T09:30:43Z

Added NRPE category

← Older revision		Revision as of 09:30, 30 November 2016
Line 38:		Line 38:

	{{#seo:		{{#seo:
	\|title=Percona MySQL NRPE ~~plgin~~ install		\|title=Percona MySQL NRPE plugin install
	\|keywords=mysql,nrpe,nagios,monitor, percona		\|keywords=mysql,nrpe,nagios,monitor,percona, plugin
	\|description=Instructions on ~~installed~~ the Percona NRPE plugin in order to be able to monitor a MySQL server from Nagios		\|description=Instructions on installing the Percona NRPE plugin in order to be able to monitor a MySQL server from Nagios
	}}		}}

	[[Category:MySQL]]		[[Category:MySQL]]
	[[Category:Nagios]]		[[Category:Nagios]]
			[[Category:NRPE]]

Sstrutt: Typo fix

2016-09-26T16:05:00Z

Typo fix

← Older revision		Revision as of 16:05, 26 September 2016
Line 44:		Line 44:

	[[Category:MySQL]]		[[Category:MySQL]]
	[[Category:Nagios]		[[Category:Nagios]]

Sstrutt: Initial creation

2016-09-26T16:04:44Z

Initial creation

New page

Instructions on installed the Percona NRPE plugin in order to be able to monitor a MySQL server from Nagios. See the following page form more info - https://www.percona.com/doc/percona-monitoring-plugins/1.0/nagios/index.html

# Add the Percona repository
#* <code> yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm </code>
# Install the Percona NRPE Nagios plugins
#* <code> yum install percona-nagios-plugins percona-toolkit</code>
# Append checks to NRPE config file (see below - change user/pass as required)
#* <code> vi /usr/local/nagios/etc/nrpe.cfg </code>
# Check NRPE is set to allow parameters
#* <code> dont_blame_nrpe=1</code>
# Create MySQL user
#* <code> mysql -u root -p </code>
#* <code> GRANT SELECT, PROCESS, SUPER ON *.* to 'nagios'@'localhost' IDENTIFIED BY 'nagios123'; </code>

<pre>
# MySQL checks
command[check_mysql]=/usr/lib64/nagios/plugins/check_mysql -u nagios -p nagios123
command[check_mysql_status]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -l nagios -p nagios123 $ARG1$
command[check_mysql_processlist]=/usr/lib64/nagios/plugins/pmp-check-mysql-processlist -l nagios -p nagios123
command[check_mysql_innodb]=/usr/lib64/nagios/plugins/pmp-check-mysql-innodb -l nagios -p nagios123 -C $ARG1$
command[check_mysql_status_uptime]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -l nagios -p nagios123 -x Uptime -C '<' -w $ARG1$ -c $ARG2$
command[check_mysql_status_connx]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -l nagios -p nagios123 -x Threads_connected -o / -y max_connections -T pct -w $ARG1$ -c $ARG2$
command[check_mysql_status_threadrun]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -l nagios -p nagios123 -x Threads_running -w $ARG1$ -c $ARG2$
command[check_mysql_slave_running]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-running -l nagios -p nagios123
command[check_mysql_slave_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay -l nagios -p nagios123
</pre>

== NRPE Compiled Without Argument Support ==
Sometime Nagios has been compiled and installed so that it will never accept arguments (regardless of <code>dont_blame_nrpe</code> config).
<pre>
cd /root/nrpe/nrpe-2.13/
./configure --enable-command-args
/etc/init.d/nrpe stop
make
make install
/etc/init.d/nrpe start
</pre>

{{#seo:
|title=Percona MySQL NRPE plgin install
|keywords=mysql,nrpe,nagios,monitor, percona
|description=Instructions on installed the Percona NRPE plugin in order to be able to monitor a MySQL server from Nagios
}}

[[Category:MySQL]]
[[Category:Nagios]