[Kea-users] Kea 1.1.0, MySQL and client-id

[Marcin Siodelski]

On 09.01.2017 17:46, Olivier Français wrote:
> Hi,
>
> I've apply your patch, recompile and install : it doesn't work.
> My device get and IP, but not the reserved IP.
>
> To test my config, I try host reservation with hw-address : it works.
>
> The test config :
>
> {
>   "Dhcp4": {
>     "renew-timer": 60,
>     "rebind-timer": 120,
>     "expired-leases-processing": {
>       "hold-reclaimed-time": 3600,
>       "unwarned-reclaim-cycles": 5,
>       "max-reclaim-time": 250,
>       "max-reclaim-leases": 100,
>       "flush-reclaimed-timer-wait-time": 25,
>       "reclaim-timer-wait-time": 10
>     },
>     "valid-lifetime": 180,
>     "interfaces-config": {
>       "interfaces": [
>         "*"
>       ],
>       "dhcp-socket-type": "udp"
>     },
>     "option-def": [
>       
>     ],
>     "option-data": [
>       
>     ],
>     "subnet4": [
>       {
>         "pools": [
>           {
>             "pool": "192.168.1.5-192.168.1.10"
>           }
>         ],
>         "next-server": "",
>         "id": 1,
>         "subnet": "192.168.1.0\/24",
>         "option-data": [
>           
>         ]
>       }
>     ],
>     "hosts-database": {
>       "name": "kea",
>       "user": "kea",
>       "type": "postgresql",
>       "password": "***",
>       "host": "db"
>     },
>     "lease-database": {
>       "name": "kea",
>       "user": "kea",
>       "type": "postgresql",
>       "password": "***",
>       "host": "db"
>     }
>   }
> }
>
> Info in database (PG 9.4.10) :
>
> kea=> select * from lease4;
> -[ RECORD 1 ]--+-----------------------------
> address        | 3232235781
> hwaddr         | \xc8f9f9f79440
> client_id      | \x0073772d3235373431332d326b
> valid_lifetime | 180
> expire         | 2017-01-09 16:25:34+00
> subnet_id      | 1
> fqdn_fwd       | t
> fqdn_rev       | t
> hostname       | sw-257413-2k
> state          | 0
>
> kea=> select * from hosts;
> -[ RECORD 1 ]---------+-----------------------------
> host_id               | 5
> dhcp_identifier       | \x0073772d3235373431332d326b
> dhcp_identifier_type  | 3
> dhcp4_subnet_id       | 1
> dhcp6_subnet_id       |
> ipv4_address          | 3232235802
> hostname              |
> dhcp4_client_classes  |
> dhcp6_client_classes  |
> dhcp4_next_server     |
> dhcp4_server_hostname |
> dhcp4_boot_file_name  |
>  
> Maybe I've make a mistake, but I didn't see it.
> If you need more info, feel free
>

Please specify:

"host-reservation-identifiers": [ "circuit-id", "hw-address", "duid",
"client-id" ]

or simply:

"host-reservation-identifiers": [ "client-id" ]

if only using client ids in host reservations.

Marcin