This is a module for monitoring any data from a MySQL SQL database server (versions 3.22 and above).
It requires the Mytcl package to be installed (can be found at http://jfontain.free.fr/).
Note that although this module is for Linux, the MySQL server to be monitored could be running on any remote machine, even an NT one (which is unlikely, since you need a reliable database system).
Data is retrieved using the SELECT * FROM table query if a table name is passed as argument using the --t (--table) switch, or using the query passed as argument using the --q (--query) switch (SELECT and SHOW queries work, as may others that return row/column data). Resulting data is initially displayed in 1 table.
Module options:
Examples:
$ moodss myquery --host 1.2.3.4 -t test.table $ moodss myquery --host dbserver.company.com --port 3307 -t test.table $ moodss myquery --host dbserver.company.com --user root --password xxx --table mysql.user $ moodss myquery -q 'select * from database.table order by column' $ moodss myquery --query 'show variables'