[Kea-users] subnet and DHCP options for MySQL backend

[xbgmsharp]

Hello,

I'm trying to use MySQL as backend for DHCP, but I can't find 
documentation for this configuration. I've found how to compile and 
import tables ( http://kea.isc.org/docs/kea-guide.html ), but there's no 
documentation about how to configure a DHCP server for MySQL backend. I 
also setup some host reservation using the following wiki page, 
http://kea.isc.org/wiki/HostReservationsHowTo

I found in the mailing list a few samples and configure as below the 
lease-database and hosts-database. How do i configure a subnet and DHCP 
options for MySQL backend?

In the mysql schema, there is a dhcp4_options and dhcp_option_scope 
table.

INFO  [kea-dhcp4.dhcp4/19405] DHCP4_CONFIG_COMPLETE DHCPv4 server has 
completed configuration: no IPv4 subnets!; DDNS: disabled
INFO  [kea-dhcp4.dhcpsrv/19405] DHCPSRV_MYSQL_DB opening MySQL lease 
database: host=<host> name=<database> password=***** type=mysql 
universe=4 user=<user>
INFO  [kea-dhcp4.dhcpsrv/19405] DHCPSRV_MYSQL_HOST_DB opening MySQL 
hosts database: host=<host> name=<database> password=***** type=mysql 
universe=4 user=<user>

"Dhcp4":
{
   "interfaces-config": {
     "interfaces": [ "eth0" ]
   },

   "lease-database": {
     "type": "mysql",
     "host": "<host>",
     "user": "<user>",
     "password": "<password>",
     "name": "<database>"
   },

   "hosts-database": {
     "type": "mysql",
     "name": "<database>",
     "host": "<host>",
     "user": "<user>",
     "password": "<password>"
   }

}

Thanks