BiTel

#!/bin/bash
d=`date +%M%H%d%m%g`
dns_childs_1=192.168.121.143
dns_childs_2=192.168.217.222
dns_left4_1=192.168.217.210
dns_left4_2=8.8.8.8
dns_left5_1=192.168.217.210
dns_left5_2=8.8.8.8
switch_left4=192.168.22.159
switch_left5=192.168.22.159
switch_childs=192.168.22.159
switch_left4_1=`echo $switch_left4|tr "." "_"`
switch_left5_1=`echo $switch_left5|tr "." "_"`
switch_childs_1=`echo $switch_childs|tr "." "_"`
cat > /root/22.dhcpd.conf.head.txt << EOF
default-lease-time 12000;
max-lease-time 30000;
authoritative;
local-address 192.168.22.254;
ddns-update-style none;
log-facility local7;
if exists agent.remote-id and exists agent.circuit-id {
log(info, "------------------------------------------------------------------------------");
set switch-addr = binary-to-ascii(10, 8, ".", packet(24, 4));
set switch-port = binary-to-ascii(10, 8, "", substring(option agent.circuit-id, 5, 1));
set switch-port-vlan = binary-to-ascii(10, 16, "", substring(option agent.circuit-id, 2, 2));
log(info, concat("- Lease: ", binary-to-ascii(10, 8, ".", leased-address), " via IP: ", switch-addr,  " on port: ", switch-port, " in VLAN: ", switch-port-vlan));
}
EOF
########################################################################################################################################################################
cat > /root/22.dhcpd.conf.tail.txt << EOF
subnet 192.168.22.0  netmask 255.255.255.0 { }
}
EOF
cat > /root/22.dhcpd.conf.middle.txt << EOF
shared-network "ipoe_22" {
EOF
#######################################################################################################
LINES=2257
while read line
do
net=`echo $line|awk '{ print $1 }'`
oct3_net=`echo $net|awk -F '.' '{print $3}'`
mask=`echo $line|awk '{ print $2 }'`
ipcalc -nb $net/$mask 29|sed '1,14d'|egrep "Network|HostMin|Broadcast"|sed -e 'N;N;s/\n/ /g'|awk '{ print $2, $4, $6 }' > /root/${oct3_net}_left4.txt
n=1
vlan_n=`cat /root/${oct3_net}_left4.txt|wc -l`
        while read LINE
        do
        net=$( echo "$LINE" |awk '{print $1}' )
        def_g=$( echo "$LINE" |awk '{print $2}' )
        brd=$( echo "$LINE" |awk '{print $3}' )
#################################################
        class=`echo $switch_left4_1'_'$LINES`
        echo 'class "'$class'"' >> left4.dhcpd.conf.1.txt
        echo '{match if  binary-to-ascii(10, 16, "", substring( option agent.circuit-id, 2, 2)) = "'$LINES'" and binary-to-ascii(10, 8, ".", packet(24, 4)) = "'$switch_childs'";}'  >> left4.dhcpd.conf.1.txt
        net_1=${net%/*}
        echo 'subnet '$net_1' netmask 255.255.255.248 {' >> left4.dhcpd.conf.2.txt
        echo 'option routers '$def_g';' >> left4.dhcpd.conf.2.txt
        echo 'option domain-name-servers '$dns_left4_1', '$dns_left4_2';' >> left4.dhcpd.conf.2.txt
        echo 'option broadcast-address '$brd';' >> left4.dhcpd.conf.2.txt
        echo 'option subnet-mask 255.255.255.248;' >> left4.dhcpd.conf.2.txt
        oct1_min=`echo $def_g|awk -F '.' '{print $1}'`
        oct2_min=`echo $def_g|awk -F '.' '{print $2}'`
        oct3_min=`echo $def_g|awk -F '.' '{print $3}'`
        oct4_min=`echo $def_g|awk -F '.' '{print $4}'`
        oct1_max=`echo $brd|awk -F '.' '{print $1}'`
        oct2_max=`echo $brd|awk -F '.' '{print $2}'`
        oct3_max=`echo $brd|awk -F '.' '{print $3}'`
        oct4_max=`echo $brd|awk -F '.' '{print $4}'`
        oct4_min_1=$(( $oct4_min + 1 ))
        oct4_max_1=$(( $oct4_max - 1 ))
        echo 'pool {range '$oct1_min'.'$oct2_min'.'$oct3_min'.'$oct4_min_1' '$oct1_max'.'$oct2_max'.'$oct3_max'.'$oct4_max_1'; allow members of "'$class'"; }}'  >> left4.dhcpd.conf.2.txt
        LINES=$(( $LINES + 1 ))
        n=$(( $n + 1 ))
        if [ $n -gt $vlan_n ]
        then
        break
        else
        continue
        fi
        done < /root/${oct3_net}_left4.txt
done < //root/ipoe_users_left4
###########################################################################################################################################################################
LINES=2513
while read line
do
net=`echo $line|awk '{ print $1 }'`
oct3_net=`echo $net|awk -F '.' '{print $3}'`
mask=`echo $line|awk '{ print $2 }'`
ipcalc -nb $net/$mask 29|sed '1,14d'|egrep "Network|HostMin|Broadcast"|sed -e 'N;N;s/\n/ /g'|awk '{ print $2, $4, $6 }' > /root/${oct3_net}_left5.txt
n=1
vlan_n=`cat /root/${oct3_net}_left5.txt|wc -l`
        while read LINE
        do
        net=$( echo "$LINE" |awk '{print $1}' )
        def_g=$( echo "$LINE" |awk '{print $2}' )
        brd=$( echo "$LINE" |awk '{print $3}' )
#################################################
        class=`echo $switch_left5_1'_'$LINES`
        echo 'class "'$class'"' >> left5.dhcpd.conf.1.txt
        echo '{match if  binary-to-ascii(10, 16, "", substring( option agent.circuit-id, 2, 2)) = "'$LINES'" and binary-to-ascii(10, 8, ".", packet(24, 4)) = "'$switch_childs'";}'  >> left5.dhcpd.conf.1.txt
        net_1=${net%/*}
        echo 'subnet '$net_1' netmask 255.255.255.248 {' >> left5.dhcpd.conf.2.txt
        echo 'option routers '$def_g';' >> left5.dhcpd.conf.2.txt
        echo 'option domain-name-servers '$dns_left5_1', '$dns_left5_2';' >> left5.dhcpd.conf.2.txt
        echo 'option broadcast-address '$brd';' >> left5.dhcpd.conf.2.txt
        echo 'option subnet-mask 255.255.255.248;' >> left5.dhcpd.conf.2.txt
        oct1_min=`echo $def_g|awk -F '.' '{print $1}'`
        oct2_min=`echo $def_g|awk -F '.' '{print $2}'`
        oct3_min=`echo $def_g|awk -F '.' '{print $3}'`
        oct4_min=`echo $def_g|awk -F '.' '{print $4}'`
        oct1_max=`echo $brd|awk -F '.' '{print $1}'`
        oct2_max=`echo $brd|awk -F '.' '{print $2}'`
        oct3_max=`echo $brd|awk -F '.' '{print $3}'`
        oct4_max=`echo $brd|awk -F '.' '{print $4}'`
        oct4_min_1=$(( $oct4_min + 1 ))
        oct4_max_1=$(( $oct4_max - 1 ))
        echo 'pool {range '$oct1_min'.'$oct2_min'.'$oct3_min'.'$oct4_min_1' '$oct1_max'.'$oct2_max'.'$oct3_max'.'$oct4_max_1'; allow members of "'$class'"; }}'  >> left5.dhcpd.conf.2.txt
        LINES=$(( $LINES + 1 ))
        n=$(( $n + 1 ))
        if [ $n -gt $vlan_n ]
        then
        break
        else
        continue
        fi
        done < /root/${oct3_net}_left5.txt
done < //root/ipoe_users_left5
#######################################################################################################
LINES=1769
while read line
do
net=`echo $line|awk '{ print $1 }'`
oct3_net=`echo $net|awk -F '.' '{print $3}'`
mask=`echo $line|awk '{ print $2 }'`
ipcalc -nb $net/$mask 29|sed '1,14d'|egrep "Network|HostMin|Broadcast"|sed -e 'N;N;s/\n/ /g'|awk '{ print $2, $4, $6 }' > /root/${oct3_net}_childs.txt
n=1
vlan_n=`cat /root/${oct3_net}_childs.txt|wc -l`
        while read LINE
        do
        net=$( echo "$LINE" |awk '{print $1}' )
        def_g=$( echo "$LINE" |awk '{print $2}' )
        brd=$( echo "$LINE" |awk '{print $3}' )
#################################################
        class=`echo $switch_childs_1'_'$LINES`
        echo 'class "'$class'"' >> childs.dhcpd.conf.1.txt
        echo '{match if  binary-to-ascii(10, 16, "", substring( option agent.circuit-id, 2, 2)) = "'$LINES'" and binary-to-ascii(10, 8, ".", packet(24, 4)) = "'$switch_childs'";}'  >> childs.dhcpd.conf.1.txt
        net_1=${net%/*}
        echo 'subnet '$net_1' netmask 255.255.255.248 {' >> childs.dhcpd.conf.2.txt
        echo 'option routers '$def_g';' >> childs.dhcpd.conf.2.txt
        echo 'option domain-name-servers '$dns_childs_1', '$dns_childs_2';' >> childs.dhcpd.conf.2.txt
        echo 'option broadcast-address '$brd';' >> childs.dhcpd.conf.2.txt
        echo 'option subnet-mask 255.255.255.248;' >> childs.dhcpd.conf.2.txt
        oct1_min=`echo $def_g|awk -F '.' '{print $1}'`
        oct2_min=`echo $def_g|awk -F '.' '{print $2}'`
        oct3_min=`echo $def_g|awk -F '.' '{print $3}'`
        oct4_min=`echo $def_g|awk -F '.' '{print $4}'`
        oct1_max=`echo $brd|awk -F '.' '{print $1}'`
        oct2_max=`echo $brd|awk -F '.' '{print $2}'`
        oct3_max=`echo $brd|awk -F '.' '{print $3}'`
        oct4_max=`echo $brd|awk -F '.' '{print $4}'`
        oct4_min_1=$(( $oct4_min + 1 ))
        oct4_max_1=$(( $oct4_max - 1 ))
        echo 'pool {range '$oct1_min'.'$oct2_min'.'$oct3_min'.'$oct4_min_1' '$oct1_max'.'$oct2_max'.'$oct3_max'.'$oct4_max_1'; allow members of "'$class'"; }}'  >> childs.dhcpd.conf.2.txt
        LINES=$(( $LINES + 1 ))
        n=$(( $n + 1 ))
        if [ $n -gt $vlan_n ]
        then
        break
        else
        continue
        fi
        done < /root/${oct3_net}_childs.txt
done < /root/ipoe_users_childs
############################################################################################################################################################################
cat left4.dhcpd.conf.1.txt left5.dhcpd.conf.1.txt childs.dhcpd.conf.1.txt 22.dhcpd.conf.middle.txt left4.dhcpd.conf.2.txt left5.dhcpd.conf.2.txt childs.dhcpd.conf.2.txt > dhcpd_22.conf.0.txt
cat 22.dhcpd.conf.head.txt dhcpd_22.conf.0.txt 22.dhcpd.conf.tail.txt > dhcpd_22.conf.txt
exit 0

sa.command.inetOption.1.enable=/queue/simple/set\n=max-limit=0/1M\n=numbers=vlan$c-vlan_i:$s-vlan_j
sa.command.inetOption.1.disable=/queue/simple/set\n=max-limit=0/100M\n=numbers=vlan$c-vlan_i:$s-vlan_j
.....
sa.command.serv.create.1=/ip/firewall/address-list/add\n=address=$ip/29\n=list=ACCESS_LIST\n=comment=!!$servId!!\n=disabled=yes
sa.command.serv.create.2=/queue/simple/add\n=max-limit=0/100M\n=target=vlan$c-vlan_i:$s-vlan_j\n=name=vlan$c-vlan_i:$s-vlan_j\n=comment=vlan$c-vlan_i:$s-vlan_j
sa.command.serv.enable=/ip/firewall/address-list/enable\n=numbers="!!$servId!!"
sa.command.serv.disable=/ip/firewall/address-list/disable\n=numbers="!!$servId!!"
sa.command.serv.cancel.1=/ip/firewall/address-list/remove\n=numbers="!!$servId!!"
sa.command.serv.cancel.2=/queue/simple/remove\n=numbers=vlan$c-vlan_i:$s-vlan_j