Re: (RADIATOR) RADONLINE Table ?

Hugh Irvine Tue, 03 Jul 2001 00:59:02 -0700

Title: Re: (RADIATOR) RADONLINE Table ?

Hello Chairarth -

The problem you describe below is due to the NAS not sending the NAS-Port attribute in the accounting stop record.

There are two things you can do. First, you should lodge a bug report with your NAS vendor and get the problem fixed properly. Second, you can try adding a Class attribute in the access accept and verify the resulting trace 4 to make sure that the Class attribute is properly contained in both the accounting start and the accounting stop. If it is present, you can write a PreClientHook to copy the Class attribute into the NAS-Port attribute and fix the problem that way.

Here is how to add the Class attribute:

......

AddToReply Class = %{NAS-Port}

</AuthBy>

Please send me the resulting trace 4 and if the Class attribute is in both the accounting start and the accounting stop I will send you a PreClientHook to do the job (I have done this for another client already).

regards

Hugh

At 14:24 +0700 01/7/3, chairarth wrote:

Hi,

I'm facing problem about RADONLINE Table. I found that even if I 've already log out but the Current Sessions Widnows at RADMIN still show it . So I try to look at logfile to see what happen , and then I wonder that after Radiator received Accouning-request type Stop (from NASPORT 49153) why Radiator do query delete RADONLINE where NASPORT=0 .

How can I fix it ?

Thanks in advance!

Chairath

------------------------- LOG FILE ------------------------
*** Received from 10.2.0.1 port 49152 ....
Code: Access-Request
Identifier: 46
Authentic: <0><0>X<234><0><0>B<137><0><0>+<186><0><0>%<177>
Attributes:
User-Name = "alan"
User-Password = "<150><128><12><217><137><223><150>g<139>p<193><237><136><182>n<150>"
Acct-Session-Id = "5600cde1"
NAS-IP-Address = 10.10.0.2
Shasta-SGROUP = "Shasta 5000: iSOS (tm), 2.1(17)"
Service-Type = Framed-User
Framed-Protocol = PPP
Calling-Station-Id = "ldc_12200000069"
NAS-Port = 1644167237

Tue Jul 3 10:24:11 2001: DEBUG: Check if Handler Request-Type=Accounting-Request should be used to handle this request
Tue Jul 3 10:24:11 2001: DEBUG: Check if Handler Realm=radius should be used to handle this request
Tue Jul 3 10:24:11 2001: DEBUG: Check if Handler should be used to handle this request
Tue Jul 3 10:24:11 2001: DEBUG: Handling request with Handler ''
Tue Jul 3 10:24:11 2001: DEBUG: Deleting session for alan, 10.10.0.2, 1644167237
Tue Jul 3 10:24:11 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='10.10.0.2' and NASPORT=01644167237

Tue Jul 3 10:24:11 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (994130651, 4, 'Handling with Radius::AuthRADMIN')

Tue Jul 3 10:24:11 2001: DEBUG: Query is: select PASS_WORD, STATICADDRESS, TIMELEFT, MAXLOGINS from RADUSERS where USERNAME='alan' and BADLOGINS < 5 and VALIDFROM < 994130651 and VALIDTO > 994130651

Tue Jul 3 10:24:11 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (994130651, 4, 'Radius::AuthRADMIN looks for match with alan')

Tue Jul 3 10:24:11 2001: DEBUG: Query is: select NASIDENTIFIER, NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where USERNAME='alan'

Tue Jul 3 10:24:11 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (994130651, 4, 'Radius::AuthRADMIN ACCEPT: ')

Tue Jul 3 10:24:11 2001: DEBUG: do query is: update RADUSERS set BADLOGINS=0 where USERNAME='alan'

Tue Jul 3 10:24:11 2001: DEBUG: Access accepted for alan
Tue Jul 3 10:24:11 2001: DEBUG: Packet dump:
*** Sending to 10.2.0.1 port 49152 ....
Code: Access-Accept
Identifier: 46
Authentic: <0><0>X<234><0><0>B<137><0><0>+<186><0><0>%<177>
Attributes:
Session-Timeout = 289
Framed-Protocol = PPP

Service-Type = Framed-User
Framed-IP-Netmask = 255.255.255.255
Framed-Routing = None
Framed-MTU = 1500
Framed-Compression = Van-Jacobson-TCP-IP
Idle-Timeout = 600

Tue Jul 3 10:24:14 2001: DEBUG: Packet dump:
*** Received from 10.2.0.1 port 49153 ....
Code: Accounting-Request
Identifier: 30
Authentic: 4<143><194><161>y;<9><206>W<141>IJO<207><209><203>
Attributes:
Acct-Status-Type = Start
User-Name = "alan"
Shasta-SGROUP = "Shasta 5000: iSOS (tm), 2.1(17)"
Event-Timestamp = 994155664
Service-Type = Framed-User
NAS-IP-Address = 10.10.0.2
NAS-Port = 1644167237
Acct-Session-Id = "5600cde1"
Acct-Authentic = RADIUS
Framed-IP-Address = 10.10.64.26
Framed-IP-Netmask = 255.255.255.255
Calling-Station-Id = "ldc_12200000069"

Tue Jul 3 10:24:14 2001: DEBUG: Check if Handler Request-Type=Accounting-Request should be used to handle this request
Tue Jul 3 10:24:14 2001: DEBUG: Handling request with Handler 'Request-Type=Accounting-Request'
Tue Jul 3 10:24:14 2001: DEBUG: Adding session for alan, 10.10.0.2, 1644167237
Tue Jul 3 10:24:14 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='10.10.0.2' and NASPORT=01644167237

Tue Jul 3 10:24:14 2001: DEBUG: do query is: insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('alan', '10.10.0.2', 01644167237, '5600cde1', 994130654, '10.10.64.26', '', 'Framed-User')

Tue Jul 3 10:24:14 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (994130654, 4, 'Handling with Radius::AuthRADMIN')

Tue Jul 3 10:24:14 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (994130654, 4, 'Handling accounting with Radius::AuthRADMIN')

Tue Jul 3 10:24:14 2001: DEBUG: do query is: update RADUSERS set TIMELEFT=TIMELEFT-0, OCTETSINLEFT=OCTETSINLEFT-0, OCTETSOUTLEFT=OCTETSOUTLEFT-0 where USERNAME='alan'

Tue Jul 3 10:24:14 2001: DEBUG: do query is: insert into RADUSAGE
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTSESSIONID, FRAMEDIPADDRESS, NASIDENTIFIER, NASPORT, DATE)
values
('alan', 994130654, 1, '5600cde1', '10.10.64.26', '10.10.0.2', 1644167237, ' 3 07 2001 10:24:14')

Tue Jul 3 10:24:14 2001: DEBUG: Accounting accepted
Tue Jul 3 10:24:14 2001: DEBUG: Packet dump:
*** Sending to 10.2.0.1 port 49153 ....
Code: Accounting-Response
Identifier: 30
Authentic: 4<143><194><161>y;<9><206>W<141>IJO<207><209><203>
Attributes:

Tue Jul 3 10:27:00 2001: DEBUG: Packet dump:
*** Received from 10.2.0.1 port 49153 ....
Code: Accounting-Request
Identifier: 31
Authentic: <160>r<248><134><4>|<143>,a<255><151><217>s<243>6'
Attributes:
Acct-Status-Type = Stop
User-Name = "alan"
Shasta-SGROUP = "Shasta 5000: iSOS (tm), 2.1(17)"
Event-Timestamp = 994155829
Service-Type = Framed-User
NAS-IP-Address = 10.10.0.2
Acct-Session-Id = "5600cde1"
Acct-Authentic = RADIUS
Framed-IP-Address = 10.10.64.26
Framed-IP-Netmask = 255.255.255.255
Calling-Station-Id = "ldc_12200000069"
Acct-Input-Octets = 4320
Acct-Output-Octets = 1176
Acct-Input-Packets = 34
Acct-Output-Packets = 21
Acct-Terminate-Cause = User-Request
Acct-Session-Time = 165

Tue Jul 3 10:27:00 2001: DEBUG: Check if Handler Request-Type=Accounting-Request should be used to handle this request
Tue Jul 3 10:27:00 2001: DEBUG: Handling request with Handler 'Request-Type=Accounting-Request'
Tue Jul 3 10:27:00 2001: DEBUG: Deleting session for alan, 10.10.0.2,
Tue Jul 3 10:27:00 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='10.10.0.2' and NASPORT=0

Tue Jul 3 10:27:00 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (994130820, 4, 'Handling with Radius::AuthRADMIN')

Tue Jul 3 10:27:00 2001: DEBUG: do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (994130820, 4, 'Handling accounting with Radius::AuthRADMIN')

Tue Jul 3 10:27:00 2001: DEBUG: do query is: update RADUSERS set TIMELEFT=TIMELEFT-0165, OCTETSINLEFT=OCTETSINLEFT-04320, OCTETSOUTLEFT=OCTETSOUTLEFT-01176 where USERNAME='alan'

Tue Jul 3 10:27:00 2001: DEBUG: do query is: insert into RADUSAGE
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, ACCTTERMINATECAUSE, FRAMEDIPADDRESS, NASIDENTIFIER, DATE)
values
('alan', 994130820, 2, 4320, 1176, '5600cde1', 165, 1, '10.10.64.26', '10.10.0.2', ' 3 07 2001 10:27:00')

Tue Jul 3 10:27:00 2001: DEBUG: Accounting accepted
Tue Jul 3 10:27:00 2001: DEBUG: Packet dump:
*** Sending to 10.2.0.1 port 49153 ....
Code: Accounting-Response
Identifier: 31
Authentic: <160>r<248><134><4>|<143>,a<255><151><217>s<243>6'
Attributes:

--

NB: I am travelling this week, so there may be delays in our correspondence.

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.

Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.

Re: (RADIATOR) RADONLINE Table ?

Reply via email to