Thanks Omar for your input. I am trying here to rely on the automatic loading of the free radius into the Oracle database. The thing is that all the records including those with Acct-Delay-Time time with non zero values are loaded. The trigger on the accounting table fires all the times, I can tell not to fire for the records with Acct-Delay-Time time having non zero values,, but is this right to do ?
The manual loading is of course an option, again eliminating the records of Acct-Delay-Time time having non zero is there also. Yours Ayman -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Omar Farid Ibrahim Sent: Sunday, February 13, 2005 9:17 AM To: freeradius-users@lists.freeradius.org Subject: Re: Accounting and the Acct-Delay-Time Hi, Why don't you have a unique record based on session id or combination of fields (after all you are a DBA)? For the second Q No answer. Recommendation: use detail files and load manually to your database :))))) Best regards, Omar Ayman Alashquar wrote: > Hi all, > > I am accounting all vpdn connections using free radius against an Oracle > database. I am getting duplicate accounting records for the same session > with different Acct-Delay-Time time (0,5,10) : > > 1. What causes these duplicates and can they be avoided? > 2. When doing accounting, should I process the records with > Acct-Delay-Time=0 only? > > Many thanks > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html