Long OID's

[rvg]

Hey,

I am having trouble getting the poller to work with long OID's. If you

Code: Select all

mysql> select arg1 from poller_item;
| .1.3.6.1.4.1.99999.1.1.1.3.8.118.111.100.97.99.111.109.49                               |
| .1.3.6.1.4.1.99999.1.2.1.3.21.110.101.119.115.115.111.117.116.104.97.102.114.105.99.97. |
| .1.3.6.1.4.1.99999.1.2.1.3.20.114.111.109.97.110.116.105.99.113.117.111.116.101.115.95. |
| .1.3.6.1.4.1.99999.1.2.1.3.19.101.120.99.104.97.110.103.101.114.97.116.101.115.95.104.9 |
| .1.3.6.1.4.1.99999.1.2.1.3.18.102.97.109.111.117.115.113.117.111.116.101.115.95.104.97. |
| .1.3.6.1.4.1.99999.1.2.1.3.17.112.105.99.107.117.112.108.105.110.101.115.95.104.97.110. |
| .1.3.6.1.4.1.99999.1.2.1.3.14.100.105.100.117.107.110.111.119.95.104.97.110.103.105     |
| .1.3.6.1.4.1.99999.1.2.1.3.14.99.97.112.105.116.97.108.115.95.104.97.110.103.105        |

You can see that the OID's have been truncated. I think this column should be enlarged.

Rudolph

[rvg]

On second thought:

Code: Select all

mysql> show columns from poller_item;
+----------------+-----------------------+------+-----+---------+-------+
| Field          | Type                  | Null | Key | Default | Extra |
+----------------+-----------------------+------+-----+---------+-------+
| local_data_id  | mediumint(8) unsigned |      | PRI | 0       |       |
| poller_id      | smallint(5) unsigned  |      |     | 0       |       |
| host_id        | mediumint(8)          |      | MUL | 0       |       |
| action         | tinyint(2) unsigned   |      |     | 1       |       |
| hostname       | varchar(250)          |      |     |         |       |
| snmp_community | varchar(100)          |      |     |         |       |
| snmp_version   | tinyint(1) unsigned   |      |     | 0       |       |
| snmp_username  | varchar(50)           |      |     |         |       |
| snmp_password  | varchar(50)           |      |     |         |       |
| snmp_port      | mediumint(5) unsigned |      |     | 161     |       |
| snmp_timeout   | mediumint(8) unsigned |      |     | 0       |       |
| rrd_name       | varchar(19)           |      | PRI |         |       |
| rrd_path       | varchar(255)          |      |     |         |       |
| rrd_num        | tinyint(2) unsigned   |      |     | 0       |       |
| arg1           | varchar(255)          | YES  |     | NULL    |       |
| arg2           | varchar(255)          | YES  |     | NULL    |       |
| arg3           | varchar(255)          | YES  |     | NULL    |       |
+----------------+-----------------------+------+-----+---------+-------+

The table seem to be large enough. So where did my oids get truncated?

[rony]

The field size in the database is 255....

And your data is only 87 char long.... Truncation has to be happening elsewhere.

[rvg]

The poller gives this error:

Code: Select all

03/13/2005 07:55:05 PM - CMDPHP: Poller[0] Host[6] WARNING: Result from SNMP not valid.  Partial Result: No Such Instance cur
03/13/2005 07:55:05 PM - CMDPHP: Poller[0] Host[6] SNMP: v2: 66.8.37.238, dsname: application_invokes, oid: .1.3.6.1.4.1.99999.1.2.1.3.21.110.101.119.115.115.111.117.116.104.97.102.114.105.99.97., output: U
03/13/2005 07:55:05 PM - CMDPHP: Poller[0] Host[6] WARNING: Result from SNMP not valid.  Partial Result: No Such Instance cur
03/13/2005 07:55:05 PM - CMDPHP: Poller[0] Host[6] SNMP: v2: 66.8.37.238, dsname: application_invokes, oid: .1.3.6.1.4.1.99999.1.2.1.3.20.114.111.109.97.110.116.105.99.113.117.111.116.101.115.95., output: U
03/13/2005 07:55:06 PM - CMDPHP: Poller[0] Host[6] WARNING: Result from SNMP not valid.  Partial Result: No Such Instance cur
03/13/2005 07:55:06 PM - CMDPHP: Poller[0] Host[6] SNMP: v2: 66.8.37.238, dsname: application_invokes, oid: .1.3.6.1.4.1.99999.1.2.1.3.19.101.120.99.104.97.110.103.101.114.97.116.101.115.95.104.9, output: U
03/13/2005 07:55:06 PM - CMDPHP: Poller[0] Host[6] WARNING: Result from SNMP not valid.  Partial Result: No Such Instance cur
03/13/2005 07:55:06 PM - CMDPHP: Poller[0] Host[6] SNMP: v2: 66.8.37.238, dsname: application_invokes, oid: .1.3.6.1.4.1.99999.1.2.1.3.18.102.97.109.111.117.115.113.117.111.116.101.115.95.104.97., output: U
03/13/2005 07:55:06 PM - CMDPHP: Poller[0] Host[6] WARNING: Result from SNMP not valid.  Partial Result: No Such Instance cur

[TheWitness]

Truncation does occur. There is a post somewhere. I will have to find it. This will have to be an enhancement request/bug. I will find the post and the mods and update this record.

TheWitness

[TheWitness]

Here is the post. Has the solution. We need a patch. Fixing short term should be a table mod using one of the available tools.

TheWitness

http://forums.cacti.net/about6613.html