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
