No graphs (and everything I have tried so far)

shakey_1 · Post by **shakey_1** » Thu Feb 16, 2006 12:52 pm

First off, I apologize for yet another "no graph" thread. I searched and worked for several days before posting this though to try and clear up the situation. It hasn't happened though and I need to get this up and running. I will include everything that I have tried so far (from reading the other posts).

System Info:
Windows XP SP2
apache 2.0.55
cacti-0.8.6h
cacti-cactid-0.8.6g
mysql 4.1.18
net-snmp-5.2.2-1
php-4.4.2
rrdtool-cygwin-1.2.12
cygwin

I followed the guide from bsod2600 and that made it relatively painless. Thanks for that!

Settings
SNMP Utility Version - NET-SNMP 5.x
RRDTool Utility Version - RRDTool 1.2.x
SNMP Version - 1 (I have verified that the community string is correct and the IP allowed)

Paths
snmpwalk Binary Path - c:/net-snmp/bin/snmpwalk.exe
snmpget Binary Path - c:/net-snmp/bin/snmpget.exe
snmpbulkwalk Binary Path - c:/net-snmp/bin/snmpbulkwalk.exe
snmpgetnext Binary Path - c:/net-snmp/bin/snmpgetnext.exe
RRDTool Binary Path - c:/rrdtool/rrdtool.exe
RRDTool Default Font Path - c:/windows/fonts/arial.ttf
PHP Binary Path - c:/php/php.exe

Patches
Installed the patches using cygwin

Now onto the problems... cacti is running (the interface anyway). I can create a device, but when I try to create a graph they are all empty (simply showing the "X" image like they do not exist.

I have noticed in the cacti log file that I get this error -
02/16/2006 09:09:30 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "update data_template_data set rrd_maximum='|query_ifSpeed|' where local_data_id=24". I am not sure what it means though.

I have set the poller level to debug, but am getting nothing in my log file (<web root>\cacti\log>).

I ran both:
C:\php>php localhost\cacti/cmd.php >cmdlog.log
C:\php>php poller.php >pollerlog.log

and they produce the same results:
Cannot find module (IP-MIB): At line 0 in (none)
Cannot find module (IF-MIB): At line 0 in (none)
Cannot find module (TCP-MIB): At line 0 in (none)
Cannot find module (UDP-MIB): At line 0 in (none)
Cannot find module (SNMPv2-MIB): At line 0 in (none)
Cannot find module (SNMPv2-SMI): At line 0 in (none)
Cannot find module (UCD-SNMP-MIB): At line 0 in (none)
Cannot find module (UCD-DEMO-MIB): At line 0 in (none)
Cannot find module (SNMP-TARGET-MIB): At line 0 in (none)
Cannot find module (SNMP-VIEW-BASED-ACM-MIB): At line 0 in (none)
Cannot find module (SNMP-COMMUNITY-MIB): At line 0 in (none)
Cannot find module (UCD-DLMOD-MIB): At line 0 in (none)
Cannot find module (SNMP-FRAMEWORK-MIB): At line 0 in (none)
Cannot find module (SNMP-MPD-MIB): At line 0 in (none)
Cannot find module (SNMP-USER-BASED-SM-MIB): At line 0 in (none)
Cannot find module (SNMP-NOTIFICATION-MIB): At line 0 in (none)
Cannot find module (SNMPv2-TM): At line 0 in (none)

Running a manual poll (C:\php>php localhost/cacti/poller.php), I get this:
Cannot find module (IP-MIB): At line 0 in (none)
Cannot find module (IF-MIB): At line 0 in (none)
Cannot find module (TCP-MIB): At line 0 in (none)
Cannot find module (UDP-MIB): At line 0 in (none)
Cannot find module (SNMPv2-MIB): At line 0 in (none)
Cannot find module (SNMPv2-SMI): At line 0 in (none)
Cannot find module (UCD-SNMP-MIB): At line 0 in (none)
Cannot find module (UCD-DEMO-MIB): At line 0 in (none)
Cannot find module (SNMP-TARGET-MIB): At line 0 in (none)
Cannot find module (SNMP-VIEW-BASED-ACM-MIB): At line 0 in (none)
Cannot find module (SNMP-COMMUNITY-MIB): At line 0 in (none)
Cannot find module (UCD-DLMOD-MIB): At line 0 in (none)
Cannot find module (SNMP-FRAMEWORK-MIB): At line 0 in (none)
Cannot find module (SNMP-MPD-MIB): At line 0 in (none)
Cannot find module (SNMP-USER-BASED-SM-MIB): At line 0 in (none)
Cannot find module (SNMP-NOTIFICATION-MIB): At line 0 in (none)
Cannot find module (SNMPv2-TM): At line 0 in (none)
Status: 404
X-Powered-By: PHP/4.4.2
Content-type: text/html

So that is kind of where I stand. Any idea's on what I can do to resolve this? Thanks.

BSOD2600 · Post by **BSOD2600** » Thu Feb 16, 2006 1:31 pm

Ahhh, finally a first post with lots of info so I don't have to play 20 questions

1) that SQL Exec Failed can be ignored for now. the devs have recently been adding more debugging info and thats old code it's found.

2) Those Cannot find module (IP-MIB errors are from not properly setting up the MIBDIRS system variable and pointing it to your php mib directory. Cacti doesn't use MIB files so they're really not needed anyways.

3) Curious, try running rrdtool from the command prompt. No errors?
4) No graphs can be for several reasons:

a) no data being returned. To find out if that is the cause, Turn the polling level in cacti to debug (Settings | Polling level) for one cycle, wait for Cacti to run, and paste the output of the actual log file (<webroot>/cacti/log/cacti.log). If it contains WEBLOG entries, then don't bother posting since they just clutter up the log. Turn off WEBEVENTS logging and try again.

b) Wrong permissions set on a plethora of things. rrdtool.exe, php.exe, or the cacti folders/files. Use Sysinternals.com FileMon to take a look if your cactiuser account is getting denied when creating rrd files.

shakey_1 · Post by **shakey_1** » Thu Feb 16, 2006 3:46 pm

BSOD2600 wrote:Ahhh, finally a first post with lots of info so I don't have to play 20 questions

Thanks. It makes it tough when people don't give me enough information to work with, so I try not to do it myself.

I ran the following command from a command line: rrdtool create c:/localhost/cacti/rra/pvdc01_traffic_in_24.rrd\ --step 300 which resulted in this - ERROR: you must define at least one Round Robin Archive.

I ran filemon and did not see any access denied errors for my cacti user and have checked the file permissions on all folders relating to cacti (apache, cacti, php, rrdtool, cactid and mysql) and they should all have read, write and modify access.

I attached a copy of my log file, maybe that can help?

I really appreciate your help.

BSOD2600 · Post by **BSOD2600** » Thu Feb 16, 2006 9:19 pm

It doesn't appear you ran/waited for cacti to run one cycle with the debugging logging set. You'll notice a lot more / different information when this is on. Please try again. In it, you should also see the rrdtool.exe create commands.

shakey_1 · Post by **shakey_1** » Thu Feb 16, 2006 9:49 pm

Sorry about that, guess I misunderstood. I thought one cycle would have been the poll setting (5 minutes). Here is a file that has everything from when I last submitted the log. Thanks again.

BSOD2600 · Post by **BSOD2600** » Thu Feb 16, 2006 10:45 pm

I'm looking for stuff like:

Code: Select all

04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 4
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[2] SNMP: v2: ggeuxde4.gemenos.eur.gemplus.com, dsname: cpu_system, oid: .1.3.6.1.4.1.2021.11.52.0, value: 7889025
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (11,'cpu_system','2005-04-11 10:27:37','7889025')
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[9] SNMP Result: Host responded to SNMP
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: update host set status='3',status_event_count='0', status_fail_date='0000-00-00 00:00:00',status_rec_date='0000-00-00 00:00:00',status_last_error='',min_time='1.823900',max_time='209.597830',cur_time='2.274040',avg_time='63.901992',total_polls='5',failed_polls='0',availability='100.0000' where id='9'

04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[9] SNMP: v2: ggeuxde7.gemenos.eur.gemplus.com, dsname: cpu_nice, oid: .1.3.6.1.4.1.2021.11.51.0, value: 10141414
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (169,'cpu_nice','2005-04-11 10:27:37','10141414')
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[2] SNMP: v2: ggeuxde4.gemenos.eur.gemplus.com, dsname: cpu_user, oid: .1.3.6.1.4.1.2021.11.50.0, value: 2255892
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[9] SNMP: v2: ggeuxde7.gemenos.eur.gemplus.com, dsname: cpu_system, oid: .1.3.6.1.4.1.2021.11.52.0, value: 165334747
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (170,'cpu_system','2005-04-11 10:27:37','165334747')
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (12,'cpu_user','2005-04-11 10:27:37','2255892')
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[9] SNMP: v2: ggeuxde7.gemenos.eur.gemplus.com, dsname: cpu_user, oid: .1.3.6.1.4.1.2021.11.50.0, value: 113285284
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (171,'cpu_user','2005-04-11 10:27:37','113285284')
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[9] DEBUG: The POPEN returned the following File Descriptor 16
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/11/2005 10:27:39 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 5
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[10] SNMP Result: Host responded to SNMP
04/11/2005 10:27:39 AM - CACTID: Poller[0] Host[2] DEBUG: The POPEN returned the following File Descriptor 14
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: In Poller, About to Start Polling of Host
04/11/2005 10:27:39 AM - CACTID: Poller[0] MYSQL: Connecting to MySQL database 'cacti' on 'localhost'...
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: Valid Thread to be Created
04/11/2005 10:27:39 AM - CACTID: Poller[0] DEBUG: The Value of Active Threads is 2

Try setting the logging level to low, then save. Then change it back to debugging, save. That should enable debugging this time....

shakey_1 · Post by **shakey_1** » Thu Feb 16, 2006 11:25 pm

Okay, think I have what you were looking for this time. Your listing made me do a little more research. My log files have been showing the poller as cmdphp while your's showed as cactid. I found this thread that mentioned changing the poller path for the scheduled task and when I run it manually, it creates entries in the log file for the cactid poller and the cmdphp poller (not sure if that is correct or not). Also, I did finally have an .rrd file created in the rra folder, so that's a step in the right direction.

BSOD2600 · Post by **BSOD2600** » Fri Feb 17, 2006 2:13 pm

Sorry, I didn't mean to make you switch from cmd.php to cactid.exe just to get a debugging log. I was just trying to show a sample debugging output of a polling cycle, which is what your previous log was not. But on the otherhand, it appears it's working and you got a rrd file created for your traffic so it's a step in the right direction.

Since you've got a rrd file created now, no graph problems right?

shakey_1 · Post by **shakey_1** » Fri Feb 17, 2006 3:08 pm

No, unfortunately I am still not getting any graphs.

Maybe I need to go back through and make sure that I didn't miss an instruction somewhere.

BSOD2600 · Post by **BSOD2600** » Fri Feb 17, 2006 5:12 pm

Your rrd file(s) are being updated every 5 minutes right?

Click the wrench icon next to the graph to see the rrdtool.exe graph command. Copy that and manually run it yourself from the commandline. Do you get any errors? If you get a bunch of non-sense characters, it works. Then that means you have a permission issue with rrdtool.exe, cmd.exe or your files/folders.

shakey_1 · Post by **shakey_1** » Fri Feb 17, 2006 10:05 pm

No, I don't think that they are updating. When I look at the properties for the one I created yesterday, it shows the create date and modified date as the same - "Yesterday, February 16, 2006, 11:11:31 PM".

When I click on the wrench, I get the following and I am honestly not sure which one is the actual command:

c:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Servername - Traffic - IP Address (42:72:6F:61:64:)" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="C\:/Apache/Apache2/htdocs/cacti/rra/Servername_traffic_in_28.rrd":traffic_in:AVERAGE \
DEF:b="C\:/Apache/Apache2/htdocs/cacti/rra/Servername_traffic_in_28.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#002A97:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s"

I have double checked the permissions on all folders and there should be no problems there, so I am not sure what is going on.

BSOD2600 · Post by **BSOD2600** » Sat Feb 18, 2006 12:15 pm

1) hmm, rrdfile created but not being updated. sounds like a permission issue. Fire up Sysinternals Filemon and look during a polling cycle, if there are any access denied errors; I'm betting there are. You sure you gave the IIUSR_X account read/execute rights on cmd.exe?

2) That whole thing is the command... from c:/rrdtool/rrdtool.exe graph to GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s"

shakey_1 · Post by **shakey_1** » Mon Feb 20, 2006 10:10 pm

I'm back after having worked with it few days. I have now gotten graphs to be created for localhost, but not for other servers. If I try to add a new server, it comes back stating "SNMP Error". I know the SNMP Community string is correct and I can ping the server from a command prompt. It just doesn't seem to be communicating somewhere. I ran a verbose query and got this:

Data Query Debug Information

+ Running data query [1].
+ Found type = '3' [snmp query].
+ Found data query XML file at 'C:/Apache2/htdocs/cacti/resource/snmp_queries/interface.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.2.1.2.2.1.1'
+ No SNMP data returned
+ Found data query XML file at 'C:/Apache2/htdocs/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at 'C:/Apache2/htdocs/cacti/resource/snmp_queries/interface.xml'
+ Found data query XML file at 'C:/Apache2/htdocs/cacti/resource/snmp_queries/interface.xml'

I'm definitely moving in the right direction, but not quite there yet. Any idea's?

BSOD2600 · Post by **BSOD2600** » Mon Feb 20, 2006 10:38 pm

Firewall / router blocking SNMP traffic probably. Does SNMP work on the servers locally? Use a tool like GetIF or net-snmp snmpwalk to test. If it does, then thats even more reason to believe there is a firewall/router blocking your snmp traffic.

shakey_1 · Post by **shakey_1** » Mon Feb 20, 2006 11:28 pm

That thought had crossed my mind, but we have been using MRTG for a couple of months now with no problem. When I use snmpwalk - snmpwalk -v 1 -c cacti IP Address, I get this returned:

C:\net-snmp>snmpwalk -v 1 -c cacti IP Address
Cannot find module (NOTIFICATION-LOG-MIB): At line 1 in (none)
Cannot find module (NET-SNMP-AGENT-MIB): At line 1 in (none)
Cannot find module (DISMAN-EVENT-MIB): At line 1 in (none)
Timeout: No Response from IP Address

Just seems like they aren't communicating with each other.

No graphs (and everything I have tried so far)

No graphs (and everything I have tried so far)

Who is online