(RADIATOR) Handler working now.... but ;-)

Thu Sep 19 23:38:41 CDT 2002

Won't this ignore any normal accounting packets?

Normal dialup accounting packets are Async, too

Skeeve, do you have a separate config/handler for Static IP ports?

--------- Static IP Packet ----------------------------
Fri Sep 20 14:00:27 2002: DEBUG: Packet dump:
*** Sending to 203.25.159.1 port 1646 ....
Code:       Accounting-Request
Identifier: 180
Attributes:
        NAS-IP-Address = 203.220.251.113
        NAS-Port = 6173
        NAS-Port-Type = Async
        Called-Station-Id = "142320198333333"
        Calling-Station-Id = "89333333"
        Acct-Status-Type = Alive
        Acct-Authentic = Local
        Service-Type = Framed-User
        Acct-Session-Id = "0000000C"
        Framed-Protocol = PPP
        Tunnel-Server-Endpoint = 50:03.194.30.244
        Tunnel-Client-Endpoint = 50:03.220.251.65
        Tunnel-Client-Auth-ID = 65:CC01-WARA-KTA
        Tunnel-Server-Auth-ID = 76:NS01-KENT-SYD
        Tunnel-ID = 50:932100001
        Ascend-Session-Svr-Key = "4xxxxxx"
        Ascend-PreSession-Time = 25
        Ascend-Pre-Input-Octets = 100
        Ascend-Pre-Output-Octets = 107
        Ascend-Pre-Input-Packets = 4
        Ascend-Pre-Output-Packets = 4
        Acct-Input-Octets = 8452558
        Acct-Output-Octets = 20087929
        Acct-Input-Packets = 43993
        Acct-Output-Packets = 56951
        Acct-Session-Time = 123136
        Acct-Delay-Time = 0
        User-Name = "xxxxxxx"
        Proxy-State = BSP2ims01-xxxxxx
        Timestamp = 1032494427

--------- Normal Accounting Packet --------------------
*** Received from 203.194.56.120 port 1813 ....
Code:       Accounting-Request
Identifier: 155
Attributes:
        NAS-IP-Address = 203.220.79.14
        NAS-Port = 7372
        NAS-Port-Type = Async
        Called-Station-Id = "142330399133333"
        Calling-Station-Id = "394233333"
        Acct-Status-Type = Alive
        Acct-Authentic = RADIUS
        Service-Type = Framed-User
        Acct-Session-Id = "00064193"
        Framed-Protocol = PPP
        Ascend-Session-Svr-Key = "7A233332"
        Framed-IP-Address = 203.221.34.15
        Ascend-PreSession-Time = 27
        Ascend-Pre-Input-Octets = 99
        Ascend-Pre-Output-Octets = 103
        Ascend-Pre-Input-Packets = 4
        Ascend-Pre-Output-Packets = 4
        Acct-Input-Octets = 507369
        Acct-Output-Octets = 3009061
        Acct-Input-Packets = 4978
        Acct-Output-Packets = 4566
        Acct-Session-Time = 2313
        Acct-Delay-Time = 0
        User-Name = "dxxxxx6"
        Proxy-State = BSP2ims01-syd/xxxxxxxxxxxxxxx

-----Original Message-----
From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au]On
Behalf Of Hugh Irvine
Sent: Friday, September 20, 2002 2:01 PM
To: Skeeve Stevens
Cc: radiator at open.com.au
Subject: Re: (RADIATOR) Handler working now.... but ;-)

Hello Skeve -

Try something like this (note the Handler defintion below also):

# define Session Databases

<SessionDatabase SQL>
	Identifier SQLSDB
	....
</SessionDatabase>

<SessionDatabase NULL>
	Identifier NULLSDB
	.....
</SessionDatabase>

# define Handlers

<Handler Request-Type = Accounting-Request, NAS-Port-Type = Async>
	# use NULL session database
	SessionDatabase NULLSDB
	<AuthBy INTERNAL>
		AcctResult ACCEPT
	</AuthBy>
	.....
</Handler>

<Handler>
	# use SQL session database
	SessionDatabase SQLSDB
	.....
</Handler>

regards

Hugh

On Friday, September 20, 2002, at 01:44 PM, Skeeve Stevens wrote:

>
>
>
> Ok.. With the awesome help of Hugh my handler is working fine.
>
> But.....  my SessionDatabase is still getting both accounting data.
>
> Can I move the below into the main <Handler> or is there something  
> else to address this?
>
>
>
> #This keeps track of who is online
> <SessionDatabase SQL>
>         Identifier SDB1
>         DBSource dbi:mysql:x:x
>         DBUsername radius
>         DBAuth t3ch3xAuTh
>
>         AddQuery insert into online  
> (acct_handle,nas_id,online_nasport,online_sessionid,online_date,online_ 
> ipaddress,online_servicetype,online_calling_station,online_called_stati 
> on,online_key) values  
> ('%n','%N','%{NAS-Port}','%{Acct-Session- 
> Id}',from_unixtime(%{Timestamp}),'%{Framed-IP-Address}','%{Service- 
> Type}','%{Calling-Station-Id}','%{Called-Station-Id}','%{Ascend- 
> Session-Svr-Key}')
>
>         DeleteQuery delete from online where acct_handle = '%n' and  
> nas_id = '%N' and online_nasport = %{NAS-Port}
>
>         ClearNasQuery delete from online where nas_id = '%N'
>
>         CountQuery select nas_id,online_nasport,online_sessionid from  
> online where acct_handle = '%n'
> </SessionDatabase>
>
>
>
>
> -- 
>       
> ---------------------------------------------------------------------
>     | Skeeve Stevens                          url:  
> http://www.skeeve.org/ |
>     | email://skeeve@skeeve.org/          url:  
> http://www.eIntellego.org/ |
>       
> ---------------------------------------------------------------------
> ===
> 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.
>
>

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
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.