help:about data source name and graph title

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
yangzi0859
Posts: 3
Joined: Thu Mar 24, 2011 11:40 pm

help:about data source name and graph title

Post by yangzi0859 »

0.8.7b ,in manage mode, data source name or graph title like this :|host_description| - |query_ifName| - |query_ifalias| ,
but upgrade to 0.8.7e, data source name or graph title like this :|host_description| - GigabitEthernet3/0/4 - Szl_S8016_G_4/0/2

how can i keep the name/title use |host_description| - |query_ifName| - |query_ifalias| ?

sorry my English.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: help:about data source name and graph title

Post by gandalf »

yangzi0859
Posts: 3
Joined: Thu Mar 24, 2011 11:40 pm

Re: help:about data source name and graph title

Post by yangzi0859 »

thanks,
i already have a Data Query define the title and name like :|host_description| - |query_ifName| - |query_ifalias|,
when i create a graph , that in mysql table "data_template_data" the fieldname "name" value is :|host_description| - GigabitEthernet3/0/4 - Szl_S8016_G_4/0/2 ,This is not what i want, i want the value is :|host_description| - |query_ifName| - |query_ifalias|.

What can i do ?
yangzi0859
Posts: 3
Joined: Thu Mar 24, 2011 11:40 pm

Re: help:about data source name and graph title

Post by yangzi0859 »

Who can help me?
Thanks
noname
Cacti Guru User
Posts: 1566
Joined: Thu Aug 05, 2010 2:04 am
Location: Japan

Re: help:about data source name and graph title

Post by noname »

Try this:

(1) Go Device-> (your device) -> Data Source List
(2) Select all datasources, choose an action: Reapply Suggested Names, and click go
(3) Check whether if the value of "name" field in that table was rewrited (by the following SQL)

Code: Select all

SELECT id,data_template_id,name,name_cache FROM data_template_data WHERE data_template_id=XX;
I tested this behavior at Cacti 0.8.7e, don't know this is a bug or not.


But, if using Cacti 0.8.7g, you'll be asked to decide name/title field when creating graphs.
Cacti 0.8.7g
Cacti 0.8.7g
create_graphs_from_data_query.png (18.63 KiB) Viewed 1305 times
(Default value in textbox is depend on your Data/Graph template)

Also the value for "name" field in data_template_data table will be set properly.
Query results
Query results
data_template_data.png (25.27 KiB) Viewed 1302 times
bdiez
Posts: 15
Joined: Thu Sep 08, 2005 8:09 am
Location: Spain

Re: help:about data source name and graph title

Post by bdiez »

Hi all.

I'm having the same problem than yangzi0859.

When creating new graphs with suggested values for the datasource and graph names with several fields, like "|host_description| - |query_ifName| - |query_ifalias|", both the created DS and graphs get a name value on wich the first field (|host_description|) is maintained as is, but the next ones (|query_ifName| - |query_ifalias|) are substituted by the calculated values.

This means that if I go to the device and change for example the interface alias (description) the change will not be reflected in the graph or DS names as desired.

I've tried the solution proposed by noname, going to the DS and Graph lists and reapplying the suggested names and it seems to work fine, so at least there is a workaround.

I'm using Cacti 0.8.7g, but I'm pretty sure this problem did not exists in previous versions.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest