Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
windowsrefund wrote:Everything installed as per the docs. Database permissions are fine and I've verified using mysql_stats.php from a shell.
Everything is good with the exception of the graphs not showing any data. Any ideas? Perhaps I'm just not waiting long enough? It's been about 20 minutes already.
Thanks
I have same problem,
I get this error when I run poller.php
Notice: Undefined index: in /usr/share/cacti/lib/rrd.php on line 224
So I installed this plugin on a few other servers and got it to work right away. In both cases I can connect remotely from the cacti server, and get information from information_schema. Presumably this is the DB where the stats come from.
Working server
mysql> select * from USER_PRIVILEGES;
+-------------+---------------+----------------+--------------+
| GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+-------------+---------------+----------------+--------------+
| 'cacti'@'%' | NULL | PROCESS | NO |
| 'cacti'@'%' | NULL | SUPER | NO |
+-------------+---------------+----------------+--------------+
2 rows in set (0.00 sec)
mysql> quit
Bye
Broken server
mysql> use information_schema;
Database changed
mysql> select * from USER_PRIVILEGES;
+-------------+---------------+----------------+--------------+
| GRANTEE | TABLE_CATALOG | PRIVILEGE_TYPE | IS_GRANTABLE |
+-------------+---------------+----------------+--------------+
| 'cacti'@'%' | NULL | PROCESS | NO |
| 'cacti'@'%' | NULL | SUPER | NO |
+-------------+---------------+----------------+--------------+
2 rows in set (0.00 sec)
Figured it out by reading mysl_stats.php. The innodb stuff references "show innodb status". Try to login as the user you setup with SUPER privileges and see if it works. In my case the problem ended up being related to INNODB logging. I had changed the innodb_log_size but not stopped mysql, moved the logfiles, started mysql to update.
I've got some other sort problem.
I did everything according to the README, Created new host with new graphs. But now when I select the host to display the graphs, my server goes to a load of 40-50(!) and that's it!
I tried both templates, same problem.
Connection to mysql-server is ok. Can run script from command line.
Poller gives no errors.
Even tried it with only one graph (teMySQL - InnoDB Buffers Pages/Mem), directly hangs the server.
I'm not sure what i did wrong. I followed the readme completely but still my graphs don't show anything when cron is set to 5 minutes.
----------------------------------!!!!!!!!-----------------------------------
WARNING: These graphs assume a 1-minute Poller cron frequency! If you use the
default 5-minute interval, run convertXmlTo5minutePollingInterval.sh, which
will make a step=300, heartbeat=600 version of the XML file for you to import.
If you don't do this, none of your graphs will ever show any data.
----------------------------------!!!!!!!!-----------------------------------
I followed all instructions in README in any possible way. Using sh script as well as changing it manually. No matter what it only works when cron is set for 1 minute interval .... however it's raping my server so it's not a solution for me.
Any tips and help appreciated.
Attachments
graph_image.php.png (37.94 KiB) Viewed 12448 times
May I bring up the old topic again, friends?
I came accross this cacti plugin to graph MySQL and felt my hands itching trying to implement it. But alas, my graphs come blank.
I might be asking the question that was answered. I'm trying to graph MySQL 5.0 and my graphs show only CPU Usage and Load Average of MySQL server.
Should it be specific problem with php and MySQL 5 or I have something misconfigured?
I'm trying to connect to the MySQL server in question using root credentials so I belive the question of granting privileges is not an issue ?
And I did export necessary xml templates following readme.txt to match with my poller that makes queries every 5 minutes.
Hmm. I went and downloaded the latest version of this from the web page (20060810), went to follow the instructions in the readme, and the GRANT PROCESS statement doesn't work for me:
mysql> GRANT PROCESS ON * TO cactiuser@'localhost' IDENTIFIED by 'cactipassword';
ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
The "GRANT SUPER" worked just fine.
(username & passwd changed to protect the innocent)
The mysql installed is version 4.1.20, default with RHEL 4 update 5.
Is there a particular version of mysql this requires?
Maby I'm dumb, but how do I set the mysql servers port? I have several mysql hosts, each one listens to a different port... This uses the default port?
kamina wrote:Maby I'm dumb, but how do I set the mysql servers port? I have several mysql hosts, each one listens to a different port... This uses the default port?
Hi
IMO you'll have to :
modify the scripts/mysql_stats.php script to add something like this
[size=84]
[color=green]HOWTOs[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15353]Install and configure the Net-SNMP agent for Unix[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=26151]Install and configure the Net-SNMP agent for Windows[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=28175]Graph multiple servers using an SNMP proxy[/url][/list]
[color=green]Templates[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15412]Multiple CPU usage for Linux[/url]
[*][url=http://forums.cacti.net/viewtopic.php?p=125152]Memory & swap usage for Unix[/url][/list][/size]
I guess you'll be able to enter it when adding MySQL graphs to a host.
[size=84]
[color=green]HOWTOs[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15353]Install and configure the Net-SNMP agent for Unix[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=26151]Install and configure the Net-SNMP agent for Windows[/url]
[*][url=http://forums.cacti.net/viewtopic.php?t=28175]Graph multiple servers using an SNMP proxy[/url][/list]
[color=green]Templates[/color] :
[list][*][url=http://forums.cacti.net/viewtopic.php?t=15412]Multiple CPU usage for Linux[/url]
[*][url=http://forums.cacti.net/viewtopic.php?p=125152]Memory & swap usage for Unix[/url][/list][/size]
My graphs for the memcached poller are empty.
When I run the script directly from the command line I get this:
Fatal error: Class 'Memcache' not found in /usr/local/apache2/htdocs/cacti/scripts/dumpMemcachedStats.php on line 8
