(RADIATOR) SessionDatabaseSQL

[Hugh Irvine]

Hello Harrison -

Our example table layouts are meant to be starting points for you to  
extend in whatever way is suitable.

Feel free to alter/modify in whatever way works in your situation.

regards

Hugh


On 9 Mar 2004, at 18:02, Harrison Ng wrote:

> Hi,
>
> We want to use SessionDatabaseSQL for controlling multiple logon.
> But INSERT query failed:"Duplicate entry 'smartone-0' for key 1".
>
> From mailing list  
> http://www.open.com.au/archives/radiator/2003-07/msg00186.html
> Attribute NAS-Identifier and NAS-Port must unique.
>
> Here are my questions:
> 1) I don't understand why these two attributes are used for default  
> key,
>    even though we can define our own DeleteQuery,AddQuery,CountQuery.
>
> 2) Is it possible to release the 'unique' requirement
>
> 3) If the answer of (2) is not, how about using other attributes such  
> as Account-Session-Id or Framed-IP-Address
>
> Regards,
> Harrison
>
>
>
> Tue Mar  9 14:10:52 2004 377905: DEBUG: Handling request with Handler  
> 'Client-Id=/202.140.93.(11|12)/,Called-Station-Id=/(smartone)/,NAS-IP- 
> Address=10.32.16.1'
>
> Tue Mar  9 14:10:52 2004 382082: DEBUG: SessionDatabaseA Adding  
> session for , 10.32.16.1, 1
> Tue Mar  9 14:10:52 2004 383821: DEBUG: do query is: 'delete from  
> RADONLINE where NASIDENTIFIER='smartone' and  
> ACCTSESSIONID='00000002543992' and FRAMEDIPADDRESS='10.32.20.157'':
>
>  Tue Mar  9 14:10:52 2004 386700: DEBUG: do query is: 'insert into  
> RADONLINE (USERNAME,CALLINGSTATIONID,NASIDENTIFIER,  
> ACCTSESSIONID,FRAMEDIPADDRESS,TIME_STAMP) values  
> ('','85291399096','smartone',  
> '00000002543992',1078812652,'10.32.20.157')':
>
>  Tue Mar  9 14:10:52 2004 388700: ERR: do failed for 'insert into  
> RADONLINE (USERNAME,CALLINGSTATIONID,NASIDENTIFIER,  
> ACCTSESSIONID,FRAMEDIPADDRESS,TIME_STAMP) values  
> ('','85291399096','smartone',  
> '00000002543992',1078812652,'10.32.20.157')': Duplicate entry  
> 'smartone-0' for key 1
>
> Tue Mar  9 14:10:52 2004 389810: DEBUG: Handling with  
> Radius::AuthFILE: defaultaccept
> Tue Mar  9 14:10:52 2004 390911: DEBUG: Accounting accepted
> <InterScan_Disclaimer.txt>

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.