Kontrollbase - MySQL Monitoring

VMware Virtual Appliance Install Guide

Download the appliance

If you don't already have the appliance you can get it here: http://kontrollsoft.com/software-downloads. If you are having issues running it you might need to convert it from the .ova file format to whatever format you need for your player. If you need to convert it download the VMware converter: http://www.vmware.com/products/converter/.

VA specs

The virtual appliance has been setup with the following specs:

Login to the VA

The VA was setup in our testing lab, and as such it runs on the 192.168.0.0/24 network. It has a static address of 192.168.0.20. You may need to change that for your specific network. I'm not going to get into setting OS settings or network settings for this because you should know how to do that already. If not, refer to the Redhat/Fedora/CentOS documentation.

At the console you can login as 'root' with the password 'password'. Once you're in you can find the kontrollbase install at /var/www/html (which is a symlink to /usr/local/src/kontrollbase-googlecode). Apache and MySQL are setup to run at boot. At this time you probably want to set the root password for mysql and the os for your own needs since 'password' is not secure.

If you change the IP address of the server you HAVE to change the config files for Kontrollbase to reference the new IP.

Changing the config files for Kontrollbase

As mentioned before, if you change the server IP then you need to change the Kontrollbase config files to reference the new IP. If you are not changing the IP of the server, skip this step. Files in question with the lines you need to change:
/var/www/html/config.php # Web Stuff - no trailing slash WEB_ROOT=http://192.168.0.20

/var/www/html/system/application/config/config.php $config['base_url']= "http://192.168.0.20/"; //USE TRAILING SLASH

Login to Kontrollbase and setup basics

Now you should be set to login to the web interface. Using your browser of choice, go to the IP address: http://192.168.0.20/ or whatever you set the IP to. The login box should appear. User: admin , Password: password. Once you login you should go to the System Management -> Users tab and edit the admin user and set a new password. You'll notice that there is no data for the graphs to display, and no content for any of the other display areas. This is because the server install is fresh and you will need to setup your hosts. Generally speaking, once you have your hosts setup and the data collection is working - you will immediately see overview information. You will not see any graphs until after about a day of data collection, so don't think it's broken, it just takes a bit of time.

To setup the hosts you will want to refer to the other sections of documentation: Client Installation. Once your hosts are setup you can test that they are working by running the bin/kontroll-server_loop-5.0.x_linux-x86-2.0.1.pl script by hand - this way you will know if the kontrollbase server is connecting to the host clients correctly or see any errors that might occur.

You will also want to set the Kontrollbase system email. Very simple, just go to the System Management -> System tab and edit the necessary field.