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
pgpyzIw2sQxcd.pgp
Description: PGP signature
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
