Change default "Re-Index Method"

[ogou]

Hi,

I've create a "Host Template" with many Interfaces graph ...
I'd like to know if I can change the default "Re-Index Method".

The default is "Uptime Goes Backwards" but I'd like to have "Index Count Changed".

Thanks,
Olivier

[gandalf]

Once the Data Query is added, there's no chance to change this. Perhaps changing the MySQL table and re-generating the poller_cache would work?
Reinhard

[ogou]

Hi Reinhard,

I just whant to know, when I apply a host template (with Associated Data Queries) if I can have the "Re-Index Method" set to "Index Count Changed" BY DEFAULT.

This is because when I apply a Host Template, the "Re-Index Method" is set to "Uptime Goes Backwards". So I must delete the "Data Queries" and recreate it.

Thanks,
Olivier

[gandalf]

AFAIK this is not configurable. This will require a code change, but only a very small one. If you're interested in this, I may provide it
Reinhard

[ogou]

Yes Reinhard,

If you could send me the code to change.

Thanks,
Olivier

[gandalf]

Please change host.php,

Code: Select all

<?php form_dropdown("reindex_method",$reindex_types,"","","1","","");?>

to

Code: Select all

<?php form_dropdown("reindex_method",$reindex_types,"","","2","","");?>

to get "Index Count changed" etc.
Reinhard

[anuraganuj]

you can change re-indexing method any time as i did and tested it also to work.just delete that data query from host and add same data query with new reindexing method that is it.

[ogou]

Thanks Reinhard,

The default "Re-Index Method" is now set to "Index Count Changed" when I add manually "Data Query".

This is ok BUT when I apply a "HOST TEMPLATE" on a new host, the "Re-Index Method" is still "Uptime Goes Backwards" for my data query.

In my example, I apply a host template with this conf :

Graph Template
1) Redback - CPU
2) Redback - Memory
Data Query Name
1) Interfaces 64-bit Stat

The "Interfaces 64-bit Stat" is apply to my host with an "Index Method" set to "Uptime Goes Backwards".

[anuraganuj]

you can change re-indexing method any time as i did and tested it also to work.just delete that data query from host and add same data query with new reindexing method that is it.

[gandalf]

This is ok BUT when I apply a "HOST TEMPLATE" on a new host, the "Re-Index Method" is still "Uptime Goes Backwards" for my data query.

Ah, yes. Did not realize this fact. Perhaps will have a look, but need some time
Reinhard

[dgerow]

Any word on this? The Win32_runningprocs template provided in another thread[0] require a re-index method of 'Index Count Changed'. As I'd failed to notice this before adding all required devices, I now have to go through and change the method for a few hundred hosts.

[0]http://forums.cacti.net/viewtopic.php?t ... sc&start=0

[gandalf]

Any word on this? The Win32_runningprocs template provided in another thread[0] require a re-index method of 'Index Count Changed'. As I'd failed to notice this before adding all required devices, I now have to go through and change the method for a few hundred hosts.

[0]http://forums.cacti.net/viewtopic.php?t ... sc&start=0

Assuming you're familiar with sql or at least are using stuff like phpmyadmin, you may have a look at the table `host_snmp_query` to find the field reindex_method. You may try to play around with this on a test system of your own. It is a good idea, to do a mysqldump before.
I won't _really_ suggest using this on a production system, but this depends ...
Reinhard

[dgerow]

Yep, that works great for the bulk update (already done and completed), but it would still be nice to not have to add a query to a device every time it's added.

I suppose an option would be to keep the runningprocs in the template, then just do bulk SQL updates every time we import new devices (another few dozen are coming in soon), but, as you said, it's not ideal for a production system.

[gandalf]

You may post a Feature Request on this. Neither my code snippet nor the sql hint I gave will be officially supported and may change without notice.
Reinhard

[tilli]

If you want to change the reindex value for all of the previously added devices,
it can be done through mysql using the following command

mysql> UPDATE `cacti`.`host_snmp_query` SET `reindex_method` = '2';