[SOLVED] following docs.cacti.net/node/54 -> poller_items
Moderators: Developers, Moderators
[SOLVED] following docs.cacti.net/node/54 -> poller_items
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
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
What append with this request :
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...
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;
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...
poller_item still missing
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
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
- 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
Please decribe in more detail, which steps you've run and which settings were used. Post at least the full rra tablethomasw 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
Reinhard
details
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
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
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
Re: details
finethomasw 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
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 well2. created a data template based on interface traffic
Reinhard
screenshots
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
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.JPG (93.03 KiB) Viewed 3527 times
-
- Data Template -> RRA Relation
- data_template_rra_relation.JPG (85.8 KiB) Viewed 3531 times
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
Re: screenshots
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?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?
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
late reply
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
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_cacti_predefined.JPG (69.23 KiB) Viewed 3469 times
-
- RRA Relation for interface traffic (cacti predefined)
- rra_relation_cacti_predefined.JPG (84.28 KiB) Viewed 3469 times
SOLVED
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
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
- checkboxes.JPG (86.61 KiB) Viewed 3440 times
Who is online
Users browsing this forum: No registered users and 4 guests