Try using
where USERNAME = '%{User-Name}'
or
where USERNAME = '%n'
and see Table 1 in Section 6.2 of the Radiator reference manual for more
details (http://www.open.com.au/radiator/ref.html)
> -----Original Message-----
> From: Craig Gittens [mailto:[EMAIL PROTECTED]
> Sent: 29 August 2003 16:12
> To: Matthew Trout; 'Craig Gittens'; Mike McCauley; Radiator
> Cc: Hugh Irvine
> Subject: RE: (RADIATOR) Emergency - Please help
>
>
> The NAS port isn't a common denominator. It seems that we
> aren't getting all
> the stop records. But when we do get one it would be great to
> erase ALL old
> records under that username.
>
> Craig.
>
> -----Original Message-----
> From: Matthew Trout [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 29, 2003 10:40 AM
> To: 'Craig Gittens'; Mike McCauley; Radiator
> Cc: Hugh Irvine
> Subject: RE: (RADIATOR) Emergency - Please help
>
>
> The query I gave you will do that - you probably aren't
> seeing the user in
> the stop packet
>
> An alternative is to try doing it by NAS port - e.g.
>
> DeallocateQuery update RADPOOL set STATE=0,TIME_STAMP=%t
> where NASIP='%N'
> and NASPORT=%{NAS-Port}
>
> which is what we use
>
> > -----Original Message-----
> > From: Craig Gittens [mailto:[EMAIL PROTECTED]
> > Sent: 29 August 2003 15:03
> > To: Mike McCauley; Craig Gittens; Radiator
> > Cc: Hugh Irvine
> > Subject: RE: (RADIATOR) Emergency - Please help
> > Importance: High
> >
> >
> > Ok Mike. I get that the only variable it replaces is the
> IP. But can I
> > possibly get a patch that will replace the username since it
> > is in the stop
> > packet?
> >
> > Desperate,
> >
> > Craig.
> >
> > Fri Aug 29 09:32:35 2003: DEBUG: Packet dump:
> > *** Received from 205.214.223.130 port 1646 ....
> > Code: Accounting-Request
> > Identifier: 209
> > Authentic: <177><206><16><161><244><205>Ya/<219>2<148><243>~`j
> > Attributes:
> > NAS-IP-Address = x.x.x.x
> > NAS-Port = 311
> > NAS-Port-Type = Async
> > User-Name = "cbravo"
> > Called-Station-Id = "1111111111"
> > Calling-Station-Id = "111111111111"
> > Acct-Status-Type = Stop
> > Acct-Authentic = RADIUS
> > Service-Type = Framed-User
> > Acct-Session-Id = "000005C5"
> > Framed-Protocol = PPP
> > Tunnel-Server-Endpoint = 192.168.255.20
> > Tunnel-Client-Endpoint = 10.193.5.9
> > Tunnel-Type = 0:L2TP
> > Tunnel-Client-Auth-ID = lnsbios3
> > Tunnel-Server-Auth-ID = sunbeachrout
> > Tunnel-ID = 43383
> > Framed-IP-Address = 66.205.10.9
> > Acct-Terminate-Cause = Host-Request
> > Acct-Input-Octets = 184107
> > Acct-Output-Octets = 1256882
> > Acct-Input-Packets = 2436
> > Acct-Output-Packets = 2427
> > Acct-Session-Time = 5073
> > Acct-Delay-Time = 0
> >
> >
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> > Behalf Of Mike McCauley
> > Sent: Friday, August 29, 2003 8:56 AM
> > To: Craig Gittens; Radiator
> > Cc: Hugh Irvine
> > Subject: Re: (RADIATOR) Emergency - Please help
> >
> >
> > Hello Craig,
> >
> >
> > On Fri, 29 Aug 2003 10:27 pm, Craig Gittens wrote:
> > > I have been having endless problems with an upgrade the
> > modem providers
> > > have done. What I am seeing now is that IP allocation is
> > done and gives
> > 6-8
> > > IP addresses to the same person. Ok we are investigating
> > and I will get
> > > back to you with data. However, in the mean time I want to add the
> > > Deallocate Query and change the default query to use
> > USERNAME = %2 instead
> > > of looking for the IP used in the stop packet. This would
> > solve my porblem
> > > temporarily. However when I add it to the config and
> > restart radius at
> > > debug, it still uses the default query. Is it a bug with 3.6.0?
> >
> > Sounds curious. BTW The only positional arg that is used by
> > DeallocateQuery
> > is
> > %0, which is replaced by the address.
> >
> > If Radiator is not using the Deallocate Query in your config
> > file, then the
> > possibilites are:
> >
> > 1. You have incorrect spelling or capitalisaiton of DeallocateQuery
> > 2. The config file you changed is _not_ the one that Radiaotr is not
> > actually
> > using (Radiator will tell you which it read in the log file
> > when it starts
> > up).
> >
> > To tell more we would need to see your configuraiton file (no
> > secrets) and a
> > log file at trace level 4.
> >
> > Cheers.
> >
> >
> >
> > ===
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on [EMAIL PROTECTED]
> > To unsubscribe, email '[EMAIL PROTECTED]' with
> > 'unsubscribe radiator' in the body of the message.
> >
>
>
>
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
