(RADIATOR) 2.18.3 still has bugs ???

Fri Aug 31 05:49:14 CDT 2001

Hi,

I think Radiator 2.18.3 works incorrect with SessionDatabase SQL.
It seems it does not delete sessions after disconnect from RADONLINE.
As a result RADONLINE grows up and the logfile looks like below.
Version 2.18.2 works fine.

Was Mariano right? :)

*** Received from x.x.x.10 port 1026 ....
Code:       Accounting-Request
Identifier: 37
Authentic:  5<184><245>Q<148>Qj<187><15><221><251><3><173><196><206>9
Attributes:
        User-Name = "user1"
        NAS-IP-Address = x.x.x.10
        Ascend-Owner-IP-Addr = x.x.x.10
        NAS-Port = 34
        Ascend-NAS-Port-Format = 2_4_5_5
        NAS-Port-Type = Async
        Service-Type = Framed-User
        Acct-Status-Type = Start
        Acct-Delay-Time = 0
        Acct-Session-Id = "99833012"
        Acct-Authentic = RADIUS
        Ascend-Attr-28 = 2040
        Ascend-Multilink-ID = 1091175862
        Ascend-Num-In-Multilink = 1
        Acct-Link-Count = 1
        Acct-Multi-Session-Id = "410a05b6"
        Ascend-Modem-PortNo = 2
        Ascend-Modem-SlotNo = 7
        Called-Station-Id = "55555555"
        Framed-Protocol = MP
        Framed-IP-Address = y.y.y.162

Fri Aug 31 13:02:27 2001: DEBUG: Check if Handler  should be used to handle this request
Fri Aug 31 13:02:27 2001: DEBUG: Handling request with Handler ''
Fri Aug 31 13:02:27 2001: DEBUG: SessDB Adding session for user1, x.x.x.10, 34
Fri Aug 31 13:02:27 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='user1' and NASPORT=034

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', 'x.x.x.10', 034, '99833012', 999248547, 'y.y.y.162', 'Async', 'Framed-User')

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', '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)
Fri Aug 31 13:02:29 2001: DEBUG: Handling with Radius::AuthPLSQL
Fri Aug 31 13:02:29 2001: DEBUG: Handling accounting with Radius::AuthPLSQL
Fri Aug 31 13:02:29 2001: DEBUG: Entering checkDemo
Fri Aug 31 13:02:29 2001: DEBUG: Exiting checkDemo
Fri Aug 31 13:02:29 2001: DEBUG: Accounting accepted
Fri Aug 31 13:02:29 2001: DEBUG: Packet dump:
*** Sending to x.x.x.10 port 1026 ....
Code:       Accounting-Response
Identifier: 37
Authentic:  5<184><245>Q<148>Qj<187><15><221><251><3><173><196><206>9
Attributes:

...
[skip]
...

*** Received from x.x.x.10 port 1026 ....
Code:       Accounting-Request
Identifier: 48
Authentic:  <201><253><243><251>K<219><9><22><219>M<191><28>)<157>3<22>
Attributes:
        User-Name = "user2"
        NAS-IP-Address = x.x.x.10
        Ascend-Owner-IP-Addr = 0.0.0.0
        NAS-Port = 33
        Ascend-NAS-Port-Format = 2_4_5_5
        NAS-Port-Type = Async
        Service-Type = Framed-User
        Acct-Status-Type = Start
        Acct-Delay-Time = 0
        Acct-Session-Id = "99833018"
        Acct-Authentic = RADIUS
        Ascend-Attr-28 = 130
        Ascend-Modem-PortNo = 14
        Ascend-Modem-SlotNo = 7
        Called-Station-Id = "55555555"
        Framed-Protocol = PPP
        Framed-IP-Address = y.y.y.161

Fri Aug 31 13:08:06 2001: DEBUG: Check if Handler  should be used to handle this request
Fri Aug 31 13:08:06 2001: DEBUG: Handling request with Handler ''
Fri Aug 31 13:08:06 2001: DEBUG: SessDB Adding session for user2, x.x.x.10, 33
Fri Aug 31 13:08:06 2001: DEBUG: do query is: delete from RADONLINE where NASIDENTIFIER='user2' and NASPORT=033

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', 'x.x.x.10', 033, '99833018', 999248886, 'y.y.y.161', 'Async', 'Framed-User')

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', '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)
Fri Aug 31 13:08:07 2001: DEBUG: Handling with Radius::AuthPLSQL
Fri Aug 31 13:08:07 2001: DEBUG: Handling accounting with Radius::AuthPLSQL
Fri Aug 31 13:08:07 2001: DEBUG: Entering checkDemo
Fri Aug 31 13:08:07 2001: DEBUG: Exiting checkDemo
Fri Aug 31 13:08:07 2001: DEBUG: Accounting accepted
Fri Aug 31 13:08:07 2001: DEBUG: Packet dump:
*** Sending to x.x.x.10 port 1026 ....

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.