(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