<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>I work with Mtik too, and I have the same problem with duplicate sessions.<BR>
I am going to try Alex's solution. <BR>
Thanks!!!<BR><BR><BR><BR><BR>
<HR id=stopSpelling>
<BR>
> Date: Wed, 8 Oct 2008 10:46:43 +0100<BR>> From: alex@evilal.com<BR>> To: freeradius-users@lists.freeradius.org<BR>> Subject: Re: Primary key in radacct table<BR>> <BR>> I use an index on acctuniqueid<BR>> <BR>> along with<BR>> <BR>> acct_unique {<BR>> key = "User-Name, Acct-Session-Id, NAS-IP-Address,<BR>> Client-IP-Address, NAS-Port-Id"<BR>> }<BR>> <BR>> It works fine for me.<BR>> <BR>> Thanks,<BR>> <BR>> Alex<BR>> <BR>> <BR>> 2008/10/7 Marinko Tarlac <mangia81@gmail.com>:<BR>> > acctuniqueid is not unique in default configuration. according to my<BR>> > experience, problem with duplicated session is very strange. My NAS (Mtik<BR>> > 2.9.x and Mtik 3.x) sends duplicated session ids but almost in the same<BR>> > time. For example one session is started now and the second one is<BR>> > transfered 1 second later.<BR>> ><BR>> > On Tue, Oct 7, 2008 at 8:54 AM, Santiago Balaguer García<BR>> > <santiagoawa@hotmail.com> wrote:<BR>> >><BR>> >> I have a script to delete duplicate entries and stale session. But the<BR>> >> duplicate accounting records were created in real time, I have to create a<BR>> >> trigger in the database to detect these entries or activate a exec in<BR>> >> accounting module.<BR>> >><BR>> >> Is the 'acctuniqueid' attribute unique in all database in a default<BR>> >> freeradius configuration?<BR>> >><BR>> >><BR>> >><BR>> >><BR>> >> ________________________________<BR>> >> Date: Mon, 6 Oct 2008 17:53:32 +0200<BR>> >> From: mangia81@gmail.com<BR>> >> To: freeradius-users@lists.freeradius.org<BR>> >> Subject: Re: Primary key in radacct table<BR>> >><BR>> >><BR>> >> You can do it and it will solve your problem but it can create small<BR>> >> overhead because radius tries to write into database and it will be<BR>> >> rejected. you will see this in your log files.<BR>> >><BR>> >> Another idea is to change NAS or you can create cron script to delete<BR>> >> duplicated entries.<BR>> >><BR>> >> MT<BR>> >><BR>> >> On Mon, Oct 6, 2008 at 5:35 PM, Santiago Balaguer García<BR>> >> <santiagoawa@hotmail.com> wrote:<BR>> >><BR>> >> Hi,<BR>> >><BR>> >> I am using a freeradius 1.1.7 + postgres since 3 years ago. The AAA<BR>> >> service works fine, however my radacct table has sonetimes duplicate<BR>> >> registers.<BR>> >> I realize that it happens when a NAS does not have a realiable Internet<BR>> >> conection, so NAS send the accounting packets several times.<BR>> >><BR>> >> My radacct table has 'radacctid' as primary key. I realize that two (or<BR>> >> more) duplicate registers share 'acctsessionid' and 'acctuniqueid' fields<BR>> >> amog others.<BR>> >> I know 'acctsessionid' field can be the same in diferent NASes.<BR>> >> Would be a good idea change the primery key by 'acctuniqueid' ?<BR>> >><BR>> >> Santiago<BR>> >><BR>> >> ________________________________<BR>> >> La cartera, las gafas. ¿te falta algo? Ahora llévate Messenger en tu móvil<BR>> >> -<BR>> >> List info/subscribe/unsubscribe? See<BR>> >> http://www.freeradius.org/list/users.html<BR>> >><BR>> >><BR>> >> ________________________________<BR>> >> Ahora llévate lo mejor de MSN y Windows Live, en tu móvil<BR>> >> -<BR>> >> List info/subscribe/unsubscribe? See<BR>> >> http://www.freeradius.org/list/users.html<BR>> ><BR>> ><BR>> > -<BR>> > List info/subscribe/unsubscribe? See<BR>> > http://www.freeradius.org/list/users.html<BR>> ><BR>> <BR>> -<BR>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html<BR><BR><br /><hr />La cartera, las gafas. ¿te falta algo? <a href='http://www.vivelive.com/abecedario' target='_new'>Ahora llévate Messenger en tu móvil</a></body>
</html>