[Kea-users] kea-dhcp4 mysql lease - how to interpret it!

[Neil Briscoe]

Kea-1.0.0 on Ubuntu 16

MySQL (schema 5.0)

 

Currently running kea and the leases are working fine – handing out IP address as expected.

 

When I look in the MySQL DB for the leases, I can see that the lease4 table is being populated.

 

However, the address column isn’t an IP address (as I would expect) and the hwaddr is not a MAC address (as I would expect).

 

Is there something I am missing or should be using a different way to look at the IP vs MAC vs Hostname?

 

mysql> select * from lease4;

+-----------+--------+-------------+----------------+---------------------+-----------+----------+----------+-----------------+-------+

| address   | hwaddr | client_id   | valid_lifetime | expire              | subnet_id | fqdn_fwd | fqdn_rev | hostname        | state |

+-----------+--------+-------------+----------------+---------------------+-----------+----------+----------+-----------------+-------+

| 168059909 | g?6܆   | g?6܆       |            300 | 2017-09-12 19:11:50 |         1 |        0 |        0 | neil-ultrabook. |     0 |

| 171049482 | p????     | p????         |            300 | 2017-09-12 19:09:49 |         5 |        0 |        0 | WS1394.     |     0 |

| 171049483 | p????     | p????         |            300 | 2017-09-12 18:59:49 |         4 |        0 |        0 |                 |     2 |

| 171056451 | ????      |  sla-2,6161 |            300 | 2017-09-12 19:12:08 |        45 |        0 |        0 |                 |     0 |

+-----------+--------+-------------+----------------+---------------------+-----------+----------+----------+-----------------+-------+

4 rows in set (0.00 sec)

 

 

Neil Briscoe

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20170912/f6070818/attachment.htm>