System Administrator's Guide/Monitoring Mahara with Munin
Courtesy of Lancaster University CIS, Munin plugin for generating various Mahara stats is available for download on GitHub. This is a multigraph wildcard Munin plugin, that allows you to gather some useful statistics from Mahara database and represent it in the nice graphs. Among the graphs it generates are:
- Currently logged-in users
- Disk usage
- Users's activity
The plugin can be used with Mahara 1.5 and above. It works with PostgreSQL database only at the moment.
You need to have Munin installed and configured on your system. This is beyond the scope of this discussion, please use Munin documentation for more information.
To make this work, you have to install plugin, create plugin configuration file and then create a symlink to plugin that reflects the name of the Moodle database.
You can clone using git or download the plugin from GitHub, unpack (if you downloaded it) and copy to either Munin standard plugins directory (i.e. /usr/share/munin/plugins/) or custom directory if you want to keep custom plugins separate.
mv /tmp/mahara_ /usr/share/munin/plugins/mahara_
You need to create configuration file in plugin-conf.d directory, it's usually located in /etc/munin/. There is no specific requirements for configuration file name, but it is better to call it mahara for convenience. The configuration may contain standard Munin plugin configuration attributes, libpq environment variables for configuring database connection settings (e.g. PGUSER, PGHOST, etc.) and plugin-specific settings. Generally, it is easier if you run the the plugin directly on the database server as postgres user. In this case the minimum configuration will look like:
[mahara_*] user postgres
If your plugin located on the different server, it will need an additional settings to accessing Mahara database. Given that plugin is using Munin::Plugin::Pgsql library, it supports all libpq variables, the most common of them are:
- PGHOST - hostname to connect to
- PGPORT - port number to connect to
- PGUSER - username to connect as
- PGPASSWORD - password to connect with, if a password is required
For using these variables in the plugin configuration, you need to pass them as environment setting, i.e. prepend them with env.
[mahara_*] user root env.PGHOST your_db_hostname env.PGUSER your_db_username env.PGPASSWORD your_db_password
Plugin also has some own configuration variables that need to be set as environment setting as well if you wish using them:
- env.updatetime - you may configure the period for which the time-based data is calculated (e.g. used in the number of logged-in users reporting or assignments submissions). By default the value of 300 sec is used (which is 5 min Munin default update interval).
- env.dbprefix - if you use prefix in Mahara database tables, pass the correct one using this parameter.
- env.showdefaultpages - whether to show default/system pages on the graph (user dashboard, user profile, group home page). Can be enabled by setting this variable to 1. Disabled by default.
For more information on Munin plugins configuration see corresponding Munin wiki page.
The final bit that needs to be done is to create a symlink to the plugin in /etc/munin/plugins directory. Being a wildcard plugin, Mahara plugin will attempt to determine the database name it will be using from the symlink, thus the symlink need to contain the name of the Mahara database:
ln -s /usr/share/munin/plugins/mahara_ /etc/munin/plugins/mahara_yourmaharadatabasename
ls -la command run in /usr/share/munin/plugins directory will display that the symlink is correct:
lrwxrwxrwx 1 root root 52 Nov 21 16:29 mahara_mahara-db -> /usr/share/munin/plugins/mahara_
The database name in the example above is mahara-db
The wildcard plugin concept is especially useful for large scale systems when you have more than one Mahara database on the same database server. I this case you may create symlink for each Mahara database on the same system and have them all monitored.
Testing configuration and plugin
You will need to restart munin node on the client to make sure it picked up new plugins. Now, you may see what the plugin outputs when it is being queried by Munin service:
~# munin-run mahara_mahara-db
will output the current data values for each graph
multigraph maharausers users.value 1 multigraph maharapages groupportfolio.value 42 instportfolio.value 1 userportfolio.value 531 ...
to see the graphs configuration that plugin returns run
~# munin-run mahara_mahara-db config
You may read more about plugin debugging in Munin wiki document.
Some useful hints
You may set up warning and critical thresholds for particular services on the Munin server side. When one of the values will be above defined limits, the service will be highlighted in the Munin web interface. You may elaborate this further and set up various alerts. For more info see page.
Note for developers
This Munin Mahara plugin is using Munin::Plugin::Pgsql library, which makes it work with PostgreSQL database only at the moment. It is also a multigraph plugin which allows to keep all the graphs generation code within the same file. The wildcard plugin functionality is implemented the way that it takes database name from the symlink.
You are more than welcome to contribute to this work and create pull request for integration of your changes.