Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
The contents I've posted above is correct.
And again, I've downloaded v0.31 from http://docs.cacti.net/plugin:autom8 and verified headers of both versions for 087d and 087e and did not find anything unusual. Is it possible, that your file stems from an older version of the plugin?
I think there is a problem with host.php.patch from paches-087e:
in file header it looks for /cli/host.php , but this file suppose to be in cacti main folder as it is in patches-087d.
Correct me if I am wrong.
Finally, I found the issue and fixed it. Thanks for posting
R.
02/25/2010 09:29:00 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT DISTINCT data_local.id FROM data_local LEFT JOIN data_template_data ON (data_local.id=data_template_data.local_data_id) LEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id) LEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id) LEFT JOIN snmp_query_graph ON (data_input_data.value=snmp_query_graph.id) WHERE data_input_fields.type_code=output_type AND snmp_query_graph.id=24 AND data_local.host_id=18 AND data_local.snmp_query_id=11 AND data_local.snmp_index='1'"
02/25/2010 09:28:58 AM - AUTOM8: Poller[0] Host[18] Graph Added - graph-id: (672) - data-source-ids: (675, 675)
02/25/2010 09:28:58 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT DISTINCT data_local.id FROM data_local LEFT JOIN data_template_data ON (data_local.id=data_template_data.local_data_id) LEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id) LEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id) LEFT JOIN snmp_query_graph ON (data_input_data.value=snmp_query_graph.id) WHERE data_input_fields.type_code=output_type AND snmp_query_graph.id=23 AND data_local.host_id=18 AND data_local.snmp_query_id=10 AND data_local.snmp_index='2'"
02/25/2010 09:28:58 AM - AUTOM8: Poller[0] Host[18] Graph Added - graph-id: (671) - data-source-ids: (674, 674)
02/25/2010 09:28:58 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT DISTINCT data_local.id FROM data_local LEFT JOIN data_template_data ON (data_local.id=data_template_data.local_data_id) LEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id) LEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id) LEFT JOIN snmp_query_graph ON (data_input_data.value=snmp_query_graph.id) WHERE data_input_fields.type_code=output_type AND snmp_query_graph.id=23 AND data_local.host_id=18 AND data_local.snmp_query_id=10 AND data_local.snmp_index='16'"
02/25/2010 09:28:58 AM - AUTOM8: Poller[0] Host[18] Graph Added - graph-id: (670) - data-source-ids: (673, 673)
02/25/2010 09:28:58 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT DISTINCT data_local.id FROM data_local LEFT JOIN data_template_data ON (data_local.id=data_template_data.local_data_id) LEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id) LEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id) LEFT JOIN snmp_query_graph ON (data_input_data.value=snmp_query_graph.id) WHERE data_input_fields.type_code=output_type AND snmp_query_graph.id=23 AND data_local.host_id=18 AND data_local.snmp_query_id=10 AND data_local.snmp_index='1'"
02/25/2010 09:28:58 AM - AUTOM8: Poller[0] Host[18] Graph Added - graph-id: (669) - data-source-ids: (672, 672)
02/25/2010 09:28:58 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT DISTINCT data_local.id FROM data_local LEFT JOIN data_template_data ON (data_local.id=data_template_data.local_data_id) LEFT JOIN data_input_data ON (data_template_data.id=data_input_data.data_template_data_id) LEFT JOIN data_input_fields ON (data_input_data.data_input_field_id=data_input_fields.id) LEFT JOIN snmp_query_graph ON (data_input_data.value=snmp_query_graph.id) WHERE data_input_fields.type_code=output_type AND snmp_query_graph.id=14 AND data_local.host_id=18 AND data_local.snmp_query_id=1 AND data_local.snmp_index='10008'"
When trying to apply host.php.patch I was getting asked where the file was, i noted that -p1 was striping the path so it couldn't find hosts.php correctly, when i ran without the -p1 I got this reversed warning
I'm running PA 2.6, Cacti 0.8.7e and autom8 0.31 now, I forced the host.php.patch to apply per my previous post and am seeing that functions such as add graph, data source, re-query data source or verbose query on a data source return blank pages (completly void of code).
Can some one help me identify what is broken and or how I might patch host.php correctly since this is most likely the issue?
-- Edit --
I've swapped back the old host.php and it doesn't correct the problem. I've put the patched version back in and instead disabled autom8 from the plugin management and the queries are functioning as expected now.
-- Edit again --
I pulled down 0.32 from SVN and it doesn't have the issue noted here.
Now that it's working, I enjoy the plugin and it works great.
I was wondering what it might take to either 1) add in multiple graph types per data-source so that in the same rule one could specify 64-Bit interfaces, and error/discards to be created. OR 2) extrapolate the rule components (Host Eligibility, and Index Eligibility) so that they could be added to multiple "Graph rules" so that duplication of these components could be minimized.
Where can I find the SVN so that I can checkout the latest version?
I tried to use 0.31 from the link in the first post, however, I am unable to force it to run the tree creation script. It only runs when a new graph is actually created (I would post screen shot but I deleted the plugin...).
I just can't for the life of me understand why I can't get the patches applied to my Cacti install. Here's some results:
[root@cacti html]# patch -p1 -N --dry-run < plugins/autom8/patches-087e/cli.patch
patching file cli/add_graph_template.php
Hunk #1 FAILED at 145.
1 out of 1 hunk FAILED -- saving rejects to file cli/add_graph_template.php.rej
patching file cli/add_tree.php
Hunk #1 FAILED at 32.
1 out of 1 hunk FAILED -- saving rejects to file cli/add_tree.php.rej
patching file cli/host_update_template.php
Hunk #1 FAILED at 137.
1 out of 1 hunk FAILED -- saving rejects to file cli/host_update_template.php.rej
[root@cacti html]# patch -p1 -N --dry-run < plugins/autom8/patches-087e/host.php.patch
missing header for unified diff at line 3 of patch
can't find file to patch at input line 3
Perhaps you used the wrong -p or --strip option?
The text leading up to this was:
--------------------------
|--- host.php 2009-11-20 23:18:46.000000000 +0100
|+++ ../cacti-0.8.7e-orig/host.php 2009-06-28 18:07:11.000000000 +0200
--------------------------
File to patch:
[root@cacti html]#
These are two examples. I'm not sure exactly what I'm doing wrong. I'm using Cacti 0.8.7e with PA 2.6 and v0.31 of the autom8 plugin. I installed cacti via Yum on CentOS 5.4.
