Vists every day

[Oscar Jofre]

No one ?

-----Mensaje original-----
De: Freeradius-Users [mailto:freeradius-users-bounces+oscar=jofre.com at 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 at 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