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:[EMAIL PROTECTED]/ url:
> http://www.eIntellego.org/ |
>
> ---------------------------------------------------------------------
> ===
> 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.
>
>
--
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
