The Network People Support Forums

Other TNPI Software => RRDutil => Topic started by: Marc on May 05, 2005, 08:50:37 PM

Title: Pulling data from MySQL
Post by: Marc on May 05, 2005, 08:50:37 PM
Hey there!

Trying to get rrdutil to make pretty graphs for MySQL (everything else works) but not having much luck.

mysqlstatus.pl seems to be functional

/usr/local/sbin/mysqlstatus.pl "type"
mysql_select:3549449:mysql_changedb:729590:mysql_update:9733 55:mysql_insert:257844:mysql_delete:213606

/usr/local/sbin/mysqlstatus.pl "queries"
mysql_queriessec:33509946:mysql_connections:740738:mysql_slo wqueries:12

but, no result on the graph side. This is as root.

Can someone point me at what I'm missing from this info?

Thanks!
Marc
Title: Re: Pulling data from MySQL
Post by: Marc on May 05, 2005, 09:29:24 PM
Doh! Just popped to life!

I set perms on the root .my.cnf to 744. What user is it looking to run as if not root?

Sure looks like it's running as root.
184 root       2   0  4112K  2976K select   8:12  0.00%  0.00% snmpd
root  63301 41.7  2.4 12860 12380  p0  R+    8:26PM   0:01.35 /usr/bin/perl

Thanks!
Marc
Title: Re: Pulling data from MySQL
Post by: danone on July 08, 2005, 10:56:42 AM