(RADIATOR) Emergency - Please help

[Matthew Trout]

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:cgittens at sunbeach.net] 
> 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:MatthewTrout at businessserve.co.uk]
> 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:cgittens at sunbeach.net]
> > 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: owner-radiator at open.com.au 
> [mailto:owner-radiator at open.com.au]On
> > 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 radiator-announce at open.com.au
> > To unsubscribe, email 'majordomo at open.com.au' with
> > 'unsubscribe radiator' in the body of the message.
> >
> 
> 
> 
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.