(RADIATOR) User are not able to disconnect

Hugh Irvine hugh at open.com.au
Sat Jan 10 00:15:41 CST 2004 

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 = "00003238"
	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 YYYY HH24:MI:SS'), 'Stop', 
'00003238', 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 YYYY HH24:MI:SS'), 'Stop', 
'00003238', 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 YYYY HH24:MI:SS'), 'Stop', 
'00003238', 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" <hugh at open.com.au>
> To: "unixware" <talha at worldcall.net.pk>
> Cc: <radiator at open.com.au>
> 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 radiator-announce at open.com.au
>> To unsubscribe, email 'majordomo at open.com.au' with
>> 'unsubscribe radiator' in the body of the message.
> <radius.cfg.txt><2004010911.log>

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