Autom8 V0.33

[killshoot]

Well... Run perfect

Thank you for your help.

Best regards,

Vince

P.S Some idea for new features:
- feature that allow devices import from CSV via the gui (no more need to use CLI script)
- feature that allow to delete graphs when ports are down since a defined time (we've 96'000 active ports...) and give a log from these deleted graphs
- automatic creation of threshold according the created thold template (no more need to use the thold cli script)
- possibility to automate the reindexing of hosts (no more need to use the cli script)

[gandalf]

Well... Run perfect

fine

- feature that allow devices import from CSV via the gui (no more need to use CLI script)
- feature that allow to delete graphs when ports are down since a defined time (we've 96'000 active ports...) and give a log from these deleted graphs
- automatic creation of threshold according the created thold template (no more need to use the thold cli script)
- possibility to automate the reindexing of hosts (no more need to use the cli script)

Please open seperate feature requests for those as given by http://www.cacti.net/bugs.php
The first two are well understood.
The 3rd requires support from thold, not sure how to do this ATM.
The 4th requires some re-thinking. Re-Indexing should work without any user intervention if set correctly. I know, we do have some bugs that will be fixed in cacti087g and spine087g. So I hope this gets solved in a different place
R.

[highflight]

Fantastic plugin.

Version: autom8, v0.33 - 0.8.7.e on CentOS 5.2

Recently, I noticed the following error in the cacti.log file:

When running the following CLI command

php -q poller_graphs_reapply_names.php -id={host id}

the following error shows up in the cacti log file.

06/25/2010 04:28:54 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"

Is this error due a bug in v0.33 autom8 or poller_graphs_reapply_names.php?

Thank you for your help in troubleshooting this problem.

[gandalf]

Please try the new version attached to this thread on a test system, if possible. This will be released with 087g soon
R.

[highflight]

I updated autom8 from v0.33 to v0.35b3 on the same development host, and the 1064 error is still present when running the php -q poller_graphs_reapply_names.php -id={host id} command.

06/27/2010 01:00:22 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
06/27/2010 01:00:22 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
06/27/2010 01:00:22 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"

plugin detail:
Directory: autom8
Version: 0.35b3
Author: Reinhard Scheck
Home Page:http://docs.cacti.net/plugin:autom8
Status: Active, Enable

The plugin update involved moving the old 0.33 version of autom8 to /tmp and gunzip/untarring autom8-v0.35b3.tgz in the plugin directory. The 087e patches were not applied as they are the same between 0.33 and 0.35.

Reinhard, can you test running the poller_graphs_reapply_names.php command using autom8 0.35b3 on your system. I verified that the error occurs on two separate development servers running the same version of cacti and the v0.35b3 autom8 plugin.

My goal is to re-index and re-apply names to interfaces via a cron job. Should the data sources be re-labeled as well?


Danke .

[gandalf]

Thanks for the hint. I will investigate.
R.

[gandalf]

I suppose that this is a cacti error, not an issue with the plugin.

To verify, please deactivate the plugin first. Then, please goto Graph Management and select a non-data query graph. Use the "Re-Apply Suggested Names" from dropdown.

I suppose, that cacti.log will show exactly the same error.

I've got an idea how to fix that.
R.

[gandalf]

The patch will be postponed.
The error does no harm, so there's no urgent action required.

The mantis bug refers to the same function but a different situation.

R.

[gandalf]

Fix against main is SVN#6018.
Just a hint: the patch applies nicely to 087 as well
R.

[highflight]

The autom8 plugin was disabled as suggested and then I performed the following on a non-data query graph.

Goto Graph Management and select a non-data query graph. Use the "Re-Apply Suggested Names" from dropdown.

No errors were recorded in the cacti.log file.

However, when the plugin is enabled,

this bug generates 1000's of "Critical" messages in the log file, thus alerting staff.

Does SVN#6018 fix the problem?

[gandalf]

The autom8 plugin was disabled as suggested and then I performed the following on a non-data query graph.

Goto Graph Management and select a non-data query graph. Use the "Re-Apply Suggested Names" from dropdown.

No errors were recorded in the cacti.log file.

However, when the plugin is enabled,

this bug generates 1000's of "Critical" messages in the log file, thus alerting staff.

Does SVN#6018 fix the problem?

IMHO, yes. Did you try?
R.

[sukanta]

Waiting for the new version for Cacti 0.8.7g

[gandalf]

This should be the last beta befor releasing v0.35 officially. Please comment.
R.

[gandalf]

Waiting for the new version for Cacti 0.8.7g

Why? The requested patch is part of the patch file provided with my last v0.35b4
R.

[killshoot]

Hi,

I've tested it for you. I see the following error in cactilog (using cacti 0.87e).

Code: Select all

07/15/2010 04:43:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
07/15/2010 04:43:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
07/15/2010 04:43:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"
07/15/2010 04:43:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select text,field_name from snmp_query_graph_sv where snmp_query_graph_id= order by sequence"

Do I need to patch someting from beta3 to beta4?


Regards,

Vince