RRDs not created or graphed

echouin12 · Posted: Fri Jul 18, 2008 10:39 am Post subject: RRDs not created or graphed

I've just installed Cacti 0.8.7b and I am working on the very basics. I configured the localhost in host templates and now I am trying to graph localhost.

If I turn on graph debug mode I see an error, the rrd is not created so the rra is empty.
So then, to do a little debugging copied the commands to create the rrd in shell and executed it and everything works, but now after about 20 minutes nothing is showing up on my graph.

So my first issue is that the rrd is not atumatically created and secondly if I create the rrd nothing is graphed. (I also don't have the spine installed)

Please keep in mind that I am not only new to Cacti, but to programming also. So please be very specific and don't worry about insulting me with easy instructions.

Cacti Version: 0.8.7b
Httpd (apache) Version: 2.0.52
MySql Version: 4.0.21
Net-SNMP Version: 5.1.2
PHP Version: 4.3.8
RRDtool Version: 1.0.49 (should prolly be updated)
Linux: Red Hat 4

Thanks for your help!

echouin12 · Posted: Fri Jul 18, 2008 11:26 am Post subject:

The graph doesn't display anything becasue its given NaN values and therefore nothing is graphed and when I try to open the rra file I get a bunch of mumbu-jumbo, not even NaN values. So I think the problem may lie in my rrdtool which I have both an old version, as I have listed above, but I also have the newest version 1.2.23-3 which is the one I think it is using. I just need some help getting started and figuring out a resolution to my problem.

I really appreciate your help, thanks!!

mylo · Joined: 19 Jul 2008 Posts: 6

Can someone help me out..I have installed cacti on fedora2 and have re-installed it for more than 10 times but getting the error below i do not see any graphs populated....even for the local host as well.

Im running the latest verison of cati 0.8.7b

RRDTool Command:

/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Localhost - Load Average" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--units-exponent=0 \
--vertical-label="processes in the run queue" \
DEF:a="/usr/local/cacti/rra/localhost_load_1min_5.rrd":load_1min:AVERAGE \
DEF:b="/usr/local/cacti/rra/localhost_load_1min_5.rrd":load_5min:AVERAGE \
DEF:c="/usr/local/cacti/rra/localhost_load_1min_5.rrd":load_15min:AVERAGE \
CDEF:cdefg=TIME,1216463042,GT,a,a,UN,0,a,IF,IF,TIME,1216463042,GT,b,b,UN,0,b,IF,IF,TIME,1216463042,GT,c,c,UN,0,c,IF,IF,+,+ \
AREA:a#EACC00:"1 Minute Average" \
GPRINT:a:LAST:" Current\:%8.2lf\n" \
STACK:b#EA8F00:"5 Minute Average" \
GPRINT:b:LAST:" Current\:%8.2lf\n" \
STACK:c#FF0000:"15 Minute Average" \
GPRINT:c:LAST:"Current\:%8.2lf\n" \
LINE1:cdefg#000000:""

RRDTool Says:

ERROR: opening '/usr/local/cacti/rra/localhost_load_1min_5.rrd': No such file or directory

echouin12 · Posted: Mon Jul 21, 2008 8:18 am Post subject:

It seems we are both having trouble with RRDtool, is there anyone who has experienced the same thing who can offer help or suggestions to fix this issue.

Also, I have been trying to follow an example but keep getting Net-SNMP errors, and all the solutions say to make changes to my snmpd.conf file, but I can't find mine, nor do I think I have one.

So any help or suggestions would be greatly appreciated.

Thanks

echouin12 · Posted: Mon Jul 21, 2008 8:39 am Post subject:

Here's a bit more about my RRDtool issue. I am using the host linux box and when I turn on Data Source Debug Mode I find this
/usr/bin/rrdtool create \
/www/htdocs/cacti/rra/localhost_5min_cpu_8.rrd \
--step 300 \
DS:5min_cpu:GAUGE:600:0:100 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
Which I had to execute by hand because it won't create the rrd. When I graph nothing shows up and when I lood at the rrd localhost_5min_cpu_8.rrd I get this
��
over and over, so not even NAN values are being stored and I don't know how to debug this. It says the host is alive and and the Unix-Get Mounted Partition is Status:Success so any help trying to discover the cause of these issues would be really helpful.
Thanks!!!

echouin12 · Posted: Mon Jul 21, 2008 10:40 am Post subject:

Are there plugins I should add or what? I've been reading through the manuals, the forum and noone seems to have answers for me, I'm completely stuck. I don't know where to go or how to fix this problem, I would really appreciate some help.
Thanks!

mylo · Joined: 19 Jul 2008 Posts: 6

Guys can someone please help i am a newbie to this and getting this error and i really googled alot but havent manage dto solve th eproblem..read in the manual that when creating the crone you should not run it as rra files will not be deteced and it will regenerate more files....I re-installed cacti and havent runned cronn just restarted the machine and cron started with the services in cacti...can someone help me out to solve th ebelow.

RRDTool Command:

/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Consolbase - CPU Usage" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="percent" \
--slope-mode \
DEF:a="/usr/local/cacti/rra/consolbase_5min_cpu_9.rrd":5min_cpu:AVERAGE \
AREA:a#FF0000:"CPU Usage" \
GPRINT:a:LAST:"Current\:%8.0lf" \
GPRINT:a:AVERAGE:"Average\:%8.0lf" \
GPRINT:a:MAX:"Maximum\:%8.0lf"

RRDTool Says:

ERROR: opening '/usr/local/cacti/rra/consolbase_5min_cpu_9.rrd': No such file or directory

mylo · Joined: 19 Jul 2008 Posts: 6

07/21/2008 11:17:32 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=8"

07/21/2008 11:16:25 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=8"

Thats my Log fil e in cacti

mylo · Joined: 19 Jul 2008 Posts: 6

07/21/2008 11:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT poller_item.*, data_template_data.name_cache, host.description FROM data_template_data INNER JOIN (poller_item INNER JOIN host ON poller_item.host_id = host.id) ON data_template_data.local_data_id = poller_item.local_data_id WHERE poller_item.local_data_id=data_template_data.local_data_id ORDER BY data_template_data.name_cache ASC, action ASC LIMIT 0,30"
07/21/2008 11:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(*) FROM data_template_data INNER JOIN (poller_item INNER JOIN host ON poller_item.host_id = host.id) ON data_template_data.local_data_id = poller_item.local_data_id WHERE poller_item.local_data_id=data_template_data.local_data_id"
07/21/2008 11:25:13 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=8"
07/21/2008 11:24:57 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT poller_item.*, data_template_data.name_cache, host.description FROM data_template_data INNER JOIN (poller_item INNER JOIN host ON poller_item.host_id = host.id) ON data_template_data.local_data_id = poller_item.local_data_id WHERE poller_item.local_data_id=data_template_data.local_data_id ORDER BY data_template_data.name_cache ASC, action ASC LIMIT 0,30"
07/21/2008 11:24:57 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(*) FROM data_template_data INNER JOIN (poller_item INNER JOIN host ON poller_item.host_id = host.id) ON data_template_data.local_data_id = poller_item.local_data_id WHERE poller_item.local_data_id=data_template_data.local_data_id"
07/21/2008 11:17:32 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=8"
07/21/2008 11:16:25 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select snmp_query_graph_rrd.snmp_field_name, data_template_rrd.id as data_template_rrd_id from (snmp_query_graph_rrd,data_template_rrd) where snmp_query_graph_rrd.data_template_rrd_id=data_template_rrd.local_data_template_rrd_id and snmp_query_graph_rrd.snmp_query_graph_id= and snmp_query_graph_rrd.data_template_id=41 and data_template_rrd.local_data_id=8"

jrego · Joined: 14 Jul 2008 Posts: 33

Im having the same issue. Im using fedora though.

Try this. If you run the below commands from terminal bein already in the /usr/local/cacti/rra/ directory. See if it runs. Then do an ls to see if its there ? with me it works when i run it manually. But for some reason it doesn't though the app. I think it has something to do with permissions to the rrdtool as well as the folder where you are placing the files.

I havent figured mine out yet but i thought i would add my findings as well.

/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Consolbase - CPU Usage" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="percent" \
--slope-mode \
DEF:a="/usr/local/cacti/rra/consolbase_5min_cpu_9.rrd":5min_cpu:AVERAGE \
AREA:a#FF0000:"CPU Usage" \
GPRINT:a:LAST:"Current\:%8.0lf" \
GPRINT:a:AVERAGE:"Average\:%8.0lf" \
GPRINT:a:MAX:"Maximum\:%8.0lf"

mylo · Joined: 19 Jul 2008 Posts: 6

what command do i have to run in the rra directory ???
How do i enebale permision on the rra tools ?

Please help

Thanks

mylo · Joined: 19 Jul 2008 Posts: 6

when i runn poller .php i get tthe below error..is ithis ok ????

[root@localhost rra]# dir
[root@localhost rra]# php poller.php
Status: 404
Content-type: text/html
X-Powered-By: PHP/4.3.10

No input file specified.
[root@localhost rra]#

jrego · Joined: 14 Jul 2008 Posts: 33

just try and copy and paste the below into terminal. Be sure you are in the rra directory.

/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Consolbase - CPU Usage" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="percent" \
--slope-mode \
DEF:a="/usr/local/cacti/rra/consolbase_5min_cpu_9.rrd":5min_cpu:AVERAGE \
AREA:a#FF0000:"CPU Usage" \
GPRINT:a:LAST:"Current\:%8.0lf" \
GPRINT:a:AVERAGE:"Average\:%8.0lf" \
GPRINT:a:MAX:"Maximum\:%8.0lf"

also do you have the BOOST plugin installed?

are you using the discovery plugin? if so how many subnets are you scanning at a time?

jrego · Joined: 14 Jul 2008 Posts: 33

if you are using discovery make sure that you have set up your Discovery tamplates correct with the correct version of snmp as well as the correct type of device.

echouin12 · Posted: Tue Jul 22, 2008 1:22 pm Post subject:

Alright well I still haven't figure out what's up, but if your RRDtool isn't creating the rrd files in the rra and your cacti.log file is empty thats because your poller.php isn't right. I haven't quite figured it out be here is the posts I've been working off of, hopefully it can help some of you. Best of Luck,
http://forums.cacti.net/viewtopic.php?t=28288&postdays=0&postorder=asc&start=0