[arch-general] Fwd: Munin and MySQL

[Martín Cigorraga]

---------- Forwarded message ----------
From: Martín Cigorraga <martincigorraga at gmail.com>
Date: Mon, Sep 17, 2012 at 7:32 AM
Subject: Re: [arch-general] Munin and MySQL
To: General Discussion about Arch Linux <arch-general at archlinux.org>



On Mon, Sep 17, 2012 at 6:42 AM, Martín Cigorraga <martincigorraga at gmail.com
> wrote:

> On Mon, Sep 17, 2012 at 5:58 AM, Krzysztof Warzecha <kwarzecha7 at gmail.com>wrote:
>
>> 2012/9/17 Martín Cigorraga <msx at archlinux.us>:
>> > Whenever I run:
>> > # munin-node-configure --shell | sh
>> > I got this:
>> > # The following plugins caused errors:
>> > # mysql_:
>> > #       Non-zero exit during autoconf (2)
>> > # ntp_states:
>> > #       Non-zero exit during autoconf (2)
>> > # proc:
>> > #       In family 'auto' but doesn't have 'autoconf' capability
>>
>> Try:
>>
>> /usr/lib/munin/plugins/mysql_ suggest
>>
>> If in doubt, read plugin source. This one needs some extra perl
>> packages (it will show helpful error message if dependencies are
>> missing), configuration in /etc/munin/plugin-conf.d/ (in existing or
>> new file, no difference) and meaningful symlink name. If you want to
>> install that plugin manually try something like this:
>>
>> ln -s /usr/lib/munin/plugins/mysql_ /etc/munin/plugins/mysql_$GRAPH
>>
>> Where $GRAPH is one from: (bin_relay_log, 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,
>> replication, select_types, slow, sorts, table_locks, tmp_tables).
>>
>> --
>> Krzysztof Warzecha
>>
>
> Mmm, things are starting to clarify... ;-)
> As you correctly said the mysql_ plugin needs the community/perl-dbi
> package and a Cache::Cache module (Missing dependency Cache::Cache at
> /usr/lib/munin/plugins/mysql_ line 729.) I'm gonna install from CPAN.
> Once I get this working I think I should fill a bug report to add these
> libraries as optdepend to munin-node package.
> Munin is plain awesome, thanks for the tips!
>

Finally, I managed to install and run mysql_ and ntp_states plugins.
mysql_: needs community/perl-dbi package and "Cache::Cache" module -
available through CPAN.
 ntp_states: needs "Net::DNS::Resolver" module, available through CPAN too.

Still I'm having this error message for proc when I do:
/usr/lib/munin/plugins # munin-node-configure --shell | sh
# The following plugins caused errors:
# proc:
#       In family 'auto' but doesn't have 'autoconf' capability

But on the other side
~ $ sudo munin-run --servicedir /usr/lib/munin/plugins/ proc
multigraph proc_cpu

multigraph proc_memory

multigraph proc_ctxt_switches

multigraph proc_threads

multigraph proc_processes

multigraph proc_io


I will check the plugin as soon as I get some sleep - Perl is beautiful...
and cryptic at times!

Note: I opened a new bug report - FS#31579 - community/perl-dbi pkg should
be added to muni-node optdepends <https://bugs.archlinux.org/task/31579>