Problem Update RRD

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Post Reply
alladus
Posts: 2
Joined: Tue Jul 28, 2009 10:43 am

Problem Update RRD

Post by alladus »

hi all,

i did a script to count the number of mac on a particular interface on my cisco switch, the debugging log says the following:
07/28/2009 11:30:28 AM - CMDPHP: Poller[0] Host[341] PING: TCP Ping Success (16.86 ms)
07/28/2009 11:30:28 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "update host set status = '3', status_event_count = '0', status_fail_date = '2009-07-26 18:30:09', status_rec_date = '2009-07-14 12:27:32', status_last_error = 'TCP ping timed out', min_time = '9.99999', max_time = '163.52000', cur_time = '16.86', avg_time = '20.142281070037', total_polls = '56894', failed_polls = '1195', availability = '97.899602770064' where hostname = '172.16.30.3'"
07/28/2009 11:30:28 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_reindex.data_query_id, poller_reindex.action, poller_reindex.op, poller_reindex.assert_value, poller_reindex.arg1 from poller_reindex where poller_reindex.host_id=341"
07/28/2009 11:30:28 AM - CMDPHP: Poller[0] Host[341] DS[6435] CMD: perl /var/www/html/cacti/scripts/check_connect_ap.pl -d Cisco -h 172.16.30.3 -p ***** -ena ***** -t fastethernet -n 0/23, output: total:1
07/28/2009 11:30:28 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (6435, 'total', '2009-07-28 11:30:28', 'total:1')"
07/28/2009 11:30:28 AM - CMDPHP: Poller[0] Time: 25.2379 s, Theads: N/A, Hosts: 44
07/28/2009 11:30:28 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"
07/28/2009 11:30:29 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_id,end_time from poller_time where poller_id=0"
07/28/2009 11:30:29 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"
07/28/2009 11:30:29 AM - CMDPHP: Poller[0] DEVEL: SQL Assoc: "select data_template_rrd.data_source_name, data_input_fields.data_name from (data_template_rrd,data_input_fields) where data_template_rrd.data_input_field_id=data_input_fields.id and data_template_rrd.local_data_id=6435"
07/28/2009 11:30:29 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "delete from poller_output where local_data_id='6435' and rrd_name='total' and time='2009-07-28 11:30:28'"
07/28/2009 11:30:29 AM - CMDPHP: Poller[0] DEVEL: SQL Exec: "delete from poller_output where local_data_id='6432' and rrd_name='total' and time='2009-07-28 11:30:27'"
07/28/2009 11:30:29 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/html/cacti/rra/ap-sw_-_172_16_30_3_-_023_-_ap_volcan_total_6435.rrd --template total 1248795028:U
07/28/2009 11:30:29 AM - POLLER: Poller[0] CACTI2RRD: /usr/bin/rrdtool update /var/www/html/cacti/rra/ap-sw_-_172_16_10_2_-_012_-_ap_taller_mecanica_total_6432.rrd --template total 1248795027:U

when sending the update to the RRD file, it sends a parameter U, someone knows that it can be happening?
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Does the script spit out "total:1" or simply "1"? How does the Data Template look like?
Reinhard
Top
alladus
Posts: 2
Joined: Tue Jul 28, 2009 10:43 am

Post by alladus »

Code: Select all

- <cacti>
- <hash_0000196cd5fb67183f4391acc96e3337d7916d>
  <name>AP-SW - 172.16.30.3 - 0/23 - AP VOLCAN</name> 
- <graph>
  <t_title /> 
  <title>Clientes AP Volcan - SEDE Osorno</title> 
  <t_image_format_id /> 
  <image_format_id>1</image_format_id> 
  <t_height /> 
  <height>120</height> 
  <t_width /> 
  <width>500</width> 
  <t_slope_mode /> 
  <slope_mode>on</slope_mode> 
  <t_auto_scale /> 
  <auto_scale>on</auto_scale> 
  <t_auto_scale_opts /> 
  <auto_scale_opts>2</auto_scale_opts> 
  <t_auto_scale_log /> 
  <auto_scale_log /> 
  <t_scale_log_units /> 
  <scale_log_units /> 
  <t_auto_scale_rigid /> 
  <auto_scale_rigid>on</auto_scale_rigid> 
  <t_auto_padding /> 
  <auto_padding>on</auto_padding> 
  <t_export /> 
  <export>on</export> 
  <t_upper_limit /> 
  <upper_limit>100</upper_limit> 
  <t_lower_limit /> 
  <lower_limit>0</lower_limit> 
  <t_base_value /> 
  <base_value>1000</base_value> 
  <t_unit_value /> 
  <unit_value /> 
  <t_unit_exponent_value /> 
  <unit_exponent_value /> 
  <t_vertical_label /> 
  <vertical_label /> 
  </graph>
- <items>
- <hash_100019a106c2f8c6f80ac5a70d9041601729be>
  <task_item_id>hash_080019f5065eea46764a5240af6f614c8b361c</task_item_id> 
  <color_id>311F4E</color_id> 
  <alpha>FF</alpha> 
  <graph_type_id>4</graph_type_id> 
  <consolidation_function_id>1</consolidation_function_id> 
  <cdef_id>0</cdef_id> 
  <value /> 
  <gprint_id>hash_06001919414480d6897c8731c7dc6c5310653e</gprint_id> 
  <text_format /> 
  <hard_return /> 
  <sequence>1</sequence> 
  </hash_100019a106c2f8c6f80ac5a70d9041601729be>
- <hash_1000193a0336cf6892f87f53af6871e188414f>
  <task_item_id>hash_080019f5065eea46764a5240af6f614c8b361c</task_item_id> 
  <color_id>0</color_id> 
  <alpha>FF</alpha> 
  <graph_type_id>9</graph_type_id> 
  <consolidation_function_id>4</consolidation_function_id> 
  <cdef_id>0</cdef_id> 
  <value /> 
  <gprint_id>hash_06001919414480d6897c8731c7dc6c5310653e</gprint_id> 
  <text_format>Current:</text_format> 
  <hard_return>on</hard_return> 
  <sequence>2</sequence> 
  </hash_1000193a0336cf6892f87f53af6871e188414f>
- <hash_10001952320ab74441386c6a3b581b03ded013>
  <task_item_id>hash_080019f5065eea46764a5240af6f614c8b361c</task_item_id> 
  <color_id>0</color_id> 
  <alpha>FF</alpha> 
  <graph_type_id>9</graph_type_id> 
  <consolidation_function_id>1</consolidation_function_id> 
  <cdef_id>0</cdef_id> 
  <value /> 
  <gprint_id>hash_06001919414480d6897c8731c7dc6c5310653e</gprint_id> 
  <text_format>Average:</text_format> 
  <hard_return>on</hard_return> 
  <sequence>3</sequence> 
  </hash_10001952320ab74441386c6a3b581b03ded013>
- <hash_1000195a39f4583515963356e3e183cef51fc2>
  <task_item_id>hash_080019f5065eea46764a5240af6f614c8b361c</task_item_id> 
  <color_id>0</color_id> 
  <alpha>FF</alpha> 
  <graph_type_id>9</graph_type_id> 
  <consolidation_function_id>3</consolidation_function_id> 
  <cdef_id>0</cdef_id> 
  <value /> 
  <gprint_id>hash_06001919414480d6897c8731c7dc6c5310653e</gprint_id> 
  <text_format>Maximum:</text_format> 
  <hard_return>on</hard_return> 
  <sequence>4</sequence> 
  </hash_1000195a39f4583515963356e3e183cef51fc2>
  </items>
- <inputs>
- <hash_09001949fd7faf7373cd33927651c491629128>
  <name>Data Source [total]</name> 
  <description /> 
  <column_name>task_item_id</column_name> 
  <items>hash_000019a106c2f8c6f80ac5a70d9041601729be|hash_0000193a0336cf6892f87f53af6871e188414f|hash_00001952320ab74441386c6a3b581b03ded013|hash_0000195a39f4583515963356e3e183cef51fc2</items> 
  </hash_09001949fd7faf7373cd33927651c491629128>
  </inputs>
  </hash_0000196cd5fb67183f4391acc96e3337d7916d>
- <hash_010019a1d6dfa1b5eae68914dc6204f9044389>
  <name>AP-SW - 172.16.30.3 - 0/23 - AP VOLCAN</name> 
- <ds>
  <t_name /> 
  <name>Clientes AP Volcan</name> 
  <data_input_id>hash_0300191f40ca6ca206ebca3911ab5d4a3da63e</data_input_id> 
  <t_rra_id /> 
  <t_rrd_step /> 
  <rrd_step>300</rrd_step> 
  <t_active /> 
  <active>on</active> 
  <rra_items>hash_150019c21df5178e5c955013591239eb0afd46|hash_1500190d9c0af8b8acdc7807943937b3208e29|hash_1500196fc2d038fb42950138b0ce3e9874cc60|hash_150019e36f3adb9f152adfa5dc50fd2b23337e|hash_150019283ea2bf1634d92ce081ec82a634f513</rra_items> 
  </ds>
- <items>
- <hash_080019f5065eea46764a5240af6f614c8b361c>
  <t_data_source_name /> 
  <data_source_name>total</data_source_name> 
  <t_rrd_minimum /> 
  <rrd_minimum>0</rrd_minimum> 
  <t_rrd_maximum /> 
  <rrd_maximum>0</rrd_maximum> 
  <t_data_source_type_id /> 
  <data_source_type_id>1</data_source_type_id> 
  <t_rrd_heartbeat /> 
  <rrd_heartbeat>600</rrd_heartbeat> 
  <t_data_input_field_id /> 
  <data_input_field_id>0</data_input_field_id> 
  </hash_080019f5065eea46764a5240af6f614c8b361c>
  </items>
  <data /> 
  </hash_010019a1d6dfa1b5eae68914dc6204f9044389>
- <hash_0300191f40ca6ca206ebca3911ab5d4a3da63e>
  <name>AP-SW - 172.16.30.3 - 0/23 - AP VOLCAN</name> 
  <type_id>1</type_id> 
  <input_string>perl <path_cacti>/scripts/check_connect_ap.pl -d Cisco -h <hostname> -p ***** -ena ******* -t fastethernet -n 0/23</input_string> 
- <fields>
- <hash_070019a530be09d903512d3312add546702848>
  <name>Numero de clientes volcan</name> 
  <update_rra>on</update_rra> 
  <regexp_match /> 
  <allow_nulls /> 
  <type_code /> 
  <input_output>out</input_output> 
  <data_name>total</data_name> 
  </hash_070019a530be09d903512d3312add546702848>
- <hash_07001996613c4c2e7eac15f644136ee7168999>
  <name>hostname</name> 
  <update_rra /> 
  <regexp_match /> 
  <allow_nulls>on</allow_nulls> 
  <type_code>hostname</type_code> 
  <input_output>in</input_output> 
  <data_name>hostname</data_name> 
  </hash_07001996613c4c2e7eac15f644136ee7168999>
  </fields>
  </hash_0300191f40ca6ca206ebca3911ab5d4a3da63e>
- <hash_150019c21df5178e5c955013591239eb0afd46>
  <name>Daily (5 Minute Average)</name> 
  <x_files_factor>0.5</x_files_factor> 
  <steps>1</steps> 
  <rows>600</rows> 
  <timespan>86400</timespan> 
  <cf_items>1|2|3|4</cf_items> 
  </hash_150019c21df5178e5c955013591239eb0afd46>
- <hash_1500190d9c0af8b8acdc7807943937b3208e29>
  <name>Weekly (30 Minute Average)</name> 
  <x_files_factor>0.5</x_files_factor> 
  <steps>6</steps> 
  <rows>700</rows> 
  <timespan>604800</timespan> 
  <cf_items>1|2|3|4</cf_items> 
  </hash_1500190d9c0af8b8acdc7807943937b3208e29>
- <hash_1500196fc2d038fb42950138b0ce3e9874cc60>
  <name>Monthly (2 Hour Average)</name> 
  <x_files_factor>0.5</x_files_factor> 
  <steps>24</steps> 
  <rows>775</rows> 
  <timespan>2678400</timespan> 
  <cf_items>1|2|3|4</cf_items> 
  </hash_1500196fc2d038fb42950138b0ce3e9874cc60>
- <hash_150019e36f3adb9f152adfa5dc50fd2b23337e>
  <name>Yearly (1 Day Average)</name> 
  <x_files_factor>0.5</x_files_factor> 
  <steps>288</steps> 
  <rows>797</rows> 
  <timespan>33053184</timespan> 
  <cf_items>1|2|3|4</cf_items> 
  </hash_150019e36f3adb9f152adfa5dc50fd2b23337e>
- <hash_150019283ea2bf1634d92ce081ec82a634f513>
  <name>Hourly (1 Minute Average)</name> 
  <x_files_factor>0.5</x_files_factor> 
  <steps>1</steps> 
  <rows>500</rows> 
  <timespan>14400</timespan> 
  <cf_items>1|3</cf_items> 
  </hash_150019283ea2bf1634d92ce081ec82a634f513>
- <hash_06001919414480d6897c8731c7dc6c5310653e>
  <name>Exact Numbers</name> 
  <gprint_text>%8.0lf</gprint_text> 
  </hash_06001919414480d6897c8731c7dc6c5310653e>
  </cacti>
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Oh, I meant a screenshot, please
Reinhard
Top
Post Reply

Return to “Help: Linux/Unix Specific”

Who is online

Users browsing this forum: No registered users and 6 guests