Autom8 V0.33
Moderators: Developers, Moderators
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
Currently, you will have to split this rule into two.
The first rule covers the first parenthesis, the second one matches the second parenthesis.
It is possible to have many rules match a single target, you know.
But thinking about your approach, I might change the options to allow a single OR/AND without selecting an operator or field ...
No promise made
R.
The first rule covers the first parenthesis, the second one matches the second parenthesis.
It is possible to have many rules match a single target, you know.
But thinking about your approach, I might change the options to allow a single OR/AND without selecting an operator or field ...
No promise made
R.
hi,
yes my problem is that i've around 3000 devices into my cacti (all my 96000 rra on a ramdisk and I'm not using BOOST)
Unfortunately the naming concept and the IP concept of my network aren't consistant (we have merged three différent network). I need to do multiple and/or to match the correct devices for the tree.
I'll test the latest SVN tomorrow but I already thank you for this great plugin that really push Cacti before the $$$ entreprise monitoring software.
Best regards,
Vince
yes my problem is that i've around 3000 devices into my cacti (all my 96000 rra on a ramdisk and I'm not using BOOST)
Unfortunately the naming concept and the IP concept of my network aren't consistant (we have merged three différent network). I need to do multiple and/or to match the correct devices for the tree.
I'll test the latest SVN tomorrow but I already thank you for this great plugin that really push Cacti before the $$$ entreprise monitoring software.
Best regards,
Vince
OK tested,
New option work good but I've an SQL error :
06/18/2010 08:21:16 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT host.id AS host_id, host.hostname, host.description, host.disabled, host.status, host_template.name AS host_template_name FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE ( ( host.description LIKE '%xba%' OR host.description LIKE '%zba%' ) AND 0 ( host.description LIKE '%son%' OR host.description LIKE '%own%' OR host.description LIKE '%cln%' ))"
After manualy deleting the filed value "0" for the apporpriate ID in the "plugin_autom8_match_rule_items" SQL table everything run very good.
I think the the problem comes from this line in setup.php :
Best regards and again thank you!
Vince
New option work good but I've an SQL error :
06/18/2010 08:21:16 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT host.id AS host_id, host.hostname, host.description, host.disabled, host.status, host_template.name AS host_template_name FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE ( ( host.description LIKE '%xba%' OR host.description LIKE '%zba%' ) AND 0 ( host.description LIKE '%son%' OR host.description LIKE '%own%' OR host.description LIKE '%cln%' ))"
After manualy deleting the filed value "0" for the apporpriate ID in the "plugin_autom8_match_rule_items" SQL table everything run very good.
I think the the problem comes from this line in setup.php :
Code: Select all
define("AUTOM8_OP_NONE", 0);
Vince
Here the rules. As you can see in the SQL error there is a "0" directly after the "AND"
Code: Select all
06/21/2010 11:07:43 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT host.id AS host_id, host.hostname, host.description, host.disabled, host.status, host_template.name AS host_template_name FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE ( host.description LIKE '%bck%' AND 0 ( host.description LIKE '%pos%' OR host.description LIKE '%zen%' OR host.description LIKE '%zol%' )) ORDER BY description ASC LIMIT 0,50"
- Attachments
-
- rules_and.gif (6.36 KiB) Viewed 3561 times
Hi,
I've tried to resave the element with a "0" but without success. I've also tried (expr) and (expr) but I got the same error.
Comes this "0" from the structure of the table itself? I can see that the default value in table is "0".
Regards,
Vince
I've tried to resave the element with a "0" but without success. I've also tried (expr) and (expr) but I got the same error.
Comes this "0" from the structure of the table itself? I can see that the default value in table is "0".
Regards,
Vince
Code: Select all
06/22/2010 01:02:37 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT host.id AS host_id, host.hostname, host.description, host.disabled, host.status, host_template.name AS host_template_name FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE ( ( host.description LIKE '%bck%' OR host.description LIKE '%son%' ) AND 0 ( host.description LIKE '%pos%' OR host.description LIKE '%zen%' OR host.description LIKE '%zol%' )) ORDER BY description ASC LIMIT 0,50"
- Attachments
-
- rules_and_expr.gif (6.54 KiB) Viewed 3523 times
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
Oops, I only changed graph rules. Now the same feature is in for tree rules. SVN#1086.killshoot wrote:Here the rules. As you can see in the SQL error there is a "0" directly after the "AND"
Code: Select all
06/21/2010 11:07:43 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT host.id AS host_id, host.hostname, host.description, host.disabled, host.status, host_template.name AS host_template_name FROM host LEFT JOIN host_template ON (host.host_template_id = host_template.id) WHERE ( host.description LIKE '%bck%' AND 0 ( host.description LIKE '%pos%' OR host.description LIKE '%zen%' OR host.description LIKE '%zol%' )) ORDER BY description ASC LIMIT 0,50"
You will have to re-save all bogus items. That should do.
R.
Who is online
Users browsing this forum: No registered users and 0 guests