Hi, I use PostgreSQL for the database. Also, I've add a pool of ip in the subnet in case of wrong reservation. Kea doesn't respond to the cisco nexus, but it works for other devices.
...
{
"subnet":"10.106.0.0/23",
"next-server":"10.15.25.76",
"id":82,
"pools":[
{
"pool":"10.106.1.50 - 10.106.1.55"
}
],
"option-data":[
{
"data":"10.106.1.254",
"csv-format":true,
"name":"routers",
"space":"dhcp4",
"code":3
}
]
},
...
select * from hosts where host_id = 289;
-[ RECORD 1 ]---------+---------------
host_id | 289
dhcp_identifier | \x00a2eec66281
dhcp_identifier_type | 0
dhcp4_subnet_id | 82
dhcp6_subnet_id |
ipv4_address | 174719066
hostname | sw-818103-n3
dhcp4_client_classes |
dhcp6_client_classes |
dhcp4_next_server |
dhcp4_server_hostname | sw-818103-n3
dhcp4_boot_file_name |
--
Olivier Français
OVH SOC phy
[email protected]
On lun., 2017-05-15 at 12:16 +0200, Marcin Siodelski wrote:
> On 15.05.2017 10:56, Olivier Français wrote:
> > Hi,
> >
> > Yes, we use reservation in SQL database with mac address. We also add a
> > pool of IPs in the subnet.
> >
> >
>
> We have recently got similar report from another Kea user and it turned
> out to be the issue with a reservation for an option inserted into MySQL
> database.
>
> The way it should be done is:
>
> SET @dns_servers_option_code = 5;
> -- This option comprises one or multiple IPv4 addresses. --
> -- We insert option containing two IPv4 addresses: 192.0.2.1 and --
> -- 192.0.2.2 by concatenating hexadecimal representations of these --
> -- addresses and then converting the result into binary format. --
> SET @dns_servers_option_value =
> UNHEX(CONCAT(LPAD(HEX(INET_ATON('10.0.2.1')), 8, 0),
> LPAD(HEX(INET_ATON('10.0.2.2')), 8, 0)));
>
> INSERT INTO dhcp4_options (code, value, space, host_id, scope_id)
> VALUES (@dns_servers_option_code,
> @dns_servers_option_value,
> 'dhcp4',
> @inserted_host_id,
> (SELECT scope_id FROM dhcp_option_scope WHERE scope_name =
> @scope_name));
>
>
> You should pay attention to the use of LPAD() MySQL function which, in
> this example, guarantees that each IP address (10.0.2.1 and 10.0.2.2) is
> padded with a leading zeros if needed and is exactly 8 digits long. If
> you omit the LPAD() function some IP addresses will be truncated and the
> overall option length will be shorter. Kea will complain that the
> options are invalid.
>
> Please give it a try and let me know if you have further issues.
>
> Marcin Siodelski
> ISC
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
