<div dir="ltr"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">Hi Kevin,</span><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">What version of mysql are you using? I have no problems with mysql 5.7 (client and server). Also, have you initialized the database?</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">Finally, I assume you are using version 1.1 because that it the only version available on Debian Apt... I am still trying to have the maintainer take more of my patches, and push the 1.3 packages to the testing repo, but it is not going well. If anyone knows the maintainer for this package, or has any advice about how to get more traction with the debian maintainer, I would be grateful. I have done a lot of work to patch the 1.1 package to become the 1.3 package, and I am using in my testing. But I would like to make this available to all. :)</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">Cheers,</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial">Jason</div><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Mar 19, 2018 at 9:22 AM, Thomas Markwalder <span dir="ltr"><<a href="mailto:tmark@isc.org" target="_blank">tmark@isc.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<tt>Hello Kevin:<br>
<br>
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.<br>
<br>
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):<br>
<br>
<br>
"Logging":<br>
{<br>
"loggers": [<br>
{<br>
"name": "kea-dhcp4",<br>
"output_options": [<br>
{<br>
"output": "stdout"<br>
}<br>
],<br>
"severity": "INFO",<br>
"debuglevel":99<br>
}<br>
]<br>
}<br>
<br>
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.<br>
<br>
<br>
<br>
Regards,<br>
<br>
Thomas Markwalder<br>
ISC Software Engineering<br>
<br>
<br>
</tt><div><div class="h5"><br>
<div class="m_7282488258640920344moz-cite-prefix">On 03/18/2018 06:02 PM, Kevin Olbrich
wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div dir="ltr">Hi,
<div><br>
</div>
<div>I set the following as my lease-db:</div>
<div><br>
</div>
<div>
<div> "lease-database": {</div>
<div> "type": "mysql",</div>
<div> "name": "dc_dhcp",</div>
<div> "host": "192.168.30.2",</div>
<div> "user": "dc_dhcp",</div>
<div> "password": "xxxxxxxxxxxxxx"</div>
<div># "type": "memfile",</div>
<div># "persist": true,</div>
<div># "name": "/tmp/kea-leases4.csv",</div>
<div># "lfc-interval": 1800</div>
<div> },</div>
</div>
<div><br>
</div>
<div>If I use MySQL, no lease is ever created. The server also
never answers any DHCP request.</div>
<div><br>
</div>
<div>Changing from mysql to memfile (commented out code above),
everything works fine.</div>
<div>No error is logged, "it just dont work" with mysql.</div>
<div><br>
</div>
<div>
<div>root@dhcp01:~# kea-dhcp4 -v</div>
<div>1.1.0</div>
</div>
<div><br>
</div>
<div>Debian Stretch, main repo.</div>
<div><br>
</div>
<div>Is this a known issue?</div>
<div><br>
</div>
<div>Kind regards,</div>
<div>Kevin</div>
</div>
<br>
<fieldset class="m_7282488258640920344mimeAttachmentHeader"></fieldset>
<br>
</div></div><span class=""><pre>______________________________<wbr>_________________
Kea-users mailing list
<a class="m_7282488258640920344moz-txt-link-abbreviated" href="mailto:Kea-users@lists.isc.org" target="_blank">Kea-users@lists.isc.org</a>
<a class="m_7282488258640920344moz-txt-link-freetext" href="https://lists.isc.org/mailman/listinfo/kea-users" target="_blank">https://lists.isc.org/mailman/<wbr>listinfo/kea-users</a>
</pre>
</span></blockquote>
<br>
</div>
<br>______________________________<wbr>_________________<br>
Kea-users mailing list<br>
<a href="mailto:Kea-users@lists.isc.org">Kea-users@lists.isc.org</a><br>
<a href="https://lists.isc.org/mailman/listinfo/kea-users" rel="noreferrer" target="_blank">https://lists.isc.org/mailman/<wbr>listinfo/kea-users</a><br>
<br></blockquote></div><br></div>