https://wiki.freeradius.org/guide/Users-Mailing-List#full-server-debug-outpu... 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@jofre.com> wrote:
-----Mensaje original----- De: Freeradius-Users <freeradius-users-bounces+oscar=jofre.com@lists.freeradius.org> En nombre de Oscar Enviado el: martes, 16 de abril de 2019 23:52 Para: 'FreeRadius users mailing list' <freeradius-users@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