Hi again everyone. I've seen some activity on this list recently so I thought I'd ask a question again that I asked a couple months ago.<br><br>Since then I've upgraded to mrtg 2.15.0, which I believe is the newest version. However, I'm still having the problems I was having before.
<br><br>I'm trying to get data from mrtg-mysql-load from a different machine. I can run mrtg manually (using the same mrtg.cfg and with the identical command that the cron job runs) and it will generate some info in the log file:
<br><br>1169603819 2896787 1046<br>1169603819 0 0 0 0<br>1169603720 0 0 0 0<br>1169603700 0 0 0 2<br>1169603400 0 2 0 2<br>1169603100 0 2 0 2<br>1169602800 0 2 0 2<br>1169602500 0 2 0 2<br>1169602200 0 1 0 2<br>1169601900 0 0 0 0
<br><br>However, when the job runs via crontab, it becomes this:<br><br>1169604001 -1 -1<br>1169604001 0 0 0 0<br>1169603819 0 0 0 0<br>1169603700 0 0 0 2<br>1169603400 0 2 0 2<br>1169603100 0 2 0 2<br>1169602800 0 2 0 2<br>
1169602500 0 2 0 2<br>1169602200 0 1 0 2<br>1169601900 0 0 0 0<br><br>And I get a nasty error in /var/log/mrtg.log:<br><br>2007-01-23 18:00:01 -- 2007-01-23 18:00:00: WARNING: Could not get any data from external command '/usr/local/bin/mrtg-mysql-load -c /www/shoegoo.soletechnology/docs/mrtg/mysql-
load.cfg'<br>Maybe the external command did not even start. ()<br><br>2007-01-23 18:00:01 -- 2007-01-23 18:00:00: WARNING: Problem with External get '/usr/local/bin/mrtg-mysql-load -c /www/shoegoo.soletechnology/docs/mrtg/mysql-
load.cfg':<br> Expected a Number for 'in' but nothing'<br><br>2007-01-23 18:00:01 -- 2007-01-23 18:00:00: WARNING: Problem with External get '/usr/local/bin/mrtg-mysql-load -c /www/shoegoo.soletechnology/docs/mrtg/mysql-
load.cfg':<br> Expected a Number for 'out' but nothing'<br><br>2007-01-23 18:00:02 -- 2007-01-23 18:00:02: ERROR: Target[shoeshine_mysqlload][_IN_] ' $target->[12]{$mode} ' did not eval into defined data
<br>2007-01-23 18:00:02 -- 2007-01-23 18:00:02: ERROR: Target[shoeshine_mysqlload][_OUT_] ' $target->[12]{$mode} ' did not eval into defined data<br><br>How are these two different?! Why would running the command manually and the crontab running the command have any different effect?
<br><br>If anyone has some insight into this I'd greatly appreciate it.<br><br>Thanks!<br>Alex<br><br><div><span class="gmail_quote">On 11/22/06, <b class="gmail_sendername">Alex Franks</b> <<a href="mailto:arfranks@gmail.com">
arfranks@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I've poured through all the web archives, online forums and anything
<br>else I could find, but still no solution has arisen.<br><br>I'm using:<br>mrtg-mysql-load 1.02 (newest version I think?)<br>mrtg-2.15.0<br>mysql-4.1.18-log<br><br>YES, my mrtg installation works just fine for other graphic stats,
<br>including things that don't come from my router (apache stats). I'm<br>*pretty sure* mrtg-mysql-load works as well, because when I run it<br>from the command line (outside of the cron job that runs mrtg) I get
<br>the version information and uptime on the html page mrtg creates for<br>mysql load, but no data.<br><br>I've read that mrtg-mysql-load was designed for mysql 3.23.? so<br>perhaps that's not helping either.<br>
<br>And this shows up in the /var/log/mrtg.log:<br><br>2006-11-22 15:40:01 -- Wednesday, 22 November 2006 at 15:40: WARNING:<br>Could not get any data from external command<br>'/usr/local/bin/mrtg-mysql-load -c<br>/www/shoegoo.soletechnology/docs/mrtg/mysql-
load.cfg'<br>Maybe the external command did not even start. ()<br><br>2006-11-22 15:40:01 -- Wednesday, 22 November 2006 at 15:40: WARNING:<br>Problem with External get '/usr/local/bin/mrtg-mysql-load -c<br>/www/shoegoo.soletechnology/docs/mrtg/mysql-
load.cfg':<br> Expected a Number for 'in' but nothing'<br><br>2006-11-22 15:40:01 -- Wednesday, 22 November 2006 at 15:40: WARNING:<br>Problem with External get '/usr/local/bin/mrtg-mysql-load -c<br>
/www/shoegoo.soletechnology/docs/mrtg/mysql-load.cfg':<br> Expected a Number for 'out' but nothing'<br><br>2006-11-22 15:40:01 -- Wednesday, 22 November 2006 at 15:40: ERROR:<br>Target[shoeshine_mysqlload][_IN_] ' $target->[11]{$mode} ' did not
<br>eval into defined data<br>2006-11-22 15:40:01 -- Wednesday, 22 November 2006 at 15:40: ERROR:<br>Target[shoeshine_mysqlload][_OUT_] ' $target->[11]{$mode} ' did not<br>eval into defined data<br><br>I'm somewhat new to mrtg, so if this is an obvious, n00b question,
<br>I'll happily take the abuse in order to get this thing working.<br><br>Thanks<br></blockquote></div><br>