Radacct Reused ?

[Alan DeKok]

  https://wiki.freeradius.org/guide/Users-Mailing-List#full-server-debug-output_things-to-avoid

  Don't post images.  Don't post the same message.  We got it the first time.

  The default configuration works.

  If you want to know why your trigger is broken, go read the default queries and see what they do.

  i.e. you wrote code to break the server.  Don't do that.

> On Apr 18, 2019, at 2:51 AM, Oscar <oscar at jofre.com> wrote:
> 
> 
> 
> -----Mensaje original-----
> De: Freeradius-Users
> <freeradius-users-bounces+oscar=jofre.com at lists.freeradius.org> En nombre de
> Oscar
> Enviado el: martes, 16 de abril de 2019 23:52
> Para: 'FreeRadius users mailing list'
> <freeradius-users at lists.freeradius.org>
> Asunto: Radacct Reused ?
> 
> 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,
> 
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html