check_mysql.ncfg contains incorrect regexes

[David Banks]

Binary package hint: nagiosgrapher

The graph definitions provided in the /etc/nagiosgrapher/ngraph.d/standard/check_mysql.ncfg file are incorrect with respect to the output of the check_mysql command shipped with the nagios3 package.

The discrepancies are:

In page "Threads":
        graph_perf_regex diff=(\d+)

From a brief inspection, the shipped check_mysql command doesn't provide any perfdata so this won't work at all.

In page "Open_Tables":
        graph_log_regex Opentables:\s*(\d+)

Should be a space between 'Open' and 'tables'.

In page "Flush_Tables":
        graph_log_regex Flushtables:\s*(\d+)

Should be a space between 'Flush' and 'tables'.

This bug is slightly more severe than it initially seems as it not only disables the offending pages of the graph but it in fact breaks graphing for the entire service. Of course, the user will need to edit this file anyway (to change the service name from 'mysql-info'), but it would probably save users some hairy debugging work to make these changes for them.

$ lsb_release -rd
Description: Ubuntu 10.04.1 LTS
Release: 10.04

$ apt-cache policy nagiosgrapher
nagiosgrapher:
  Installed: 1.7.1-1
  Candidate: 1.7.1-1
  Version table:
 *** 1.7.1-1 0
        500 http://gb.archive.ubuntu.com/ubuntu/ lucid/universe Packages
        100 /var/lib/dpkg/status