https://t2bwiki.iihe.ac.be/index.php?action=history&feed=atom&title=QuatView 2026-04-16T03:35:57Z Revision history for this page on the wiki MediaWiki 1.43.5 https://t2bwiki.iihe.ac.be/index.php?title=QuatView&diff=232&oldid=prev 2015-08-26T12:29:00Z

<p>Created page with &quot; === QuatView at the T2B === ==== Installing Quatview ==== *Download the quatview from here http://sourceforge.net/projects/quattor/files/quatview/1.1.2/ *ccq3 is missi...&quot;</p> <p><b>New page</b></p><div><br /> === QuatView at the T2B ===<br /> <br /> ==== Installing Quatview ====<br /> <br /> *Download the quatview from here http://sourceforge.net/projects/quattor/files/quatview/1.1.2/<br /> *ccq3 is missing module named MySQLdb. For this you need to do <br /> &lt;pre&gt;<br /> yum install python-devel<br /> yum install MySQL-python<br /> &lt;/pre&gt;<br /> <br /> ==== Configuration Overview ====<br /> <br /> *Quatview consists out of two parts, a backend and a frontend<br /> **The backend is essentially a python script that fills a database (mysql) by parsing the xml templates from quattor <br /> **The script is executed on ccq3<br /> **The database is located on mon<br /> **The frontend is a web page that queries this database and displays it&#039;s information<br /> **The frontend is completely located on mon<br /> <br /> ==== Backend ====<br /> <br /> *On mon: <br /> **The database is located on mon since this machine will host the web-interface<br /> **A new user needs to be created, this is quattor<br /> **Make sure all privileges are set correctly for this user<br /> **Add a database named quattor<br /> *On ccq3:<br /> **The python script to parse the xml files into the database can be found here /root/quatview/quatview-1.1.2<br /> **The config file to run the quatview.py should be located here /etc/quatview.conf<br /> **The runcheck script is extended with following lines to have the qautview script executed<br /> &lt;pre&gt;<br /> sys.path.append(&#039;/root/quatview/quatview-1.1.2/&#039;)<br /> import quatview<br /> print &quot;Executing quatview: filling the database&quot;<br /> quatview.main()<br /> print &quot;Executing quatview: done, exiting&quot;<br /> &lt;/pre&gt;<br /> **REMARK: the ipmi feature is disabled<br /> <br /> ==== Frontend ====<br /> <br /> *On mon:<br /> **The web pages are located in /var/www/html/quatview/frontend/<br /> **config.php; contains variables to connect to database<br /> **index.php; web-interface to search the database<br /> **myquery.php; home-brew php page that allows to query the database based on input given in the url<br /> **The main webpage can be found here: http://mon.iihe.ac.be/quatview/frontend/<br /> **To query the database given an address similar to: http://mon.iihe.ac.be/quatview/frontend/myquery.php?MACaddress=00:30:48:94:6D:80<br /> <br /> ==== Using the Quatview database ====<br /> <br /> *Query the database through a web interface http://mon.iihe.ac.be/quatview/frontend/myquery.php?MACaddress=00:30:48:94:6D:80<br /> *QR codes can easily be generated on this webpage: http://www.qrdvark.com/qr-generator/<br /> *A sample QR code is here, try it out on your fancy smartphone :)<br /> [[Image(moz-screenshot.png)]]<br /> <br /> ==== Tips and Tricks ====<br /> <br /> *A good tool to work with mysql databases is phpmyadmin, this allows you to easily browse and manipulate your databases<br /> *If you are new to mysql these page can help you:<br /> **http://www.nparikh.org/unix/mysql.php<br /> **http://www.php-mysql-tutorial.com/wikis/mysql-tutorials/retrieve-data-from-a-mysql-database.aspx<br /> **Some of the comments I use<br /> &lt;pre&gt;<br /> mysql -h localhost -u quattor -p # connect to the database<br /> select * from mysql.user;# show all users<br /> show databases ;<br /> use database_name;<br /> show tables;<br /> select * from table_name;<br /> &lt;/pre&gt;<br /> *Some PHP pages that have helped<br /> **http://www.tizag.com/phpT/index.php<br /> <br /> <br /> <br /> {{TracNotice|{{PAGENAME}}}}</div>

Maintenance script