Primary key in radacct table

[Alex French]

I use an index on acctuniqueid

along with

    acct_unique {
               key = "User-Name, Acct-Session-Id, NAS-IP-Address,
Client-IP-Address, NAS-Port-Id"
       }

It works fine for me.

Thanks,

Alex


2008/10/7 Marinko Tarlac <mangia81 at gmail.com>:
> acctuniqueid is not unique in default configuration. according to my
> experience, problem with duplicated session is very strange. My NAS (Mtik
> 2.9.x and Mtik 3.x) sends duplicated session ids but almost in the same
> time. For example one session is started now and the second one is
> transfered 1 second later.
>
> On Tue, Oct 7, 2008 at 8:54 AM, Santiago Balaguer García
> <santiagoawa at hotmail.com> wrote:
>>
>> I have a script to delete duplicate entries and stale session. But the
>> duplicate accounting records were created in real time, I have to create a
>> trigger in the database to detect these entries or activate a exec in
>> accounting module.
>>
>> Is the 'acctuniqueid'  attribute unique in all database in a default
>> freeradius configuration?
>>
>>
>>
>>
>> ________________________________
>> Date: Mon, 6 Oct 2008 17:53:32 +0200
>> From: mangia81 at gmail.com
>> To: freeradius-users at lists.freeradius.org
>> Subject: Re: Primary key in radacct table
>>
>>
>> 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
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>>
>> ________________________________
>> Ahora llévate lo mejor de MSN y Windows Live, en tu móvil
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>