System Utilities says wrong RRDTool and Graphs dont show up

[jhermiz1978]

Post a screenshot of a different graph with debugging enabled which isn't working.

If you take the rrdtool graph command and manually run it on the commandline, does it work?

If on the cacti machine I go to a command line and do

snmpwalk HostNameOfAServer

Than it comes back with

"No log handling enabled - using stderr logging snmpwalk: TimeOut"

Is this normal?

[jhermiz1978]

Here is the latest screen shot of my log file:



I can do snmpwalks to the host, I see RRD files, but pictures appear to still be broken



Bump can anyone please point me in the right direction. I cannot seem to understand why this is happening.

[BSOD2600]

I wanted you to execute the rrdtool graph command manually at the command prompt, not the rrdtool create command.

No, that snmp error is not normal. Timeout signifies that either snmp is not configured on HostNameOfAServer or a firewall is blocking the traffic to/from the device.

[jhermiz1978]

I wanted you to execute the rrdtool graph command manually at the command prompt, not the rrdtool create command.

No, that snmp error is not normal. Timeout signifies that either snmp is not configured on HostNameOfAServer or a firewall is blocking the traffic to/from the device.

Can you please show me the command in dos?
I am quite new to cacti.

[jhermiz1978]

I wanted you to execute the rrdtool graph command manually at the command prompt, not the rrdtool create command.

No, that snmp error is not normal. Timeout signifies that either snmp is not configured on HostNameOfAServer or a firewall is blocking the traffic to/from the device.

I tried this:

C:\rrdtool>rrdtool graph --imgformat=PNG --start=-86400 --end=-300 --title="TKKA
H-IIS-1 Processes" --base=1000 --height=120 --width=500 DEF:a="c:\:/inetpub/wwwr
oot/cacti/rra/5/18.rrd":proc:AVERAGE

And then I see the 18.rrd file in the directory...but its a .rrd file so if I open it it just contains jibberish.

[BSOD2600]

I wanted you to execute the rrdtool graph command manually at the command prompt, not the rrdtool create command.

No, that snmp error is not normal. Timeout signifies that either snmp is not configured on HostNameOfAServer or a firewall is blocking the traffic to/from the device.

Can you please show me the command in dos?

You take the rrdtool graph command from the graph dedug window, format it to be 1 line, and specify a output filename.

[jhermiz1978]

I wanted you to execute the rrdtool graph command manually at the command prompt, not the rrdtool create command.

No, that snmp error is not normal. Timeout signifies that either snmp is not configured on HostNameOfAServer or a firewall is blocking the traffic to/from the device.

Can you please show me the command in dos?

You take the rrdtool graph command from the graph dedug window, format it to be 1 line, and specify a output filename.

C:\rrdtool>C:/rrdtool1.2/rrdtool.exe graph myfile.png --imgformat=PNG --start=-8
6400 --end=-300 --title="TKKAH-IIS-1 - Processes" --base=1000 --height=120 --wid
th=500 --alt-autoscale-max --lower-limit=0 --vertical-label="processes" --slope-
mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UNIT:7: DEF:a="C\:/
Inetpub/wwwroot/cacti/rra/5/18.rrd":proc:AVERAGE AREA:a#F51D30FF:"Running Proces
ses" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GPRINT:a
:MAX:"Maximum\:%8.0lf\n"

553x202
ERROR: failed to load /usr/local/rrdtool-1.2.15/share/rrdtool/fonts/DejaVuSansMo
no-Roman.ttf

Not sure where this file is being loaded, this is on a windows box so where is /usr/local?

[BSOD2600]

When you downloaded the rrdtool package, it should've came with DejaVuSansMono-Roman.ttf. You need to install this into the Windows fonts directory. The Windows installer does this all for you...

[jhermiz1978]

When you downloaded the rrdtool package, it should've came with DejaVuSansMono-Roman.ttf. You need to install this into the Windows fonts directory. The Windows installer does this all for you...

I used the windows installer...

I also already have that file in the windows directory....

Still same issue...

Lord I am close to giving up on this.

[jhermiz1978]

Is there any developers or anyone else who can please help me with this?

[jhermiz1978]

When you downloaded the rrdtool package, it should've came with DejaVuSansMono-Roman.ttf. You need to install this into the Windows fonts directory. The Windows installer does this all for you...

Ok so I switched to a later version of RRDTOOL, had gone back to 1.2 thinking that might of been the issue, back to 1.4.x

Now I run this:

C:\rrdtool>C:\rrdtool\rrdtool.exe graph filename="graph.png" --imgformat=PNG --s
tart=-86400 --end=-300 --title="TKKAH-IIS-1 - Logged in Users" --rigid --base=10
00 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label
="users" --slope-mode --font TITLE:10: --font AXIS:7: --font LEGEND:8: --font UN
IT:7: DEF:a="C\:/Inetpub/wwwroot/cacti/rra/5/23.rrd":users:AVERAGE AREA:a#4668E4
FF:"Users" GPRINTLAST:"Current\:%8.0lf" GPRINTAVERAGE:"Average\:%8.0lf" GP
RINTMAX:"Maximum\:%8.0lf\n"

And it returns:
595x196

I can see the image itself "graph.png" so I can see that image (although not a lot of data is there).
However on the actual cacti site I do not see any images, I only see broken image links...
Please can anyone resolve this for me.

[jhermiz1978]

I am getting closer.
I was able to use the User Management area to give myself permissions for the graphs.
But now in graph debug mode I only see Graph Access Denied. I have given rights to IIS User in the rrdtool directory and within the rra directory inside of the cacti directory.

I also checked the log file and am seeing an abundance of sql errors?

01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1064', SQL:"select local_graph_id from graph_templates_graph where local_graph_id="
01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="
01/11/2012 03:48:36 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.local_graph_id, graph_templates_graph.title from (graph_templates_graph,graph_local) where graph_templates_graph.local_graph_id=graph_local.id and graph_local.id="

I ran: php repair_database.php inside of c:\inetpub\wwwroot\cacti\cli directory and it reports that their are no errors in the records.


Can anyone tell me where to look or how to fix this please ?

[BSOD2600]

With all the errors and issues you've had so far, really sounds like you should completely start over FRESH.

[jmaris]

is this problem solved in the mean time?
I have the same issue. RRD files are not created. I am succesful in creating them manually (with the debug cmd and reformatting to get rid of the "\" char.)
Win 2003 Server / Windows installer for version 0.8.7.i (latest).
-Jan

[BSOD2600]

jmaris: Since you decided to post in this thread instead of starting a new one, you'll need to follow all of the same troubleshooting steps as jhermiz1978. Let me know if you solved the problem so the next installer corrects the issue(s).