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 <[EMAIL PROTECTED]>
Reply-To: FreeRadius users mailing list
<freeradius-users@lists.freeradius.org>
To: FreeRadius users mailing list <freeradius-users@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: [EMAIL PROTECTED]
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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
