[SOLVED] Graphs broken, can't create new ones.

[giobbi]

Hi all.

Tried to find the answer here but can't find it here or in FAQs.

I have used cacti on almost everything and it has worked great. A couple weeks ago i added an interface on a switch to graph but i didn't get any data. I saw in the debugger that it worked so i though there was some rra-file-problem, deleted them (bad idea?) to force cacti make new and fresh ones.

Now i i cant' get any interface graph on any of my servers and i can't figure out why. I have checked the database witch myiamchk and no errors here. Cacti is working on many other things on my net so the problem must lie on just these switches/graph.

thx.

G

[BSOD2600]

Follow the steps in http://docs.cacti.net/node/283

[giobbi]

Great thx for the tip BSOD2600!

I found the problem in my logs:

Apache
ERROR: opening '/usr/share/cacti/rra/cisco-24i-serverum_switch_fb_se_traffic_in_401.rrd': No such file or directory
ERROR: opening '/usr/share/cacti/rra/cisco-24i-serverum_switch_fb_se_traffic_in_407.rrd': No such file or directory
ERROR: opening '/usr/share/cacti/rra/cisco-24i-serverum_switch_fb_se_traffic_in_405.rrd': No such file or directory


php poller.php
ERROR: Duplicate DS name: traffic_out
ERROR: opening '/usr/share/cacti/rra/ap-serverrummet_traffic_in_392.rrd': No such file or directory
ERROR: Duplicate DS name: traffic_out
ERROR: opening '/usr/share/cacti/rra/ap-serverrummet_traffic_in_391.rrd': No such file or directory


So here is my problem - im missing the rra-files for the graphs! How do i make new ones? I tried to delete the host and all graphs but that didn't help.

thx.

[chrisgapske]

you could try to delete the graph item and than re add it in cacti.

[giobbi]

Thanks for replying.

I did delete the whole host acctually and then added the host again. The host is a Cisco-switch. I have imported a template for voltage and cpu, these two works great. When i add an interface i cant get any graph for any interface, only cpu and temp. The same goes for many of my hosts interface.

Is there any way to create an rrd-file "manually"?



thx

[giobbi]

Hello all.

I have found something strange; every time i try to create a new grap on an interface i get this strange name on the graph:

Graph Template: ucd 80 Lan

Strange?

[giobbi]

Update: I did a fresh install, 0.8.7a with fresh database. My problem seems to be that i cant create any Graphs on any interface, switch, host, ap-access but graphs on load, processes, discs works great. I see no errors besides that the rra-files are missing. Still cant figure out how to create those.. : (

Any helpful input is apreciated.

[gandalf]

Looks like an SNMP issue. When editing a switch, what does show up at the upper left of the screen?
Reinhard

[giobbi]

Hi Gandalf - thx for taking the time!

Everything looks ok, here is my upper left screen:

Cisco 24i Serverummet (10.0.5.218)
SNMP Information
System: Cisco IOS Software, C3560 Software (C3560-IPBASEK9-M), Version 12.2(25)SEE3, RELEASE SOFTWARE (fc2) Copyright (c) 1986-2007 by Cisco Systems, Inc. Compiled Thu 22-Feb-07 15:39 by myl
Uptime: 180820857 (20 days, 22 hours, 16 minutes)
Hostname: 24i-SERVERUM.fb.se
Location: Stora serverummet
Contact: Piero Giobbi

Like you i think there's something wrong with snmp but i can easly do snmpwalk to any interface on any host (NET-SNMP) and when i do a verbose query i see Success [249 Items, 31 Rows] wich indicates everything ok?


When i run the graph in debug i see:

RRDTool Command:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Cisco 24i Serverummet - Traffic - Gi0/27" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
--font TITLE:12: \
--font AXIS:8: \
--font LEGEND:10: \
--font UNIT:8: \
DEF:a="/usr/share/cacti/rra/cisco_24i_serverummet_traffic_in_16.rrd":traffic_in:AVERAGE \
DEF:b="/usr/share/cacti/rra/cisco_24i_serverummet_traffic_in_16.rrd":traffic_in:MAX \
DEF:c="/usr/share/cacti/rra/cisco_24i_serverummet_traffic_in_16.rrd":traffic_out:AVERAGE \
DEF:d="/usr/share/cacti/rra/cisco_24i_serverummet_traffic_in_16.rrd":traffic_out:MAX \
CDEF:cdefa=a,8,* \
CDEF:cdefd=b,8,* \
CDEF:cdefe=c,8,* \
CDEF:cdefh=d,8,* \
AREA:cdefa#00CF00FF:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefd:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#002A97FF:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefh:MAX:"Maximum\:%8.2lf %s"
RRDTool Says:
ERROR: opening '/usr/share/cacti/rra/cisco_24i_serverummet_traffic_in_16.rrd': No such file or directory

So, i got no rrd-file for this interface (and many other) but the query and poller seems to dont care? When i do php -f cmd.php in terminal i get:

12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] PING: Host is alive
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] SNMP: Host responded to SNMP
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[9] SNMP: v1: 10.0.5.218, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.1, output: 1159337232
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[9] SNMP: v1: 10.0.5.218, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.1, output: 367217984
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[10] SNMP: v1: 10.0.5.218, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.2, output: 2573272
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[10] SNMP: v1: 10.0.5.218, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.2, output: 30848
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[11] SNMP: v1: 10.0.5.218, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10101, output: 2124204004
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[11] SNMP: v1: 10.0.5.218, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10101, output: 4145206109
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[12] SNMP: v1: 10.0.5.218, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10105, output: 1716296242
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[12] SNMP: v1: 10.0.5.218, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10105, output: 3987706214
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[13] SNMP: v1: 10.0.5.218, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10121, output: 4168839054
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[13] SNMP: v1: 10.0.5.218, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10121, output: 967456445
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[14] SNMP: v1: 10.0.5.218, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10125, output: 125341817
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[14] SNMP: v1: 10.0.5.218, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10125, output: 3557874448
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[15] SNMP: v1: 10.0.5.218, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10126, output: 4119238546
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[15] SNMP: v1: 10.0.5.218, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10126, output: 1752787005
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[16] SNMP: v1: 10.0.5.218, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10127, output: 3564757907
12/16/2007 11:41:43 AM - CMDPHP: Poller[0] Host[3] DS[16] SNMP: v1: 10.0.5.218, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10127, output: 3967519122

I really don't know what to look for anymore. The file-permissions are set to 777 in whole cactifolder. Im running Debian 4, etch, latest cacti, latest pluginarc., se below.


Host info:
Technical Support
General Information
Date Sun, 16 Dec 2007 11:24:23 +0100
Cacti Version 0.8.7a
Cacti OS unix
SNMP Version net-snmp
RRDTool Version RRDTool 1.2.x
Hosts 8
Graphs 25
Data Sources Script/Command: 5
SNMP: 2
SNMP Query: 19
Total: 26
Poller Information
Interval 300
Type cmd.php
Items Action[0]: 40
Action[1]: 5
Total: 45
Concurrent Processes 3
Max Threads 3
PHP Servers 3
Script Timeout 25
Max OID 10
Last Run Statistics Time:1.4996 Method:cmd.php Processes:3 Threads:N/A Hosts:9 HostsPerProcess:3 DataSources:45 RRDsProcessed:26
PHP Information
PHP Version 5.2.0-8+etch7
PHP OS Linux
PHP uname Linux ns.intern.fb.se 2.6.18-5-686 #1 SMP Sat Dec 1 22:58:58 UTC 2007 i686
PHP SNMP Installed
max_execution_time 30
memory_limit 16M
MySQL Table Information
Name Rows Engine Collation Check Status
cdef 8 MyISAM latin1_swedish_ci OK
cdef_items 20 MyISAM latin1_swedish_ci OK
colors 101 MyISAM latin1_swedish_ci OK
data_input 12 MyISAM latin1_swedish_ci OK
data_input_data 473 MyISAM latin1_swedish_ci OK
data_input_fields 46 MyISAM latin1_swedish_ci OK
data_local 26 MyISAM latin1_swedish_ci OK
data_template 47 MyISAM latin1_swedish_ci OK
data_template_data 73 MyISAM latin1_swedish_ci OK
data_template_data_rra 323 MyISAM latin1_swedish_ci OK
data_template_rrd 714 MyISAM latin1_swedish_ci OK
graph_local 25 MyISAM latin1_swedish_ci OK
graph_template_input 93 MyISAM latin1_swedish_ci OK
graph_template_input_defs 306 MyISAM latin1_swedish_ci OK
graph_templates 39 MyISAM latin1_swedish_ci OK
graph_templates_gprint 3 MyISAM latin1_swedish_ci OK
graph_templates_graph 64 MyISAM latin1_swedish_ci OK
graph_templates_item 485 MyISAM latin1_swedish_ci OK
graph_tree 3 MyISAM latin1_swedish_ci OK
graph_tree_items 7 MyISAM latin1_swedish_ci OK
host 8 MyISAM latin1_swedish_ci OK
host_graph 6 MyISAM latin1_swedish_ci OK
host_snmp_cache 1674 MyISAM latin1_swedish_ci OK
host_snmp_query 10 MyISAM latin1_swedish_ci OK
host_template 8 MyISAM latin1_swedish_ci OK
host_template_graph 15 MyISAM latin1_swedish_ci OK
host_template_snmp_query 14 MyISAM latin1_swedish_ci OK
mac_track_approved_macs 0 MyISAM latin1_swedish_ci OK
mac_track_device_types 5 MyISAM latin1_swedish_ci OK
mac_track_devices 12 MyISAM latin1_swedish_ci OK
mac_track_interfaces 0 MyISAM latin1_swedish_ci OK
mac_track_ip_ranges 0 MyISAM latin1_swedish_ci OK
mac_track_ips 0 MyISAM latin1_swedish_ci OK
mac_track_macauth 0 MyISAM latin1_swedish_ci OK
mac_track_macwatch 0 MyISAM latin1_swedish_ci OK
mac_track_oui_database 10995 MyISAM latin1_swedish_ci OK
mac_track_ports 0 MyISAM latin1_swedish_ci OK
mac_track_processes 0 MyISAM latin1_swedish_ci OK
mac_track_scan_dates 0 MyISAM latin1_swedish_ci OK
mac_track_scanning_functions 13 MyISAM latin1_swedish_ci OK
mac_track_sites 4 MyISAM latin1_swedish_ci OK
mac_track_temp_ports 0 MyISAM latin1_swedish_ci OK
mac_track_vlans 0 MyISAM latin1_swedish_ci OK
plugin_discover_hosts 54 MyISAM latin1_swedish_ci OK
plugin_discover_template 0 MyISAM latin1_swedish_ci OK
plugin_update_info 7 MyISAM latin1_swedish_ci OK
poller 0 MyISAM latin1_swedish_ci OK
poller_command 0 MyISAM latin1_swedish_ci OK
poller_item 45 MyISAM latin1_swedish_ci OK
poller_output 0 MyISAM latin1_swedish_ci OK
poller_reindex 9 MyISAM latin1_swedish_ci OK
poller_time 3 MyISAM latin1_swedish_ci OK
rra 5 MyISAM latin1_swedish_ci OK
rra_cf 10 MyISAM latin1_swedish_ci OK
settings 98 MyISAM latin1_swedish_ci OK
settings_graphs 0 MyISAM latin1_swedish_ci OK
settings_tree 0 MyISAM latin1_swedish_ci OK
snmp_query 10 MyISAM latin1_swedish_ci OK
snmp_query_graph 21 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd 45 MyISAM latin1_swedish_ci OK
snmp_query_graph_rrd_sv 59 MyISAM latin1_swedish_ci OK
snmp_query_graph_sv 40 MyISAM latin1_swedish_ci OK
user_auth 3 MyISAM latin1_swedish_ci OK
user_auth_perms 0 MyISAM latin1_swedish_ci OK
user_auth_realm 43 MyISAM latin1_swedish_ci OK
user_log 11 MyISAM latin1_swedish_ci OK
version 1 MyISAM latin1_swedish_ci OK


snmp

NET-SNMP Support enabled
NET-SNMP Version 5.2.3

thx

[TheWitness]

http://forums.cacti.net/viewtopic.php?t=6773

[giobbi]

Thx Witness!

That was my problem, can't figure out how it got like that from a fresh install?

thx again.

g

[TheWitness]

What version of MySQL? If you run following command, what do you get:

Code: Select all

mysql 
show global variables like 'sql%';
quit

TheWitness