munin node config for mysql not working
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
munin (Ubuntu) |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
I just installed a fresh Ubuntu 20.04 with mysql and munin.
It previously worked quite well with Ubuntu 18.04, but now the default plugin-
Here is the output of it:
# munin-run mysql_commands
DBI connect(
Warning: the execution of 'munin-run' via 'systemd-run' returned an error. This may either be caused by a problem with the plugin to be executed or a failure of the 'systemd-run' wrapper. Details of the latter can be found via 'journalctl'.
The mysql section in /etc/munin/
[mysql*]
user root
env.mysqlopts --defaults-
env.mysqluser root
env.mysqlconnection DBI:mysql:
which will result in an error using e.g. mysql_commands or so.
Changing this section to...
[mysql*]
user root
env.mysqluser debian-sys-maint
env.mysqlconnection DBI:mysql:
...did the trick for my installation.
The main problem seems to be the mysqluser set to root even though the default file contains only a "debian-sys-maint" user.
I have the same type of access problem for other plug-ins : "File /tmp/rsyncd.log cannot be read." or "/usr/bin/tail: cannot open '/home/[...].csv' for reading: Permission denied"
Everything worked perfectly with Ubuntu server 18.04, the regression happened after updating to Ubunut server 20.04
Would that be an apparmor limitation ?