Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Cisco BGP graph
Goto page Previous  1, 2, 3
 
Post new topic   Reply to topic    Cacti Forum Index -> Scripts and Templates
Author Message
churchi



Joined: 26 Oct 2004
Posts: 38

PostPosted: Fri May 18, 2007 6:26 am    Post subject: Reply with quote

hey guys,

thank you for creating this graph, it should be useful in our BGP environments as well.

i have been running this graph for a few hours now and all i seem to get is 0's on the graph. it looks like its trying to graph something (not getting NAN) so i think its polling just not graphing it properly.

has any one had this before?

(Please see the attached Pic)



BGB Updates-pic1.JPG
 Description:
 Filesize:  26.95 KB
 Viewed:  2934 Time(s)

BGB Updates-pic1.JPG


Back to top
riffe



Joined: 20 May 2007
Posts: 1

PostPosted: Sun May 20, 2007 10:23 pm    Post subject: No BGP Graph Reply with quote

Hi, I'm a newbie in Cacti and I'm having a problem on the Cisco BGP Template. It seems that there are no graphs created. I already copied the cisco_bgp.xml at the resource/snmp_queries dir. I'm using cacti-0.8.6j version.

Thanks in advance.



cisco-bgp.PNG
 Description:
 Filesize:  5.92 KB
 Viewed:  2912 Time(s)

cisco-bgp.PNG


Back to top
xmen



Joined: 22 May 2007
Posts: 2

PostPosted: Tue May 22, 2007 7:43 am    Post subject: BGP graphs not created Reply with quote

I met the sam problem as riffe, no graphs been created.
Any one could help?

Thanks.
Back to top
gandalf
Developer


Joined: 02 Dec 2004
Posts: 11377
Location: Muenster, Germany

PostPosted: Tue May 22, 2007 2:47 pm    Post subject: Reply with quote

What's the status of that host in the Device list?
Reinhard
Back to top
xmen



Joined: 22 May 2007
Posts: 2

PostPosted: Mon Jun 04, 2007 9:42 am    Post subject: Reply with quote

gandalf wrote:
What's the status of that host in the Device list?
Reinhard

Device should be ok, because traffice graphs is normally.



3.JPG
 Description:
no graphs been created.
 Filesize:  47.45 KB
 Viewed:  2777 Time(s)

3.JPG



2.JPG
 Description:
data query seems normal.
 Filesize:  42.43 KB
 Viewed:  2777 Time(s)

2.JPG



1.JPG
 Description:
my cacti version.
 Filesize:  49.61 KB
 Viewed:  2777 Time(s)

1.JPG


Back to top
redrobish



Joined: 29 May 2007
Posts: 23

PostPosted: Fri Jun 15, 2007 1:15 am    Post subject: Reply with quote

I got the same problem w/ riffe and xmen.
My graph don't display...can anyone help?
Back to top
myha



Joined: 05 Oct 2006
Posts: 1

PostPosted: Fri Aug 24, 2007 3:02 am    Post subject: Reply with quote

Hi,

same here, I guess it thinks that the host is down:

Admin Status(1-down,2-up)
All peers have status 1....

Version 0.8.6h

br, Miha
Back to top
horke



Joined: 04 Sep 2007
Posts: 1

PostPosted: Wed Sep 12, 2007 5:47 am    Post subject: Reply with quote

Go to

Templates -> Graph Templates
select "CISCO BGP Updates"
select "Unit Grid Value" and type in the value of "0"

If you create Graphs - also put in the Value of "0" if you are asked for the Grid Value again.

Then your Graphs should work. Otherwise debug you Graph and see what rrdtool shows as an error.
Back to top
jkukis



Joined: 24 Sep 2007
Posts: 23

PostPosted: Wed Oct 24, 2007 2:52 pm    Post subject: Reply with quote

I imported the data query xml file and it is able to find it, imported the graph template, and the data template.
It shows my two AS numbers when I view the 'create graphs for this host' page.
I select both AS's and click the "Create" button at the bottom and it comes back with this:

Code:

+ Created graph:
+ Created graph:


(Notice Blank graph names) I can't find the graphs anywhere.

Found this in the logs:

Code:

 10/24/2007 04:40:07 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=104 and data_template_rrd.local_data_id=18551"
10/24/2007 04:40:07 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=104 and data_template_rrd.local_data_id=18550"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id= and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select graph_templates_item.id, data_template_rrd.id as data_template_rrd_id, data_template_rrd.data_template_id from (graph_templates_item,data_template_rrd) where graph_templates_item.task_item_id=data_template_rrd.id and graph_templates_item.graph_template_id= and local_graph_id=0 and task_item_id>0"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select data_template.id, data_template.name, data_template_rrd.data_source_name from (data_template, data_template_rrd, graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.data_template_id=data_template.id and data_template_rrd.local_data_id=0 and graph_templates_item.local_graph_id=0 and graph_templates_item.graph_template_id= group by data_template.id order by data_template.name"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select graph_template_input.column_name, graph_template_input_defs.graph_template_item_id from (graph_template_input,graph_template_input_defs) where graph_template_input.id=graph_template_input_defs.graph_template_input_id and graph_template_input.graph_template_id="
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select * from graph_templates_item where local_graph_id=0 and graph_template_id= order by sequence"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "select * from graph_templates_graph where local_graph_id=0 and graph_template_id="
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "update graph_local set graph_template_id= where id=18178"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select data_input_fields.type_code, data_input_data.value from (data_input_fields,data_input_data) where data_input_fields.id=data_input_data.data_input_field_id and data_input_data.data_template_data_id= and (data_input_fields.type_code='index_type' or data_input_fields.type_code='index_value' or data_input_fields.type_code='output_type')"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select graph_templates_item.id, data_template_rrd.id as data_template_rrd_id, data_template_rrd.data_template_id from (graph_templates_item,data_template_rrd) where graph_templates_item.task_item_id=data_template_rrd.id and graph_templates_item.graph_template_id= and local_graph_id=0 and task_item_id>0"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select data_template.id, data_template.name, data_template_rrd.data_source_name from (data_template, data_template_rrd, graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.data_template_id=data_template.id and data_template_rrd.local_data_id=0 and graph_templates_item.local_graph_id=0 and graph_templates_item.graph_template_id= group by data_template.id order by data_template.name"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select graph_template_input.column_name, graph_template_input_defs.graph_template_item_id from (graph_template_input,graph_template_input_defs) where graph_template_input.id=graph_template_input_defs.graph_template_input_id and graph_template_input.graph_template_id="
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select * from graph_templates_item where local_graph_id=0 and graph_template_id= order by sequence"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "select * from graph_templates_graph where local_graph_id=0 and graph_template_id="
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "update graph_local set graph_template_id= where id=18177"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select graph_template_id from snmp_query_graph where id="
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select * from graph_template_input where graph_template_id= order by column_name,name"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "select * from graph_templates_graph where graph_template_id= and local_graph_id=0"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select name from graph_templates where id="
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "select graph_templates.name as graph_template_name, graph_templates_graph.* from (graph_templates, graph_templates_graph) where graph_templates.id=graph_templates_graph.graph_template_id and graph_templates.id= and graph_templates_graph.local_graph_id=0"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select data_template.name as data_template_name, data_template_rrd.data_source_name, data_template_data.* from (data_template, data_template_rrd, data_template_data, graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.data_template_id=data_template.id and data_template_data.data_template_id=data_template.id and data_template_rrd.local_data_id=0 and data_template_data.local_data_id=0 and graph_templates_item.local_graph_id=0 and graph_templates_item.graph_template_id= group by data_template.id order by data_template.name"
10/24/2007 04:40:05 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select graph_template_id from snmp_query_graph where id="
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Scripts and Templates All times are GMT - 5 Hours
Goto page Previous  1, 2, 3
Page 3 of 3

 



Powered by phpBB © 2001, 2005 phpBB Group