Implementación de una herramienta para el estudio de la movilidad entre los campus de la Universidad de Cuenca a través del análisis de Logs del Controlador de red inalámbrica

Abstract

This work presents the development and implementation of an analysis tool aimed at studying the mobility of the university community between the Central and Balzay campuses of the University of Cuenca, as part of the institutional Mover-U program.The proposed solution integrates an interactive visualization system that enables the monitoring of user connection records to the university’s wireless network. The system architecture is based on open-source technologies and containerized services, using Ubuntu Server 24.04 LTS as the primary platform. Tools such as Docker are used for containerization and service deployment, MySQL for structured data storage, Redis as an intermediate storage layer, and both Graylog and Rsyslog for filtering data collec-ted from the RADIUS server. To ensure data confidentiality, the system incorporates protection mechanisms including hashing functions and access controls at both the MySQL database and Graylog platform levels. The results demonstrate a clear graphi-cal representation of the mobility patterns within the university community, enabling the visualization of key statistics such as the total number of connections, distribution by campus, most frequently used access points, and movement direction. Additionally, interactive filters by date and movement direction are provided to support personalized data exploration by authorized users.