Hi guys, As far as I can see from 1.1.7, this was never rolled into the code. Can I suggest simply adding an index like this by default:
ALTER TABLE radacct ADD constraint radacct_unique_session UNIQUE ( acctuniqueid); Then the composition of acctuniqueid can still be set in the unique id module as appropriate for the site in question? Alex On 31/08/06, Peter Nixon <[EMAIL PROTECTED]> wrote: > Good question. Does anyone have anything against changing this? > > -Peter > > On Thu 31 Aug 2006 10:11, Santiago Balaguer García wrote: > > 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_proteccionin > >fantil > > > > - > > List info/subscribe/unsubscribe? See > > http://www.freeradius.org/list/users.html > > -- > > Peter Nixon > http://www.peternixon.net/ > PGP Key: http://www.peternixon.net/public.asc > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html