See the monitor script itself for most of the pertinent usage information.
This is msql-mysql.monitor, a monitor for mon that tries to intelligently
check if an mSQL or MySQL SQL server is operational.
This monitor required the perl5 modules DBI, DBD::mysql, and DBD::mSQL,
available from CPAN (http://www.cpan.org/).
The monitor may be installed as msql.monitor, in which case it defaults to
mSQL mode, or as mysql.monitor, in which case it defaults to MySQL mode.
Regardless of how it is installed, the --mode switch may be used to force
the monitor into msql or mysql mode.
In order for the monitor to succeed, the following must be true:
- For either mode, the server must be up and answering.
- For mSQL mode, the server ACLs must allow connections from the host running
mon as the effective user running mon to the given database.
- For MySQL mode, the server grant tables must allow connections from the host
running mon with the username and password provided to the given database.
- For either mode, the database specified must exist, and must contain at
least one table
If any of these conditions are not met, the monitor will fail and the DBI
error will be returned to mon for processing by the appropriate alerts.
James FitzGibbon firstname.lastname@example.org
System Engineer, ACC Global Net Voice/Fax (416)207-7171/7610