Duplicate requests in a session

Santiago Balaguer García santiagoawa at hotmail.com
Thu Aug 31 09:11:58 CEST 2006


Thanks James, I don't figure out to use primary key solves the problem of 
duplicate keys.
I had in radacct as primary key <<radacctid>> but now I am going to have 
<<acctuniqueid>>.

This proble cause a new thread: why radacctid is the primary key of radacct 
table instead od acctuniqueid?


>From: James Wakefield <jamesw at deakin.edu.au>
>Reply-To: FreeRadius users mailing list 
><freeradius-users at lists.freeradius.org>
>To: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
>Subject: Re: Duplicate requests in a session
>Date: Wed, 30 Aug 2006 22:07:09 +1000
>
>Santiago Balaguer García wrote:
>>Hi people,
>>
>>1)
>>  In my activity I realize that when the conexion to Internet of a NAS is 
>>NOT good (there are some reday in the DSL), the NAS send several Start 
>>requests. My problen is my RADIUS server ask for all these requests and 
>>they are inserted in my DB. So, when the user or the NAS finalize the 
>>session and NAS sends Stop Request, the credit associates to the user 
>>account is decremented several times. It happens so because I put a trgger 
>>in my DB to decrement the user credit atomatically.
>>
>>  Can I avoid the problem of inserting several times the start request?
>>  If it is so, how??
>>
>>2) Is it supposed that the value of acctsessionid and acctuniqueid in 
>>radacct table  are UNIQUE and they can not be duplicated ?
>>
>>Thanks,
>>                        Santiago
>
>Hi Santiago,
>
>Does your DBMS enforce primary key constraints?  Do you have a primary key 
>defined for your radacct table? If I recall correctly, MySQL by default 
>doesn't, are you using MySQL?
>
>Cheers,
>--
>James Wakefield,
>Unix Administrator, Information Technology Services Division
>Deakin University, Geelong, Victoria 3217 Australia.
>
>Phone: 03 5227 8690 International: +61 3 5227 8690
>Fax:   03 5227 8866 International: +61 3 5227 8866
>E-mail:   james.wakefield at deakin.edu.au
>Website:  http://www.deakin.edu.au
>- List info/subscribe/unsubscribe? See 
>http://www.freeradius.org/list/users.html

_________________________________________________________________
Acepta el reto MSN Premium: Protección para tus hijos en internet. 
Descárgalo y pruébalo 2 meses gratis. 
http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil




More information about the Freeradius-Users mailing list