(RADIATOR) 2.18.3 still has bugs ???

Hugh Irvine hugh at open.com.au
Thu Sep 6 02:24:17 CDT 2001


Hello Pavel -

Sorry about that.

The log shown below shows the insert into the RADONLINE table failing because 
of a unique constraint violation on one of the indexes. You should check the 
index(s) and/or the AddQuery that you are using.

regards

Hugh


On Thursday 06 September 2001 16:44, Pavel A Crasotin wrote:
> 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

-- 
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