(RADIATOR) ClearNasQuery

[daniel.teran at es.jazztel.com]

Hi all,

I saw this behaviour yesterday: an Accounting-Start packet arrives with Id
='00000000'.
First, SessionDatabase-SQL SDB1 deletes session (NAS-IP-Address,
Acct-Session-Id). OK as usual.
Then inserts the new session. OK. Finally, ClearNasQuery is executed and
deletes all the sessions
of that NAS, so new session doesn't appear on RADONLINE.

I wonder:

- criterion for ClearNasQuery to be executed (how NAS reboot is detected).
- sequence: ClearNasQuery first, then add session to radonline?

Tue Oct 23 13:26:29 2001: DEBUG: Packet dump:
*** Received from 192.168.116.64 port 32773 ....
Code:       Accounting-Request
Identifier: 94
Authentic:  <198><193>RTz<241>D<192><165>1<239><201><239><179><27>O
Attributes:
        NAS-IP-Address = w.x.y.z
        Acct-Status-Type = Start
        Acct-Session-Id = "00000000"
        NAS-Port-Type = Sync
        Calling-Station-Id = "91......."
        Called-Station-Id = "91......."
        Connect-Info = "<0><0><250>"
        NAS-Port = 0
        Acct-Authentic = RADIUS
        User-Name = "mlppp at lan.cli2vpn01"
        Acct-Multi-Session-Id = "40F90207"
        Acct-Link-Count = 1
        Timestamp = 1003835834
        Acct-Delay-Time = 0

Tue Oct 23 13:26:29 2001: DEBUG: Check if Handler ............. should be used to handle this request
Tue Oct 23 13:26:29 2001: DEBUG: Handling request with Handler ............
Tue Oct 23 13:26:29 2001: DEBUG: SDB1 Adding session for mlppp at lan.cli2vpn01, w.x.y.z, 0
Tue Oct 23 13:26:29 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='w.x.y.z' and ACCTSESSIONID='00000000'

Tue Oct 23 13:26:29 2001: DEBUG: do query is: insert into RADONLINE (...)

Tue Oct 23 13:26:29 2001: DEBUG: SDB1 Deleting all sessions for 62.14.16.25
Tue Oct 23 13:26:29 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='w.x.y.z'
......
Tue Oct 23 13:26:29 2001: DEBUG: Accounting accepted


This is my <SessionDatabase SQL> definition:

<SessionDatabase SQL>
  AddQuery insert into RADONLINE (...) values (...)
  ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
  CountNasSessionsQuery select ACCTSESSIONID from RADONLINE where NASIDENTIFIER='%N'
  CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE where USERNAME='%n'
  DeleteQuery delete from RADONLINE where NASIDENTIFIER='%N' and ACCTSESSIONID='%{Acct-Session-Id}'
  DBAuth ...
  DBSource dbi:Oracle:...
  DBUsername ...
  FailureBackoffTime 10
  Identifier SDB1
  Timeout 30
</SessionDatabase>

Thanks,
Daniel Terán.

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