Primary key in radacct table

[Marinko Tarlac]

You can do it and it will solve your problem but it can create small
overhead because radius tries to write into database and it will be
rejected. you will see this in your log files.

Another idea is to change NAS or you can create cron script to delete
duplicated entries.

MT

On Mon, Oct 6, 2008 at 5:35 PM, Santiago Balaguer García <
santiagoawa at hotmail.com> wrote:

> Hi,
>
>    I am using a freeradius 1.1.7 + postgres since 3 years ago. The AAA
> service works fine, however my radacct table has sonetimes duplicate
> registers.
> I realize that it happens when a NAS does not have a realiable Internet
> conection, so NAS send the accounting packets several times.
>
>   My radacct table has 'radacctid' as primary key. I realize that two (or
> more) duplicate registers share  'acctsessionid' and 'acctuniqueid' fields
> amog others.
> I know  'acctsessionid' field can be the same in diferent NASes.
> Would be a good idea change the primery key by 'acctuniqueid' ?
>
>      Santiago
>
> ------------------------------
> La cartera, las gafas. ¿te falta algo? Ahora llévate Messenger en tu móvil<http://www.vivelive.com/abecedario>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20081006/52555bce/attachment.html>