mysqldhcp

KEA dhcp Mysql Backend


I have an issue with the new ISC DHCP, KEA, on the MySQL backend. I want to store leases in my DB, it works but some info are not stored.

I obtain this kind of entry in my DB :

+------------+--------+-----------+----------------+---------------------+-----------+----------+----------+----------+                
| address    | hwaddr | client_id | valid_lifetime | expire              | subnet_id | fqdn_fwd | fqdn_rev | hostname |              
+------------+--------+-----------+----------------+---------------------+-----------+----------+----------+----------+
| 3232236052 | '°     | NULL      |           4000 | 2015-07-22 08:54:32 |         1 |        0 |        0 |          │                 
+------------+--------+-----------+----------------+---------------------+-----------+----------+----------+----------+   

The address field is the IP adress in decimal, I checked and it's the good one. I didn't find how change the IP adress to IPv4 format and how store mac address in the hwaddr field in the KEA documentation.

If someone know how to do this I will be really grateful !

Thank you !


Solution

  • As per KEA documentation hwaddr field is VARBINARY. You should be able to see the value IP address and hwaddr using:

    SELECT INET_NTOA(address), HEX(hwaddr), lease4.* FROM lease4;