not reading snmp interface anymore.....

[recombinator]

Hi.......i,ve been using Cacti for a while now and really love it.......forget cricket or mrtg.
But problem is now, that i can't add anymore snmp interfaces.....
Usually bi snmp interfaces i add a new one with the ip address and snmp read community. I get all the interfaces of the device and select the ones i want to monitor.
But now everytime i do it.....the interface search comes up empty. It scans the device but doesn't return any interfaces....no matter what ip address is use of which device.....
Can anyone help me out here???....i need to add another 150 devices or so. Or could this be a mysql problem??

[bulek]

If we are talking of cacti limits the answer is it depends. It depends on how many devices you have defined, how many interfaces each of devices include and how many times you pressed "refresh interfaces" button. Each interface has its own ID number in mysql table. This number is growing with every new interface. Even if you delete some devices lower numbers are never re-used. Finaly when you make "refresh interfaces" this deletes existing interfaces from DB and adds a new ones (with higher ID number). Cacti design assumes that highest ID number is 32767. You can check your maximum ID by mysql comand:

Code: Select all

select max(id) from snmp_hosts_interfaces;

- bulek

[recombinator]

The max is indeed 32767 with the command you provided. Is there a way to workaround this??.....or is the only solution that is delete all the interfaces that i don't need after an snmpwalk ??

[bulek]

You may try to change ID field definition like this:

alter table snmp_hosts_interfaces modify id int not null auto_increment;

This will give you much more space - over 2 bln possible interfaces. I don't take any responsibility if this crashes your table structure ... you have 99% chance that it will work.

- bulek

[recombinator]

Thx alot dude.....the quesry gave OK in mysql, but when i gave the command you supplied before the max was still 32767....but this won't probably mean it won't work??
I'll try it now......

[recombinator]

So far so good........i'm adding devices again.
Thx man........let's see where it ends now!!