Monthly Review

Background

This page documents how to do assemble the monthly review data for the Tier-1 meeting.

CPU numbers

There is a script which can be used to generate a csv file with the accounting numbers. The script is here: svn+ssh://svn@ndpfsvn.nikhef.nl/repos/pdpsoft/nl.nikhef.ndpf.3maand/

Example invocations:

./3maand.py -p <db passwd here> 2011-08-01
./3maand.py -p <db passwd here> 2011-08-01 +6m
./3maand.py -p <db passwd here> 2011-08-01 2011-12-05

"2011-08-01" is the start date of the period over which the accounting will be summed. With no end date provided, the default is for a period of three months (the first example). An end date of "+6m" means, sum the accounting over 6 months. The last example shows an explicit end date provided. You can use any dates you like, but the results are only guaranteed if the start date is on the first of the month, as part of the program logic is based on that assumption.

The result of running that program will be a file, 'tmp.csv'.

There is a python program that can be used to IPMI is a "standard" interface that can be used to do remote management tasks. Most of the physical machines in our farm segment our connected to a special IPMI network (which is different from the standard "internet" network). Via this special management network, you can do things like turn the machine off and on, or look at its console in some cases, or read the temperature of the box. If you know the physical machine you want to access, you can find the corresponding IPMI address on this page: NDPF_Node_Functions, in the table called "IPMI dedicated management network". Here is an example: you want to access wn-val-003.farm.nikhef.nl. You can see from that table the following line:

0.20-0.121	 wn-val-(001-102)		 valentine	 LCG2ELPROD

read this as follows: the first field gives the last two parts of the IP address (the first part is 172.20), so wn-val-003 will have IP address 172.20.0.22. The second field gives the IPMI hostname, so this node has hostname "wn-val-003.ipmi.nikhef.nl".

bosui:~> host wn-val-003.ipmi.nikhef.nl
wn-val-003.ipmi.nikhef.nl has address 172.20.0.22

This information can be used as hostname/ip input for the various IPMI client tools.

Important Note: the IPMI network is not accessible from everywhere. From your desktop, you should have the OpenVPN tunnel running, otherwise you won't be able to connect. The IPMI network is not accessible from all nodes in the farm; it does work from e.g. the install server (stal).