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.
