Hello -
At least some of your problems are due to your database column
definitions.
See below - there is a database error when trying to insert the Stop
record.
.
Fri Jan 9 11:08:17 2004: DEBUG: Packet dump:
*** Received from 192.168192.2 port 21708
Code: Accounting-Request
Identifier: 91
Authentic: Q<170><247><2>p<16><8><193><227><16><174><130><162>b!J
Attributes:
Acct-Session-Id = "3238"
Acct-Terminate-Cause = User-Request
cisco-avpair = "disc-cause-ext=TS User Exit"
cisco-avpair = "connect-progress=Call Up"
Acct-Session-Time = 0
Acct-Status-Type = Stop
Cisco-NAS-Port = "tty125"
NAS-Port = 125
NAS-Port-Type = Virtual
Calling-Station-Id = "192.168192.10"
Service-Type = NAS-Prompt-User
NAS-IP-Address = 192.168192.2
Acct-Delay-Time = 0
Fri Jan 9 11:08:17 2004: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Fri Jan 9 11:08:17 2004: DEBUG: Deleting session for , 192.168192.2,
125
Fri Jan 9 11:08:17 2004: DEBUG: do query is: delete from
TblActiveSessions where PortNo='125' and LoginName = ''
Fri Jan 9 11:08:17 2004: DEBUG: Handling with Radius::AuthSQL
Fri Jan 9 11:08:17 2004: DEBUG: Handling accounting with
Radius::AuthSQL
Fri Jan 9 11:08:17 2004: DEBUG: do query is: insert into TblTransaction
(TimeClose, RecordType, SessionId, Duration, TerminationCause,
NASIPAddress, PortNo, CLI)
values
(to_date(' 9 01 2004 11:08:17', 'DD MM HH24:MI:SS'), 'Stop',
'3238', 0, 'User-Request', '192.168192.2', 125, '192.168192.10')
Fri Jan 9 11:08:17 2004: ERR: do failed for 'insert into TblTransaction
(TimeClose, RecordType, SessionId, Duration, TerminationCause,
NASIPAddress, PortNo, CLI)
values
(to_date(' 9 01 2004 11:08:17', 'DD MM HH24:MI:SS'), 'Stop',
'3238', 0, 'User-Request', '192.168192.2', 125, '192.168192.10')':
ORA-01401: inserted value too large for column (DBD ERROR:
OCIStmtExecute)
Fri Jan 9 11:08:17 2004: ERR: do failed for 'insert into TblTransaction
(TimeClose, RecordType, SessionId, Duration, TerminationCause,
NASIPAddress, PortNo, CLI)
values
(to_date(' 9 01 2004 11:08:17', 'DD MM HH24:MI:SS'), 'Stop',
'3238', 0, 'User-Request', '192.168192.2', 125, '192.168192.10')':
ORA-01401: inserted value too large for column (DBD ERROR:
OCIStmtExecute)
There are some additional problems due to the lack of the
Framed-IP-Address attribute in the accounting records, therefore the
AuthBy DYNADDRESS will not work properly.
And from what I can see in the debug, Radiator is indeed returning the
Session-Timeout attribute, so if the NAS is not dealing with it
properly it is a NAS configuration issue (assuming that the NAS knows
what to do with it). You will need to check with your NAS vendor to
find out how to correctly configure it.
regards
Hugh
On 09/01/2004, at 9:33 PM, Muhammad Talha wrote:
Thanks for your reply
i am attahing my cfg file as well trace 4 log file .
waiting for yr reply
Regards
./UW
- Original Message -
From: "Hugh Irvine" <[EMAIL PROTECTED]>
To: "unixware" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 09, 2004 2:35 PM
Subject: Re: (RADIATOR) User are not able to disconnect
Hello -
The only way we have of helping you is to look at your configuration
file (no secrets) together with a trace 4 debug from Radiator showing
what is happening. From what you are describing it sounds like the NAS
is not configured correctly.
regards
Hugh
On 09/01/2004, at 6:40 PM, unixware wrote:
Dear all
i have some problemregarding communication with Radius server and NAS
( Radiaotor 2.18 on Sun Solaris ) using Oracle 9.2.0 ,Cisco AS5300
NAS
i can see correct SessionTimeout is calculated in radius log. but
still users are not disconnected and their balance going in negative.
no stop record recieved by Radius .
RAS configuration is seem to be ok.
any help will greatly appreciated
Regards
./UW
NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email
