Duplicate requests in a session

[Peter Nixon]

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 <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_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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-devel/attachments/20060831/63cbab22/attachment.pgp>