Cacti installed but No Graphs and No rrds Files

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
rsheb
Posts: 3
Joined: Mon Jul 10, 2006 4:30 am
Location: France

Cacti installed but No Graphs and No rrds Files

Post by rsheb »

Hi for all .. I installed the cacti8.0.6h version but idont get Graphs neither Rdds Files plz help me ... This is my log file:

07/10/2006 11:36:33 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=4"
07/10/2006 11:36:33 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=4"
07/10/2006 11:36:33 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='4' and user_auth_realm.realm_id='15'"
07/10/2006 11:36:33 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/10/2006 11:36:33 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/10/2006 11:36:29 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=4"
07/10/2006 11:36:29 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=4"
07/10/2006 11:36:29 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='4' and user_auth_realm.realm_id='15'"
07/10/2006 11:36:29 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/10/2006 11:36:29 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/10/2006 11:36:26 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=4"
07/10/2006 11:36:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=4"
07/10/2006 11:36:26 AM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='4' and user_auth_realm.realm_id='8'"
07/10/2006 11:36:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/10/2006 11:36:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/10/2006 11:36:26 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into user_log (username,user_id,result,ip,time) values('cactiuser',4,1,'127.0.0.1',NOW())"
07/10/2006 11:36:26 AM - CMDPHP: Poller[0] DEBUG: SQL Row: "select * from user_auth where username='cactiuser' and password = '4f38f4117791e85980213136bb816569' and realm = 0"
07/10/2006 11:36:26 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/10/2006 11:36:23 AM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/07/2006 04:06:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=4"
07/07/2006 04:06:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=4"
07/07/2006 04:06:27 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='4' and user_auth_realm.realm_id='15'"
07/07/2006 04:06:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/07/2006 04:06:27 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/07/2006 04:06:24 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select realm_id from user_auth_realm where user_id=4"
07/07/2006 04:06:24 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select username from user_auth where id=4"
07/07/2006 04:06:24 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select user_auth_realm.realm_id from user_auth_realm where user_auth_realm.user_id='4' and user_auth_realm.realm_id='15'"
07/07/2006 04:06:24 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select id from user_auth where username='guest'"
07/07/2006 04:06:24 PM - CMDPHP: Poller[0] DEBUG: SQL Cell: "select cacti from version"
07/07/2006 04:06:21 PM - WEBLOG: Poller[0] CACTI2RRD: c:\rrdtool\rrdtool.exe graph - --imgformat=PNG --start=-86400 --end=-300 --title="PONTICELLI-SIEGE - Traffic - Nu0" --rigid --base=1000 --height=120 --width=500 --alt-autoscale-max --lower-limit=0 --vertical-label="bits per second" --slope-mode DEF:a="C\:/Program Files/xampp/htdocs/cacti/rra/ponticellisiege_traffic_in_42.rrd":traffic_in:AVERAGE DEF:b="C\:/Program Files/xampp/htdocs/cacti/rra/ponticellisiege_traffic_in_42.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"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=42"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=8"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=9"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select type,value from cdef_items where id=7"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select * from cdef_items where cdef_id=2 order by sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select name,data_source_path from data_template_data where local_data_id=42"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Assoc: "select graph_templates_item.id as graph_templates_item_id, graph_templates_item.cdef_id, graph_templates_item.text_format, graph_templates_item.value, graph_templates_item.hard_return, graph_templates_item.consolidation_function_id, graph_templates_item.graph_type_id, graph_templates_gprint.gprint_text, colors.hex, data_template_rrd.id as data_template_rrd_id, data_template_rrd.local_data_id, data_template_rrd.rrd_minimum, data_template_rrd.rrd_maximum, data_template_rrd.data_source_name, data_template_rrd.local_data_template_rrd_id from graph_templates_item left join data_template_rrd on (graph_templates_item.task_item_id=data_template_rrd.id) left join colors on (graph_templates_item.color_id=colors.id) left join graph_templates_gprint on (graph_templates_item.gprint_id=graph_templates_gprint.id) where graph_templates_item.local_graph_id=41 order by graph_templates_item.sequence"
07/07/2006 04:06:21 PM - CMDPHP: Poller[0] DEBUG: SQL Row: "select graph_local.host_id, graph_local.snmp_query_id, graph_local.snmp_index, graph_templates_graph.title_cache, graph_templates_graph.vertical_label, graph_templates_graph.auto_scale, graph_templates_graph.auto_scale_opts, graph_templates_graph.auto_scale_log, graph_templates_graph.auto_scale_rigid, graph_templates_graph.auto_padding, graph_templates_graph.base_value, graph_templates_graph.upper_limit, graph_templates_graph.lower_limit, graph_templates_graph.height, graph_templates_graph.width, graph_templates_graph.image_format_id, graph_templates_graph.unit_value, graph_templates_graph.unit_exponent_value, graph_templates_graph.export from (graph_templates_graph,graph_local) where graph_local.id=graph_templates_graph.local_graph_id and graph_templates_graph.local_graph_id=41"
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

1) read http://forums.cacti.net/viewtopic.php?t=11747

2) Per the last entry in the FAQ, you are not in debugging mode. Please try again.
Top
rsheb
Posts: 3
Joined: Mon Jul 10, 2006 4:30 am
Location: France

Post by rsheb »

thanks for your help BSDD but,
i had read your URL more than twice,
2) Per the last entry in the FAQ, you are not in debugging mode. Please try again.
my cacti is turning in Debug mode i'm sure ....
have you another solution plz
Top
rsheb
Posts: 3
Joined: Mon Jul 10, 2006 4:30 am
Location: France

Post by rsheb »

This what i obtain when i click on one of graph titles in the section "Graph Management" :

RRDTool Command:

c:\rrdtool\rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="PONTICELLI-SIEGE - Traffic - ATM1.106-aal5 l" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="C\:/Program Files/xampp/htdocs/cacti/rra/ponticellisiege_traffic_in_45.rrd":traffic_in:AVERAGE \
DEF:b="C\:/Program Files/xampp/htdocs/cacti/rra/ponticellisiege_traffic_in_45.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"

RRDTool Says:

ERROR: opening 'C:/Program Files/xampp/htdocs/cacti/rra/ponticellisiege_traffic_in_45.rrd': No such file or directory
Top
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Please follow the last entry in the FAQ, it DOES apply to you. Repost your cacti log once it's truly in debugging mode.

1) Are you able to see basic snmp information from PONTICELLI-SIEGE?
2) You didn't follow the install guide and instead used xmapp, which has been known to cause problems for cacti users. I strongly suggest you follow the installation guide.
Top
Post Reply

Return to “Help: Windows Specific”

Who is online

Users browsing this forum: No registered users and 5 guests