(RADIATOR) 2.18.3 still has bugs ???
Pavel A Crasotin
pavel at ctk.ru
Wed Sep 5 08:54:29 CDT 2001
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.
More information about the radiator
mailing list