Skip to main content Logo (IEC resistor symbol)logo

Quis custodiet ipsos custodes?
Home | About | All pages | RSS Feed | Gopher

Munin - Fix MySQL plugin on Ubuntu 12.04 and Debian 6

Published: 02-02-2013 | Author: Remy van Elst | Text only version of this article

Table of Contents

On Ubuntu and Debian (12.04/6) the munin plugins which graphs mysql by defaultgives the following error:

Missing dependency Cache::Cache at /usr/share/munin/plugins/mysql_ line 716.

If you like this article, consider sponsoring me by trying out a Digital OceanVPS. With this link you'll get $100 credit for 60 days). (referral link)

This is because a Perl cache package is needed. In the repositories there aretwo of those packages. Install them both:

## Execute as rootapt-get install libcache-{perl,cache-perl} 

Now generate the munin plugin config again:

## Execute as rootmunin-node-configure --suggest --shell | sh

And restart the munin-node service:

## Execute as root/etc/init.d/munin-node restart

The graphs should now appear. If not, you might need to manually symlink themunin mysql plugins from /usr/share/munin/plugins/ to /etc/munin/plugins/.

If you need to define another user for MySQL, configure /etc/munin/plugin-conf.d/munin-node with the following settings:

[mysql*]user rootenv.mysqluser monitoringenv.mysqlpassword MyOwnSuperSecretPassword

Altough on Ubuntu and Debian this should run via the debian maintenance user.

Tags: debian, monitoring, munin, mysql, snippets, ubuntu