57 lines
1.5 KiB
Bash
57 lines
1.5 KiB
Bash
|
#!/bin/sh
|
||
|
|
|
||
|
|
SQL="/usr/bin/psql -U camembert -d camembert -t -c"
|
||
|
|
MY_PATH=/home/camembert/scripts
|
||
|
|
DHCPCONF=/etc/dhcp/dhcpd.conf
|
||
|
|
DNSCONF=/etc/bind/named.pacaterie.users
|
||
|
|
RESTARTSCRIPT=/etc/restartDHCPDNS.sh
|
||
|
|
|
||
|
|
cat ${MY_PATH}/dhcpd.conf.head >/tmp/dhcpd.conf
|
||
|
|
res=`${SQL} "SELECT r.name, nom, prenom, datedeco, c.name, mac FROM user_pac u, room r, computer c WHERE c.iduser = u.iduser AND u.idroom = r.idroom ORDER BY r.idroom"`
|
||
|
|
echo "${res}" | awk -F '|' -v cur_room=0 '{
|
||
|
|
gsub(" ", "", $1);
|
||
|
|
gsub(" ", "", $2);
|
||
|
|
gsub(" ", "", $3);
|
||
|
|
gsub(" ", "", $4);
|
||
|
|
gsub("-28", "", $4);
|
||
|
|
gsub(" ", "", $5);
|
||
|
|
gsub(" ", "", $6);
|
||
|
|
|
||
|
|
if($1 != cur_room) {
|
||
|
|
print "\n# Chambre "$1" "$2" "$3" "$4;
|
||
|
|
cur_room = $1;
|
||
|
|
}
|
||
|
|
|
||
|
|
print "\thost "$5" {"
|
||
|
|
print"\t\thardware ethernet "toupper($6)";";
|
||
|
|
print"\t\tfixed-address "$5".pacaterie.u-psud.fr;";
|
||
|
|
print"\t}"
|
||
|
|
}' >>/tmp/dhcpd.conf
|
||
|
|
echo "}" >>/tmp/dhcpd.conf
|
||
|
|
|
||
|
|
res=`${SQL} "SELECT r.name, c.name, ip FROM computer c, user_pac u, room r WHERE c.iduser = u.iduser AND u.idroom = r.idroom ORDER BY ip"`
|
||
|
|
echo "${res}" | awk -F '|' '{
|
||
|
|
gsub(" ", "", $1);
|
||
|
|
gsub(" ", "", $2);
|
||
|
|
gsub(" ", "", $3);
|
||
|
|
print "; Chambre "$1"\n"$2" IN A "$3"\n";
|
||
|
|
}' >/tmp/named.pacaterie.users
|
||
|
|
|
||
|
|
restart=false
|
||
|
|
diffs=`diff /tmp/dhcpd.conf ${DHCPCONF} | wc -l`
|
||
|
|
if [ ${diffs} -ne 0 ]; then
|
||
|
|
mv /tmp/dhcpd.conf ${DHCPCONF}
|
||
|
|
restart=true
|
||
|
|
fi
|
||
|
|
diffs=`diff /tmp/named.pacaterie.users ${DNSCONF} | wc -l`
|
||
|
|
if [ ${diffs} -ne 0 ]; then
|
||
|
|
mv /tmp/named.pacaterie.users ${DNSCONF}
|
||
|
|
restart=true
|
||
|
|
fi
|
||
|
|
|
||
|
|
if ${restart}; then
|
||
|
|
${RESTARTSCRIPT} >/dev/null
|
||
|
|
fi
|
||
|
|
|
||
|
|
rm -rf /tmp/dhcpd.conf /tmp/named.pacaterie.users
|