A+A
-Netflow-source
--Inet Gateway
---DHCP-relay 3-level
----Home switch (opt82 ) 1
----Home switch (opt82 ) 2
----Home switch (opt82 ) 3
----Home switch (opt82 ) 4

config vlan default delete 1
create vlan 2 tag 2
config vlan 2 add tagged 1
create vlan vlanid 1000-4000
config vlan vlanid 1000-4000 add tagged 1
config ipif System vlan 2 ipaddress 192.168.222.250/24 state enable

disable dhcp_local_relay
config dhcp_relay option_82 remote_id user_define "192.168.222.250"
config dhcp_relay add vlanid 1000-4000 192.168.222.254
enable dhcp_relay

...........
...........
authoritative;
local-address 192.168.222.254;
................
................
class "192_168_222_250_1000"
{match if  binary-to-ascii(10, 16, "", substring( option agent.circuit-id, 2, 2)) = "1000" and binary-to-ascii(10, 8, ".", packet(24, 4)) = "192.168.222.250";}
class "192_168_222_250_1001"
{match if  binary-to-ascii(10, 16, "", substring( option agent.circuit-id, 2, 2)) = "1001" and binary-to-ascii(10, 8, ".", packet(24, 4)) = "192.168.222.250";}
...............
...............
shared-network "ipoe" {
subnet 172.18.150.0 netmask 255.255.255.248 {
option routers 172.18.150.1;
option domain-name-servers 192.168.222.1, 8.8.8.8;
option broadcast-address 172.18.150.7;
option subnet-mask 255.255.255.248;
pool {range 172.18.150.2 172.18.150.6; allow members of "192_168_222_250_1000"; }}
subnet 172.18.150.8 netmask 255.255.255.248 {
option routers 172.18.150.9;
option domain-name-servers 192.168.222.1, 8.8.8.8;
option broadcast-address 172.18.150.15;
option subnet-mask 255.255.255.248;
pool {range 172.18.150.10 172.18.150.14; allow members of "192_168_222_250_1001"; }}
.................
.................
subnet 192.168.222.0  netmask 255.255.255.0 { }
}

ip.resource.category=1:

ip range : 172.18.150.2 - 172.18.150.6
gate : 172.18.150.1
mask: 255.255.255.248
DNS: 192.168.222.1

ip.resource.category=2:

ip range : 172.18.150.10 - 172.18.150.14
gate : 172.18.150.9
mask: 255.255.255.248
DNS: 192.168.222.1

A+A
-Netflow-source
--Inet Gateway (mikrotik SA типа API)
---user vlan (opt82 ) 1000
---user vlan (opt82 ) 1001
---user vlan (opt82 ) 1002
..........
..........
---user vlan (opt82 ) 3000

ip.resource.category=1
vlan.resource.category=1

ip.resource.category=2
vlan.resource.category=2
................

ip.resource.category=3000
vlan.resource.category=3000

#!/bin/bash
rm -f sp.dhcpd.conf.*
rm -f *_sp.txt
d=`date +%M%H%d%m%g`
dns1=192.168.222.1
dns2=8.8.8.8
switch=192.168.222.250
switch_1=`echo $switch|tr "." "_"`
cat > /root/sp.dhcpd.conf.head.txt << EOF
default-lease-time 12000;
max-lease-time 30000;
authoritative;
local-address 192.168.222.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/sp.dhcpd.conf.tail.txt << EOF
subnet 192.168.121.0  netmask 255.255.255.0 { }
}
EOF
cat > /root/sp.dhcpd.conf.middle.txt << EOF
shared-network "ipoe" {
EOF
############################################################################################################################################################################
LINES=1001
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}_sp.txt
n=1
vlan_n=`cat /root/${oct3_net}_sp.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_1'_'$LINES`
        echo 'class "'$class'"' >> sp.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'";}'  >> sp.dhcpd.conf.1.txt
        net_1=${net%/*}
        echo 'subnet '$net_1' netmask 255.255.255.248 {' >> sp.dhcpd.conf.2.txt
        echo 'option routers '$def_g';' >> sp.dhcpd.conf.2.txt
        echo 'option domain-name-servers '$dns1', '$dns2';' >> sp.dhcpd.conf.2.txt
        echo 'option broadcast-address '$brd';' >> sp.dhcpd.conf.2.txt
        echo 'option subnet-mask 255.255.255.248;' >> sp.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'"; }}'  >> sp.dhcpd.conf.2.txt
        LINES=$(( $LINES + 1 ))
        n=$(( $n + 1 ))
        if [ $n -gt $vlan_n ]
        then
        break
        else
        continue
        fi
        done < /root/${oct3_net}_sp.txt
done < /root/ipoe_users_sp
cat sp.dhcpd.conf.head.txt sp.dhcpd.conf.1.txt sp.dhcpd.conf.middle.txt sp.dhcpd.conf.2.txt sp.dhcpd.conf.tail.txt > dhcpd_sp.conf.txt