[Solved] Autom8 and trees

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
ELDemorose
Posts: 23
Joined: Thu Jul 15, 2010 8:56 am
Location: Tours, FRANCE

[Solved] Autom8 and trees

Post by ELDemorose »

Hi,

I'm using Autom8 v 0.35b6 and I want to sort my hosts in several tree, following this schema:

Server
- 01
- 02
- 03
.
.
.
Router
- 01
- 02
- 03
.
.
.

I have a convention to name my hosts: for routeur, it's RT[0-9]{2}[A-Z]{3}[0-9]{3} for example: RT01CAN001
The subtree is named from tree rules, it the 2 figures after RT.
When I apply the Autom8 rules on two router that both have the same 2 figures, the rules create 2 subtree with the same name.
(e.g :
Router

- 01
--- RT01CAN001
- 01
--- RT01CAN002
- 02
.
.
.

I want:

- 01
--- RT01CAN001
--- RT01CAN002
- 02
.
.
.
)
Have someone an idea so that only one subtree is create?

My rule is:
Item#1 | 1 | host.description | Manual Ordering (No Sorting) | No | ^.{2}([0-9]{2})([A-Z]{3}).*$ | $1
Last edited by ELDemorose on Wed Jan 12, 2011 8:45 am, edited 2 times in total.
Cacti Version - 0.8.7g
Plugin Architecture - 2.8
Poller Type - Spine
Server Info - Linux 2.6.16.60-0.21-smp
Web Server - Apache/2.2.3 (Linux/SUSE)
PHP - 5.2.5
MySQL - 5.0.26
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins Autom8 - Aggregate - Realtime
ELDemorose
Posts: 23
Joined: Thu Jul 15, 2010 8:56 am
Location: Tours, FRANCE

Re: Autom8 and trees

Post by ELDemorose »

Nobody has an answer?
Cacti Version - 0.8.7g
Plugin Architecture - 2.8
Poller Type - Spine
Server Info - Linux 2.6.16.60-0.21-smp
Web Server - Apache/2.2.3 (Linux/SUSE)
PHP - 5.2.5
MySQL - 5.0.26
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins Autom8 - Aggregate - Realtime
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Autom8 and trees

Post by gandalf »

ELDemorose wrote:Nobody has an answer?
calm down ...
Yes, that's a valid request.
Please visit the rule's edit screen and display the "debug" tables. Post screenshots please. If possible, please recreate those items while grepping the log file for AUTOM8 entries. Set "Settings -> Misc -> Poller Logging Level for AUTOM8" to HIGH. This should provide a quite detailed call trace.
R.
ELDemorose
Posts: 23
Joined: Thu Jul 15, 2010 8:56 am
Location: Tours, FRANCE

Re: Autom8 and trees

Post by ELDemorose »

Sorry for being late,

Find attached a screenshot of my rule and a screenshot of the rules edit screen with Eligible Hosts.
I also take a screenshot of the render of the rule.

I would like to have just one subtree 29 with both routers.
No error on the logs.

thanks for your answer.
Attachments
my rule
my rule
rule.jpg (77.71 KiB) Viewed 2187 times
render tree
render tree
tree.jpg (5.68 KiB) Viewed 2187 times
Eligible host and rules
Eligible host and rules
ScreenShot00026.jpg (122.81 KiB) Viewed 2187 times
Cacti Version - 0.8.7g
Plugin Architecture - 2.8
Poller Type - Spine
Server Info - Linux 2.6.16.60-0.21-smp
Web Server - Apache/2.2.3 (Linux/SUSE)
PHP - 5.2.5
MySQL - 5.0.26
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins Autom8 - Aggregate - Realtime
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Autom8 and trees

Post by gandalf »

ELDemorose wrote:No error on the logs.
I was not searching for errors. I'm searching for an activity log. Again, see
Set "Settings -> Misc -> Poller Logging Level for AUTOM8" to HIGH. This should provide a quite detailed call trace.
The related messages are flagged with AUTOM8
R.
ELDemorose
Posts: 23
Joined: Thu Jul 15, 2010 8:56 am
Location: Tours, FRANCE

Re: Autom8 and trees

Post by ELDemorose »

Once again.. I'm late...

I've create a new device, and apply rules. It gives me this logs:

Code: Select all

01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute exits
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] execute_device_create_tree Host[5], node: 33
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_device_node Host[5] Tree Item added - id: (33)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] execute_device_create_tree Host[5], parent: 32
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_multi_header_node - object: 'RT85RSY00N', Header: '85', hooked at: 32
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_header_node Parent[0] Tree Item added - id: (32) Title: (85)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_multi_header_node - object: 'RT85RSY00N', Header: '^.{2}([0-9]{2})([A-Z]{3}).*$', parent: 0
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_all_header_nodes Item 5 - sql: SELECT host.description AS source FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE host.id=5 AND ( host_template.name LIKE '%Routeur%') matches: RT85RSY00N
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter returns: host_template.name LIKE '%Routeur%'
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: host_template.name LIKE '%Routeur%'
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:8:{s:2:"id";s:1:"3";s:7:"rule_id";s:1:"1";s:9:"rule_type";s:1:"3";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:18:"host_template.name";s:8:"operator";s:1:"1";s:7:"pattern";s:7:"Routeur";}}, prefix:
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter called rule id: 1
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_all_header_nodes called: Item 5 sql: SELECT * FROM plugin_autom8_tree_rule_items WHERE plugin_autom8_tree_rule_items.rule_id=1 ORDER BY sequence matches: 1 items
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] execute_device_create_tree Host[5], matching hosts: a:1:{i:0;a:6:{s:7:"host_id";s:1:"5";s:8:"hostname";s:10:"10.222.5.5";s:11:"description";s:10:"RT85RSY00N";s:8:"disabled";s:0:"";s:6:"status";s:1:"0";s:18:"host_template_name";s:7:"Routeur";}}
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter returns: host_template.name LIKE '%Routeur%'
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: host_template.name LIKE '%Routeur%'
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:8:{s:2:"id";s:1:"3";s:7:"rule_id";s:1:"1";s:9:"rule_type";s:1:"3";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:18:"host_template.name";s:8:"operator";s:1:"1";s:7:"pattern";s:7:"Routeur";}}, prefix:
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter called rule id: 1
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] get_matching_hosts called: a:7:{s:2:"id";s:1:"1";s:4:"name";s:11:"New Routeur";s:7:"tree_id";s:1:"2";s:12:"tree_item_id";s:1:"0";s:9:"leaf_type";s:1:"3";s:18:"host_grouping_type";s:1:"1";s:6:"rra_id";s:1:"0";} type: 3
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] execute_device_create_tree Host[5], active rule: 1 name: New Routeur type: 3
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] execute_device_create_tree Host[5], matching rule sql: SELECT plugin_autom8_tree_rules.id, plugin_autom8_tree_rules.name, plugin_autom8_tree_rules.tree_id, plugin_autom8_tree_rules.tree_item_id, plugin_autom8_tree_rules.leaf_type, plugin_autom8_tree_rules.host_grouping_type, plugin_autom8_tree_rules.rra_id FROM plugin_autom8_tree_rules WHERE enabled='on' AND leaf_type=3 matches: 1
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] execute_device_create_tree Host[5] called
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[5], create_tree for host: 5
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (747) - data-source-ids: (742, 742)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9903
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (746) - data-source-ids: (741, 741)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9902
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (745) - data-source-ids: (740, 740)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9901
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (744) - data-source-ids: (739, 739)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9501
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (743) - data-source-ids: (738, 738)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 901
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (742) - data-source-ids: (737, 737)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 30201
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (741) - data-source-ids: (736, 736)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 20201
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (740) - data-source-ids: (735, 735)
01/05/2011 09:30:12 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 201
01/05/2011 09:30:12 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (739) - data-source-ids: (734, 734)
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 104
01/05/2011 09:30:11 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (738) - data-source-ids: (733, 733)
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 103
01/05/2011 09:30:11 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (737) - data-source-ids: (732, 732)
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 102
01/05/2011 09:30:11 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (736) - data-source-ids: (731, 731)
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 101
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - graph template: 39
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: a.ifDescr NOT LIKE ''
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:7:{s:2:"id";s:2:"10";s:7:"rule_id";s:1:"8";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:7:"ifDescr";s:8:"operator";s:2:"16";s:7:"pattern";s:0:"";}}, prefix: a.
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - snmp query: 1 - rule: Routeur : Speed
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - create sql: SELECT host.id AS host_id, host.hostname, host.description, host_template.name AS host_template_name FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE ( host_template.name <=> 'Routeur') AND host.id=5 matches:1
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter returns: host_template.name <=> 'Routeur'
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: host_template.name <=> 'Routeur'
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:8:{s:2:"id";s:2:"11";s:7:"rule_id";s:1:"8";s:9:"rule_type";s:1:"1";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:18:"host_template.name";s:8:"operator";s:1:"7";s:7:"pattern";s:7:"Routeur";}}, prefix:
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter called rule id: 8
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - rule=8 name: Routeur : Speed
01/05/2011 09:30:11 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (735) - data-source-ids: (730, 730)
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9903
01/05/2011 09:30:11 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (734) - data-source-ids: (729, 729)
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9902
01/05/2011 09:30:11 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (733) - data-source-ids: (728, 728)
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9901
01/05/2011 09:30:11 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (732) - data-source-ids: (727, 727)
01/05/2011 09:30:11 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9501
01/05/2011 09:30:11 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (731) - data-source-ids: (726, 726)
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 901
01/05/2011 09:30:10 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (730) - data-source-ids: (725, 725)
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 30201
01/05/2011 09:30:10 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (729) - data-source-ids: (724, 724)
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 20201
01/05/2011 09:30:10 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (728) - data-source-ids: (723, 723)
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 201
01/05/2011 09:30:10 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (727) - data-source-ids: (722, 722)
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 104
01/05/2011 09:30:10 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (726) - data-source-ids: (721, 721)
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 103
01/05/2011 09:30:10 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (725) - data-source-ids: (720, 720)
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 102
01/05/2011 09:30:10 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (724) - data-source-ids: (719, 719)
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 101
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - graph template: 37
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: a.ifDescr NOT LIKE ''
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:7:{s:2:"id";s:1:"9";s:7:"rule_id";s:1:"7";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:7:"ifDescr";s:8:"operator";s:2:"16";s:7:"pattern";s:0:"";}}, prefix: a.
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - snmp query: 1 - rule: Routeur : LastChange
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - create sql: SELECT host.id AS host_id, host.hostname, host.description, host_template.name AS host_template_name FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE ( host_template.name <=> 'Routeur') AND host.id=5 matches:1
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter returns: host_template.name <=> 'Routeur'
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: host_template.name <=> 'Routeur'
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:8:{s:2:"id";s:2:"10";s:7:"rule_id";s:1:"7";s:9:"rule_type";s:1:"1";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:18:"host_template.name";s:8:"operator";s:1:"7";s:7:"pattern";s:7:"Routeur";}}, prefix:
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter called rule id: 7
01/05/2011 09:30:10 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - rule=7 name: Routeur : LastChange
01/05/2011 09:30:10 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (723) - data-source-ids: (718, 718)
01/05/2011 09:30:09 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9903
01/05/2011 09:30:09 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (722) - data-source-ids: (717, 717)
01/05/2011 09:30:09 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9902
01/05/2011 09:30:09 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (721) - data-source-ids: (716, 716)
01/05/2011 09:30:09 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9901
01/05/2011 09:30:09 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (720) - data-source-ids: (715, 715)
01/05/2011 09:30:09 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9501
01/05/2011 09:30:09 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (719) - data-source-ids: (714, 714)
01/05/2011 09:30:09 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 901
01/05/2011 09:30:09 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (718) - data-source-ids: (713, 713)
01/05/2011 09:30:09 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 30201
01/05/2011 09:30:09 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (717) - data-source-ids: (712, 712)
01/05/2011 09:30:09 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 20201
01/05/2011 09:30:09 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (716) - data-source-ids: (711, 711)
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 201
01/05/2011 09:30:08 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (715) - data-source-ids: (710, 710)
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 104
01/05/2011 09:30:08 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (714) - data-source-ids: (709, 709)
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 103
01/05/2011 09:30:08 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (713) - data-source-ids: (708, 708)
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 102
01/05/2011 09:30:08 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (712) - data-source-ids: (707, 707)
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 101
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - graph template: 2
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: a.ifDescr NOT LIKE ''
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:7:{s:2:"id";s:1:"8";s:7:"rule_id";s:1:"6";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:7:"ifDescr";s:8:"operator";s:2:"16";s:7:"pattern";s:0:"";}}, prefix: a.
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - snmp query: 1 - rule: Routeur : Traffic
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - create sql: SELECT host.id AS host_id, host.hostname, host.description, host_template.name AS host_template_name FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE ( host_template.name <=> 'Routeur') AND host.id=5 matches:1
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter returns: host_template.name <=> 'Routeur'
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: host_template.name <=> 'Routeur'
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:8:{s:2:"id";s:1:"9";s:7:"rule_id";s:1:"6";s:9:"rule_type";s:1:"1";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:18:"host_template.name";s:8:"operator";s:1:"7";s:7:"pattern";s:7:"Routeur";}}, prefix:
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter called rule id: 6
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - rule=6 name: Routeur : Traffic
01/05/2011 09:30:08 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (711) - data-source-ids: (706, 706)
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9903
01/05/2011 09:30:08 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (710) - data-source-ids: (705, 705)
01/05/2011 09:30:08 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9902
01/05/2011 09:30:08 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (709) - data-source-ids: (704, 704)
01/05/2011 09:30:07 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9901
01/05/2011 09:30:07 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (708) - data-source-ids: (703, 703)
01/05/2011 09:30:07 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 9501
01/05/2011 09:30:07 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (707) - data-source-ids: (702, 702)
01/05/2011 09:30:07 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 901
01/05/2011 09:30:07 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (706) - data-source-ids: (701, 701)
01/05/2011 09:30:07 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 30201
01/05/2011 09:30:07 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (705) - data-source-ids: (700, 700)
01/05/2011 09:30:07 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 20201
01/05/2011 09:30:07 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (704) - data-source-ids: (699, 699)
01/05/2011 09:30:07 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 201
01/05/2011 09:30:07 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (703) - data-source-ids: (698, 698)
01/05/2011 09:30:07 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 104
01/05/2011 09:30:07 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (702) - data-source-ids: (697, 697)
01/05/2011 09:30:07 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 103
01/05/2011 09:30:07 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (701) - data-source-ids: (696, 696)
01/05/2011 09:30:07 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 102
01/05/2011 09:30:07 AM - AUTOM8: Poller[0] create_dq_graphs Host[5] Graph Added - graph-id: (700) - data-source-ids: (695, 695)
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - checking index: 101
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - graph template: 38
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: a.ifDescr NOT LIKE ''
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:7:{s:2:"id";s:1:"7";s:7:"rule_id";s:1:"4";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:7:"ifDescr";s:8:"operator";s:2:"16";s:7:"pattern";s:0:"";}}, prefix: a.
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] create_dq_graphs Host[5] - snmp query: 1 - rule: Routeur : Statut
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - create sql: SELECT host.id AS host_id, host.hostname, host.description, host_template.name AS host_template_name FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE ( host_template.name <=> 'Routeur') AND host.id=5 matches:1
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter returns: host_template.name <=> 'Routeur'
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: host_template.name <=> 'Routeur'
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:8:{s:2:"id";s:1:"8";s:7:"rule_id";s:1:"4";s:9:"rule_type";s:1:"1";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:18:"host_template.name";s:8:"operator";s:1:"7";s:7:"pattern";s:7:"Routeur";}}, prefix:
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter called rule id: 4
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - rule=4 name: Routeur : Statut
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - sql: SELECT plugin_autom8_graph_rules.id, plugin_autom8_graph_rules.name, plugin_autom8_graph_rules.snmp_query_id, plugin_autom8_graph_rules.graph_type_id FROM plugin_autom8_graph_rules WHERE snmp_query_id=1 AND enabled='on' - found: 4
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] execute_data_query Host[5] - start - data query: 1
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] execute_data_query called: a:2:{s:7:"host_id";s:1:"5";s:13:"snmp_query_id";s:1:"1";}
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[5], dq: 1
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[5], sql: SELECT graph_templates.id, graph_templates.name FROM (graph_templates,host_graph) WHERE graph_templates.id=host_graph.graph_template_id AND host_graph.host_id=5 AND graph_templates.id NOT IN (SELECT graph_local.graph_template_id FROM graph_local WHERE host_id=5)
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[5]
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute, items: a:1:{i:0;s:1:\"5\";}
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute called, action: plugin_autom8_device
01/05/2011 09:30:06 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute called
01/05/2011 09:30:05 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_prepare called
Thanks,
Cacti Version - 0.8.7g
Plugin Architecture - 2.8
Poller Type - Spine
Server Info - Linux 2.6.16.60-0.21-smp
Web Server - Apache/2.2.3 (Linux/SUSE)
PHP - 5.2.5
MySQL - 5.0.26
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins Autom8 - Aggregate - Realtime
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Autom8 and trees

Post by gandalf »

ok, now I understand better. I should be able to reproduce this. But not before weekend
R.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Autom8 and trees

Post by gandalf »

gandalf wrote:ok, now I understand better. I should be able to reproduce this. But not before weekend
R.
I've run the test with your tree rule. And it worked exactly as you need it aka: I'm not able to reproduce the error; it simply works.
This is 087g (SVN latest) with AUTOM8 v0.35 (latest published version)
--- 0.35 ---
- fix: change input type='image' to 'button'
- fix: some html issues
- fix: remove unnecessary SQL
- fix: fix handling of graph items and trees (courtesy David Koski)
- fix: JS code for tree rule items added to handle closing bracket like graph rule items
- compat: all required patches for Cacti 087g aggregated in a single patch file
- feature: allow "( ... ) AND/OR ( ... )"
empty fields, operators and patterns
There's a slight glitch related to v035b6. I don't know whether this will fix your issue. So please try that version. If it does NOT fix the issue, please dump your database and pm it to me.
R.
ELDemorose
Posts: 23
Joined: Thu Jul 15, 2010 8:56 am
Location: Tours, FRANCE

Re: Autom8 and trees

Post by ELDemorose »

gandalf wrote: This is 087g (SVN latest)
Is this one different from the one we can download on this page : http://www.cacti.net/download_cacti.php ?
I have apply all patchs find here: http://www.cacti.net/download_patches.php
I already have autom8 v0.35, download here: http://docs.cacti.net/plugin:autom8
Should I take the version from SVN?

thanks
Cacti Version - 0.8.7g
Plugin Architecture - 2.8
Poller Type - Spine
Server Info - Linux 2.6.16.60-0.21-smp
Web Server - Apache/2.2.3 (Linux/SUSE)
PHP - 5.2.5
MySQL - 5.0.26
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins Autom8 - Aggregate - Realtime
ELDemorose
Posts: 23
Joined: Thu Jul 15, 2010 8:56 am
Location: Tours, FRANCE

Re: Autom8 and trees

Post by ELDemorose »

I have reinstall my cacti, using the version from SVN. I also took the SVN version of autom8 and It works. Thanks for your help.
Cacti Version - 0.8.7g
Plugin Architecture - 2.8
Poller Type - Spine
Server Info - Linux 2.6.16.60-0.21-smp
Web Server - Apache/2.2.3 (Linux/SUSE)
PHP - 5.2.5
MySQL - 5.0.26
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins Autom8 - Aggregate - Realtime
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: Autom8 and trees

Post by gandalf »

ELDemorose wrote:I have reinstall my cacti, using the version from SVN. I also took the SVN version of autom8 and It works. Thanks for your help.
That makes me happy.
Please pay attention: SVN as of now has halfway the changes required for 087h. It should be fine, but has not yet been tested. Please report any errors
R.
ELDemorose
Posts: 23
Joined: Thu Jul 15, 2010 8:56 am
Location: Tours, FRANCE

Re: [Solved] Autom8 and trees

Post by ELDemorose »

OK.
For the moment, everything goes right. I'll check next wednesday.
Cacti Version - 0.8.7g
Plugin Architecture - 2.8
Poller Type - Spine
Server Info - Linux 2.6.16.60-0.21-smp
Web Server - Apache/2.2.3 (Linux/SUSE)
PHP - 5.2.5
MySQL - 5.0.26
RRDTool - 1.2.12
SNMP - 5.3.0.1
Plugins Autom8 - Aggregate - Realtime
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests