munin mysql_ plugin not working: Cache::Cache

[gilthanaz]

[Problem]
If you try to use the mysql_ plugin(s) with munin, you receive errors about "Cache::Cache" missing.
E.g. "Missing dependency Cache::Cache at ./mysql_"

[Solution]
For some reason, a package that the mysql_ plugin is depending on is not installed as a munin prerequisite. Install the package:

Code: Select all

 apt-get install libcache-cache-perl

Executing:

Code: Select all

munin-node-configure --suggest

should then return something like:

Code: Select all

 mysql_                     | yes  | yes (commands connections files_tables innodb_bpool innodb_bpool_act innodb_insert_buf innodb_io innodb_io_pend innodb_log innodb_rows innodb_semaphores innodb_tnx myisam_indexes network_traffic qcache qcache_mem select_types slow sorts table_locks tmp_tables +bin_relay_log +replication)

If you get an error message there regarding access rights, thats a different topic and solved by checking the plugin configuration. The default location for that is in /etc/munin/plugin-conf.d/munin-node and the [mysql*] section should give you a very good idea of what to do next