<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hi <br></div><div><br data-mce-bogus="1"></div><div>I believe your missing package is now called default-mysqlclient-dev - it appears to have been renamed last year. Try that and see if it fixes your problem.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Regards<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Bill<br data-mce-bogus="1"></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Matija Turk" <mturk@ovis-software.com><br><b>To: </b>"kea-users" <kea-users@lists.isc.org><br><b>Sent: </b>Wednesday, 11 October, 2017 08:57:41<br><b>Subject: </b>[Kea-users] Kea server problem with MariaDB server<br></blockquote></div><div data-marker="__QUOTED_TEXT__"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><div dir="ltr">Hi all,<br><div>I've seen the problem I'm having described in thread "1.3.0 beta not working with mysql", but don't know how to reply to that thread.</div><br><div>I'm running Debian 8 and 9 and trying to setup Kea 1.2 and 1.3 to work with Mysql/Maria. These are my observations, and I am able to do further tests as necessary.</div><br><div>My config is working perfectly on Debian 9 with stock Kea 1.1 server and mysql and mariadb servers. I'm using both host reserveations and leases in mysql database.</div><br><div>Problem is only when I'm compiling 1.2 stable or 1.3 beta from source. Error is the same as in beforementioned thread:</div><br><div><div>ERROR [kea-dhcp4.alloc-engine/46030] ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 5c:35:3b:3f:2a:51], </div><div>cid=[ff:3b:3f:2a:51:5c:35:3b:3f:2a:51], tid=0x364694e5: error during attempt to allocate an IPv4 address: </div><div>unable to bind parameters for </div><div><INSERT INTO lease4(address, hwaddr, client_id, valid_lifetime, expire, subnet_id, fqdn_fwd, fqdn_rev, hostname, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)>, reason: (error code 0)</div></div><br><div>The way to fix the problem is to install mysql-client and mysql-client-dev library through package manager instead mariadb before compiling kea. When this is done everything work even connecting to Mariadb and Mysql.</div><br><div>My real issue is that on Debian 9 there is no mysql client library anymore, so it would be good to see why mariadb library is causing problems.</div><br><div>Also, </div><br><div><a href="http://isc.lists.org" target="_blank">isc.lists.org</a> gives <span style="color:rgb(100,100,100);font-family:"Segoe UI",Tahoma,sans-serif;font-size:13px;text-transform:uppercase;background-color:rgb(247,247,247)">NET::ERR_CERT_DATE_INVALID </span></div><div><div><div class="gmail_signature"><div dir="ltr"><p><span data-mce-style="font-family: arial,helvetica,sans-serif;" style="font-family: arial,helvetica,sans-serif;" face="arial, helvetica, sans-serif"><b><span style="font-size:9pt;color:rgb(81,81,81)" lang="EN-GB">Matija Turk</span></b><span style="font-size:9pt;color:rgb(81,81,81)" lang="EN-GB"><br></span></span><span style="color:black" lang="EN-GB"></span></p></div></div></div>
</div></div>
<br>_______________________________________________<br>Kea-users mailing list<br>Kea-users@lists.isc.org<br>https://lists.isc.org/mailman/listinfo/kea-users<br></blockquote></div></div></body></html>