Re: Accounting and the Acct-Delay-Time
Ayman Alashquar wrote: 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? Here are some that could be the cause: - the NAS is sending retry packets too fast - the radius server takes too long to process the packets and send an Ack back the to NAS - the network between the NAS and the radius server can't handle the load - bug in the NAS 2. When doing accounting, should I process the records with Acct-Delay-Time=0 only? I would say it doesn't really matter, as long as you have at least one of them, you have all necessary session data. -- Groeten, Regards, Salutations, Thor Spruyt M: +32 (0)475 67 22 65 E: [EMAIL PROTECTED] W: www.thor-spruyt.com www.salesguide.be www.telenethotspot.be - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Accounting and the Acct-Delay-Time
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
RE: Accounting and the Acct-Delay-Time
Thanks alot Spruyt So if I neglect the other records it would be a safe calculation for the usage ? Best -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Thor Spruyt Sent: Sunday, February 13, 2005 4:34 PM To: freeradius-users@lists.freeradius.org Subject: Re: Accounting and the Acct-Delay-Time Ayman Alashquar wrote: 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? Here are some that could be the cause: - the NAS is sending retry packets too fast - the radius server takes too long to process the packets and send an Ack back the to NAS - the network between the NAS and the radius server can't handle the load - bug in the NAS 2. When doing accounting, should I process the records with Acct-Delay-Time=0 only? I would say it doesn't really matter, as long as you have at least one of them, you have all necessary session data. -- Groeten, Regards, Salutations, Thor Spruyt M: +32 (0)475 67 22 65 E: [EMAIL PROTECTED] W: www.thor-spruyt.com www.salesguide.be www.telenethotspot.be - 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: Accounting and the Acct-Delay-Time
Ayman Alashquar wrote: So if I neglect the other records it would be a safe calculation for the usage ? No! If the first packet from the NAS doesn't make it to your server or can't be handled by your server, then you'll need the non-zero packets! -- Groeten, Regards, Salutations, Thor Spruyt M: +32 (0)475 67 22 65 E: [EMAIL PROTECTED] W: www.thor-spruyt.com www.salesguide.be www.telenethotspot.be - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Accounting and the Acct-Delay-Time
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
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 begin:vcard n:Ibrahim;Omar tel;cell:+971506626210 tel;fax:+97143359573 tel;home:+97143526373 tel;work:+97142025112 x-mozilla-html:FALSE org:Etisalat;IeS version:2.1 email;internet:[EMAIL PROTECTED] title:SE/IeS/SOM adr;quoted-printable:;;2nd floor, Zaabeel=0D=0AP.O.Box 1150;DXB;UAE;;UAE fn:Omar Ibrahim end:vcard