Duplicated records in RADACCT with differents delay times
Hi everybody, I have a problema with my FreeRADIUS accounting. I have detected that there are a lot of records duplicated but with different AcctStartDelay and AcctStopDelay. In raddact table appears for the same user more than one use when should appear only one. AN EXAMPLE =========================================================== INSERT INTO `radacct` (`RadAcctId`, `AcctSessionId`, `AcctUniqueId`, `UserName`, `Realm`, `NASIPAddress`, `NASPortId`, `NASPortType`, `AcctStartTime`, `AcctStopTime`, `AcctSessionTime`, `AcctAuthentic`, `ConnectInfo_start`, `ConnectInfo_stop`, `AcctInputOctets`, `AcctOutputOctets`, `CalledStationId`, `CallingStationId`, `AcctTerminateCause`, `ServiceType`, `FramedProtocol`, `FramedIPAddress`, `AcctStartDelay`, `AcctStopDelay`, `XAscendSessionSvrKey`) VALUES (3970329, '80d0090b', '28e7b4a55f1dead8', 'ni334ROHUH', '', '192.168.1.102', '2161117451', 'Wireless-802.11', '2013-02-05 20:14:42', '2013-02-05 20:39:23', 1481, '', '', '', 1443428, 3321047, 'aptrevoli', 'E0:B9:BA:DB:B4:E4', 'Lost-Service', '', '', '172.21.0.31', 4, 4, ''); INSERT INTO `radacct` (`RadAcctId`, `AcctSessionId`, `AcctUniqueId`, `UserName`, `Realm`, `NASIPAddress`, `NASPortId`, `NASPortType`, `AcctStartTime`, `AcctStopTime`, `AcctSessionTime`, `AcctAuthentic`, `ConnectInfo_start`, `ConnectInfo_stop`, `AcctInputOctets`, `AcctOutputOctets`, `CalledStationId`, `CallingStationId`, `AcctTerminateCause`, `ServiceType`, `FramedProtocol`, `FramedIPAddress`, `AcctStartDelay`, `AcctStopDelay`, `XAscendSessionSvrKey`) VALUES (3970328, '80d0090b', '28e7b4a55f1dead8', 'ni334ROHUH', '', '192.168.1.102', '2161117451', 'Wireless-802.11', '2013-02-05 20:14:38', '2013-02-05 20:39:23', 1481, '', '', '', 1443428, 3321047, 'aptrevoli', 'E0:B9:BA:DB:B4:E4', 'Lost-Service', '', '', '172.21.0.31', 0, 4, ''); =========================================================== Anybody knows how could I fix this? Regards, Antonio.
On 14 Jun 2013, at 12:27, Antonio Fernández Pérez <antoniofernandez@fabergames.com> wrote:
Hi everybody,
I have a problema with my FreeRADIUS accounting. I have detected that there are a lot of records duplicated but with different AcctStartDelay and AcctStopDelay. In raddact table appears for the same user more than one use when should appear only one.
Add a unique index on AcctUniuqeId. It's required for the rlm_sql module to work correctly. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team
participants (2)
-
Antonio Fernández Pérez -
Arran Cudbard-Bell