(RADIATOR) 2.18.3 still has bugs ???
Hugh Irvine
hugh at open.com.au
Wed Sep 5 16:43:19 CDT 2001
Hello Pavel -
Radiator 2.18.3 was reissued several days ago - please download the new
distribution and reinstall.
We apologise for the inconvenience.
regards
Hugh
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.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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