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 = "[EMAIL PROTECTED]" 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 [EMAIL PROTECTED], 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.