I work with Mtik too, and I have the same problem with duplicate sessions.
I am going to try Alex's solution.
Thanks!!!

---

> Date: Wed, 8 Oct 2008 10:46:43 +0100
> From: alex@evilal.com
> To: freeradius-users@lists.freeradius.org
> Subject: Re: Primary key in radacct table
>
> 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@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@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@gmail.com
> >> 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
> >> <santiagoawa@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
> >
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

---

La cartera, las gafas. ¿te falta algo? Ahora llévate Messenger en tu móvil