<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1683630689;
mso-list-type:hybrid;
mso-list-template-ids:1470562210 67698705 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’ve recently been working on a project which focuses on gathering printer meter readings using snmp and placing this data into a mysql db. This all works fine. I do this every 5 minutes.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’ve since installed MRTG and am wanting to graph the number of print jobs during this 5 minute period.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’ve created a PHP script which is set as the target in mrtg.cfg. The printer name can be passed to the script as a command line option which makes it particularly good in this sense. The script queries mysql
and calculates the number of pages printed in the last 5 minutes. This data is then output in the form:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">5 <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">0<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">(Just the two lines) The 5 represents say, 5 pages in total and the 0 represents 0 b/w pages.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’ll post my mrtg.cfg file below.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"># Global configuration<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">WorkDir: /var/www/mrtg/printers<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">MaxBytes[_]: 20000<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Options[_]: gauge,growright<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Refresh: 300<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Interval: 60<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Factor[_]: 1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"># E0_ColLaser<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">MaxBytes[E0_ColLaser]: 1500<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">AbsMax[E0_ColLaser]: 3000<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Options[E0_ColLaser]: growright, nopercent, noinfo, withzeroes, integer, perhour, unknaszero<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Step[E0_ColLaser]: 300<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Target[E0_ColLaser]: `php /var/www/mrtg/scripts/get_meters_from_db.php E0_ColLaser`<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Title[E0_ColLaser]: Meters - E0_ColLaser<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">PageTop[E0_ColLaser]: <h1>Meters - E0_ColLaser</h1><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">YLegend[E0_ColLaser]: Jobs in the past 5 minutes<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">ShortLegend[E0_ColLaser]: Pages / 5 Mins<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">LegendI[E0_ColLaser]: Total Prints / 5 Mins<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">LegendO[E0_ColLaser]: Colour Prints / 5 Mins<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"># E2_ColLaser<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">MaxBytes[E2_ColLaser]: 1500<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">AbsMax[E2_ColLaser]: 3000<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Options[E2_ColLaser]: growright, nopercent, noinfo, withzeroes, integer, perhour, unknaszero<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Step[E2_ColLaser]: 300<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Target[E2_ColLaser]: `php /var/www/mrtg/scripts/get_meters_from_db.php E2_ColLaser`<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Title[E2_ColLaser]: Meters - E2_ColLaser<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">PageTop[E2_ColLaser]: <h1>Meters - E2_ColLaser</h1><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">YLegend[E2_ColLaser]: Jobs in the past 5 minutes<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">ShortLegend[E2_ColLaser]: Pages / 5 Mins<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">LegendI[E2_ColLaser]: Total Prints / 5 Mins<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">LegendO[E2_ColLaser]: Colour Prints / 5 Mins<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">NB: My printers print at 25 pages per minute. I’ve used 25*60 to get a pages per hour figure and hopefully set the global interval at 60 minutes.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">The figures I’m getting are completely wrong. For example, I’ve printed at the most 2 or 3 pages and yet my graph shows the following values and the scale has a max value of 36?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0">
<tbody>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:9.5pt;font-family:"Times New Roman","serif";color:#00CC00">Total Prints / 5 Mins<o:p></o:p></span></b></p>
</td>
<td style="padding:0cm 7.5pt 0cm 7.5pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.5pt;font-family:"Times New Roman","serif"">35 Pages / 5 Mins<o:p></o:p></span></p>
</td>
<td style="padding:0cm 7.5pt 0cm 7.5pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.5pt;font-family:"Times New Roman","serif"">0 Pages / 5 Mins
<o:p></o:p></span></p>
</td>
<td style="padding:0cm 7.5pt 0cm 7.5pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.5pt;font-family:"Times New Roman","serif"">0 Pages / 5 Mins
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:9.5pt;font-family:"Times New Roman","serif";color:blue">Colour Prints / 5 Mins<o:p></o:p></span></b></p>
</td>
<td style="padding:0cm 7.5pt 0cm 7.5pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.5pt;font-family:"Times New Roman","serif"">11 Pages / 5 Mins
<o:p></o:p></span></p>
</td>
<td style="padding:0cm 7.5pt 0cm 7.5pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.5pt;font-family:"Times New Roman","serif"">0 Pages / 5 Mins
<o:p></o:p></span></p>
</td>
<td style="padding:0cm 7.5pt 0cm 7.5pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.5pt;font-family:"Times New Roman","serif"">0 Pages / 5 Mins
<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Please, any assistance in understanding:<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span style="color:#1F497D"><span style="mso-list:Ignore">1)<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#1F497D"> What output I need to provide from my script so that MRTG can use it as input data
<o:p></o:p></span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><![if !supportLists]><span style="color:#1F497D"><span style="mso-list:Ignore">2)<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#1F497D">Configure MRTG to simply graph the integer value for pages printed per 5 minute interval.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Chris<o:p></o:p></span></p>
</div>
</body>
</html>