Overview

mmMySQL started life as a Macro for viewing MySQL Server Status and Variables from anywhere in your Wiki. Where will it go from here? Who knows.....

Requirements

• Python 2.5 (ElementTree Module required for Python 2.4)

• MySQLdb

• MoinMoin Wiki

Installation

The first step in installing the mmMySQL macro is to create an account on your MySQL server that you will use to obtain Status/Variables. The procedure for creating such an account is straightforward and can be done as follows:

MySQL server is located on same server as your MoinMoin Wiki

mysql> CREATE USER 'monitor'@'localhost' IDENTIFIED BY 'M0n1t0$';

MySQL server is located on another server remote to your MoinMoin Wiki

mysql> CREATE USER 'monitor'@'IP OF YOUR MOIN MOIN SERVER GOES HERE' IDENTIFIED BY 'M0n1t0$';

Once the account has been created you need to download and copy the macro/support files into your [wikiroot]/data/plugin/macro folder.
The following files are required to render the mmMySQL macro:

• mmMySQL.py

• mysql_status_variables.xml

• mysql_system_variables.xml

Remember to ensure that your webserver has read access to these files.

Usage

Once installed you can insert the macro onto any page within your wiki using the following:

MySQL server is located on same server as your MoinMoin Wiki

[[mmMySQL(username=XXXX,password=XXXX)]]

MySQL server is located on another server remote to your MoinMoin Wiki

[[mmMySQL(username=XXXX,password=XXXX,hostname=remote.server.org,port=3306)]]

Screenshots