(RADIATOR) Emergency - Please help

[Craig Gittens]

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.