| [e53b14b1] | 1 | #!/bin/bash |
|---|
| [ed1886b] | 2 | #/** |
|---|
| 3 | #@file comparemac |
|---|
| 4 | #@brief Comparar las direcciones MAC (ethernet) de los clientes conectados a la red con las registradas en OpenGnsys. |
|---|
| 5 | #@usage comparemac |
|---|
| 6 | #@warning Usa el programa "arp-scan". |
|---|
| 7 | #@version 1.0.6 - Versión inicial. |
|---|
| 8 | #@author Manuel González, Ramón M. Gómez - Univ. Sevilla |
|---|
| 9 | #@date 2014-07-11 |
|---|
| 10 | #*/ ## |
|---|
| 11 | |
|---|
| [e53b14b1] | 12 | |
|---|
| 13 | # Variables. |
|---|
| 14 | OPENGNSYS=${OPENGNSYS:-"/opt/opengnsys"} |
|---|
| [bbf5371] | 15 | SERVERCONF=$OPENGNSYS/etc/ogserver.cfg |
|---|
| [e53b14b1] | 16 | |
|---|
| [ed1886b] | 17 | # Funciones globales. |
|---|
| 18 | source $OPENGNSYS/lib/ogfunctions.sh || exit 1 |
|---|
| [e53b14b1] | 19 | |
|---|
| 20 | # Control de errores. |
|---|
| [ed1886b] | 21 | [ "$*" == "help" ] && help |
|---|
| 22 | [ "$*" == "version" ] && version |
|---|
| 23 | [ $# -gt 0 ] && raiseError usage |
|---|
| 24 | [ "$USER" != "root" ] && raiseError access "Need to be root" |
|---|
| 25 | [ -r $SERVERCFG ] || raiseError access "Server configuration file" |
|---|
| 26 | which arp-scan &>/dev/null || raiseError notfound "Need to install \"arp-scan\"" |
|---|
| [e53b14b1] | 27 | |
|---|
| 28 | # Obtener datos de acceso a la base de datos. |
|---|
| 29 | source $SERVERCONF |
|---|
| 30 | |
|---|
| 31 | # Borrar ficheros temporales si termina el proceso. |
|---|
| [ed1886b] | 32 | trap "rm -f $TMPSQL $TMPSCAN" 0 1 2 3 6 9 15 |
|---|
| 33 | |
|---|
| 34 | # Ficheros temporales. |
|---|
| 35 | TMPSQL=$(mktemp /tmp/mysql.cnf.XXXXX) |
|---|
| 36 | TMPSCAN=$(mktemp /tmp/scan.cnf.XXXXX) |
|---|
| [e53b14b1] | 37 | |
|---|
| 38 | # Obtener datos de ordenadores registrados. |
|---|
| [ed1886b] | 39 | dbexec "SELECT ip, mac, REPLACE (aulas.nombreaula, ' ', '_') AS aula |
|---|
| 40 | FROM ordenadores |
|---|
| 41 | JOIN aulas USING (idaula) |
|---|
| 42 | ORDER BY ip" > $TMPSQL |
|---|
| [e53b14b1] | 43 | |
|---|
| 44 | # Obtener datos de red. |
|---|
| 45 | NET=$(ip -o addr show up | awk -v ip="^$ServidorAdm/" '{if ($3=="inet" && $4 ~ ip) print $4}') |
|---|
| [455906f] | 46 | arp-scan $NET 2>/dev/null | awk '/^[0-2]*\./ {gsub(/:/,"");print $1,toupper($2)}' > $TMPSCAN |
|---|
| [e53b14b1] | 47 | |
|---|
| 48 | # Comparar los ficheros y mostrar las diferencias de direcciones MAC. |
|---|
| 49 | (while read -e IP MAC; do |
|---|
| 50 | awk -v ip=$IP -v mac=$MAC '{if ($1 == ip && $2 != mac) |
|---|
| 51 | printf("%s (%s) conectado con MAC %s, registrado con %s\n",ip,$3,mac,$2); |
|---|
| 52 | }' $TMPSQL |
|---|
| 53 | done) < $TMPSCAN |
|---|
| 54 | |
|---|
