Autom8 V0.33

[gandalf]

Please find new beta2 attached.
It's quite verbose ...
R.

[killshoot]

Hi,

Thanks for the update. Unfortunately it didn't solve my problem.

I've still the same error logs entry in cacti log file :

Code: Select all

06/14/2010 11:32:46 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key from graph_tree_items where graph_tree_items.graph_tree_id=|arg1:tree_id| and graph_tree_items.title != '' order by graph_tree_items.order_key"
06/14/2010 11:32:04 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree_items.id, graph_tree_items.title, graph_tree_items.order_key from graph_tree_items where graph_tree_items.graph_tree_id=|arg1:tree_id| and graph_tree_items.title != '' order by graph_tree_items.order_key" 

I don't see other logs, event with log level in "Devel". Just tell me if I can help for something.

Vince

[TheWitness]

Did you not update lib/html_utility.php?

TheWitness

[killshoot]

Oh my bad you right the Witness...

Now everything seems to run. I'll test all and update asap

Thank for your help

[killshoot]

Ok,

My first attempt seems to demonstrate the following problem: the plugin don't care about eligible host when running tree rules.

You can find an exemple below. I've select two device in the console and done an "apply autom8 rules". I've only two tree rules that you can see after.

Note: If I make a "show eligible hosts" I really see only the hosts that I want

[gandalf]

Oh my bad you right the Witness...

Now everything seems to run. I'll test all and update asap

Thank for your help

This is which version of Cacti? Which set of patches did you apply?
R.

[gandalf]

Ok,

My first attempt seems to demonstrate the following problem: the plugin don't care about eligible host when running tree rules.

You can find an exemple below. I've select two device in the console and done an "apply autom8 rules". I've only two tree rules that you can see after.

Note: If I make a "show eligible hosts" I really see only the hosts that I want

Thanks for the hint. Please attach a cacti.log, filtered for "AUTOM8" of such an action. You will at least have MEDIUM logging level active.
But for this time, I assume that I have a clue.
R.

[killshoot]

Hi,

I'm using cacti 0.87e with PIA 2.4.

I've applied all patch for version 0.33. When I'm making a patch with v.035 I've a msg that say my files are already patched,

I've done the same tests as before with one eligible host (xbebeiappbckv01 with cacti ID 2585) and one not eligible (mbel01frw with cacti ID 2421).

Below the requested log:

Code: Select all

06/14/2010 06:58:26 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_prepare called
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute called
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute called, action: plugin_autom8_device
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute, items: a:2:{i:0;s:4:\"2421\";i:1;s:4:\"2585\";}
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2421]
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2421], 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=2421 AND graph_templates.id NOT IN (SELECT graph_local.graph_template_id FROM graph_local WHERE host_id=2421)
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2421], dq: 1
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] execute_data_query Host[2421] - 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: 3
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2421], dq: 17
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] execute_data_query Host[2421] - 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=17 AND enabled='on'  - found: 0
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2421], dq: 18
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] execute_data_query Host[2421] - 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=18 AND enabled='on'  - found: 0
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2421], create_tree for host: 2421
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] execute_device_create_tree, 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: 2
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] create_all_header_nodes called: Item 2421 sql: SELECT * FROM plugin_autom8_tree_rule_items WHERE plugin_autom8_tree_rule_items.rule_id=10 ORDER BY sequence matches: 1 items
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] create_all_header_nodes called: Item 2421 sql: SELECT * FROM plugin_autom8_tree_rule_items WHERE plugin_autom8_tree_rule_items.rule_id=11 ORDER BY sequence matches: 1 items
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2585]
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2585], 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=2585 AND graph_templates.id NOT IN (SELECT graph_local.graph_template_id FROM graph_local WHERE host_id=2585)
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2585], dq: 1
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] execute_data_query Host[2585] - 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: 3
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[2585], create_tree for host: 2585
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] execute_device_create_tree, 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: 2
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] create_all_header_nodes called: Item 2585 sql: SELECT * FROM plugin_autom8_tree_rule_items WHERE plugin_autom8_tree_rule_items.rule_id=10 ORDER BY sequence matches: 1 items
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] create_all_header_nodes called: Item 2585 sql: SELECT * FROM plugin_autom8_tree_rule_items WHERE plugin_autom8_tree_rule_items.rule_id=11 ORDER BY sequence matches: 1 items
06/14/2010 06:58:28 PM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute exits

[gandalf]

So this is NOT autom8-v.035 beta2?
Then, please switch to that code. No need to apply patches again.
R.

[killshoot]

What? In my PIA I can see 0.35.

Do I need to completely uninstall v0.33 and remove file then reinstall v0.35 beta 2?

[gandalf]

What? In my PIA I can see 0.35.

This is ok. You were talking about 0.33 in one of your last posts. So I assumed you were using an old version ...
Have to revisit the code, then ...
R.

[killshoot]

Ok. If I can help you for something don't hesitate to ask.

Regards,

Vince

[gandalf]

Evaluation of matching rules was incorrect. Please try attached beta3
R.

[killshoot]

Hi,

Good news, my first tests seems to run smoothly The problem for tree is corrected

I'll do some more tests and report you the result.

Have a nice day

Vince

EDIT : I've done some tests with tree creation with around 3000 devices and it look very promising

[killshoot]

Hi,

I've done some more tests and I've an "possible" issue with multiple and/or statement as you can see:

If I separate the rules, I can see eligible hosts but if I try to merge it I'haven't anymore eligible host. Am I wrong with the "syntax"?

Regards,

Vince