Duly noted. We'll update the documentation. Thanks, Marcin
On 11.04.2016 13:25, Thomas Andersen wrote: > Hi Marcin, > > Thanks for the answer, it works now. :) > The subnet id was already correct. It was simply a matter of inserting > the mac correctly. > > A simple example like the one you gave me would be terrific in the > documentation. > > Br, > Thomas > > > > > On 11/04/16 13:03, "Marcin Siodelski" <[email protected]> wrote: > > > Hello Thomas, > > > > How about this: > > > > INSERT INTO hosts(dhcp_identifier, dhcp_identifier_type, > > dhcp4_subnet_id, dhcp6_subnet_id, ipv4_address, hostname) > > VALUES (UNHEX("010203040506"), 0, 1, 2, INET_ATON('192.0.2.1'), > > "super-host.isc.org."); > > > > > > where "010203040506" represents a MAC address by which you want to > > identify the host. > > > > Also, please note that the dhcp4_subnet_id is a DHCPv4 subnet identifier > > where the host belongs. This identifier can be explicitly assigned to a > > subnet where the host is connected through the Kea configuration file. > > If the identifier is not explicitly assigned to the subnet, it will be > > auto-generated, in which case it may cause the troubles with matching > > hosts in the database with a database. > > > > You may also consult the > > http://kea.isc.org/docs/kea-guide.html#ipv4-subnet-id > > > > Marcin Siodelski > > ISC > > > > On 11.04.2016 11:06, Thomas Andersen wrote: > >> Hi all, > >> > >> I have a bit of a problem with the host reservations in mysql. The > lease > >> ‘file’ is already in mysql, so that part do work. > >> > >> I can see from the log that is actually do connect to the DB > >> 2016-04-11 10:59:24.028 INFO [kea-dhcp4.dhcpsrv/30140] > >> DHCPSRV_MYSQL_HOST_DB opening MySQL hosts database: host=mysql > >> name=keadhcp password=***** type=mysql universe=4 user=dhcp > >> > >> > >> I think that the problem is how I insert the dhcp_identifier (mac > address). > >> > >> Can anyone send me an example on how to insert this value correct? > >> > >> Br, > >> Thomas > >> > >> > >> > >> > >> > >> _______________________________________________ > >> Kea-users mailing list > >> [email protected] > >> https://lists.isc.org/mailman/listinfo/kea-users > >> _______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
