QuatView

From T2B Wiki
Jump to navigation Jump to search

QuatView at the T2B

Installing Quatview

yum install python-devel
yum install MySQL-python

Configuration Overview

  • Quatview consists out of two parts, a backend and a frontend
    • The backend is essentially a python script that fills a database (mysql) by parsing the xml templates from quattor
    • The script is executed on ccq3
    • The database is located on mon
    • The frontend is a web page that queries this database and displays it's information
    • The frontend is completely located on mon

Backend

  • On mon:
    • The database is located on mon since this machine will host the web-interface
    • A new user needs to be created, this is quattor
    • Make sure all privileges are set correctly for this user
    • Add a database named quattor
  • On ccq3:
    • The python script to parse the xml files into the database can be found here /root/quatview/quatview-1.1.2
    • The config file to run the quatview.py should be located here /etc/quatview.conf
    • The runcheck script is extended with following lines to have the qautview script executed
sys.path.append('/root/quatview/quatview-1.1.2/')
import quatview
print "Executing quatview: filling the database"
quatview.main()
print "Executing quatview: done, exiting"
    • REMARK: the ipmi feature is disabled

Frontend

Using the Quatview database

Image(moz-screenshot.png)

Tips and Tricks

mysql -h localhost -u quattor -p # connect to the database
select * from mysql.user;# show all users
show databases ;
use database_name;
show tables;
select * from table_name;


Template:TracNotice