Vists every day

Oscar Jofre oscar at
Thu Mar 1 23:46:33 CET 2018

No one ?

-----Mensaje original-----
De: Freeradius-Users [ at] En nombre de Oscar Jofre
Enviado el: miƩrcoles, 28 de febrero de 2018 19:37
Para: 'FreeRadius users mailing list' <freeradius-users at>
Asunto: Vists every day



I need Help to try to create a new table (MariaDB) with one row from each user identified by day on the radacct.


Because radacct is growing fast I need to store a new table with the visits per day by username.


Something like visits_table





with username and date_visit unique keys.


Also a need to store this table in a different server from the server where is installed the radius_db.


I've been reading and I can do a trigger on radius_db and every insert on radacct fire an insert-update on the new visits_table.


Also a I can create this visits_table as a FederatedX table on the other MariaDB machine.


I would like to know if someone have done this before and can give me a little bit of light on how to solve this.


I think with the trigger and plus the FederatedX maybe a slow down to much the database, maybe some code (need help in this) on the radius part will do the job better.


If anyone can give me a hand will be appreciate.






List info/subscribe/unsubscribe? See

More information about the Freeradius-Users mailing list