Anyone get teMySQLcacti working

[homerpuck]

Thanks,
I am trying to get teMySQLcacti working
I am following the readme
I have copied mysql_stats.php and dumpMemcachedStats.php to my scripts dir.

i have imported cacti_host_template_memcached_host.xml and cacti_host_template_temysql_host.xml.

Now when i go to cacti, and add a new device, the Host template does not have the new templates listed.

Is there some step i am missing?

Thanks for any help

Randy

[jlangan]

So I setup temysql today and everything went smoothly except for two things.

Firstly the instructions were vague on if/when/how to grant permission to the cacti user :

To enable access from the Cacti-machine to the MySQL-status informations, you must have the "process" right. If you want to monitor InnoDB stats, the cactiuser needs the "SUPER" privelege.

Okay, I don't have any InnoDB tables, so I assume I only need to run the grant process statement:

GRANT PROCESS ON * TO cacti@'cactimachine' IDENTIFIED by 'cactipasswd';

When I run this on my mysql server, it prompts me to specify a db. Fair enough, I specify mysql and I get this in return:

mysql> use mysql;
Database changed
mysql> GRANT PROCESS ON * TO cacti@'localhost' identified by 'xxxx';
ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

So I ran the same command with *.*, that works, however does that give the same result? Also, do I need to run this statement against every db?

Unsure if this is related or not, but only two graphs seem to work: teMySQL - CPU Usage and teMySQL - Load Average. The rest appear with no data except Old Handler Stats which is a broken image. So I manually run the poller and I get this:

/site/php/php/bin/php /site/cacti/poller.php
OK u:0.00 s:0.00 r:0.02
ERROR: Not enough arguments
OK u:0.00 s:0.00 r:0.02
OK u:0.00 s:0.00 r:0.02
OK u:0.00 s:0.00 r:0.02
ERROR: Not enough arguments
ERROR: Not enough arguments
ERROR: Not enough arguments
ERROR: Not enough arguments
ERROR: Not enough arguments
ERROR: Not enough arguments
OK u:0.00 s:0.00 r:0.02
OK u:0.00 s:0.00 r:0.02
ERROR: Not enough arguments
ERROR: Not enough arguments
ERROR: Not enough arguments
ERROR: Not enough arguments
OK u:0.00 s:0.00 r:0.02
06/27/2007 09:58:44 PM - SYSTEM STATS: Time:1.0337 Method:cmd.php Processes:1 Th
reads:N/A Hosts:3 HostsPerProcess:3 DataSources:52 RRDsProcessed:42
OK u:0.00 s:0.00 r:0.02

So I looked at the data sources and saw how they were being executed. With that I put together a command to run on the command line which seemed to work perfectly:

[root@mail ~]# /site/php/php/bin/php /site/cacti/scripts/mysql_stats.php telock
ingandslow localhost cacti xxxx
Table_locks_immediate:20004817 Table_locks_waited:112244 Slow_launch_threads:0 Slow_queries:1285

What the heck am I doing wrong?

Thanks

[windowsrefund]

I've got the same problem.

http://forums.cacti.net/viewtopic.php?p=105444#105444

[windowsrefund]

Turns out I must have imported the wrong .xml template. Everything works now.