[mrtg] Re: [nonspam] mrtg-mysql-load not returning usable data?

[Alex Franks]

Johannes,

Thanks for the response, but I think I've already ruled that out. The
cron job runs as root and I ran the command at the prompt with sudo...
so those 2 runs of the same command should be equivalent.

I first suspected mrtg didn't like the command that was being fed in
the Target, but I simplified it by cramming the mrtg-mysql-load
command into a separate script which only returned 2 lines, 1 integer
per line (queries / slow queries). This still produced the same
results so I'm puzzled.

Here is my current config (commented out since it was just filling my
log with errors). The 2nd Target was my experimental script, returning
only the 2 lines with no uptime/version info:
### shoeshine mysql load
#Target[shoeshine_mysqlload]: `/usr/local/bin/mrtg-mysql-load -c
/www/shoegoo.soletechnology/docs/mrtg/mysql-load.cfg`
#Target[shoeshine_mysqlload]: `/home/alex/bin/mysql-mrtg-stats`
#Options[shoeshine_mysqlload]: perminute,nopercent,integer,nobanner,growright
#MaxBytes[shoeshine_mysqlload]: 250
#AbsMax[shoeshine_mysqlload]: 4000
#Unscaled[shoeshine_mysqlload]: ymwd
#Title[shoeshine_mysqlload]: MySQL load analysis
#PageTop[shoeshine_mysqlload]: <H1>MySQL load Analysis</H1>
#YLegend[shoeshine_mysqlload]: # of queries
#ShortLegend[shoeshine_mysqlload]: q/m
#Legend1[shoeshine_mysqlload]: # of queries
#Legend2[shoeshine_mysqlload]: # of slow queries
#Legend3[shoeshine_mysqlload]: Maximal # of questions per min.
#Legend4[shoeshine_mysqlload]: Maximal # of slow queries per min.
#LegendI[shoeshine_mysqlload]: Queries:&nbsp;
#LegendO[shoeshine_mysqlload]: Slow queries&nbsp;

Is there anything in this that looks glaringly, obviously wrong?

On 11/22/06, Johannes Prost <Johannes at yorktondigital.ca> wrote:
> Frank,
>
> I am a newby too to mrtg, but
> could that be an access rights issue ? As it is working fine from the commandline, "who"
> is running the cron job ?  And "who" has "which" access rights to the mysql log ?
> Just poking into the dark.....
>
> Johannes
>
>
> > I've poured through all the web archives, online forums and anything
> > else I could find, but still no solution has arisen.
> >
> > I'm using:
> > mrtg-mysql-load 1.02 (newest version I think?)
> > mrtg-2.14.5
> > mysql-4.1.18-log
> >
> > YES, my mrtg installation works just fine for other graphic stats,
> > including things that don't come from my router (apache stats). I'm
> > *pretty sure* mrtg-mysql-load works as well, because when I run it
> > from the command line (outside of the cron job that runs mrtg) I get
> > the version information and uptime on the html page mrtg creates for
> > mysql load, but no data.
> >
> > I've read that mrtg-mysql-load was designed for mysql 3.23.? so
> > perhaps that's not helping either.
> >
>
> --
> Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
> Archive     http://lists.ee.ethz.ch/mrtg
> FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
> WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi
>
>

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://lists.ee.ethz.ch/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://lists.ee.ethz.ch/lsg2.cgi