RE: [tkined] SNMP to SQL (was: High volume SNMP poller)

From: John Stumbles (visstmbl@reading.ac.uk)
Date: Mon Feb 21 2000 - 11:59:22 MET


On Thu, 17 Feb 2000, Chandrasekhar Kanakam wrote:

> It's interesting discussion, let it go in this group.
>
> Chandra
>
> >
> > cc: me, if you don't mind. Thanks.
> >
> > Keith Plourd
> > P. O. Box 151
> > 16 Tuckaway Shores Road
> > Nottingham, NH 03290
> > (603) 895-1438 (603) 498-2639 (Cell)

I'm interested also.

        I'm working on an NMS-type system (www.rdg.ac.uk/ITS/NOC/scripts)
collecting (amongst other data such as NIS and user logs) SNMP-derived
info from hosts on our network, so I can discover all routers and collect
their arp tables, and dot1d tables from bridges/switches, and use this
data to show e.g. which switch or router port a given host is (probably :)
connected to. At present most code is Perl with the Scotty 'snmpwalk' code
(more-or-less) for collecting the SNMP stuff, and using mSQL with the Perl
DBI module for access.

        I'm inclined to think of moving to the Perl SNMP module (or
perhaps Wes Hardaker's UCDavis code which I think has a Perl interface)
instead of Scotty, partly because it's not elegant to fire off a Scotty
script from Perl to do snmpwalk, and partly because maintaining Tcl/Tk +
Scotty. (Our NMS Sun got upgraded to 2.6 just before Xmas (to make it
Y2KOK) and broke Scotty ... the hassle I had to get everything working
again <grrr!> ... I'm not a unix wizard :-( .)

        OTOH I'm also planning to move to mySQL (tired of "mSQL server has
gone away messages" :-) and if I could pirate^H^H^H^H^H^Hborrow someone
else's Scotty <-> mySQL code it might be a good idea to hack on that to go
directly from SNMP to SQL....

        Also it's just an interesting discussion :-)

- --
John Stumbles j.d.stumbles@reading.ac.uk
I.T. Services Centre, University of Reading http://www.rdg.ac.uk/~visstmbl
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
          Press any key to continue or any other key to quit.

--
!! This message is brought to you via the `tkined & scotty' mailing list.
!! Please do not reply to this message to unsubscribe. To subscribe or
!! unsubscribe, send a mail message to <tkined-request@ibr.cs.tu-bs.de>.
!! See http://wwwsnmp.cs.utwente.nl/~schoenw/scotty/ for more information.



This archive was generated by hypermail 2b29 : Mon Jan 08 2001 - 15:27:36 MET