<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
i try to give more.<br>
<br>
dhclient dhcpdebug:<br>
root@test:~# dhcpdump -i eth0 -h ^00:16:3e:c3:3a:d1<br>
TIME: 2014-09-21 07:50:55.133<br>
IP: 0.0.0.0 (0:16:3e:c3:3a:d1) > 255.255.255.255
(ff:ff:ff:ff:ff:ff)<br>
OP: 1 (BOOTPREQUEST)<br>
HTYPE: 1 (Ethernet)<br>
HLEN: 6<br>
HOPS: 0<br>
XID: a260ac3c<br>
SECS: 0<br>
FLAGS: 0<br>
CIADDR: 0.0.0.0<br>
YIADDR: 0.0.0.0<br>
SIADDR: 0.0.0.0<br>
GIADDR: 0.0.0.0<br>
CHADDR: 00:16:3e:c3:3a:d1:00:00:00:00:00:00:00:00:00:00<br>
SNAME: .<br>
FNAME: .<br>
OPTION: 53 ( 1) DHCP message type 1 (DHCPDISCOVER)<br>
OPTION: 50 ( 4) Request IP address 193.93.72.41<br>
OPTION: 12 ( 4) Host name test<br>
OPTION: 55 ( 13) Parameter Request List 1 (Subnet mask)<br>
28 (Broadcast address)<br>
2 (Time offset)<br>
3 (Routers)<br>
15 (Domainname)<br>
6 (DNS server)<br>
119 (Domain Search)<br>
12 (Host name)<br>
44 (NetBIOS name server)<br>
47 (NetBIOS scope)<br>
26 (Interface MTU)<br>
121 (Classless Static Route)<br>
42 (NTP servers)<br>
<br>
---------------------------------------------------------------------------<br>
<br>
TIME: 2014-09-21 07:50:55.134<br>
IP: 193.93.72.40 (0:16:3e:3d:bd:4f) > 193.93.72.41
(0:16:3e:c3:3a:d1)<br>
OP: 2 (BOOTPREPLY)<br>
HTYPE: 1 (Ethernet)<br>
HLEN: 6<br>
HOPS: 0<br>
XID: a260ac3c<br>
SECS: 0<br>
FLAGS: 0<br>
CIADDR: 0.0.0.0<br>
YIADDR: 193.93.72.41<br>
SIADDR: 193.93.72.40<br>
GIADDR: 0.0.0.0<br>
CHADDR: 00:16:3e:c3:3a:d1:00:00:00:00:00:00:00:00:00:00<br>
SNAME: .<br>
FNAME: .<br>
OPTION: 53 ( 1) DHCP message type 2 (DHCPOFFER)<br>
OPTION: 1 ( 4) Subnet mask 255.255.255.192<br>
OPTION: 3 ( 4) Routers 193.93.72.30<br>
OPTION: 6 ( 4) DNS server 193.93.72.10<br>
OPTION: 15 ( 11) Domainname radiolan.sk<br>
OPTION: 42 ( 4) NTP servers 193.93.72.11<br>
OPTION: 51 ( 4) IP address leasetime 600 (10m)<br>
OPTION: 54 ( 4) Server identifier 193.93.72.40<br>
---------------------------------------------------------------------------<br>
<br>
dhclient freeradius:<br>
Received DHCP-Discover of Id a260ac3c from 0.0.0.0:68 to
255.255.255.255:67<br>
DHCP-Opcode = Client-Message<br>
DHCP-Hardware-Type = Ethernet<br>
DHCP-Hardware-Address-Length = 6<br>
DHCP-Hop-Count = 0<br>
DHCP-Transaction-Id = 2724244540<br>
DHCP-Number-of-Seconds = 0<br>
DHCP-Flags = 0<br>
DHCP-Client-IP-Address = 0.0.0.0<br>
DHCP-Your-IP-Address = 0.0.0.0<br>
DHCP-Server-IP-Address = 0.0.0.0<br>
DHCP-Gateway-IP-Address = 0.0.0.0<br>
DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
DHCP-Message-Type += DHCP-Discover<br>
DHCP-Requested-IP-Address += 193.93.72.41<br>
DHCP-Hostname += 'test'<br>
DHCP-Parameter-Request-List += DHCP-Subnet-Mask<br>
DHCP-Parameter-Request-List += DHCP-Broadcast-Address<br>
DHCP-Parameter-Request-List += DHCP-Time-Offset<br>
DHCP-Parameter-Request-List += DHCP-Router-Address<br>
DHCP-Parameter-Request-List += DHCP-Domain-Name<br>
DHCP-Parameter-Request-List += DHCP-Domain-Name-Server<br>
DHCP-Parameter-Request-List += DHCP-Domain-Search<br>
DHCP-Parameter-Request-List += DHCP-Hostname<br>
DHCP-Parameter-Request-List += DHCP-NETBIOS-Name-Servers<br>
DHCP-Parameter-Request-List += DHCP-NETBIOS<br>
DHCP-Parameter-Request-List += DHCP-Interface-MTU-Size<br>
DHCP-Parameter-Request-List += DHCP-Classless-Static-Route<br>
DHCP-Parameter-Request-List += DHCP-NTP-Servers<br>
(1) Received packet from host 0.0.0.0 port 68 code=1025,
id=-1570722756, length=300<br>
(1) DHCP-Opcode = Client-Message<br>
(1) DHCP-Hardware-Type = Ethernet<br>
(1) DHCP-Hardware-Address-Length = 6<br>
(1) DHCP-Hop-Count = 0<br>
(1) DHCP-Transaction-Id = 2724244540<br>
(1) DHCP-Number-of-Seconds = 0<br>
(1) DHCP-Flags = 0<br>
(1) DHCP-Client-IP-Address = 0.0.0.0<br>
(1) DHCP-Your-IP-Address = 0.0.0.0<br>
(1) DHCP-Server-IP-Address = 0.0.0.0<br>
(1) DHCP-Gateway-IP-Address = 0.0.0.0<br>
(1) DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
(1) DHCP-Message-Type += DHCP-Discover<br>
(1) DHCP-Requested-IP-Address += 193.93.72.41<br>
(1) DHCP-Hostname += 'test'<br>
(1) DHCP-Parameter-Request-List += DHCP-Subnet-Mask<br>
(1) DHCP-Parameter-Request-List += DHCP-Broadcast-Address<br>
(1) DHCP-Parameter-Request-List += DHCP-Time-Offset<br>
(1) DHCP-Parameter-Request-List += DHCP-Router-Address<br>
(1) DHCP-Parameter-Request-List += DHCP-Domain-Name<br>
(1) DHCP-Parameter-Request-List += DHCP-Domain-Name-Server<br>
(1) DHCP-Parameter-Request-List += DHCP-Domain-Search<br>
(1) DHCP-Parameter-Request-List += DHCP-Hostname<br>
(1) DHCP-Parameter-Request-List += DHCP-NETBIOS-Name-Servers<br>
(1) DHCP-Parameter-Request-List += DHCP-NETBIOS<br>
(1) DHCP-Parameter-Request-List += DHCP-Interface-MTU-Size<br>
(1) DHCP-Parameter-Request-List += DHCP-Classless-Static-Route<br>
(1) DHCP-Parameter-Request-List += DHCP-NTP-Servers<br>
Trying sub-section dhcp DHCP-Discover {...}<br>
(1) dhcp DHCP-Discover {<br>
(1) update reply {<br>
(1) DHCP-Message-Type = DHCP-Offer<br>
(1) DHCP-NTP-Servers = 193.93.72.11<br>
(1) } # update reply = noop<br>
(1) update reply {<br>
(1) DHCP-Domain-Name-Server = 193.93.72.10<br>
(1) DHCP-Domain-Name-Server = 193.93.72.1<br>
(1) DHCP-IP-Address-Lease-Time = 600<br>
(1) DHCP-DHCP-Server-Identifier = 193.93.72.40<br>
(1) } # update reply = noop<br>
(1) sql : EXPAND %{DHCP-Client-Hardware-Address}<br>
(1) sql : --> 00:16:3e:c3:3a:d1<br>
(1) sql : SQL-User-Name set to '00:16:3e:c3:3a:d1'<br>
rlm_sql (sql): Reserved connection (4)<br>
(1) sql : EXPAND SELECT id, username, attribute, value, op FROM
radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id<br>
(1) sql : --> SELECT id, username, attribute, value, op FROM
radcheck WHERE username = '00:16:3e:c3:3a:d1' ORDER BY id<br>
rlm_sql (sql): Executing query: 'SELECT id, username, attribute,
value, op FROM radcheck WHERE username = '00:16:3e:c3:3a:d1' ORDER
BY id'<br>
(1) sql : User found in radcheck table<br>
(1) sql : Check items matched<br>
(1) sql : EXPAND SELECT id, username, attribute, value, op FROM
radreply WHERE username = '%{SQL-User-Name}' ORDER BY id<br>
(1) sql : --> SELECT id, username, attribute, value, op FROM
radreply WHERE username = '00:16:3e:c3:3a:d1' ORDER BY id<br>
rlm_sql (sql): Executing query: 'SELECT id, username, attribute,
value, op FROM radreply WHERE username = '00:16:3e:c3:3a:d1' ORDER
BY id'<br>
(1) sql : User found in radreply table<br>
(1) sql : EXPAND SELECT groupname FROM radusergroup WHERE username
= '%{SQL-User-Name}' ORDER BY priority<br>
(1) sql : --> SELECT groupname FROM radusergroup WHERE
username = '00:16:3e:c3:3a:d1' ORDER BY priority<br>
rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup
WHERE username = '00:16:3e:c3:3a:d1' ORDER BY priority'<br>
(1) sql : User not found in any groups<br>
rlm_sql (sql): Released connection (4)<br>
rlm_sql (sql): Closing connection (3): Hit idle_timeout, was idle
for 87 seconds<br>
rlm_sql (sql): You probably need to lower "min"<br>
rlm_sql_mysql: Socket destructor called, closing socket<br>
rlm_sql (sql): Closing connection (2): Hit idle_timeout, was idle
for 87 seconds<br>
rlm_sql (sql): You probably need to lower "min"<br>
rlm_sql_mysql: Socket destructor called, closing socket<br>
rlm_sql (sql): Closing connection (1): Hit idle_timeout, was idle
for 87 seconds<br>
rlm_sql (sql): You probably need to lower "min"<br>
rlm_sql_mysql: Socket destructor called, closing socket<br>
<br>
dhcpcd5 dhcpdebug:<br>
root@test:~# dhcpdump -i eth0 -h ^00:16:3e:c3:3a:d1<br>
TIME: 2014-09-21 07:55:21.853<br>
IP: 0.0.0.0 (0:16:3e:c3:3a:d1) > 255.255.255.255
(ff:ff:ff:ff:ff:ff)<br>
OP: 1 (BOOTPREQUEST)<br>
HTYPE: 1 (Ethernet)<br>
HLEN: 6<br>
HOPS: 0<br>
XID: 04e4059c<br>
SECS: 0<br>
FLAGS: 0<br>
CIADDR: 0.0.0.0<br>
YIADDR: 0.0.0.0<br>
SIADDR: 0.0.0.0<br>
GIADDR: 0.0.0.0<br>
CHADDR: 00:16:3e:c3:3a:d1:00:00:00:00:00:00:00:00:00:00<br>
SNAME: .<br>
FNAME: .<br>
OPTION: 53 ( 1) DHCP message type 1 (DHCPDISCOVER)<br>
OPTION: 57 ( 2) Maximum DHCP message size 1500<br>
OPTION: 60 ( 52) Vendor class identifier
dhcpcd-5.5.6:Linux-3.2.0-4-amd64:x86_64:GenuineIntel<br>
OPTION: 12 ( 4) Host name test<br>
OPTION: 55 ( 15) Parameter Request List 1 (Subnet mask)<br>
121 (Classless Static Route)<br>
33 (Static route)<br>
3 (Routers)<br>
6 (DNS server)<br>
12 (Host name)<br>
15 (Domainname)<br>
26 (Interface MTU)<br>
28 (Broadcast address)<br>
42 (NTP servers)<br>
51 (IP address leasetime)<br>
54 (Server identifier)<br>
58 (T1)<br>
59 (T2)<br>
119 (Domain Search)<br>
<br>
---------------------------------------------------------------------------<br>
<br>
TIME: 2014-09-21 07:55:21.861<br>
IP: 193.93.72.40 (0:16:3e:3d:bd:4f) > 193.93.72.41
(0:16:3e:c3:3a:d1)<br>
OP: 2 (BOOTPREPLY)<br>
HTYPE: 1 (Ethernet)<br>
HLEN: 6<br>
HOPS: 0<br>
XID: 04e4059c<br>
SECS: 0<br>
FLAGS: 0<br>
CIADDR: 0.0.0.0<br>
YIADDR: 193.93.72.41<br>
SIADDR: 193.93.72.40<br>
GIADDR: 0.0.0.0<br>
CHADDR: 00:16:3e:c3:3a:d1:00:00:00:00:00:00:00:00:00:00<br>
SNAME: .<br>
FNAME: .<br>
OPTION: 53 ( 1) DHCP message type 2 (DHCPOFFER)<br>
OPTION: 1 ( 4) Subnet mask 255.255.255.192<br>
OPTION: 3 ( 4) Routers 193.93.72.30<br>
OPTION: 6 ( 4) DNS server 193.93.72.10<br>
OPTION: 15 ( 11) Domainname radiolan.sk<br>
OPTION: 42 ( 4) NTP servers 193.93.72.11<br>
OPTION: 51 ( 4) IP address leasetime 600 (10m)<br>
OPTION: 54 ( 4) Server identifier 193.93.72.40<br>
OPTION: 57 ( 2) Maximum DHCP message size 1500<br>
---------------------------------------------------------------------------<br>
<br>
TIME: 2014-09-21 07:55:21.884<br>
IP: 0.0.0.0 (0:16:3e:c3:3a:d1) > 255.255.255.255
(ff:ff:ff:ff:ff:ff)<br>
OP: 1 (BOOTPREQUEST)<br>
HTYPE: 1 (Ethernet)<br>
HLEN: 6<br>
HOPS: 0<br>
XID: 04e4059c<br>
SECS: 0<br>
FLAGS: 0<br>
CIADDR: 0.0.0.0<br>
YIADDR: 0.0.0.0<br>
SIADDR: 0.0.0.0<br>
GIADDR: 0.0.0.0<br>
CHADDR: 00:16:3e:c3:3a:d1:00:00:00:00:00:00:00:00:00:00<br>
SNAME: .<br>
FNAME: .<br>
OPTION: 53 ( 1) DHCP message type 3 (DHCPREQUEST)<br>
OPTION: 50 ( 4) Request IP address 193.93.72.41<br>
OPTION: 54 ( 4) Server identifier 193.93.72.40<br>
OPTION: 57 ( 2) Maximum DHCP message size 1500<br>
OPTION: 60 ( 52) Vendor class identifier
dhcpcd-5.5.6:Linux-3.2.0-4-amd64:x86_64:GenuineIntel<br>
OPTION: 12 ( 4) Host name test<br>
OPTION: 55 ( 15) Parameter Request List 1 (Subnet mask)<br>
121 (Classless Static Route)<br>
33 (Static route)<br>
3 (Routers)<br>
6 (DNS server)<br>
12 (Host name)<br>
15 (Domainname)<br>
26 (Interface MTU)<br>
28 (Broadcast address)<br>
42 (NTP servers)<br>
51 (IP address leasetime)<br>
54 (Server identifier)<br>
58 (T1)<br>
59 (T2)<br>
119 (Domain Search)<br>
<br>
---------------------------------------------------------------------------<br>
<br>
TIME: 2014-09-21 07:55:21.890<br>
IP: 193.93.72.40 (0:16:3e:3d:bd:4f) > 193.93.72.41
(0:16:3e:c3:3a:d1)<br>
OP: 2 (BOOTPREPLY)<br>
HTYPE: 1 (Ethernet)<br>
HLEN: 6<br>
HOPS: 0<br>
XID: 04e4059c<br>
SECS: 0<br>
FLAGS: 0<br>
CIADDR: 0.0.0.0<br>
YIADDR: 193.93.72.41<br>
SIADDR: 193.93.72.40<br>
GIADDR: 0.0.0.0<br>
CHADDR: 00:16:3e:c3:3a:d1:00:00:00:00:00:00:00:00:00:00<br>
SNAME: .<br>
FNAME: .<br>
OPTION: 53 ( 1) DHCP message type 5 (DHCPACK)<br>
OPTION: 1 ( 4) Subnet mask 255.255.255.192<br>
OPTION: 3 ( 4) Routers 193.93.72.30<br>
OPTION: 6 ( 4) DNS server 193.93.72.10<br>
OPTION: 15 ( 11) Domainname radiolan.sk<br>
OPTION: 42 ( 4) NTP servers 193.93.72.11<br>
OPTION: 51 ( 4) IP address leasetime 600 (10m)<br>
OPTION: 54 ( 4) Server identifier 193.93.72.40<br>
OPTION: 57 ( 2) Maximum DHCP message size 1500<br>
---------------------------------------------------------------------------<br>
<br>
freeradius dhcpd5:<br>
Received DHCP-Discover of Id 04e4059c from 0.0.0.0:68 to
255.255.255.255:67<br>
DHCP-Opcode = Client-Message<br>
DHCP-Hardware-Type = Ethernet<br>
DHCP-Hardware-Address-Length = 6<br>
DHCP-Hop-Count = 0<br>
DHCP-Transaction-Id = 82052508<br>
DHCP-Number-of-Seconds = 0<br>
DHCP-Flags = 0<br>
DHCP-Client-IP-Address = 0.0.0.0<br>
DHCP-Your-IP-Address = 0.0.0.0<br>
DHCP-Server-IP-Address = 0.0.0.0<br>
DHCP-Gateway-IP-Address = 0.0.0.0<br>
DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
DHCP-Message-Type += DHCP-Discover<br>
DHCP-DHCP-Maximum-Msg-Size += 1500<br>
DHCP-Vendor-Class-Identifier +=
0x6468637063642d352e352e363a4c696e75782d332e322e302d342d616d6436343a7838365f36343a47656e75696e65496e74656c<br>
DHCP-Hostname += 'test'<br>
DHCP-Parameter-Request-List += DHCP-Subnet-Mask<br>
DHCP-Parameter-Request-List += DHCP-Classless-Static-Route<br>
DHCP-Parameter-Request-List += DHCP-Static-Routes<br>
DHCP-Parameter-Request-List += DHCP-Router-Address<br>
DHCP-Parameter-Request-List += DHCP-Domain-Name-Server<br>
DHCP-Parameter-Request-List += DHCP-Hostname<br>
DHCP-Parameter-Request-List += DHCP-Domain-Name<br>
DHCP-Parameter-Request-List += DHCP-Interface-MTU-Size<br>
DHCP-Parameter-Request-List += DHCP-Broadcast-Address<br>
DHCP-Parameter-Request-List += DHCP-NTP-Servers<br>
DHCP-Parameter-Request-List += DHCP-IP-Address-Lease-Time<br>
DHCP-Parameter-Request-List += DHCP-DHCP-Server-Identifier<br>
DHCP-Parameter-Request-List += DHCP-Renewal-Time<br>
DHCP-Parameter-Request-List += DHCP-Rebinding-Time<br>
DHCP-Parameter-Request-List += DHCP-Domain-Search<br>
(0) Received packet from host 0.0.0.0 port 68 code=1025,
id=82052508, length=325<br>
(0) DHCP-Opcode = Client-Message<br>
(0) DHCP-Hardware-Type = Ethernet<br>
(0) DHCP-Hardware-Address-Length = 6<br>
(0) DHCP-Hop-Count = 0<br>
(0) DHCP-Transaction-Id = 82052508<br>
(0) DHCP-Number-of-Seconds = 0<br>
(0) DHCP-Flags = 0<br>
(0) DHCP-Client-IP-Address = 0.0.0.0<br>
(0) DHCP-Your-IP-Address = 0.0.0.0<br>
(0) DHCP-Server-IP-Address = 0.0.0.0<br>
(0) DHCP-Gateway-IP-Address = 0.0.0.0<br>
(0) DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
(0) DHCP-Message-Type += DHCP-Discover<br>
(0) DHCP-DHCP-Maximum-Msg-Size += 1500<br>
(0) DHCP-Vendor-Class-Identifier +=
0x6468637063642d352e352e363a4c696e75782d332e322e302d342d616d6436343a7838365f36343a47656e75696e65496e74656c<br>
(0) DHCP-Hostname += 'test'<br>
(0) DHCP-Parameter-Request-List += DHCP-Subnet-Mask<br>
(0) DHCP-Parameter-Request-List += DHCP-Classless-Static-Route<br>
(0) DHCP-Parameter-Request-List += DHCP-Static-Routes<br>
(0) DHCP-Parameter-Request-List += DHCP-Router-Address<br>
(0) DHCP-Parameter-Request-List += DHCP-Domain-Name-Server<br>
(0) DHCP-Parameter-Request-List += DHCP-Hostname<br>
(0) DHCP-Parameter-Request-List += DHCP-Domain-Name<br>
(0) DHCP-Parameter-Request-List += DHCP-Interface-MTU-Size<br>
(0) DHCP-Parameter-Request-List += DHCP-Broadcast-Address<br>
(0) DHCP-Parameter-Request-List += DHCP-NTP-Servers<br>
(0) DHCP-Parameter-Request-List += DHCP-IP-Address-Lease-Time<br>
(0) DHCP-Parameter-Request-List += DHCP-DHCP-Server-Identifier<br>
(0) DHCP-Parameter-Request-List += DHCP-Renewal-Time<br>
(0) DHCP-Parameter-Request-List += DHCP-Rebinding-Time<br>
(0) DHCP-Parameter-Request-List += DHCP-Domain-Search<br>
Trying sub-section dhcp DHCP-Discover {...}<br>
(0) dhcp DHCP-Discover {<br>
(0) update reply {<br>
(0) DHCP-Message-Type = DHCP-Offer<br>
(0) DHCP-NTP-Servers = 193.93.72.11<br>
(0) } # update reply = noop<br>
(0) update reply {<br>
(0) DHCP-Domain-Name-Server = 193.93.72.10<br>
(0) DHCP-Domain-Name-Server = 193.93.72.1<br>
(0) DHCP-IP-Address-Lease-Time = 600<br>
(0) DHCP-DHCP-Server-Identifier = 193.93.72.40<br>
(0) } # update reply = noop<br>
(0) sql : EXPAND %{DHCP-Client-Hardware-Address}<br>
(0) sql : --> 00:16:3e:c3:3a:d1<br>
(0) sql : SQL-User-Name set to '00:16:3e:c3:3a:d1'<br>
rlm_sql (sql): Reserved connection (4)<br>
(0) sql : EXPAND SELECT id, username, attribute, value, op FROM
radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id<br>
(0) sql : --> SELECT id, username, attribute, value, op FROM
radcheck WHERE username = '00:16:3e:c3:3a:d1' ORDER BY id<br>
rlm_sql (sql): Executing query: 'SELECT id, username, attribute,
value, op FROM radcheck WHERE username = '00:16:3e:c3:3a:d1' ORDER
BY id'<br>
(0) sql : User found in radcheck table<br>
(0) sql : Check items matched<br>
(0) sql : EXPAND SELECT id, username, attribute, value, op FROM
radreply WHERE username = '%{SQL-User-Name}' ORDER BY id<br>
(0) sql : --> SELECT id, username, attribute, value, op FROM
radreply WHERE username = '00:16:3e:c3:3a:d1' ORDER BY id<br>
rlm_sql (sql): Executing query: 'SELECT id, username, attribute,
value, op FROM radreply WHERE username = '00:16:3e:c3:3a:d1' ORDER
BY id'<br>
(0) sql : User found in radreply table<br>
(0) sql : EXPAND SELECT groupname FROM radusergroup WHERE username
= '%{SQL-User-Name}' ORDER BY priority<br>
(0) sql : --> SELECT groupname FROM radusergroup WHERE
username = '00:16:3e:c3:3a:d1' ORDER BY priority<br>
rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup
WHERE username = '00:16:3e:c3:3a:d1' ORDER BY priority'<br>
(0) sql : User not found in any groups<br>
rlm_sql (sql): Released connection (4)<br>
(0) [sql.authorize] = ok<br>
(0) sql : EXPAND .query<br>
(0) sql : --> .query<br>
(0) sql : Using query template 'query'<br>
rlm_sql (sql): Reserved connection (4)<br>
(0) sql : EXPAND %{DHCP-Client-Hardware-Address}<br>
(0) sql : --> 00:16:3e:c3:3a:d1<br>
(0) sql : SQL-User-Name set to '00:16:3e:c3:3a:d1'<br>
(0) sql : EXPAND INSERT INTO radpostauth (username, pass, reply,
authdate) VALUES ( '%{SQL-User-Name}',
'%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}',
'%S')<br>
(0) sql : --> INSERT INTO radpostauth (username, pass, reply,
authdate) VALUES ( '00:16:3e:c3:3a:d1', '', '0', '2014-09-21
07:55:18')<br>
rlm_sql (sql): Executing query: 'INSERT INTO radpostauth (username,
pass, reply, authdate) VALUES ( '00:16:3e:c3:3a:d1', '', '0',
'2014-09-21 07:55:18')'<br>
rlm_sql (sql): Released connection (4)<br>
(0) [sql.post-auth] = ok<br>
(0) [ok] = ok<br>
(0) } # dhcp DHCP-Discover = ok<br>
(0) DHCP: Reply will be unicast to your-ip-address<br>
(0) Sending packet to host 193.93.72.41 port 68 code=1026,
id=82052508, length=0<br>
(0) DHCP-Message-Type = DHCP-Offer<br>
(0) DHCP-NTP-Servers = 193.93.72.11<br>
(0) DHCP-Domain-Name-Server = 193.93.72.10<br>
(0) DHCP-IP-Address-Lease-Time = 600<br>
(0) DHCP-DHCP-Server-Identifier = 193.93.72.40<br>
(0) DHCP-Your-IP-Address = 193.93.72.41<br>
(0) DHCP-Subnet-Mask = 255.255.255.192<br>
(0) DHCP-Router-Address = 193.93.72.30<br>
(0) DHCP-Domain-Name = 'radiolan.sk'<br>
(0) DHCP-DHCP-Maximum-Msg-Size = 1500<br>
(0) DHCP-Opcode = Server-Message<br>
(0) DHCP-Hardware-Type = Ethernet<br>
(0) DHCP-Hardware-Address-Length = 6<br>
(0) DHCP-Hop-Count = 0<br>
(0) DHCP-Transaction-Id = 82052508<br>
(0) DHCP-Flags = 0<br>
(0) DHCP-Client-IP-Address = 0.0.0.0<br>
(0) DHCP-Gateway-IP-Address = 0.0.0.0<br>
(0) DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
DHCP-Opcode = Server-Message<br>
DHCP-Hardware-Type = Ethernet<br>
DHCP-Hardware-Address-Length = 6<br>
DHCP-Hop-Count = 0<br>
DHCP-Transaction-Id = 82052508<br>
DHCP-Number-of-Seconds = 0<br>
DHCP-Flags = 0<br>
DHCP-Client-IP-Address = 0.0.0.0<br>
DHCP-Your-IP-Address = 193.93.72.41<br>
DHCP-Server-IP-Address = 193.93.72.40<br>
DHCP-Gateway-IP-Address = 0.0.0.0<br>
DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
DHCP-Server-Host-Name = ''<br>
DHCP-Boot-Filename = ''<br>
DHCP-Subnet-Mask = 255.255.255.192<br>
DHCP-Router-Address = 193.93.72.30<br>
DHCP-Domain-Name-Server = 193.93.72.10<br>
DHCP-Domain-Name = 'radiolan.sk'<br>
DHCP-NTP-Servers = 193.93.72.11<br>
DHCP-IP-Address-Lease-Time = 600<br>
DHCP-DHCP-Server-Identifier = 193.93.72.40<br>
DHCP-DHCP-Maximum-Msg-Size = 1500<br>
Sending DHCP-Offer Id 04e4059c from 193.93.72.40:67 to
193.93.72.41:68<br>
(0) Finished request<br>
Waking up in 0.3 seconds.<br>
Received DHCP-Request of Id 04e4059c from 0.0.0.0:68 to
255.255.255.255:67<br>
(0) Cleaning up request packet ID 82052508 with timestamp +10<br>
DHCP-Opcode = Client-Message<br>
DHCP-Hardware-Type = Ethernet<br>
DHCP-Hardware-Address-Length = 6<br>
DHCP-Hop-Count = 0<br>
DHCP-Transaction-Id = 82052508<br>
DHCP-Number-of-Seconds = 0<br>
DHCP-Flags = 0<br>
DHCP-Client-IP-Address = 0.0.0.0<br>
DHCP-Your-IP-Address = 0.0.0.0<br>
DHCP-Server-IP-Address = 0.0.0.0<br>
DHCP-Gateway-IP-Address = 0.0.0.0<br>
DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
DHCP-Message-Type += DHCP-Request<br>
DHCP-Requested-IP-Address += 193.93.72.41<br>
DHCP-DHCP-Server-Identifier += 193.93.72.40<br>
DHCP-DHCP-Maximum-Msg-Size += 1500<br>
DHCP-Vendor-Class-Identifier +=
0x6468637063642d352e352e363a4c696e75782d332e322e302d342d616d6436343a7838365f36343a47656e75696e65496e74656c<br>
DHCP-Hostname += 'test'<br>
DHCP-Parameter-Request-List += DHCP-Subnet-Mask<br>
DHCP-Parameter-Request-List += DHCP-Classless-Static-Route<br>
DHCP-Parameter-Request-List += DHCP-Static-Routes<br>
DHCP-Parameter-Request-List += DHCP-Router-Address<br>
DHCP-Parameter-Request-List += DHCP-Domain-Name-Server<br>
DHCP-Parameter-Request-List += DHCP-Hostname<br>
DHCP-Parameter-Request-List += DHCP-Domain-Name<br>
DHCP-Parameter-Request-List += DHCP-Interface-MTU-Size<br>
DHCP-Parameter-Request-List += DHCP-Broadcast-Address<br>
DHCP-Parameter-Request-List += DHCP-NTP-Servers<br>
DHCP-Parameter-Request-List += DHCP-IP-Address-Lease-Time<br>
DHCP-Parameter-Request-List += DHCP-DHCP-Server-Identifier<br>
DHCP-Parameter-Request-List += DHCP-Renewal-Time<br>
DHCP-Parameter-Request-List += DHCP-Rebinding-Time<br>
DHCP-Parameter-Request-List += DHCP-Domain-Search<br>
(1) Received packet from host 0.0.0.0 port 68 code=1027,
id=82052508, length=337<br>
(1) DHCP-Opcode = Client-Message<br>
(1) DHCP-Hardware-Type = Ethernet<br>
(1) DHCP-Hardware-Address-Length = 6<br>
(1) DHCP-Hop-Count = 0<br>
(1) DHCP-Transaction-Id = 82052508<br>
(1) DHCP-Number-of-Seconds = 0<br>
(1) DHCP-Flags = 0<br>
(1) DHCP-Client-IP-Address = 0.0.0.0<br>
(1) DHCP-Your-IP-Address = 0.0.0.0<br>
(1) DHCP-Server-IP-Address = 0.0.0.0<br>
(1) DHCP-Gateway-IP-Address = 0.0.0.0<br>
(1) DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
(1) DHCP-Message-Type += DHCP-Request<br>
(1) DHCP-Requested-IP-Address += 193.93.72.41<br>
(1) DHCP-DHCP-Server-Identifier += 193.93.72.40<br>
(1) DHCP-DHCP-Maximum-Msg-Size += 1500<br>
(1) DHCP-Vendor-Class-Identifier +=
0x6468637063642d352e352e363a4c696e75782d332e322e302d342d616d6436343a7838365f36343a47656e75696e65496e74656c<br>
(1) DHCP-Hostname += 'test'<br>
(1) DHCP-Parameter-Request-List += DHCP-Subnet-Mask<br>
(1) DHCP-Parameter-Request-List += DHCP-Classless-Static-Route<br>
(1) DHCP-Parameter-Request-List += DHCP-Static-Routes<br>
(1) DHCP-Parameter-Request-List += DHCP-Router-Address<br>
(1) DHCP-Parameter-Request-List += DHCP-Domain-Name-Server<br>
(1) DHCP-Parameter-Request-List += DHCP-Hostname<br>
(1) DHCP-Parameter-Request-List += DHCP-Domain-Name<br>
(1) DHCP-Parameter-Request-List += DHCP-Interface-MTU-Size<br>
(1) DHCP-Parameter-Request-List += DHCP-Broadcast-Address<br>
(1) DHCP-Parameter-Request-List += DHCP-NTP-Servers<br>
(1) DHCP-Parameter-Request-List += DHCP-IP-Address-Lease-Time<br>
(1) DHCP-Parameter-Request-List += DHCP-DHCP-Server-Identifier<br>
(1) DHCP-Parameter-Request-List += DHCP-Renewal-Time<br>
(1) DHCP-Parameter-Request-List += DHCP-Rebinding-Time<br>
(1) DHCP-Parameter-Request-List += DHCP-Domain-Search<br>
Trying sub-section dhcp DHCP-Request {...}<br>
(1) dhcp DHCP-Request {<br>
(1) update reply {<br>
(1) DHCP-Message-Type = DHCP-Ack<br>
(1) DHCP-NTP-Servers = 193.93.72.11<br>
(1) } # update reply = noop<br>
(1) update reply {<br>
(1) DHCP-Domain-Name-Server = 193.93.72.10<br>
(1) DHCP-Domain-Name-Server = 193.93.72.1<br>
(1) DHCP-IP-Address-Lease-Time = 600<br>
(1) DHCP-DHCP-Server-Identifier = 193.93.72.40<br>
(1) } # update reply = noop<br>
(1) sql : EXPAND %{DHCP-Client-Hardware-Address}<br>
(1) sql : --> 00:16:3e:c3:3a:d1<br>
(1) sql : SQL-User-Name set to '00:16:3e:c3:3a:d1'<br>
rlm_sql (sql): Reserved connection (4)<br>
(1) sql : EXPAND SELECT id, username, attribute, value, op FROM
radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id<br>
(1) sql : --> SELECT id, username, attribute, value, op FROM
radcheck WHERE username = '00:16:3e:c3:3a:d1' ORDER BY id<br>
rlm_sql (sql): Executing query: 'SELECT id, username, attribute,
value, op FROM radcheck WHERE username = '00:16:3e:c3:3a:d1' ORDER
BY id'<br>
(1) sql : User found in radcheck table<br>
(1) sql : Check items matched<br>
(1) sql : EXPAND SELECT id, username, attribute, value, op FROM
radreply WHERE username = '%{SQL-User-Name}' ORDER BY id<br>
(1) sql : --> SELECT id, username, attribute, value, op FROM
radreply WHERE username = '00:16:3e:c3:3a:d1' ORDER BY id<br>
rlm_sql (sql): Executing query: 'SELECT id, username, attribute,
value, op FROM radreply WHERE username = '00:16:3e:c3:3a:d1' ORDER
BY id'<br>
(1) sql : User found in radreply table<br>
(1) sql : EXPAND SELECT groupname FROM radusergroup WHERE username
= '%{SQL-User-Name}' ORDER BY priority<br>
(1) sql : --> SELECT groupname FROM radusergroup WHERE
username = '00:16:3e:c3:3a:d1' ORDER BY priority<br>
rlm_sql (sql): Executing query: 'SELECT groupname FROM radusergroup
WHERE username = '00:16:3e:c3:3a:d1' ORDER BY priority'<br>
(1) sql : User not found in any groups<br>
rlm_sql (sql): Released connection (4)<br>
(1) [sql.authorize] = ok<br>
(1) sql : EXPAND .query<br>
(1) sql : --> .query<br>
(1) sql : Using query template 'query'<br>
rlm_sql (sql): Reserved connection (4)<br>
(1) sql : EXPAND %{DHCP-Client-Hardware-Address}<br>
(1) sql : --> 00:16:3e:c3:3a:d1<br>
(1) sql : SQL-User-Name set to '00:16:3e:c3:3a:d1'<br>
(1) sql : EXPAND INSERT INTO radpostauth (username, pass, reply,
authdate) VALUES ( '%{SQL-User-Name}',
'%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}',
'%S')<br>
(1) sql : --> INSERT INTO radpostauth (username, pass, reply,
authdate) VALUES ( '00:16:3e:c3:3a:d1', '', '0', '2014-09-21
07:55:18')<br>
rlm_sql (sql): Executing query: 'INSERT INTO radpostauth (username,
pass, reply, authdate) VALUES ( '00:16:3e:c3:3a:d1', '', '0',
'2014-09-21 07:55:18')'<br>
rlm_sql (sql): Released connection (4)<br>
(1) [sql.post-auth] = ok<br>
(1) [ok] = ok<br>
(1) } # dhcp DHCP-Request = ok<br>
(1) DHCP: Reply will be unicast to your-ip-address<br>
(1) Sending packet to host 193.93.72.41 port 68 code=1029,
id=82052508, length=0<br>
(1) DHCP-Message-Type = DHCP-Ack<br>
(1) DHCP-NTP-Servers = 193.93.72.11<br>
(1) DHCP-Domain-Name-Server = 193.93.72.10<br>
(1) DHCP-IP-Address-Lease-Time = 600<br>
(1) DHCP-DHCP-Server-Identifier = 193.93.72.40<br>
(1) DHCP-Your-IP-Address = 193.93.72.41<br>
(1) DHCP-Subnet-Mask = 255.255.255.192<br>
(1) DHCP-Router-Address = 193.93.72.30<br>
(1) DHCP-Domain-Name = 'radiolan.sk'<br>
(1) DHCP-DHCP-Maximum-Msg-Size = 1500<br>
(1) DHCP-Opcode = Server-Message<br>
(1) DHCP-Hardware-Type = Ethernet<br>
(1) DHCP-Hardware-Address-Length = 6<br>
(1) DHCP-Hop-Count = 0<br>
(1) DHCP-Transaction-Id = 82052508<br>
(1) DHCP-Flags = 0<br>
(1) DHCP-Client-IP-Address = 0.0.0.0<br>
(1) DHCP-Gateway-IP-Address = 0.0.0.0<br>
(1) DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
DHCP-Opcode = Server-Message<br>
DHCP-Hardware-Type = Ethernet<br>
DHCP-Hardware-Address-Length = 6<br>
DHCP-Hop-Count = 0<br>
DHCP-Transaction-Id = 82052508<br>
DHCP-Number-of-Seconds = 0<br>
DHCP-Flags = 0<br>
DHCP-Client-IP-Address = 0.0.0.0<br>
DHCP-Your-IP-Address = 193.93.72.41<br>
DHCP-Server-IP-Address = 193.93.72.40<br>
DHCP-Gateway-IP-Address = 0.0.0.0<br>
DHCP-Client-Hardware-Address = 00:16:3e:c3:3a:d1<br>
DHCP-Server-Host-Name = ''<br>
DHCP-Boot-Filename = ''<br>
DHCP-Subnet-Mask = 255.255.255.192<br>
DHCP-Router-Address = 193.93.72.30<br>
DHCP-Domain-Name-Server = 193.93.72.10<br>
DHCP-Domain-Name = 'radiolan.sk'<br>
DHCP-NTP-Servers = 193.93.72.11<br>
DHCP-IP-Address-Lease-Time = 600<br>
DHCP-DHCP-Server-Identifier = 193.93.72.40<br>
DHCP-DHCP-Maximum-Msg-Size = 1500<br>
Sending DHCP-Ack Id 04e4059c from 193.93.72.40:67 to 193.93.72.41:68<br>
(1) Finished request<br>
Waking up in 0.3 seconds.<br>
Waking up in 4.6 seconds.<br>
(1) Cleaning up request packet ID 82052508 with timestamp +10<br>
Ready to process requests<br>
<br>
or please try to sugest me which debug is helpfull.<br>
<br>
Best regards bubulak<br>
<br>
<div class="moz-cite-prefix">On 21.09.2014 06:22, Arran Cudbard-Bell
wrote:<br>
</div>
<blockquote
cite="mid:5719E874-A549-4922-8709-5480E905E54B@freeradius.org"
type="cite">
<pre wrap="">
On 21 Sep 2014, at 00:04, Mike O'Connor <a class="moz-txt-link-rfc2396E" href="mailto:freeradius@pineview.net"><freeradius@pineview.net></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On 20/09/2014 11:56 pm, <a class="moz-txt-link-abbreviated" href="mailto:bubulak@radiolan.sk">bubulak@radiolan.sk</a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hi i trying to configure Freeradius 3.0.4 with DHCP server with
backend on Mysql DB and authorization against MAC adresses. Problem is
that this configuration don't work with standart dhclient only with
dhcpd5 (in debian 7.6).
</pre>
</blockquote>
<pre wrap="">Maybe I'm missing something but dhcpd is a the server and dhclient is a
client. Freeradius can only work with a dhcp server.
</pre>
</blockquote>
<pre wrap="">
Um, nope. FreeRADIUS should be able to work with DHCP clients and relays,
it implements quite a few of the DHCP RFCs and has a DHCP protocol
encode/decoder.
It can even parse out DHCP options from RADIUS attributes :)
Anyway OP hasn't provided any debugging from the client, so it's not really
possible to see what's going on.
Arran Cudbard-Bell <a class="moz-txt-link-rfc2396E" href="mailto:a.cudbardb@freeradius.org"><a.cudbardb@freeradius.org></a>
FreeRADIUS development team
FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></pre>
</blockquote>
<br>
</body>
</html>