(RADIATOR) 2.18.3 still has bugs ???
Pavel A Crasotin
pavel at ctk.ru
Thu Sep 6 01:44:31 CDT 2001
Hello Hugh,
I've tried the last release of 2.18.3, Aug 30, 2001, size - 1900500
bites.
HI> Hello Pavel -
HI> Radiator 2.18.3 was reissued several days ago - please download the new
HI> distribution and reinstall.
HI> We apologise for the inconvenience.
HI> regards
HI> Hugh
HI> On Wednesday 05 September 2001 23:54, Pavel A Crasotin wrote:
>> Hi,
>>
>> I still cannot use Radiator 2.18.3 because it works incorrect with
>> SessionDatabase SQL I think.
>>
>> Is anyone else who faced such problem?
>> How correct it?
>>
>> Any comments or thoughts?
>>
>> PAC> Hi,
>>
>> PAC> I think Radiator 2.18.3 works incorrect with SessionDatabase SQL.
>> PAC> It seems it does not delete sessions after disconnect from RADONLINE.
>> PAC> As a result RADONLINE grows up and the logfile looks like below.
>> PAC> Version 2.18.2 works fine.
>>
>> PAC> Was Mariano right? :)
>>
>> PAC> *** Received from x.x.x.10 port 1026 ....
>> PAC> Code: Accounting-Request
>> PAC> Identifier: 37
>> PAC> Authentic: 5<184><245>Q<148>Qj<187><15><221><251><3><173><196><206>9
>> PAC> Attributes:
>> PAC> User-Name = "user1"
>> PAC> NAS-IP-Address = x.x.x.10
>> PAC> Ascend-Owner-IP-Addr = x.x.x.10
>> PAC> NAS-Port = 34
>> PAC> Ascend-NAS-Port-Format = 2_4_5_5
>> PAC> NAS-Port-Type = Async
>> PAC> Service-Type = Framed-User
>> PAC> Acct-Status-Type = Start
>> PAC> Acct-Delay-Time = 0
>> PAC> Acct-Session-Id = "99833012"
>> PAC> Acct-Authentic = RADIUS
>> PAC> Ascend-Attr-28 = 2040
>> PAC> Ascend-Multilink-ID = 1091175862
>> PAC> Ascend-Num-In-Multilink = 1
>> PAC> Acct-Link-Count = 1
>> PAC> Acct-Multi-Session-Id = "410a05b6"
>> PAC> Ascend-Modem-PortNo = 2
>> PAC> Ascend-Modem-SlotNo = 7
>> PAC> Called-Station-Id = "55555555"
>> PAC> Framed-Protocol = MP
>> PAC> Framed-IP-Address = y.y.y.162
>>
>> PAC> Fri Aug 31 13:02:27 2001: DEBUG: Check if Handler should be used to
>> handle this request PAC> Fri Aug 31 13:02:27 2001: DEBUG: Handling request
>> with Handler '' PAC> Fri Aug 31 13:02:27 2001: DEBUG: SessDB Adding session
>> for user1, x.x.x.10, 34 PAC> Fri Aug 31 13:02:27 2001: DEBUG: do query is:
>> delete from RADONLINE where NASIDENTIFIER='user1' and NASPORT=034
>>
>> PAC> Fri Aug 31 13:02:27 2001: DEBUG: do query is: insert into RADONLINE
>> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
>> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('user1', PAC>
>> 'x.x.x.10', 034, '99833012', 999248547, 'y.y.y.162', 'Async',
>> 'Framed-User')
>>
>> PAC> Fri Aug 31 13:02:29 2001: ERR: do failed for 'insert into RADONLINE
>> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
>> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('user1', PAC>
>> 'x.x.x.10', 034, '99833012', 999248547, 'y.y.y.162', 'Async',
>> 'Framed-User')': ORA-00001: unique constraint (RADIUS.RADONLINE_I) violated
>> (DBD ERROR: OCIStmtExecute) PAC> Fri Aug 31 13:02:29 2001: DEBUG: Handling
>> with Radius::AuthPLSQL PAC> Fri Aug 31 13:02:29 2001: DEBUG: Handling
>> accounting with Radius::AuthPLSQL PAC> Fri Aug 31 13:02:29 2001: DEBUG:
>> Entering checkDemo
>> PAC> Fri Aug 31 13:02:29 2001: DEBUG: Exiting checkDemo
>> PAC> Fri Aug 31 13:02:29 2001: DEBUG: Accounting accepted
>> PAC> Fri Aug 31 13:02:29 2001: DEBUG: Packet dump:
>> PAC> *** Sending to x.x.x.10 port 1026 ....
>> PAC> Code: Accounting-Response
>> PAC> Identifier: 37
>> PAC> Authentic: 5<184><245>Q<148>Qj<187><15><221><251><3><173><196><206>9
>> PAC> Attributes:
>>
>> PAC> ...
>> PAC> [skip]
>> PAC> ...
>>
>> PAC> *** Received from x.x.x.10 port 1026 ....
>> PAC> Code: Accounting-Request
>> PAC> Identifier: 48
>> PAC> Authentic:
>> <201><253><243><251>K<219><9><22><219>M<191><28>)<157>3<22> PAC>
>> Attributes:
>> PAC> User-Name = "user2"
>> PAC> NAS-IP-Address = x.x.x.10
>> PAC> Ascend-Owner-IP-Addr = 0.0.0.0
>> PAC> NAS-Port = 33
>> PAC> Ascend-NAS-Port-Format = 2_4_5_5
>> PAC> NAS-Port-Type = Async
>> PAC> Service-Type = Framed-User
>> PAC> Acct-Status-Type = Start
>> PAC> Acct-Delay-Time = 0
>> PAC> Acct-Session-Id = "99833018"
>> PAC> Acct-Authentic = RADIUS
>> PAC> Ascend-Attr-28 = 130
>> PAC> Ascend-Modem-PortNo = 14
>> PAC> Ascend-Modem-SlotNo = 7
>> PAC> Called-Station-Id = "55555555"
>> PAC> Framed-Protocol = PPP
>> PAC> Framed-IP-Address = y.y.y.161
>>
>> PAC> Fri Aug 31 13:08:06 2001: DEBUG: Check if Handler should be used to
>> handle this request PAC> Fri Aug 31 13:08:06 2001: DEBUG: Handling request
>> with Handler '' PAC> Fri Aug 31 13:08:06 2001: DEBUG: SessDB Adding session
>> for user2, x.x.x.10, 33 PAC> Fri Aug 31 13:08:06 2001: DEBUG: do query is:
>> delete from RADONLINE where NASIDENTIFIER='user2' and NASPORT=033
>>
>> PAC> Fri Aug 31 13:08:06 2001: DEBUG: do query is: insert into RADONLINE
>> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
>> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('user2', PAC>
>> 'x.x.x.10', 033, '99833018', 999248886, 'y.y.y.161', 'Async',
>> 'Framed-User')
>>
>> PAC> Fri Aug 31 13:08:07 2001: ERR: do failed for 'insert into RADONLINE
>> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
>> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('user2', PAC>
>> 'x.x.x.10', 033, '99833018', 999248886, 'y.y.y.161', 'Async',
>> 'Framed-User')': ORA-00001: unique constraint (RADIUS.RADONLINE_I) violated
>> (DBD ERROR: OCIStmtExecute) PAC> Fri Aug 31 13:08:07 2001: DEBUG: Handling
>> with Radius::AuthPLSQL PAC> Fri Aug 31 13:08:07 2001: DEBUG: Handling
>> accounting with Radius::AuthPLSQL PAC> Fri Aug 31 13:08:07 2001: DEBUG:
>> Entering checkDemo
>> PAC> Fri Aug 31 13:08:07 2001: DEBUG: Exiting checkDemo
>> PAC> Fri Aug 31 13:08:07 2001: DEBUG: Accounting accepted
>> PAC> Fri Aug 31 13:08:07 2001: DEBUG: Packet dump:
>> PAC> *** Sending to x.x.x.10 port 1026 ....
>>
>>
>> PAC> With respect,
>> PAC> Pavel A Crasotin
>> PAC> ____________________________________
>> PAC> OJSC SeverTransCom
>> PAC> 40/13 Sobinova, Yaroslavl, 150000, Russia
>> PAC> Tel/Fax: +7 (0852) 47-71-70, 47-69-49
>> PAC> +7 (0852) 72-17-28, 72-17-38
>>
>> PAC> ===
>> PAC> Archive at http://www.open.com.au/archives/radiator/
>> PAC> Announcements on radiator-announce at open.com.au
>> PAC> To unsubscribe, email 'majordomo at open.com.au' with
>> PAC> 'unsubscribe radiator' in the body of the message.
>>
>>
>> With respect,
>> Pavel A Crasotin
>> ____________________________________
>> OJSC SeverTransCom
>> 40/13 Sobinova, Yaroslavl, 150000, Russia
>> Tel/Fax: +7 (0852) 47-71-70, 47-69-49
>> +7 (0852) 72-17-28, 72-17-38
>>
>> ===
>> 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.
With respect,
Pavel A Crasotin
____________________________________
OJSC SeverTransCom
40/13 Sobinova, Yaroslavl, 150000, Russia
Tel/Fax: +7 (0852) 47-71-70, 47-69-49
+7 (0852) 72-17-28, 72-17-38
===
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.
More information about the radiator
mailing list