Radacct Reused ?

[Oscar]

Hi,

 

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 

                BEGIN

                               INSERT into usuario_instalacion_stoptime (

                                                               select
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) ;

 

                END$$

 

 

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 ?

 

 

Thanks,

-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 9266 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20190416/a4ffbd48/attachment-0001.png>