No one ? -----Mensaje original----- De: Freeradius-Users [mailto:freeradius-users-bounces+oscar=jofre.com@lists.freeradius.org] En nombre de Oscar Jofre Enviado el: miércoles, 28 de febrero de 2018 19:37 Para: 'FreeRadius users mailing list' <freeradius-users@lists.freeradius.org> Asunto: Vists every day Hi, 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 idVisits_table username date_visit 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. Thanks. Oscar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html