Duplicated records in RADACCT with differents delay times
Ok, thank you for your reply. We are going to study how to process the records that already exist in the table. Regards, Antonio.
Hi Arran, Could you tell me what is the reason why there are duplicated records in radacct? NAS's configuration mistakes? Why AcctUniqueId is not a UNIQUE INDEX by default? Is a bug? Could I have any problem after execute this alter into the radacct table? I hope your answer. Best regards, Antonio.
On 3 Jul 2013, at 15:50, Antonio Fernández Pérez <antoniofernandez@fabergames.com> wrote:
Hi Arran,
Could you tell me what is the reason why there are duplicated records in radacct? NAS's configuration mistakes? Why AcctUniqueId is not a UNIQUE INDEX by default? Is a bug?
Should of been UNIQUE INDEX by default, this is fixed in current SQL schema files.
Could I have any problem after execute this alter into the radacct table?
Nope, just adding the UNIQUE INDEX should fix it. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team
Hi everybody, Recently I posted a problem with accounting rows duplicated. Following Arran's advices I changed radacct table, defining AcctUniqueId column as a unique index. Solved it! Now, I have the same problem but, at this time with AcctSesionId column. There are a lot of rows that have different AcctUniqueId value with the same AcctSessionId (Is the same record, about the same user). Should I to define AcctSessionId as a unique index? AcctSessionId is generated by the NAS. Will be problematic to make this change in the table? Records have not delay. In AcctStartTime column the difference between both rows is 21 seconds. Any ideas? Thank you very much. Regards, Antonio.
participants (2)
-
Antonio Fernández Pérez -
Arran Cudbard-Bell