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 <[EMAIL PROTECTED]>: > 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 > <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] >> To: freeradius-users@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 >> <[EMAIL PROTECTED]> 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 > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html