The MySQL Graph Collection - Version 2.0!

[cobi]

I corrected on my config the empty problem of graph by change the lib/poller.php line 215
preg_match("/^([a-zA-Z0-9_\.-]+):([0-9Ee-\+\.]+)$/", $values[$i], $matches) by
preg_match("/^([a-zA-Z0-9_\.-]+):([0-9-Ee\+\.]+)$/", $values[$i], $matches)
and I also filled the rrd_name in the table poller_item by using the
rrd_path

Sorry for my english i m french.

[Kroontje]

Hello Cacti-freaks,

I'am new with cacti and linux and try to install the MySQL graphs. When I try to import the xml-files I'll get the error: Error: XML: Cacti version does not exist.

Fedora Core 3
Cacti 0.8.6d

Is there another way to import the xml-files?

Thanks in advance for your help

[ottob]

youre right! I have to export this template for 0.8.6d. Currently they are run only with 0.8.6c.

There will be an update very soon...!

otto

[Kroontje]

youre right! I have to export this template for 0.8.6d. Currently they are run only with 0.8.6c.

There will be an update very soon...!

otto

Great! Thanks a lot!

[tenkawa69]

Hello everybody ,

first of all , thank you very much for these scripts . they are impressive.

my problem is that i am unable to graph a foreign host, actually localhost is working great.
but when i try to graph another hosts it said :
->ERROR: Not enough arguments

i didn't forgot to set privilege for the cactiuser
->GRANT PROCESS ON * TO cacti@'192.168.0.52' IDENTIFIED by 'cacti';

if anyone can help me
thanks everybody in advance

[feeman]

First! Thank otto for giving us such a wonderful tool!!

okay i found the problem.

normally a mysql connection has a priveliges system for localhost i just set that (so nobody from the outside can connect)

But my cacti has a hostname www.only4clans.com so it connects to that, but that doens't work..
so you should change your stuff to localhost instead to |hostname|

(also alot of the time php -q doesnt work)
example i have to use /usr/local/bin/php instead of only php

When I try the addon , I meet the same problem that without any graph but the command line php-q <cacti_path> ... <username> <password> work!!
Cacti log tell me "WARNING: Result from CMD not valid. Partial Result: Error: MySQL connect "

After watching SCaRaBaeuS's article above , I realize that I have changed my default hostname in DEVICE. Finally I change it back to localhost and it works... Ya!! Maybe this is helpful to those people who have met the same problem like mine!!

My BOX
Pentium 4-1.6G
Ram 1G
OS: Freebsd 5.4
Apache/2.0.54
PHP 4.3.11 (cli)
mysql Distrib 4.1.12
CACTI 0.8.6f

[jayray]

Is there a release for 0.8.6d? I can not get this one to import correctly.

[jeffreyheinen]

What about a conversion into the php script_server. Shouldn't that help preformance some? Is that in the works as well?

[paulbeard206]

Is this a problem with the templates and the current version?

Code: Select all

cactiuser@scout1:~/cacti> php -q poller.php 

public: Unknown Object Identifier (Sub-id not found: mib-2 -> public)

Actually, scratch that: I am using these scripts with 0.8.6f on my home network. works fine. It seems some people are using 0.8.6f without any issues?

[EmiT]

At first thanks for this cool script. But I'm using MySQL database version 4.1 and PHP uses new functions for MySQL 4.1x and later. So I have updated your script and templates. They are called MySQLi and can coexist with mysql_stats. I have tested it on 0.8.6f and it works well.

Write if something won't work.

[pruesse]

The above files do require PHP5, as far as I can see. What do I want to do to monitor MySQL 4.1 using PHP4 ?

[suse]

can not use it on 0.8.6g + mysql 4.0.26{foreign DB host)

php -q ./mysql_stats.php command localhost user pass

did not give anything.

[suse]

how to monitor multi DB host at same time?

[ottob]

what does "php --version" give?

[suse]

now only
MySQL - Command statistics
MySQL - Connections

can graph for me,
others can not.
error msg is

RRDTool Says:

ERROR: Not a valid vname: #FF9900 in line LINE1:#FF9900:Read Rnd Next


maybe it is template error?

Thanks for your help