RE: [Emerald] OID's for a Cisco 5300

Robert H. Clugston ( (no email) )
Fri, 30 Jun 2000 14:44:16 -0700

Can SNMP be used to kick users from the calls table view in emerald? If no,
why not?

I'm having some trouble understading how to use SNMP with RadiusNT. I've
enabled SNMP on my Portmasters. I set the readcommunity/writecommunity. I
added a snmp reader/write entry for my RadiusNT machine. In Emerald I set
the community the same as on the PM3's. What else do I have to do?
I keep seeing a SQL query being passed around, but where does this go? Do I
only have to run the query once or does it go in a store procedure. Also,
does the query change if I'm running NFAS PRI's (I plan on doing this soon.)
Currently I'm running 4x23B+1D pri's, but hope to change to 1x23b+1D & 3x24B
in the near future.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of NCKCN
Sent: Friday, June 30, 2000 9:35 AM
To: emerald@iea-software.com
Subject: Re: [Emerald] OID's for a Cisco 5300

Duane,

This script will set the correct OID for Cisco 2511. It should work for all
Cisco Routers.

UPDATE ServerPorts
Set SNMPUser=".1.3.6.1.4.1.9.2.9.2.1.18." + convert(varchar(5), Port)
Where ServerID='x'

Just replace the 'x' with your ServerIDs. You can find the Cisco OIDs in the
Radius NT Manual under SNMP Concurrency Checking.

-----------------------------------------------------------------
Thanks,
TKT
-----------------------------------------------------------------

----- Original Message -----
From: "Duane Schaub" <dschaub@terraworld.net>
To: <emerald@iea-software.com>
Sent: Friday, June 30, 2000 11:28 AM
Subject: [Emerald] OID's for a Cisco 5300

> Does anyone know the OID's for SNMP checking on a 192port cisco 5301?
>
> Duane.
>
>
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Beachlink
> Administrator
> Sent: Thursday, June 29, 2000 9:06 AM
> To: emerald@iea-software.com
> Subject: RE: [Emerald] Malformed Data in Calls Table
>
>
> You may also want to enable SNMP checking. That has solved everything for
> me. Even if the CALLS table shows the customer is still online, SNMP
> checking will actually query the NAS to see if that user is online. It is
> very slick, and has relieved the headaches involved in the "over login
> limit" scenario you describe.
>
> See http://www.iea-software.com/radiusnt/faqs/SNMP-Concurrency.html for
> instructions.
>
> --Gary Walworth
> admin@beachlink.com
>
>
> > "Robert H. Clugston" wrote:
> >
> > > List,
> > > I'm reviewing my calls table to see if I can find out
> > why some of my users
> > > are getting "over login limit" errors. I ran this query:
> > > SELECT
> > > DISTINCT Calls.UserName,
> > > Calls.AcctSessionTime,
> > > Calls.NASIdentifier,
> > > Calls.NASPort,
> > > Calls.CallDate,
> > > Calls.CallerID
> > > FROM
> > > Emerald.dbo.Calls Calls
> > > WHERE
> > > Calls.UserName = 'user'
> > > ORDER BY
> > > Calls.CallDate ASC
> > >
> > > When I was searching throught the results I noticed
> > that there was alot of
> > > data that looked corrupt. Any idea if this is a problem or is this is
> > > normal?
> > >
> > > For more information about this list (including removal) go to:
> > > http://www.iea-software.com/support/maillists/liststart
> >
> > If your NAS crashes (no BBU) or for any other reason does not
> > send the Stop packet.
> > Emerald will believe they are still online and they must be
> > cleared from the Online
> > screen manually.
> >
> > I was also getting duplicate packets (Session IDs) that it was
> > not receiving properly
> > for obvious reasons.
> > I cleared old data, older than 2 months (or the affected period)
> > and the accounting
> > began working properly again.
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart