RE: Primary key in radacct table

[Santiago Balaguer García]

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: [EMAIL PROTECTED]> 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 <[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
_
Llega la nueva temporada. Consulta las nuevas tendencias en MSN Estilo
http://estilo.es.msn.com/moda/-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: 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 <[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

Re: Primary key in radacct table

[Marinko Tarlac]

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<http://www.vivelive.com/abecedario>
>
> -
> 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<http://serviciosmoviles.es.msn.com/>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: Primary key in radacct table

[Santiago Balaguer García]

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 +0200From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: 
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
_
¿Sigue el calor? Consulta MSN El tiempo
http://eltiempo.es.msn.com/-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

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