[SOLVED] following docs.cacti.net/node/54 -> poller_items

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

Moderators: Developers, Moderators

Post Reply
thomasw
Posts: 33
Joined: Thu Nov 10, 2005 6:11 am

[SOLVED] following docs.cacti.net/node/54 -> poller_items

Post by thomasw »

Hello,

I try to setup graphs which hold 5-min polling results for 125 days. I followed exactly the instructions on the page http://docs.cacti.net/node/54. the result is that the entries in the table poller_item are being not created. If I insert the entries manually into the table poller_item the rrd-files are being created at next poller-time and the graphing starts.

Does anybody notice the same behaviour, when following the mentioned document?
I`m using cacti 0.8.7a with both of the official patches and no plugins installed.

any help is highly welcome!

thanks in advance,

best regards,

tom
msylvain
Posts: 9
Joined: Wed Jan 23, 2008 3:30 am

Post by msylvain »

What append with this request :

Code: Select all

 select * from data_template_data,data_input,data_local 
    where data_template_data.data_input_id=data_input.id
        and data_local.id=data_template_data.local_data_id
        and data_local.host_id = XX;
where XX is your your id device.
The result of this kind of request is used to fill in the poller_item table.

Maybe having a look at the update_poller_cache() funtion, in the lib/utility.php file would help...
thomasw
Posts: 33
Joined: Thu Nov 10, 2005 6:11 am

poller_item still missing

Post by thomasw »

Hi,

the query returns the wanted result:

10998 10925 10935 49 2 NULL |host_description| - Traffic myswitch3-2 - Traffic NULL on NULL 300 NULL 2 bf566c869ac6443b0c75d1c32b5a350e Get SNMP Data (Indexed) 3 10935 49 97 1 50
10997 10925 10934 49 2 NULL |host_description| - Traffic myswitch3-2 - Traffic NULL on NULL 300 NULL 2 bf566c869ac6443b0c75d1c32b5a350e Get SNMP Data (Indexed) 3 10934 49 97 1 49

but the entries into the table poller_item are not being created.

even the update poller_cache does not help...
Any Ideas?

thanks in advance,

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

Re: following docs.cacti.net/node/54 -> poller_items miss

Post by gandalf »

thomasw wrote:Hello,

I try to setup graphs which hold 5-min polling results for 125 days. I followed exactly the instructions on the page http://docs.cacti.net/node/54. the result is that the entries in the table poller_item are being not created. If I insert the entries manually into the table poller_item the rrd-files are being created at next poller-time and the graphing starts.

Does anybody notice the same behaviour, when following the mentioned document?
I`m using cacti 0.8.7a with both of the official patches and no plugins installed.

any help is highly welcome!

thanks in advance,

best regards,

tom
Please decribe in more detail, which steps you've run and which settings were used. Post at least the full rra table
Reinhard
thomasw
Posts: 33
Joined: Thu Nov 10, 2005 6:11 am

details

Post by thomasw »

Hello,

my rra table looks like:

########################################################################
mysql> select * from rra;
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
| id | hash | name | x_files_factor | steps | rows | timespan |
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
| 1 | c21df5178e5c955013591239eb0afd46 | Daily (5 Minute Average) | 0.5 | 1 | 600 | 86400 |
| 2 | 0d9c0af8b8acdc7807943937b3208e29 | Weekly (30 Minute Average) | 0.5 | 6 | 700 | 604800 |
| 3 | 6fc2d038fb42950138b0ce3e9874cc60 | Monthly (2 Hour Average) | 0.5 | 24 | 775 | 2678400 |
| 4 | e36f3adb9f152adfa5dc50fd2b23337e | Yearly (1 Day Average) | 0.5 | 288 | 797 | 33053184 |
| 5 | 283ea2bf1634d92ce081ec82a634f513 | Hourly (1 Minute Average) | 0.5 | 1 | 500 | 14400 |
| 6 | ae055bcf3a448f23fec02de845f504dc | Custom (125 Days, no average, 5min) | 0.5 | 1 | 36000 | 10800000 |
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
6 rows in set (0.00 sec)
######################################################################

what I have done:

1. created rra based on my calculation
=> 12 datapoints per hour, 24 hours a day, 125 days => 36000 rows
=> 3600 sec / hour * 24 hours a day * 125 days => 10800000 timespan

2. created a data template based on interface traffic

3. created a graph template based on an existing one

4. added the newly defined Graph Template to the data query "SNMP Interface - Statistics"

5. created new graphs

6. received output on top of the page
+ Created graph: sw3-2@Gi0/1#Host:nach rzfco
+ Created graph: sw3-2@Gi0/2#Host:nach rzfco

So far everything was working as expected. But the graphs are never being created.
a database query of poller_item showed up, that there are no entries in the table. So I inserted them manually into the table. After that the poller created the wanted rrd files and graphing starts.

How can I track / trace down the situation?
any help is highly welcome!

if you need more information please let me know.

thanks,

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

Re: details

Post by gandalf »

thomasw wrote: ########################################################################
mysql> select * from rra;
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
| id | hash | name | x_files_factor | steps | rows | timespan |
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
| 6 | ae055bcf3a448f23fec02de845f504dc | Custom (125 Days, no average, 5min) | 0.5 | 1 | 36000 | 10800000 |
+----+----------------------------------+------------------------------------+----------------+-------+-------+----------+
######################################################################

what I have done:

1. created rra based on my calculation
=> 12 datapoints per hour, 24 hours a day, 125 days => 36000 rows
=> 3600 sec / hour * 24 hours a day * 125 days => 10800000 timespan
fine
2. created a data template based on interface traffic
Please post a screenshot of the Data Template -> RRA relation. And visit Data Sources, select the failing one, swicth to DEBUG and attach that output as well
Reinhard
thomasw
Posts: 33
Joined: Thu Nov 10, 2005 6:11 am

screenshots

Post by thomasw »

Hello,

please find the wanted screenshots attached at this post.

Is it correct that the Data Source Fields -> Data Source Path is empty, but the rrdtool create statement has the full path to the file?

thanks in advance,

best regards,

tom

ps: if you need more information please let me know
Attachments
Data Source Debug
Data Source Debug
data_source.JPG (93.03 KiB) Viewed 3527 times
Data Template -> RRA Relation
Data Template -> RRA Relation
data_template_rra_relation.JPG (85.8 KiB) Viewed 3531 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: screenshots

Post by gandalf »

thomasw wrote:Is it correct that the Data Source Fields -> Data Source Path is empty, but the rrdtool create statement has the full path to the file?
That's weird and not to be understood as a feature. I wonder what cacti.log shows when a new data source of this type is to be created. Does it show the rrdtool create with full path like DEBUg or does it show nothing?
Please select a second RRA at the DAta Template level (one including consolidation, e.g. the weekly/monthly/yearly one) and retry. Please post same information as above for this try.
If I will have to reproduce, it will take until weekend.
Reinhard
thomasw
Posts: 33
Joined: Thu Nov 10, 2005 6:11 am

late reply

Post by thomasw »

Hi,

sorry for the late reply, but I was off of work for a couple of days because of karneval.

the cacti.log shows nothing about graph-creation, mostly poller output as far as I can see.

I tried another datasource (one which is already included into cacti, based on interface - traffic) the path to the rrd file is in the datasource-fields -> data source path included. field show the following value:

- (<path_rra>/hostname_traffic_in_10692.rrd)

Attached I have a screenshot of the data source based on cacti predefined including consolidation and a screenshot of the rra relation.

hope you can find out whats the cause of the issue.

thanks in advance,

best regards,

tom
Attachments
Data Source based on cacti predefined interface - traffic
Data Source based on cacti predefined interface - traffic
data_source_cacti_predefined.JPG (69.23 KiB) Viewed 3469 times
RRA Relation for interface traffic (cacti predefined)
RRA Relation for interface traffic (cacti predefined)
rra_relation_cacti_predefined.JPG (84.28 KiB) Viewed 3469 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Would you mind posting your db? Please answer via pm and I'll give my email@
Reinhard
thomasw
Posts: 33
Joined: Thu Nov 10, 2005 6:11 am

SOLVED

Post by thomasw »

Hello,

the entries in the table poller_item are getting created now!

I missed to "check the checkboxes" in the data-queries -> SNMP int - stats -> Associated Data Templates section. Attached you find a screenshot of my failure...

@gandalf:
thank you very much for your assistance!
may you enhance the documentation (howto define a very big rra without data loss) to not forget to check the checkboxes? thank you!

best regards,

tom
Attachments
Missing the checkboxes
Missing the checkboxes
checkboxes.JPG (86.61 KiB) Viewed 3440 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Thank you for the pointers.
The missing item is described in the HowTo for creating data queries. I was not aware, that it should be mention in the doc you pointed me to. Will have to verify and add a comment
Reinhard
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests