We are using RadiusNT 2.5.206
Options
--------------
Manual calls update
Stop records only
(we are not using calls_insert trigger)
with these options , RadiusNT is not updating Serverports.AcctSessionID
and that means we can not use this method.
Am I right ?
your serverports queries are
for start
UPDATE sp Set sp.Username='username',sp.AcctStatusType=1,
sp.CallDate=GetDate(), sp.FramedAddress='xxx.xxx.xxx.xxx' From Servers s,
ServerPorts sp WHERE sp.ServerID = s.ServerID AND
s.IPAddress='yyy.yyy.yyy.yyy' and sp.Port=19 AND (DateAdd(Second, 0-1,
GetDate()) >= CallDate OR CallDate IS NULL)
for stop
UPDATE sp Set sp.Username='username',sp.AcctStatusType=2,
sp.CallDate=GetDate(), sp.FramedAddress='xxx.xxx.xxx.xxx' From Servers s,
ServerPorts sp WHERE sp.ServerID = s.ServerID AND
s.IPAddress='yyy.yyy.yyy.yyy' and sp.Port=19 AND (DateAdd(Second, 0-2,
GetDate()) >= CallDate OR CallDate IS NULL)
and to solve our case (and for many cases, this would be helpful), can these
queries like
UPDATE sp Set sp.Username='username',sp.AcctStatusType=1,
sp.CallDate=GetDate(), sp.FramedAddress='xxx.xxx.xxx.xxx',
AcctSessionID='bla bla'
, CallerID = 'bla bla', ConnectInfo='bla bla' From Servers s, ServerPorts sp
WHERE sp.ServerID = s.ServerID AND s.IPAddress='yyy.yyy.yyy.yyy' and
sp.Port=19 AND (DateAdd(Second, 0-1, GetDate()) >= CallDate OR
CallDate IS NULL)
thanks in advance
Serkan SUBASI
----- Original Message -----
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: <radiusnt@iea-software.com>
Sent: Wednesday, December 01, 1999 9:14 PM
Subject: Re: [RadiusNT] RE: RadiusNT Digest
Serkan SUBASI wrote:
>
> > > In CVX , object id s are based on the sessionid, but as your RadiusNT
> s
> > > approximation, that must be based on nasport.
> > > (unlike PM3 or Cisco )
> >
> > Or SessionID. Ascend does it that way and there is support for it
> > in RadiusNT. Just set the type for an Ascend and follow the directtions
> > for the ascend modele
> >
> Where can I find that modele ?
Its on the FAQ. Check it out at:
http://www.iea-software.com/radiusnt/faqs/SNMP-Concurrency.html
> > (just use your own OID instead).
>
> What will I write to SNMPUSer field of serverports table ?
>
> "bla bla .2637.2.2.102.1.12."
Yes: .1.3.6.1.4.1.2637.2.2.102.1.12. should be fine (notice the ending
dot).
RadiusNT will append the ASID if the ServerType is 5-8.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
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