OID Too Long?

[cylam]

I am trying to pool a very long OID, without success.

The cacti log shows that my very long OID (10x char) was trimmed into a 90 char OID, and the device returned "U".

Has anyone faced this problem before? Is there any limit on the length of OID made in PHP script? The OID stored in the mysql db is correct.

Thanks very much!

[TheWitness]

Please goto System Utilities -> View Poller Cache and find the OID in question. Then, post those few lines. CMD.PHP should not truncate. Let's see if it's getting truncated in the poller_cache table because PHP should not be.

TheWitness

[TheWitness]

The OID text plus any script calling parameters can not be longer than 255 characters in the current version. If you are calling using snmp and not with a script, the OID can be up to 255 characters.

TheWitness

[cylam]

Data Source: BigIP (TESTING HOST) - Pool Member Connections - XXXXXXXXXXXXXPO (query_memberIndex)
RRD: /home/xxxxxx/public_html/rra/bigip_bip_testing_host_f5_poolmember_conn_324.rrd
Action: 0, OID: 1.3.6.1.4.1.3375.1.1.8.2.1.19.XX.XX.XX.XX.XX.XX.XX.XX.XX.XX.XX.XX.XX.XX.XX.XX.79.76.1XX.13 (Host: 1XX.13X.XX.XX, Community: xxxxxx)

IPs and part of OID are masked as X owing to security concern. The query method I used is "SNMP Queries (Indexed)". The OID stored in the database is correct.

Thanks very much for your quick response!

[cylam]

New info:

I found that the OID stored in the database poller_item.arg1 is already truncated. But the other table (called data_????_???) stored the correct OID. Manually update the poller_item.arg1 entry make the poller works again.

[cylam]

New info:

I found that the "snmp_index" stored in the database is defined as varchar(60), bnd F5 BigIP requires an index longer than that.

My work-around is to set the "snmp_index" field in the table host_snmp_cache and data_local to varchar(100). After removing and re-creating the existing device and graphs, cacti now pools and graphs happily!

Thank you very much for your attention! Cacti is really great!

[TheWitness]

Thanks!

I will add patches as required for the next version.

TheWitness

[cylam]

Missed one table.

The field snmp_index of graph_local needed to be enlarged to varchar(100) in order to make the |query_*| work correctly with data query of long snmp_index.

[TheWitness]

This information has been captured for Cacti 0.8.6d rollout next week (if all goes well).

TheWitness

[darrenb]

So has this been addressed? The network interface MIBs with SNMP Informant are greater than 256 bytes and are being truncated. I see the poller_item table arg1 columns still use varchar(255). I'm using 0.8.6h.


| arg1 | varchar(255) | YES | | NULL | |
| arg2 | varchar(255) | YES | | NULL | |
| arg3 | varchar(255) | YES | | NULL | |

[TheWitness]

Darren,

The limit in 0.8.6h is currently 255 characters. If your OID is longer than that, then, you will have to make a few changes.

1) Upgrade to PHP 5.0.3 or Greater (Enables Varchar 65535)
2) Make modifications to several tables
3) If you are using Cactid, then you will have to also modify a structure in cactid.h to match what you picked for the various columns.

If you have a number, then name it. Submit it as a bug report. We will not likely address it until the next release, at the earliest. For right now it's 255. You can submit a bug at bugs.cacti.net

TheWitness

[darrenb]

Since my post I've altered each of the argX columns to type 'text'. This seems to have solved the immediate issue. I'm currently using cmd.php, not cactid. Is there anything else I need to be aware of?

[TheWitness]

If you use Cactid, then you simply need to alter a structure in cactid.h from char(255) to something else.... Of course you have to recompile.

TheWitness