To see the number of orders in an example Customer Relationship Management database: Now let's assume we have a safe My SQL user 'bill' with the password 'ben' that can read the order table from database 'crm' on localhost.In a Linux shell file we can write: Target[order]: `/etc/mrtg/table-size` Options[order]: nopercent,growright,nobanner,nolegend,noinfo,gauge, integer,noi,transparent Title[order]: CRM order queue Page Top[order]: YLegend[order]: orders Short Legend[order]: Legend I[order]: Legend O[order]: orders By using the transparent option mrtg generates images that can be embedded in web pages with a background graphic.
By default these results are only accessible# from the local host.#Alias /mrtg /var/www/mrtg Order deny,allow Deny from all Allow from 127.0.0.1 Allow from 192.168←追加します。自身のネットワークからアクセスを許可する。 Allow from ::1 # Allow from .Add Default Charset euc-jp uth User File /etc/mrtg/.htpasswd Auth Name "MRTG Authorize" Auth Type Basic Require valid-user■ MRTG起動スクリプト作成# vi mrtg.sh#!
It generates html pages with graphs which are refreshed according to our network’s current state.
Its source is written in Perl and C which means that it can be installed in every Operating System we like.
By replacing the first 'echo 0' in table-size with another mysql statement, and removing the 'noi' option from the mrtg target, you can compare the sizes of two tables in one graph.
and, once you do that, apt-get is good about not upgrading any further at all.