No Graphs with Cacti

needsomehelp · Post by **needsomehelp** » Mon May 23, 2005 12:08 pm

I'm a newbie, and a novice when it comes to Cacti and any Linux software. I currently installed the new Cacti onto my Whitebox and I was able to get it up and running, but when I try to view the graphs and ran the graphing bug, this is the error that I received:

ERROR: opening '/var/www/html/cacti/rra/csweven_traffic_in_71.rrd': No such file or directory

any ideas??? I would greatly appreciate the help!! Thanks!!!

Post by **rony** » Wed May 25, 2005 11:57 am

Ok, let's start with the basics...

OS version and distrubtion?
Cacti Version?
Php Version?

Are you running the poller.php from cron every 5 minutes? If so, have you examined the cacti.log file in the log directory of you cacti installation?

needsomehelp · Post by **needsomehelp** » Wed May 25, 2005 1:00 pm

I apologize if I "hit a nerve" but that was my impression of some of the people who post on this message board. From most of what I've read on this message board, people have asked for "compensation" or a "fee", and to me, I just didn't get it since this is free software...but that's just me. I didn't mean to offend anyone, I'm just a bit frustrated and my boss is hounding me to get this finished...finish a freakin' application in which I have no experience with what-so-ever!

Ok...sorry again if I offended anyone...but now that I have ranted and raved...Here is the information you asked about...

- Whitebox 3.0
- Caci 0.8.6d
- php-4.3.2-8

This is a copy of my crontab:
*/5 * * * * cactiuser php /cacti-0.8.6d/poller.php > /dev/null 2>&1

Here is copy of my log file:

05/05/2005 10:15:02 AM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
05/05/2005 10:20:03 AM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
05/05/2005 10:25:03 AM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
05/05/2005 10:30:03 AM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
05/05/2005 10:35:03 AM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
05/05/2005 10:40:03 AM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
05/05/2005 10:45:02 AM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
05/20/2005 07:38:18 AM - CMDPHP: Poller [0] Host[0] WARNING: Result from SNMP not valid. Partial Result:
05/20/2005 07:38:24 AM - CMDPHP: Poller[0] ASSERT: "771914736<35509360' failed. Recaching host 'XXX.XXX.XXX.XXX', data query #1.
05/20/2005 07:39:00 AM - SYSTEM STATS: Time: 42.7022 s, Method: cmd.php, Processes: 1, Threads: N/A, Hosts:8, Hosts/Process:8
05/20/2005 07:39:00 AM - POLLER: Poller[0] Host[5] WARNING" Recache Event Detected for Host
05/20/2005 07:39:09 AM - RECACHE: Poller[0] STATS: Time: 8.5360 s, Hosts Recahced: 1

The XXX.XX - is my IP address.

Again, I apologize for offending anyone. I am just under a lot of pressure from my boss, and I just took it out on you inoccent folks! My sincere apologies!!!!

Post by **rony** » Wed May 25, 2005 1:06 pm

Well, those mysql errors, you need to figure out why you are getting those errors.

First, check that you include/config.php file has the correct settings.

Second, do you have mysq server running? If you surf to cacti web interface are you able to login?

jhermiz · Post by **jhermiz** » Wed May 25, 2005 1:08 pm

Your errors look familiar. You need to let mysql know about php. Do you have the mysql-php package installed ?

If not you need it...

apt-get install mysql-php

or apt-get mysql-php

rpm -i mysql-php.*

cd mysql-php*

./configure

make

make install

Post by **rony** » Wed May 25, 2005 1:11 pm

If there PHP module for mysql was not there, it would be a completely different error message.

Also, turn you Poller Logging Level up to Debug and then post one pass of the poller from your log.

needsomehelp · Post by **needsomehelp** » Thu May 26, 2005 6:59 am

Yes, mysqld is on, and I am able to login through the web interface. It's picking up data, there's just no graph to display it...arrggg...and I'm not sure how to turn on the poller logging up to debug. Sorry! Forgive me, when I say novice, I mean, a pee-brain when it comes to Linux applications :-\

Post by **rony** » Thu May 26, 2005 7:09 am

In the web interface, Settings->General->Poller Logging Level, set it to Debug. Then let the poller run and post just one run of the poller from your log/cacti.log in your cacti directory.

needsomehelp · Post by **needsomehelp** » Thu May 26, 2005 7:21 am

Thank you!!!! Set it to debug!! You're awesome! Will be back later to post log

Post by **TheWitness** » Thu May 26, 2005 1:24 pm

You need to edit my.conf and increase the number of concurrent client connections. Your error messages seemed to be associated with running out of connections. Please also give that a try. For larger sites, we have customers using as many as 500 connections in thier my.conf file.

TheWitness

No Graphs with Cacti

No Graphs with Cacti

Who is online