Radacct Reused ?

Oscar oscar at jofre.com
Thu Apr 18 08:51:08 CEST 2019

-----Mensaje original-----
De: Freeradius-Users
<freeradius-users-bounces+oscar=jofre.com at lists.freeradius.org> En nombre de
Enviado el: martes, 16 de abril de 2019 23:52
Para: 'FreeRadius users mailing list'
<freeradius-users at lists.freeradius.org>
Asunto: Radacct Reused ?



I've created a Trigger to save on a new table the las time a user has been
stop connection (acctstoptime).


So I've createad table and created this trigger:


                create TRIGGER UpdateStopTime AFTER UPDATE ON radacct

                FOR EACH ROW 


                               INSERT into usuario_instalacion_stoptime (

u.department as user,u.company as insta,if(r.acctstoptime is
null,now(),r.acctstoptime) stoptime 

                                                                from radacct
r,userinfo u where r.username=u.username  and r.radacctid=NEW.radacctid

                               ) ON DUPLICATE KEY UPDATE
stoptime=if(NEW.acctstoptime is null,now(),NEW.acctstoptime) ;





But now I'm facing that sems that radius rows from the past are beeign used
on the present


I mean, my radacctid is now arround 37.000.000


And I can see a user autheticated and updating a really old row:
accstoptime=09-2018 and beeing update today with accstarttime=04-2019




How is that possible ?


Is it correct ?




More information about the Freeradius-Users mailing list