I recently upgraded Ubuntu from 14.04 to 20.04 and so upgraded check_mk from 1.2.6p12 to 1.6.0p17.
We were having plugin issue and was getting the error :
Services of Host master2-zdt-preprod
/omd/sites/preprod/local/lib/nagios/plugins/pmp-check-mysql-innodb: 167: mysql: not found
Hence we installed the latest third party plugin “percona-monitoring-plugins-1.1.8”.
Now we need to configure this in the check_mk.
Hi,
there are two different things at this point. First, if you want to use the nagios plugin, you need to install the mysql libraries in your system.
The second thing, the monitoring plugins you describe are nagios plugins. You need to copy the command sto ~/local/lib/nagios/plugins in your side.
Are you sure you need this 3rd party plugin at all?
I’m using MariaDB, not Percona, but for me, the built-in mysql checks already return a lot of information:
On Debian, I usually just
deploy the mk_mysql agent plugin on the MySQL server
add a symlink /etc/check_mk/mysql.cfg -> /etc/mysql/debian.cnf so I don’t have to create a separate monitoring user (I’m running the agent as root)