[Kea-users] MySQL DB does not work when "lease-database" is set

[Thomas Markwalder]

Hello Kevin:

Kea is now up to version 1.3.0 with many new features added since 1.1.0 
so you may wish to consider upgrading.  However, Kea 1.1.0 should 
function using MySQL for lease storage.  Kea servers can emit a great 
deal of logging detail, provided you have it enabled.   With sufficient 
logging enabled, you should see some sort of response from Kea to client 
packets.  Even if Kea elects to drop a packet, you should still it's 
arrival logged and an explanation for why it was dropped.

I would suggest, as a starting point that you dial up the logging 
detail.  The following logger configuration will give you maximum output 
to stdout (for more information on logging please see the Logging 
chapter in the Kea Admin guide):


"Logging":
{
   "loggers": [
     {
       "name": "kea-dhcp4",
       "output_options": [
           {
             "output": "stdout"
           }
       ],
       "severity": "INFO",
       "debuglevel":99
     }
   ]
}

I have attached a log excerpt from a Kea 1.1.0 server I configured to 
use MySQL lease storage so you can see what to expect.



Regards,

Thomas Markwalder
ISC Software Engineering



On 03/18/2018 06:02 PM, Kevin Olbrich wrote:
> Hi,
>
> I set the following as my lease-db:
>
>   "lease-database": {
>     "type": "mysql",
>     "name": "dc_dhcp",
>     "host": "192.168.30.2",
>     "user": "dc_dhcp",
>     "password": "xxxxxxxxxxxxxx"
> #        "type": "memfile",
> #        "persist": true,
> #        "name": "/tmp/kea-leases4.csv",
> #        "lfc-interval": 1800
>   },
>
> If I use MySQL, no lease is ever created. The server also never 
> answers any DHCP request.
>
> Changing from mysql to memfile (commented out code above), everything 
> works fine.
> No error is logged, "it just dont work" with mysql.
>
> root at dhcp01:~# kea-dhcp4 -v
> 1.1.0
>
> Debian Stretch, main repo.
>
> Is this a known issue?
>
> Kind regards,
> Kevin
>
>
> _______________________________________________
> Kea-users mailing list
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20180319/20c1a2ca/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kea-dhcp4.log
Type: text/x-log
Size: 6542 bytes
Desc: not available
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20180319/20c1a2ca/attachment.bin>