The Kontrollbase CLI Reporter
Good news for everyone that has wanted the performance tuning abilities of Kontrollbase but didn’t want to install a centralized monitoring application for their MySQL database servers. Now the same performance tuning reports are available in a single script that can be run from the command line with results available in HTML, TXT, and XML formats. Download it now to get the best automated tuning analysis for your MySQL servers without any installation necessary. Soon I’ll be adding the analytics report from the webapp in addition to the current performance tuning report, so stay tuned for that in the next version.
How it’s different than the regular Kontrollbase application:
- runs as a single script on any Linux or Unix server
- does not require a webserver
- does not require any schema importing or local MySQL database (aside from the database you’re analyzing)
- does not require a special operating system user
- does not offer the historical analysis features of the webapp (like % growth over time) as there is only the current data to analyze
- utilizes a singe SQLite schema file to operate and report on data.
How it’s the same as the regular Kontrollbase application:
- has the same perl module requirements
- generates the same performance tuning reports
- combines the reporter, stats gather, and client code into one modified process
How to use the CLI script
The script is located in the /bin directory and named "kontroll-reporter-cli.pl". It requires the same perl modules as the main applications's client and server scripts. It also requires that you have SQLite installed on your system. You can install that via the OS's paackage management system or get it from http://www.sqlite.org.For all of the settings you can specify the "--help" option on the command line and you will see the following explanation:
ROOT-(0)> ./kontroll-reporter-cli.pl --help
#########################################################
Filename: kontroll-reporter-cli.pl
Kontrollbase Reporter CLI version
Copyright 2010-present Matt Reid - http://kontrollsoft.com
Kontrollbase package version: 2.1
#########################################################
!! Requires SQLite database application !!
!! Requires SQLite database file to run !!
SQLite file: kontroll-reporter-cli_sqlite3-alerts_def.db
#########################################################
--help = this message
--snmp-host = snmp host address
--snmp-port = snmp port
--snmp-retries = snmp retries
--snmp-rocomminity = snmp rocommunity
--snmp-timeout = snmp timeout
--snmp-version = snmp version
--mysql-user = mysql username
--mysql-pass = mysql password
--mysql-port = mysql port
--mysql-socket = mysql socket
--mysql-db = mysql database
--mysql-host = mysql host
--sqlite-file = SQLite DB file
--output = output style for report
[XML,HTML,TXT]
defaults if variables not specified
snmp-host: localhost
snmp-port: 161
snmp-rocommunity: public
snmp-version: 1
snmp-timeout: 5
snmp-retries: 2
mysql-user: root
mysql-pass:
mysql-port: 3306
mysql-socket: /var/lib/mysql/mysql.sock
mysql-db: mysql
mysql-host: localhost
sqlite-file: ./kontroll-reporter-cli_sqlite3-alerts_def.db
output: XML report output
The help contents is subject to change so please refer to the actual script's output if you want the latest information.
You must specify the --sqlite-file=