Option to respond with a different pool in Freeradius DHCP based on interface
Hello, I am running a Freeradius DHCP and I want to use the same Freeradius server to serve different pools on different interfaces but I am not seeing a way to make that happen. I was thinking on use the update-control but I was not able to find a way to make it. Scenario is like this: eth1 - 10.192.0.0/10 (pool name "dhcp_ftth") - working just fine eth2 - 10.10.0.024 (pool name "management") Both pools are in a MySQL database. Any ideas on how to make it? Bellow I am posting the result of the "radiusd -Xx" for a request I received: Tue Feb 7 11:35:37 2017 : Debug: radiusd: #### Opening IP addresses and Ports #### Tue Feb 7 11:35:37 2017 : Debug: listen { Tue Feb 7 11:35:37 2017 : Debug: type = "dhcp" Tue Feb 7 11:35:37 2017 : Debug: ipaddr = * Tue Feb 7 11:35:37 2017 : Debug: port = 67 Tue Feb 7 11:35:37 2017 : Debug: } Tue Feb 7 11:35:37 2017 : Debug: Listening on dhcp interface eth1 address * port 67 bound to server dhcp Tue Feb 7 11:35:37 2017 : Info: Ready to process requests Received DHCP-Discover of Id 130b66cc from 0.0.0.0:68 to 255.255.255.255:67 0: 01 01 06 00 13 0b 66 cc 00 00 80 00 00 00 00 00 16: 00 00 00 00 00 00 00 00 00 00 00 00 00 50 56 b8 32: 2c 62 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 01 37 06 01 79 03 21 06 2a 0c 08 4d 69 6b 256: 72 6f 54 69 6b 3d 07 01 00 50 56 b8 2c 62 ff 00 272: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 288: 00 00 00 00 00 00 00 00 00 00 00 00 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 319514316 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Message-Type = DHCP-Discover DHCP-Parameter-Request-List = DHCP-Subnet-Mask DHCP-Parameter-Request-List = DHCP-Classless-Static-Route DHCP-Parameter-Request-List = DHCP-Router-Address DHCP-Parameter-Request-List = DHCP-Static-Routes DHCP-Parameter-Request-List = DHCP-Domain-Name-Server DHCP-Parameter-Request-List = DHCP-NTP-Servers DHCP-Hostname = "MikroTik" DHCP-Client-Identifier = 0x01005056b82c62 Tue Feb 7 11:35:41 2017 : Debug: (0) Received code 1025 Id 319514316 from 0.0.0.0:68 to 255.255.255.255:67 length 300 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Opcode = Client-Message Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hardware-Type = Ethernet Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hardware-Address-Length = 6 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hop-Count = 0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Transaction-Id = 319514316 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Number-of-Seconds = 0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Flags = Broadcast Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Your-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Server-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Gateway-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Message-Type = DHCP-Discover Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Subnet-Mask Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Classless-Static-Route Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Router-Address Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Static-Routes Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Domain-Name-Server Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-NTP-Servers Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hostname = "MikroTik" Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-Identifier = 0x01005056b82c62 Tue Feb 7 11:35:41 2017 : Debug: Trying sub-section dhcp DHCP-Discover {...} Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp DHCP-Discover { Tue Feb 7 11:35:41 2017 : Debug: (0) update reply { Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Message-Type = DHCP-Offer Tue Feb 7 11:35:41 2017 : Debug: (0) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (0) update reply { Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Domain-Name-Server = 186.251.148.22 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Domain-Name-Server += 186.251.148.21 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Subnet-Mask = 255.192.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Router-Address = 10.192.0.1 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-IP-Address-Lease-Time = 86400 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-NTP-Servers = 186.251.148.3 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-NTP-Servers += 186.251.148.2 Tue Feb 7 11:35:41 2017 : Debug: (0) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (0) update control { Tue Feb 7 11:35:41 2017 : Debug: (0) &Pool-Name := "dhcp_ftth" Tue Feb 7 11:35:41 2017 : Debug: (0) } # update control = noop Tue Feb 7 11:35:41 2017 : Debug: (0) policy dhcp_sqlippool.post-auth { Tue Feb 7 11:35:41 2017 : Debug: (0) update request { Tue Feb 7 11:35:41 2017 : Debug: (0) EXPAND DHCP-%{DHCP-Client-Hardware-Address} Tue Feb 7 11:35:41 2017 : Debug: (0) --> DHCP-00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) &User-Name = DHCP-00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) EXPAND %{DHCP-Client-Hardware-Address} Tue Feb 7 11:35:41 2017 : Debug: (0) --> 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) &Calling-Station-Id = 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) EXPAND %{%{DHCP-Gateway-IP-Address}:-127.0.0.1} Tue Feb 7 11:35:41 2017 : Debug: (0) --> 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) &NAS-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) &Acct-Status-Type = Start Tue Feb 7 11:35:41 2017 : Debug: (0) } # update request = noop Tue Feb 7 11:35:41 2017 : Debug: (0) modsingle[post-auth]: calling dhcp_sqlippool (rlm_sqlippool) Tue Feb 7 11:35:41 2017 : Debug: rlm_sql (sql): Reserved connection (0) Tue Feb 7 11:35:41 2017 : Debug: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '%{Nas-IP-Address}' Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> NAS-IP-Address Tue Feb 7 11:35:41 2017 : Debug: literal --> ' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '%{Nas-IP-Address}' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '0.0.0.0' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '0.0.0.0' Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Rows matched: 0 Changed: 0 Warnings: 0 Tue Feb 7 11:35:41 2017 : Debug: COMMIT Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: COMMIT Tue Feb 7 11:35:41 2017 : Debug: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: SELECT framedipaddress FROM dhcp WHERE pool_name = '%{control:Pool-Name}' AND (callingstationid = '%{Calling-Station-Id}' or callingstationid = '') ORDER BY (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> SELECT framedipaddress FROM dhcp WHERE pool_name = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Pool-Name Tue Feb 7 11:35:41 2017 : Debug: literal --> ' AND (callingstationid = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ' or callingstationid = '') ORDER BY (callingstationid <> ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> '), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND SELECT framedipaddress FROM dhcp WHERE pool_name = '%{control:Pool-Name}' AND (callingstationid = '%{Calling-Station-Id}' or callingstationid = '') ORDER BY (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> SELECT framedipaddress FROM dhcp WHERE pool_name = 'dhcp_ftth' AND (callingstationid = '00:50:56:b8:2c:62' or callingstationid = '') ORDER BY (callingstationid <> '00:50:56:b8:2c:62'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing select query: SELECT framedipaddress FROM dhcp WHERE pool_name = 'dhcp_ftth' AND (callingstationid = '00:50:56:b8:2c:62' or callingstationid = '') ORDER BY (callingstationid <> '00:50:56:b8:2c:62'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Allocated IP 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: UPDATE dhcp SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{Calling-Station-Id}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> UPDATE dhcp SET nasipaddress = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> NAS-IP-Address Tue Feb 7 11:35:41 2017 : Debug: literal --> ', pool_key = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ', callingstationid = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ', username = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> User-Name Tue Feb 7 11:35:41 2017 : Debug: literal --> ', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND UPDATE dhcp SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{Calling-Station-Id}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> UPDATE dhcp SET nasipaddress = '0.0.0.0', pool_key = '00:50:56:b8:2c:62', callingstationid = '00:50:56:b8:2c:62', username = 'DHCP-00:50:56:b8:2c:62', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: UPDATE dhcp SET nasipaddress = '0.0.0.0', pool_key = '00:50:56:b8:2c:62', callingstationid = '00:50:56:b8:2c:62', username = 'DHCP-00:50:56:b8:2c:62', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 Tue Feb 7 11:35:41 2017 : Debug: COMMIT Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: COMMIT Tue Feb 7 11:35:41 2017 : Debug: rlm_sql (sql): Released connection (0) Tue Feb 7 11:35:41 2017 : Info: rlm_sql (sql): Need 5 more connections to reach 10 spares Tue Feb 7 11:35:41 2017 : Info: rlm_sql (sql): Opening additional connection (5), 1 of 27 pending slots used Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Starting connect to MySQL server Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Connected to database 'acs' on 172.31.255.63 via TCP/IP, server version 5.5.5-10.0.0 2.0.3-maxscale, protocol version 10 Tue Feb 7 11:35:41 2017 : Debug: (0) modsingle[post-auth]: returned from dhcp_sqlippool (rlm_sqlippool) Tue Feb 7 11:35:41 2017 : Debug: (0) [dhcp_sqlippool] = ok Tue Feb 7 11:35:41 2017 : Debug: (0) if (ok) { Tue Feb 7 11:35:41 2017 : Debug: (0) if (ok) -> TRUE Tue Feb 7 11:35:41 2017 : Debug: (0) if (ok) { Tue Feb 7 11:35:41 2017 : Debug: (0) update reply { Tue Feb 7 11:35:41 2017 : Debug: (0) EXPAND %{reply:Framed-IP-Address} Tue Feb 7 11:35:41 2017 : Debug: (0) --> 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Your-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (0) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (0) } # if (ok) = noop Tue Feb 7 11:35:41 2017 : Debug: (0) } # policy dhcp_sqlippool.post-auth = ok Tue Feb 7 11:35:41 2017 : Debug: (0) modsingle[post-auth]: calling ok (rlm_always) Tue Feb 7 11:35:41 2017 : Debug: (0) modsingle[post-auth]: returned from ok (rlm_always) Tue Feb 7 11:35:41 2017 : Debug: (0) [ok] = ok Tue Feb 7 11:35:41 2017 : Debug: (0) } # dhcp DHCP-Discover = ok Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP: Reply will be broadcast Tue Feb 7 11:35:41 2017 : Debug: (0) Sent code 1026 Id 319514316 from 10.192.0.5:67 to 255.255.255.255:68 length 0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Message-Type = DHCP-Offer Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Domain-Name-Server = 186.251.148.22 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Domain-Name-Server += 186.251.148.21 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Subnet-Mask = 255.192.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Router-Address = 10.192.0.1 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-IP-Address-Lease-Time = 86400 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-NTP-Servers = 186.251.148.3 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-NTP-Servers += 186.251.148.2 Tue Feb 7 11:35:41 2017 : Debug: (0) Framed-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Your-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Opcode = Server-Message Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hardware-Type = Ethernet Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hardware-Address-Length = 6 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hop-Count = 0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Transaction-Id = 319514316 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Flags = Broadcast Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Gateway-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Opcode = Server-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 319514316 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 10.192.1.1 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Server-Host-Name = "" DHCP-Boot-Filename = "" DHCP-Subnet-Mask = 255.192.0.0 DHCP-Router-Address = 10.192.0.1 DHCP-Domain-Name-Server = 186.251.148.22 DHCP-Domain-Name-Server += 186.251.148.21 DHCP-NTP-Servers = 186.251.148.3 DHCP-NTP-Servers += 186.251.148.2 DHCP-IP-Address-Lease-Time = 86400 DHCP-DHCP-Server-Identifier = 10.192.0.5 DHCP Sending 300 bytes 0: 02 01 06 00 13 0b 66 cc 00 00 80 00 00 00 00 00 16: 0a c0 01 01 00 00 00 00 00 00 00 00 00 50 56 b8 32: 2c 62 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 02 01 04 ff c0 00 00 03 04 0a c0 00 01 06 256: 08 ba fb 94 16 ba fb 94 15 2a 08 ba fb 94 03 ba 272: fb 94 02 33 04 00 01 51 80 36 04 0a c0 00 05 ff 288: 00 00 00 00 00 00 00 00 00 00 00 00 Sending DHCP-Offer Id 130b66cc from 10.192.0.5:67 to 255.255.255.255:68 Tue Feb 7 11:35:41 2017 : Debug: (0) Finished request Tue Feb 7 11:35:41 2017 : Debug: (0) Cleaning up request packet ID 319514316 with timestamp +4 Tue Feb 7 11:35:41 2017 : Info: Ready to process requests Received DHCP-Request of Id 130b66cc from 0.0.0.0:68 to 255.255.255.255:67 0: 01 01 06 00 13 0b 66 cc 00 00 80 00 00 00 00 00 16: 00 00 00 00 00 00 00 00 00 00 00 00 00 50 56 b8 32: 2c 62 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 03 36 04 0a c0 00 05 32 04 0a c0 01 01 37 256: 06 01 79 03 21 06 2a 0c 08 4d 69 6b 72 6f 54 69 272: 6b 3d 07 01 00 50 56 b8 2c 62 ff 00 00 00 00 00 288: 00 00 00 00 00 00 00 00 00 00 00 00 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 319514316 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Message-Type = DHCP-Request DHCP-DHCP-Server-Identifier = 10.192.0.5 DHCP-Requested-IP-Address = 10.192.1.1 DHCP-Parameter-Request-List = DHCP-Subnet-Mask DHCP-Parameter-Request-List = DHCP-Classless-Static-Route DHCP-Parameter-Request-List = DHCP-Router-Address DHCP-Parameter-Request-List = DHCP-Static-Routes DHCP-Parameter-Request-List = DHCP-Domain-Name-Server DHCP-Parameter-Request-List = DHCP-NTP-Servers DHCP-Hostname = "MikroTik" DHCP-Client-Identifier = 0x01005056b82c62 Tue Feb 7 11:35:41 2017 : Debug: (1) Received code 1027 Id 319514316 from 0.0.0.0:68 to 255.255.255.255:67 length 300 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Opcode = Client-Message Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hardware-Type = Ethernet Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hardware-Address-Length = 6 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hop-Count = 0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Transaction-Id = 319514316 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Number-of-Seconds = 0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Flags = Broadcast Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Your-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Server-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Gateway-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Message-Type = DHCP-Request Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Requested-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Subnet-Mask Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Classless-Static-Route Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Router-Address Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Static-Routes Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Domain-Name-Server Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-NTP-Servers Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hostname = "MikroTik" Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-Identifier = 0x01005056b82c62 Tue Feb 7 11:35:41 2017 : Debug: Trying sub-section dhcp DHCP-Request {...} Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp DHCP-Request { Tue Feb 7 11:35:41 2017 : Debug: (1) update reply { Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Message-Type = DHCP-Ack Tue Feb 7 11:35:41 2017 : Debug: (1) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (1) update reply { Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Domain-Name-Server = 186.251.148.22 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Domain-Name-Server += 186.251.148.21 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Subnet-Mask = 255.192.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Router-Address = 10.192.0.1 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-IP-Address-Lease-Time = 86400 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-NTP-Servers = 186.251.148.3 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-NTP-Servers += 186.251.148.2 Tue Feb 7 11:35:41 2017 : Debug: (1) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (1) update control { Tue Feb 7 11:35:41 2017 : Debug: (1) &Pool-Name := "dhcp_ftth" Tue Feb 7 11:35:41 2017 : Debug: (1) } # update control = noop Tue Feb 7 11:35:41 2017 : Debug: (1) policy dhcp_sqlippool.post-auth { Tue Feb 7 11:35:41 2017 : Debug: (1) update request { Tue Feb 7 11:35:41 2017 : Debug: (1) EXPAND DHCP-%{DHCP-Client-Hardware-Address} Tue Feb 7 11:35:41 2017 : Debug: (1) --> DHCP-00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) &User-Name = DHCP-00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) EXPAND %{DHCP-Client-Hardware-Address} Tue Feb 7 11:35:41 2017 : Debug: (1) --> 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) &Calling-Station-Id = 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) EXPAND %{%{DHCP-Gateway-IP-Address}:-127.0.0.1} Tue Feb 7 11:35:41 2017 : Debug: (1) --> 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) &NAS-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) &Acct-Status-Type = Start Tue Feb 7 11:35:41 2017 : Debug: (1) } # update request = noop Tue Feb 7 11:35:41 2017 : Debug: (1) modsingle[post-auth]: calling dhcp_sqlippool (rlm_sqlippool) Tue Feb 7 11:35:41 2017 : Debug: rlm_sql (sql): Reserved connection (1) Tue Feb 7 11:35:41 2017 : Debug: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: EXPAND START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Executing query: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: SELECT framedipaddress FROM dhcp WHERE pool_name = '%{control:Pool-Name}' AND (callingstationid = '%{Calling-Station-Id}' or callingstationid = '') ORDER BY (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> SELECT framedipaddress FROM dhcp WHERE pool_name = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Pool-Name Tue Feb 7 11:35:41 2017 : Debug: literal --> ' AND (callingstationid = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ' or callingstationid = '') ORDER BY (callingstationid <> ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> '), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: EXPAND SELECT framedipaddress FROM dhcp WHERE pool_name = '%{control:Pool-Name}' AND (callingstationid = '%{Calling-Station-Id}' or callingstationid = '') ORDER BY (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: --> SELECT framedipaddress FROM dhcp WHERE pool_name = 'dhcp_ftth' AND (callingstationid = '00:50:56:b8:2c:62' or callingstationid = '') ORDER BY (callingstationid <> '00:50:56:b8:2c:62'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Executing select query: SELECT framedipaddress FROM dhcp WHERE pool_name = 'dhcp_ftth' AND (callingstationid = '00:50:56:b8:2c:62' or callingstationid = '') ORDER BY (callingstationid <> '00:50:56:b8:2c:62'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Allocated IP 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: UPDATE dhcp SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{Calling-Station-Id}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> UPDATE dhcp SET nasipaddress = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> NAS-IP-Address Tue Feb 7 11:35:41 2017 : Debug: literal --> ', pool_key = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ', callingstationid = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ', username = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> User-Name Tue Feb 7 11:35:41 2017 : Debug: literal --> ', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: EXPAND UPDATE dhcp SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{Calling-Station-Id}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: --> UPDATE dhcp SET nasipaddress = '0.0.0.0', pool_key = '00:50:56:b8:2c:62', callingstationid = '00:50:56:b8:2c:62', username = 'DHCP-00:50:56:b8:2c:62', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Executing query: UPDATE dhcp SET nasipaddress = '0.0.0.0', pool_key = '00:50:56:b8:2c:62', callingstationid = '00:50:56:b8:2c:62', username = 'DHCP-00:50:56:b8:2c:62', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 Tue Feb 7 11:35:41 2017 : Debug: COMMIT Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: EXPAND COMMIT Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Executing query: COMMIT Tue Feb 7 11:35:41 2017 : Debug: rlm_sql (sql): Released connection (1) Tue Feb 7 11:35:41 2017 : Debug: (1) modsingle[post-auth]: returned from dhcp_sqlippool (rlm_sqlippool) Tue Feb 7 11:35:41 2017 : Debug: (1) [dhcp_sqlippool] = ok Tue Feb 7 11:35:41 2017 : Debug: (1) if (ok) { Tue Feb 7 11:35:41 2017 : Debug: (1) if (ok) -> TRUE Tue Feb 7 11:35:41 2017 : Debug: (1) if (ok) { Tue Feb 7 11:35:41 2017 : Debug: (1) update reply { Tue Feb 7 11:35:41 2017 : Debug: (1) EXPAND %{reply:Framed-IP-Address} Tue Feb 7 11:35:41 2017 : Debug: (1) --> 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Your-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (1) } # if (ok) = noop Tue Feb 7 11:35:41 2017 : Debug: (1) } # policy dhcp_sqlippool.post-auth = ok Tue Feb 7 11:35:41 2017 : Debug: (1) modsingle[post-auth]: calling ok (rlm_always) Tue Feb 7 11:35:41 2017 : Debug: (1) modsingle[post-auth]: returned from ok (rlm_always) Tue Feb 7 11:35:41 2017 : Debug: (1) [ok] = ok Tue Feb 7 11:35:41 2017 : Debug: (1) } # dhcp DHCP-Request = ok Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP: Reply will be broadcast Tue Feb 7 11:35:41 2017 : Debug: (1) Sent code 1029 Id 319514316 from 10.192.0.5:67 to 255.255.255.255:68 length 0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Message-Type = DHCP-Ack Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Domain-Name-Server = 186.251.148.22 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Domain-Name-Server += 186.251.148.21 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Subnet-Mask = 255.192.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Router-Address = 10.192.0.1 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-IP-Address-Lease-Time = 86400 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-NTP-Servers = 186.251.148.3 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-NTP-Servers += 186.251.148.2 Tue Feb 7 11:35:41 2017 : Debug: (1) Framed-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Your-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Opcode = Server-Message Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hardware-Type = Ethernet Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hardware-Address-Length = 6 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hop-Count = 0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Transaction-Id = 319514316 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Flags = Broadcast Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Gateway-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Opcode = Server-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 319514316 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 10.192.1.1 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Server-Host-Name = "" DHCP-Boot-Filename = "" DHCP-Subnet-Mask = 255.192.0.0 DHCP-Router-Address = 10.192.0.1 DHCP-Domain-Name-Server = 186.251.148.22 DHCP-Domain-Name-Server += 186.251.148.21 DHCP-NTP-Servers = 186.251.148.3 DHCP-NTP-Servers += 186.251.148.2 DHCP-IP-Address-Lease-Time = 86400 DHCP-DHCP-Server-Identifier = 10.192.0.5 DHCP Sending 300 bytes 0: 02 01 06 00 13 0b 66 cc 00 00 80 00 00 00 00 00 16: 0a c0 01 01 00 00 00 00 00 00 00 00 00 50 56 b8 32: 2c 62 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 05 01 04 ff c0 00 00 03 04 0a c0 00 01 06 256: 08 ba fb 94 16 ba fb 94 15 2a 08 ba fb 94 03 ba 272: fb 94 02 33 04 00 01 51 80 36 04 0a c0 00 05 ff 288: 00 00 00 00 00 00 00 00 00 00 00 00 Sending DHCP-Ack Id 130b66cc from 10.192.0.5:67 to 255.255.255.255:68 Tue Feb 7 11:35:41 2017 : Debug: (1) Finished request Tue Feb 7 11:35:41 2017 : Debug: (1) Cleaning up request packet ID 319514316 with timestamp +4 Tue Feb 7 11:35:41 2017 : Info: Ready to process requests Atenciosamente, *Nataniel Klug* | nataniel.klug@gmail.com
Solved with an "if" statement: if(DHCP-DHCP-Server-Identifier == 10.192.0.5) { update control { &Pool-Name := "dhcp_ftth" } } else { update control { &Pool-Name := "gestao" } } Atenciosamente, *Nataniel Klug* | nataniel.klug@gmail.com 2017-02-07 11:42 GMT-02:00 Nataniel Klug <nataniel.klug@gmail.com>:
Hello,
I am running a Freeradius DHCP and I want to use the same Freeradius server to serve different pools on different interfaces but I am not seeing a way to make that happen. I was thinking on use the update-control but I was not able to find a way to make it.
Scenario is like this:
eth1 - 10.192.0.0/10 (pool name "dhcp_ftth") - working just fine eth2 - 10.10.0.024 (pool name "management")
Both pools are in a MySQL database. Any ideas on how to make it?
Bellow I am posting the result of the "radiusd -Xx" for a request I received:
Tue Feb 7 11:35:37 2017 : Debug: radiusd: #### Opening IP addresses and Ports #### Tue Feb 7 11:35:37 2017 : Debug: listen { Tue Feb 7 11:35:37 2017 : Debug: type = "dhcp" Tue Feb 7 11:35:37 2017 : Debug: ipaddr = * Tue Feb 7 11:35:37 2017 : Debug: port = 67 Tue Feb 7 11:35:37 2017 : Debug: } Tue Feb 7 11:35:37 2017 : Debug: Listening on dhcp interface eth1 address * port 67 bound to server dhcp Tue Feb 7 11:35:37 2017 : Info: Ready to process requests Received DHCP-Discover of Id 130b66cc from 0.0.0.0:68 to 255.255.255.255:67 0: 01 01 06 00 13 0b 66 cc 00 00 80 00 00 00 00 00 16: 00 00 00 00 00 00 00 00 00 00 00 00 00 50 56 b8 32: 2c 62 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 01 37 06 01 79 03 21 06 2a 0c 08 4d 69 6b 256: 72 6f 54 69 6b 3d 07 01 00 50 56 b8 2c 62 ff 00 272: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 288: 00 00 00 00 00 00 00 00 00 00 00 00 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 319514316 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Message-Type = DHCP-Discover DHCP-Parameter-Request-List = DHCP-Subnet-Mask DHCP-Parameter-Request-List = DHCP-Classless-Static-Route DHCP-Parameter-Request-List = DHCP-Router-Address DHCP-Parameter-Request-List = DHCP-Static-Routes DHCP-Parameter-Request-List = DHCP-Domain-Name-Server DHCP-Parameter-Request-List = DHCP-NTP-Servers DHCP-Hostname = "MikroTik" DHCP-Client-Identifier = 0x01005056b82c62 Tue Feb 7 11:35:41 2017 : Debug: (0) Received code 1025 Id 319514316 from 0.0.0.0:68 to 255.255.255.255:67 length 300 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Opcode = Client-Message Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hardware-Type = Ethernet Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hardware-Address-Length = 6 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hop-Count = 0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Transaction-Id = 319514316 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Number-of-Seconds = 0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Flags = Broadcast Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Your-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Server-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Gateway-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Message-Type = DHCP-Discover Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Subnet-Mask Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Classless-Static-Route Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Router-Address Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Static-Routes Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-Domain-Name-Server Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Parameter-Request-List = DHCP-NTP-Servers Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hostname = "MikroTik" Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-Identifier = 0x01005056b82c62 Tue Feb 7 11:35:41 2017 : Debug: Trying sub-section dhcp DHCP-Discover {...} Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp DHCP-Discover { Tue Feb 7 11:35:41 2017 : Debug: (0) update reply { Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Message-Type = DHCP-Offer Tue Feb 7 11:35:41 2017 : Debug: (0) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (0) update reply { Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Domain-Name-Server = 186.251.148.22 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Domain-Name-Server += 186.251.148.21 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Subnet-Mask = 255.192.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Router-Address = 10.192.0.1 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-IP-Address-Lease-Time = 86400 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-NTP-Servers = 186.251.148.3 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-NTP-Servers += 186.251.148.2 Tue Feb 7 11:35:41 2017 : Debug: (0) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (0) update control { Tue Feb 7 11:35:41 2017 : Debug: (0) &Pool-Name := "dhcp_ftth" Tue Feb 7 11:35:41 2017 : Debug: (0) } # update control = noop Tue Feb 7 11:35:41 2017 : Debug: (0) policy dhcp_sqlippool.post-auth { Tue Feb 7 11:35:41 2017 : Debug: (0) update request { Tue Feb 7 11:35:41 2017 : Debug: (0) EXPAND DHCP-%{DHCP-Client-Hardware-Address} Tue Feb 7 11:35:41 2017 : Debug: (0) --> DHCP-00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) &User-Name = DHCP-00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) EXPAND %{DHCP-Client-Hardware-Address} Tue Feb 7 11:35:41 2017 : Debug: (0) --> 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) &Calling-Station-Id = 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (0) EXPAND %{%{DHCP-Gateway-IP-Address}:-127.0.0.1} Tue Feb 7 11:35:41 2017 : Debug: (0) --> 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) &NAS-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) &Acct-Status-Type = Start Tue Feb 7 11:35:41 2017 : Debug: (0) } # update request = noop Tue Feb 7 11:35:41 2017 : Debug: (0) modsingle[post-auth]: calling dhcp_sqlippool (rlm_sqlippool) Tue Feb 7 11:35:41 2017 : Debug: rlm_sql (sql): Reserved connection (0) Tue Feb 7 11:35:41 2017 : Debug: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '%{Nas-IP-Address}' Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> NAS-IP-Address Tue Feb 7 11:35:41 2017 : Debug: literal --> ' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '%{Nas-IP-Address}' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '0.0.0.0' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: UPDATE dhcp SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NOW() WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress = '0.0.0.0' Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Rows matched: 0 Changed: 0 Warnings: 0 Tue Feb 7 11:35:41 2017 : Debug: COMMIT Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: COMMIT Tue Feb 7 11:35:41 2017 : Debug: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: SELECT framedipaddress FROM dhcp WHERE pool_name = '%{control:Pool-Name}' AND (callingstationid = '%{Calling-Station-Id}' or callingstationid = '') ORDER BY (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> SELECT framedipaddress FROM dhcp WHERE pool_name = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Pool-Name Tue Feb 7 11:35:41 2017 : Debug: literal --> ' AND (callingstationid = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ' or callingstationid = '') ORDER BY (callingstationid <> ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> '), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND SELECT framedipaddress FROM dhcp WHERE pool_name = '%{control:Pool-Name}' AND (callingstationid = '%{Calling-Station-Id}' or callingstationid = '') ORDER BY (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> SELECT framedipaddress FROM dhcp WHERE pool_name = 'dhcp_ftth' AND (callingstationid = '00:50:56:b8:2c:62' or callingstationid = '') ORDER BY (callingstationid <> '00:50:56:b8:2c:62'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing select query: SELECT framedipaddress FROM dhcp WHERE pool_name = 'dhcp_ftth' AND (callingstationid = '00:50:56:b8:2c:62' or callingstationid = '') ORDER BY (callingstationid <> '00:50:56:b8:2c:62'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Allocated IP 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: UPDATE dhcp SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{Calling-Station-Id}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> UPDATE dhcp SET nasipaddress = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> NAS-IP-Address Tue Feb 7 11:35:41 2017 : Debug: literal --> ', pool_key = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ', callingstationid = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ', username = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> User-Name Tue Feb 7 11:35:41 2017 : Debug: literal --> ', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND UPDATE dhcp SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{Calling-Station-Id}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> UPDATE dhcp SET nasipaddress = '0.0.0.0', pool_key = '00:50:56:b8:2c:62', callingstationid = '00:50:56:b8:2c:62', username = 'DHCP-00:50:56:b8:2c:62', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: UPDATE dhcp SET nasipaddress = '0.0.0.0', pool_key = '00:50:56:b8:2c:62', callingstationid = '00:50:56:b8:2c:62', username = 'DHCP-00:50:56:b8:2c:62', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 Tue Feb 7 11:35:41 2017 : Debug: COMMIT Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: EXPAND COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (0) dhcp_sqlippool: Executing query: COMMIT Tue Feb 7 11:35:41 2017 : Debug: rlm_sql (sql): Released connection (0) Tue Feb 7 11:35:41 2017 : Info: rlm_sql (sql): Need 5 more connections to reach 10 spares Tue Feb 7 11:35:41 2017 : Info: rlm_sql (sql): Opening additional connection (5), 1 of 27 pending slots used Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Starting connect to MySQL server Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Connected to database 'acs' on 172.31.255.63 via TCP/IP, server version 5.5.5-10.0.0 2.0.3-maxscale, protocol version 10 Tue Feb 7 11:35:41 2017 : Debug: (0) modsingle[post-auth]: returned from dhcp_sqlippool (rlm_sqlippool) Tue Feb 7 11:35:41 2017 : Debug: (0) [dhcp_sqlippool] = ok Tue Feb 7 11:35:41 2017 : Debug: (0) if (ok) { Tue Feb 7 11:35:41 2017 : Debug: (0) if (ok) -> TRUE Tue Feb 7 11:35:41 2017 : Debug: (0) if (ok) { Tue Feb 7 11:35:41 2017 : Debug: (0) update reply { Tue Feb 7 11:35:41 2017 : Debug: (0) EXPAND %{reply:Framed-IP-Address} Tue Feb 7 11:35:41 2017 : Debug: (0) --> 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (0) &DHCP-Your-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (0) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (0) } # if (ok) = noop Tue Feb 7 11:35:41 2017 : Debug: (0) } # policy dhcp_sqlippool.post-auth = ok Tue Feb 7 11:35:41 2017 : Debug: (0) modsingle[post-auth]: calling ok (rlm_always) Tue Feb 7 11:35:41 2017 : Debug: (0) modsingle[post-auth]: returned from ok (rlm_always) Tue Feb 7 11:35:41 2017 : Debug: (0) [ok] = ok Tue Feb 7 11:35:41 2017 : Debug: (0) } # dhcp DHCP-Discover = ok Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP: Reply will be broadcast Tue Feb 7 11:35:41 2017 : Debug: (0) Sent code 1026 Id 319514316 from 10.192.0.5:67 to 255.255.255.255:68 length 0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Message-Type = DHCP-Offer Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Domain-Name-Server = 186.251.148.22 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Domain-Name-Server += 186.251.148.21 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Subnet-Mask = 255.192.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Router-Address = 10.192.0.1 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-IP-Address-Lease-Time = 86400 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-NTP-Servers = 186.251.148.3 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-NTP-Servers += 186.251.148.2 Tue Feb 7 11:35:41 2017 : Debug: (0) Framed-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Your-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Opcode = Server-Message Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hardware-Type = Ethernet Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hardware-Address-Length = 6 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Hop-Count = 0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Transaction-Id = 319514316 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Flags = Broadcast Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Gateway-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (0) DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Opcode = Server-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 319514316 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 10.192.1.1 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Server-Host-Name = "" DHCP-Boot-Filename = "" DHCP-Subnet-Mask = 255.192.0.0 DHCP-Router-Address = 10.192.0.1 DHCP-Domain-Name-Server = 186.251.148.22 DHCP-Domain-Name-Server += 186.251.148.21 DHCP-NTP-Servers = 186.251.148.3 DHCP-NTP-Servers += 186.251.148.2 DHCP-IP-Address-Lease-Time = 86400 DHCP-DHCP-Server-Identifier = 10.192.0.5 DHCP Sending 300 bytes 0: 02 01 06 00 13 0b 66 cc 00 00 80 00 00 00 00 00 16: 0a c0 01 01 00 00 00 00 00 00 00 00 00 50 56 b8 32: 2c 62 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 02 01 04 ff c0 00 00 03 04 0a c0 00 01 06 256: 08 ba fb 94 16 ba fb 94 15 2a 08 ba fb 94 03 ba 272: fb 94 02 33 04 00 01 51 80 36 04 0a c0 00 05 ff 288: 00 00 00 00 00 00 00 00 00 00 00 00 Sending DHCP-Offer Id 130b66cc from 10.192.0.5:67 to 255.255.255.255:68 Tue Feb 7 11:35:41 2017 : Debug: (0) Finished request Tue Feb 7 11:35:41 2017 : Debug: (0) Cleaning up request packet ID 319514316 with timestamp +4 Tue Feb 7 11:35:41 2017 : Info: Ready to process requests Received DHCP-Request of Id 130b66cc from 0.0.0.0:68 to 255.255.255.255:67 0: 01 01 06 00 13 0b 66 cc 00 00 80 00 00 00 00 00 16: 00 00 00 00 00 00 00 00 00 00 00 00 00 50 56 b8 32: 2c 62 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 03 36 04 0a c0 00 05 32 04 0a c0 01 01 37 256: 06 01 79 03 21 06 2a 0c 08 4d 69 6b 72 6f 54 69 272: 6b 3d 07 01 00 50 56 b8 2c 62 ff 00 00 00 00 00 288: 00 00 00 00 00 00 00 00 00 00 00 00 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 319514316 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Message-Type = DHCP-Request DHCP-DHCP-Server-Identifier = 10.192.0.5 DHCP-Requested-IP-Address = 10.192.1.1 DHCP-Parameter-Request-List = DHCP-Subnet-Mask DHCP-Parameter-Request-List = DHCP-Classless-Static-Route DHCP-Parameter-Request-List = DHCP-Router-Address DHCP-Parameter-Request-List = DHCP-Static-Routes DHCP-Parameter-Request-List = DHCP-Domain-Name-Server DHCP-Parameter-Request-List = DHCP-NTP-Servers DHCP-Hostname = "MikroTik" DHCP-Client-Identifier = 0x01005056b82c62 Tue Feb 7 11:35:41 2017 : Debug: (1) Received code 1027 Id 319514316 from 0.0.0.0:68 to 255.255.255.255:67 length 300 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Opcode = Client-Message Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hardware-Type = Ethernet Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hardware-Address-Length = 6 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hop-Count = 0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Transaction-Id = 319514316 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Number-of-Seconds = 0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Flags = Broadcast Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Your-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Server-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Gateway-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Message-Type = DHCP-Request Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Requested-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Subnet-Mask Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Classless-Static-Route Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Router-Address Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Static-Routes Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-Domain-Name-Server Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Parameter-Request-List = DHCP-NTP-Servers Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hostname = "MikroTik" Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-Identifier = 0x01005056b82c62 Tue Feb 7 11:35:41 2017 : Debug: Trying sub-section dhcp DHCP-Request {...} Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp DHCP-Request { Tue Feb 7 11:35:41 2017 : Debug: (1) update reply { Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Message-Type = DHCP-Ack Tue Feb 7 11:35:41 2017 : Debug: (1) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (1) update reply { Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Domain-Name-Server = 186.251.148.22 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Domain-Name-Server += 186.251.148.21 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Subnet-Mask = 255.192.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Router-Address = 10.192.0.1 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-IP-Address-Lease-Time = 86400 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-NTP-Servers = 186.251.148.3 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-NTP-Servers += 186.251.148.2 Tue Feb 7 11:35:41 2017 : Debug: (1) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (1) update control { Tue Feb 7 11:35:41 2017 : Debug: (1) &Pool-Name := "dhcp_ftth" Tue Feb 7 11:35:41 2017 : Debug: (1) } # update control = noop Tue Feb 7 11:35:41 2017 : Debug: (1) policy dhcp_sqlippool.post-auth { Tue Feb 7 11:35:41 2017 : Debug: (1) update request { Tue Feb 7 11:35:41 2017 : Debug: (1) EXPAND DHCP-%{DHCP-Client-Hardware-Address} Tue Feb 7 11:35:41 2017 : Debug: (1) --> DHCP-00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) &User-Name = DHCP-00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) EXPAND %{DHCP-Client-Hardware-Address} Tue Feb 7 11:35:41 2017 : Debug: (1) --> 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) &Calling-Station-Id = 00:50:56:b8:2c:62 Tue Feb 7 11:35:41 2017 : Debug: (1) EXPAND %{%{DHCP-Gateway-IP-Address}:-127.0.0.1} Tue Feb 7 11:35:41 2017 : Debug: (1) --> 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) &NAS-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) &Acct-Status-Type = Start Tue Feb 7 11:35:41 2017 : Debug: (1) } # update request = noop Tue Feb 7 11:35:41 2017 : Debug: (1) modsingle[post-auth]: calling dhcp_sqlippool (rlm_sqlippool) Tue Feb 7 11:35:41 2017 : Debug: rlm_sql (sql): Reserved connection (1) Tue Feb 7 11:35:41 2017 : Debug: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: EXPAND START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: --> START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Executing query: START TRANSACTION Tue Feb 7 11:35:41 2017 : Debug: SELECT framedipaddress FROM dhcp WHERE pool_name = '%{control:Pool-Name}' AND (callingstationid = '%{Calling-Station-Id}' or callingstationid = '') ORDER BY (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> SELECT framedipaddress FROM dhcp WHERE pool_name = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Pool-Name Tue Feb 7 11:35:41 2017 : Debug: literal --> ' AND (callingstationid = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ' or callingstationid = '') ORDER BY (callingstationid <> ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> '), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: EXPAND SELECT framedipaddress FROM dhcp WHERE pool_name = '%{control:Pool-Name}' AND (callingstationid = '%{Calling-Station-Id}' or callingstationid = '') ORDER BY (callingstationid <> '%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: --> SELECT framedipaddress FROM dhcp WHERE pool_name = 'dhcp_ftth' AND (callingstationid = '00:50:56:b8:2c:62' or callingstationid = '') ORDER BY (callingstationid <> '00:50:56:b8:2c:62'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Executing select query: SELECT framedipaddress FROM dhcp WHERE pool_name = 'dhcp_ftth' AND (callingstationid = '00:50:56:b8:2c:62' or callingstationid = '') ORDER BY (callingstationid <> '00:50:56:b8:2c:62'), expiry_time LIMIT 1 FOR UPDATE Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Allocated IP 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: UPDATE dhcp SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{Calling-Station-Id}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> UPDATE dhcp SET nasipaddress = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> NAS-IP-Address Tue Feb 7 11:35:41 2017 : Debug: literal --> ', pool_key = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ', callingstationid = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> Calling-Station-Id Tue Feb 7 11:35:41 2017 : Debug: literal --> ', username = ' Tue Feb 7 11:35:41 2017 : Debug: attribute --> User-Name Tue Feb 7 11:35:41 2017 : Debug: literal --> ', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: EXPAND UPDATE dhcp SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{Calling-Station-Id}', callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: --> UPDATE dhcp SET nasipaddress = '0.0.0.0', pool_key = '00:50:56:b8:2c:62', callingstationid = '00:50:56:b8:2c:62', username = 'DHCP-00:50:56:b8:2c:62', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Executing query: UPDATE dhcp SET nasipaddress = '0.0.0.0', pool_key = '00:50:56:b8:2c:62', callingstationid = '00:50:56:b8:2c:62', username = 'DHCP-00:50:56:b8:2c:62', expiry_time = NOW() + INTERVAL 86400 SECOND WHERE framedipaddress = '10.192.1.1' Tue Feb 7 11:35:41 2017 : Debug: rlm_sql_mysql: Rows matched: 1 Changed: 1 Warnings: 0 Tue Feb 7 11:35:41 2017 : Debug: COMMIT Tue Feb 7 11:35:41 2017 : Debug: Parsed xlat tree: Tue Feb 7 11:35:41 2017 : Debug: literal --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: EXPAND COMMIT Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: --> COMMIT Tue Feb 7 11:35:41 2017 : Debug: (1) dhcp_sqlippool: Executing query: COMMIT Tue Feb 7 11:35:41 2017 : Debug: rlm_sql (sql): Released connection (1) Tue Feb 7 11:35:41 2017 : Debug: (1) modsingle[post-auth]: returned from dhcp_sqlippool (rlm_sqlippool) Tue Feb 7 11:35:41 2017 : Debug: (1) [dhcp_sqlippool] = ok Tue Feb 7 11:35:41 2017 : Debug: (1) if (ok) { Tue Feb 7 11:35:41 2017 : Debug: (1) if (ok) -> TRUE Tue Feb 7 11:35:41 2017 : Debug: (1) if (ok) { Tue Feb 7 11:35:41 2017 : Debug: (1) update reply { Tue Feb 7 11:35:41 2017 : Debug: (1) EXPAND %{reply:Framed-IP-Address} Tue Feb 7 11:35:41 2017 : Debug: (1) --> 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) &DHCP-Your-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) } # update reply = noop Tue Feb 7 11:35:41 2017 : Debug: (1) } # if (ok) = noop Tue Feb 7 11:35:41 2017 : Debug: (1) } # policy dhcp_sqlippool.post-auth = ok Tue Feb 7 11:35:41 2017 : Debug: (1) modsingle[post-auth]: calling ok (rlm_always) Tue Feb 7 11:35:41 2017 : Debug: (1) modsingle[post-auth]: returned from ok (rlm_always) Tue Feb 7 11:35:41 2017 : Debug: (1) [ok] = ok Tue Feb 7 11:35:41 2017 : Debug: (1) } # dhcp DHCP-Request = ok Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP: Reply will be broadcast Tue Feb 7 11:35:41 2017 : Debug: (1) Sent code 1029 Id 319514316 from 10.192.0.5:67 to 255.255.255.255:68 length 0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Message-Type = DHCP-Ack Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Domain-Name-Server = 186.251.148.22 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Domain-Name-Server += 186.251.148.21 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Subnet-Mask = 255.192.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Router-Address = 10.192.0.1 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-IP-Address-Lease-Time = 86400 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-DHCP-Server-Identifier = 10.192.0.5 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-NTP-Servers = 186.251.148.3 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-NTP-Servers += 186.251.148.2 Tue Feb 7 11:35:41 2017 : Debug: (1) Framed-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Your-IP-Address = 10.192.1.1 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Opcode = Server-Message Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hardware-Type = Ethernet Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hardware-Address-Length = 6 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Hop-Count = 0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Transaction-Id = 319514316 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Flags = Broadcast Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Gateway-IP-Address = 0.0.0.0 Tue Feb 7 11:35:41 2017 : Debug: (1) DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Opcode = Server-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 319514316 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 10.192.1.1 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:2c:62 DHCP-Server-Host-Name = "" DHCP-Boot-Filename = "" DHCP-Subnet-Mask = 255.192.0.0 DHCP-Router-Address = 10.192.0.1 DHCP-Domain-Name-Server = 186.251.148.22 DHCP-Domain-Name-Server += 186.251.148.21 DHCP-NTP-Servers = 186.251.148.3 DHCP-NTP-Servers += 186.251.148.2 DHCP-IP-Address-Lease-Time = 86400 DHCP-DHCP-Server-Identifier = 10.192.0.5 DHCP Sending 300 bytes 0: 02 01 06 00 13 0b 66 cc 00 00 80 00 00 00 00 00 16: 0a c0 01 01 00 00 00 00 00 00 00 00 00 50 56 b8 32: 2c 62 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 05 01 04 ff c0 00 00 03 04 0a c0 00 01 06 256: 08 ba fb 94 16 ba fb 94 15 2a 08 ba fb 94 03 ba 272: fb 94 02 33 04 00 01 51 80 36 04 0a c0 00 05 ff 288: 00 00 00 00 00 00 00 00 00 00 00 00 Sending DHCP-Ack Id 130b66cc from 10.192.0.5:67 to 255.255.255.255:68 Tue Feb 7 11:35:41 2017 : Debug: (1) Finished request Tue Feb 7 11:35:41 2017 : Debug: (1) Cleaning up request packet ID 319514316 with timestamp +4 Tue Feb 7 11:35:41 2017 : Info: Ready to process requests
Atenciosamente,
*Nataniel Klug* | nataniel.klug@gmail.com
Hello again, It didn't work in the way I tought it would be. I need to test the interface that the DHCP-Discover come from but I am not being able to make that happen. The DHCP-Discover come like this: Received DHCP-Discover of Id f018203b from 0.0.0.0:68 to 255.255.255.255:67 0: 01 01 06 00 f0 18 20 3b 00 00 80 00 00 00 00 00 16: 00 00 00 00 00 00 00 00 00 00 00 00 00 50 56 b8 32: bb 95 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 01 37 06 01 79 03 21 06 2a 0c 08 4d 69 6b 256: 72 6f 54 69 6b 3d 07 01 00 50 56 b8 bb 95 ff 00 272: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 288: 00 00 00 00 00 00 00 00 00 00 00 00 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 4028112955 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:bb:95 DHCP-Message-Type = DHCP-Discover DHCP-Parameter-Request-List = DHCP-Subnet-Mask DHCP-Parameter-Request-List = DHCP-Classless-Static-Route DHCP-Parameter-Request-List = DHCP-Router-Address DHCP-Parameter-Request-List = DHCP-Static-Routes DHCP-Parameter-Request-List = DHCP-Domain-Name-Server DHCP-Parameter-Request-List = DHCP-NTP-Servers DHCP-Hostname = "MikroTik" DHCP-Client-Identifier = 0x01005056b8bb95 And for this request I need to send an specific pool and update info. This came from my eth2 interface. Any ideas? Atenciosamente, *Nataniel Klug* | nataniel.klug@gmail.com 2017-02-07 13:42 GMT-02:00 Nataniel Klug <nataniel.klug@gmail.com>:
Solved with an "if" statement:
if(DHCP-DHCP-Server-Identifier == 10.192.0.5) { update control { &Pool-Name := "dhcp_ftth" } } else { update control { &Pool-Name := "gestao" } }
Atenciosamente,
*Nataniel Klug* | nataniel.klug@gmail.com
Hello Nataniel, i worked a little bit on freeradius dhcp for another project and i did something like that: listen { type = dhcp ipaddr = 0.0.0.0 src_ipaddr = 192.168.0.1 port = 67 interface = eth0 broadcast = yes virtual_server = dhcp.eth0 } listen { type = dhcp ipaddr = 0.0.0.0 src_ipaddr = 192.168.1.1 port = 67 interface = eth1 broadcast = yes virtual_server = dhcp.eth1 } server dhcp.eth0 { dhcp DHCP-Discover { .... } server dhcp.eth1 { dhcp DHCP-Discover { .... } A listener per interface and a virtual_server for each interfaces. Regards Fabrice Le 2017-02-07 à 13:51, Nataniel Klug a écrit :
Hello again,
It didn't work in the way I tought it would be. I need to test the interface that the DHCP-Discover come from but I am not being able to make that happen. The DHCP-Discover come like this:
Received DHCP-Discover of Id f018203b from 0.0.0.0:68 to 255.255.255.255:67 0: 01 01 06 00 f0 18 20 3b 00 00 80 00 00 00 00 00 16: 00 00 00 00 00 00 00 00 00 00 00 00 00 50 56 b8 32: bb 95 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 01 37 06 01 79 03 21 06 2a 0c 08 4d 69 6b 256: 72 6f 54 69 6b 3d 07 01 00 50 56 b8 bb 95 ff 00 272: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 288: 00 00 00 00 00 00 00 00 00 00 00 00 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 4028112955 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:bb:95 DHCP-Message-Type = DHCP-Discover DHCP-Parameter-Request-List = DHCP-Subnet-Mask DHCP-Parameter-Request-List = DHCP-Classless-Static-Route DHCP-Parameter-Request-List = DHCP-Router-Address DHCP-Parameter-Request-List = DHCP-Static-Routes DHCP-Parameter-Request-List = DHCP-Domain-Name-Server DHCP-Parameter-Request-List = DHCP-NTP-Servers DHCP-Hostname = "MikroTik" DHCP-Client-Identifier = 0x01005056b8bb95
And for this request I need to send an specific pool and update info. This came from my eth2 interface. Any ideas?
Atenciosamente,
*Nataniel Klug* | nataniel.klug@gmail.com
2017-02-07 13:42 GMT-02:00 Nataniel Klug <nataniel.klug@gmail.com>:
Solved with an "if" statement:
if(DHCP-DHCP-Server-Identifier == 10.192.0.5) { update control { &Pool-Name := "dhcp_ftth" } } else { update control { &Pool-Name := "gestao" } }
Atenciosamente,
*Nataniel Klug* | nataniel.klug@gmail.com
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Fabrice! Thank you so much! It worked fine! Amazing... Atenciosamente, *Nataniel Klug* | nataniel.klug@gmail.com 2017-02-07 16:51 GMT-02:00 Nataniel Klug <nataniel.klug@gmail.com>:
Hello again,
It didn't work in the way I tought it would be. I need to test the interface that the DHCP-Discover come from but I am not being able to make that happen. The DHCP-Discover come like this:
Received DHCP-Discover of Id f018203b from 0.0.0.0:68 to 255.255.255.255:67 0: 01 01 06 00 f0 18 20 3b 00 00 80 00 00 00 00 00 16: 00 00 00 00 00 00 00 00 00 00 00 00 00 50 56 b8 32: bb 95 00 00 00 00 00 00 00 00 00 00 00 00 00 00 48: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 64: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 96: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 112: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 128: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 144: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 160: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 176: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 192: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 208: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 224: 00 00 00 00 00 00 00 00 00 00 00 00 63 82 53 63 240: 35 01 01 37 06 01 79 03 21 06 2a 0c 08 4d 69 6b 256: 72 6f 54 69 6b 3d 07 01 00 50 56 b8 bb 95 ff 00 272: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 288: 00 00 00 00 00 00 00 00 00 00 00 00 DHCP-Opcode = Client-Message DHCP-Hardware-Type = Ethernet DHCP-Hardware-Address-Length = 6 DHCP-Hop-Count = 0 DHCP-Transaction-Id = 4028112955 DHCP-Number-of-Seconds = 0 DHCP-Flags = Broadcast DHCP-Client-IP-Address = 0.0.0.0 DHCP-Your-IP-Address = 0.0.0.0 DHCP-Server-IP-Address = 0.0.0.0 DHCP-Gateway-IP-Address = 0.0.0.0 DHCP-Client-Hardware-Address = 00:50:56:b8:bb:95 DHCP-Message-Type = DHCP-Discover DHCP-Parameter-Request-List = DHCP-Subnet-Mask DHCP-Parameter-Request-List = DHCP-Classless-Static-Route DHCP-Parameter-Request-List = DHCP-Router-Address DHCP-Parameter-Request-List = DHCP-Static-Routes DHCP-Parameter-Request-List = DHCP-Domain-Name-Server DHCP-Parameter-Request-List = DHCP-NTP-Servers DHCP-Hostname = "MikroTik" DHCP-Client-Identifier = 0x01005056b8bb95
And for this request I need to send an specific pool and update info. This came from my eth2 interface. Any ideas?
Atenciosamente,
*Nataniel Klug* | nataniel.klug@gmail.com
2017-02-07 13:42 GMT-02:00 Nataniel Klug <nataniel.klug@gmail.com>:
Solved with an "if" statement:
if(DHCP-DHCP-Server-Identifier == 10.192.0.5) { update control { &Pool-Name := "dhcp_ftth" } } else { update control { &Pool-Name := "gestao" } }
Atenciosamente,
*Nataniel Klug* | nataniel.klug@gmail.com
participants (2)
-
Durand fabrice -
Nataniel Klug