====== Maintenance mode ======

  - Nella vista utenti selezionare solo email. Copincollare in un client di posta elettronica togliendo gli indirizzi particolari.
  - Disattivare sincronizzazione su DNS e DHCP
  - In /etc/apache2/sites-enabled/indirizzi.conf commentare il resto e lasciare solo <file>Require ip 140.105.171.240/28</file>
  - Riavviare apache con <file>apache2ctl reload</file> e verificare raggiungimento da fuori units

====== Modifica del mac address da parte di utenti non amministratori ======

  root@schermo:/var/www/phpipam/app/subnets/addresses# diff address-modify.php.original address-modify.php
  281,282c281,283
  <                 print ' <input type="text" name="mac" class="ip_addr form-control input-sm" placeholder="'._('MAC address').'" value="'. $address['mac']. '" size="30" '.$delete.' disabled="disabled">'.$mcast_help_block;
  <                 print ' <input type="hidden" name="mac" value="'. $address['mac']. '">';
  ---
  >                 print ' <input type="text" name="mac" class="ip_addr form-control input-sm" placeholder="'._('MAC address').'" value="'. $address['mac']. '" size="30" '.$delete.'>'.$mcast_help_block;
  >                 #print ' <input type="text" name="mac" class="ip_addr form-control input-sm" placeholder="'._('MAC address').'" value="'. $address['mac']. '" size="30" '.$delete.' disabled="disabled">'.$mcast_help_block;
  >                 #print ' <input type="hidden" name="mac" value="'. $address['mac']. '">';

====== Popolazione del last seen con i dati di netdisco ======

Crontab postgres 

<code>
  */10 * * * * /etc/adminscripts/mysql/aggiornalastseensuphpipam.sh > /etc/adminscripts/mysql/aggiornalastseensuphpipam.log
</code>


<code>
#/bin/bash
#set -x
discoDBurl='postgresql://netdisco@proteo.units.it/?sslmode=require&passfile=/etc/adminscripts/mysql/aggiornalastseensuphpipam.pgconf'
ipamDBconf='/etc/adminscripts/mysql/phpipam.cnf'

###
for pid in $(pidof -x aggiornalastseensuphpipam.sh); do
    if [ $pid != $$ ]; then
        echo "[$(date)] : aggiornalastseensuphpipam.sh : Process is already running with PID $pid"
        exit 1
    fi
done

echo "select INET_NTOA(ip_addr) from ipaddresses" |  mysql --defaults-extra-file=$ipamDBconf -N  2>/dev/null | \
while read ip
do
        psql $discoDBurl -qtc "select ip,to_char(time_last,'YYYY-MM-DD HH24:MI:SS') from node_ip where active=TRUE and ip='$ip'";
done |  \
  sed '/^\s*$/d' | awk -F'|' '{print $1,$2}' | awk '{print "update ipaddresses set lastSeen=#"$2,$3"# , state=2  where ip_addr=INET_ATON(#"$1"#)"";"}' | sed "s/#/\'/g" | \
  mysql --defaults-extra-file=$ipamDBconf -vvvv

</code>