Problem with poller cache after OID change.

[benzo]

In case anyone else has this issue, the solution to the original question is to modify the OID values in the MySQL DB using the following SQL:

UPDATE data_input_data SET value = '[new_oid]' WHERE value = '[old_oid]';

For example:
UPDATE data_input_data SET value = '.1.3.6.1.4.1.15.15.1' WHERE value = '.1.3.6.1.4.1.9600.1.2.46.8.0';

Trigger a poller cache rebuild afterwards.

Ben

[NegativeEpsilon]

Feedback anyone?

Thanks TheWitness, works for me (:

[bstanley]

I also have the exact same problem... I have to use webmin to open up poller_item database and manually correct my OID everytime I mess with the data source...

OID I am using: .1.3.6.1.4.1.9.9.392.1.3.22.1.2.12.82.101.109.111.116.101.79.102.102.105.99.101

it always gets the last 1 truncated and shows as:

.1.3.6.1.4.1.9.9.392.1.3.22.1.2.12.82.101.109.111.116.101.79.102.102.105.99.10

I will try the replacing the script provided by The Witness and see if it fixes

[gandalf]

Then please look at the data type of the column that was truncated. And please post your cacti version
R.

[artiflo]

Feedback anyone?

Cacti 0.8.7g
PIA 2.8

Works for me