[mrtg] Re: [nonspam] mrtg-mysql-load not returning usable data?
arfranks at gmail.com
Thu Nov 23 02:55:02 MET 2006
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
#Title[shoeshine_mysqlload]: MySQL load analysis
#PageTop[shoeshine_mysqlload]: <H1>MySQL load Analysis</H1>
#YLegend[shoeshine_mysqlload]: # of queries
#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.
#LegendO[shoeshine_mysqlload]: Slow queries
Is there anything in this that looks glaringly, obviously wrong?
On 11/22/06, Johannes Prost <Johannes at yorktondigital.ca> wrote:
> 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.....
> > 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
FAQ http://faq.mrtg.org Homepage http://www.mrtg.org
More information about the mrtg