<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>Am I missing something that obvious and basic, do I need to create something in the lease table? <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>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>"Wlodek Wencel" <wlodek@isc.org><br><b>To: </b>"kea-users" <kea-users@lists.isc.org><br><b>Sent: </b>Thursday, 5 October, 2017 19:27:06<br><b>Subject: </b>Re: [Kea-users] 1.3.0 beta not working with mysql<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;"><p>Hello,</p>
<p>can you show us reservation you put into database?</p>
<p>Wlodek<br>
</p>
<br>
<div class="moz-cite-prefix">On 05/10/2017 18:52, Bill Pye wrote:<br>
</div>
<blockquote cite="mid:1070090386.13043.1507222364015.JavaMail.zimbra@phoenix-systems.uk.com">
<div style="font-family: arial, helvetica, sans-serif; font-size:
12pt; color: #000000">
<div>Hi all<br>
</div>
<div><br>
</div>
<div>I'm having problems with the current beta not working with
a 'mysql' server, I've built this version against the current
MariaDB version (and the required devel versions) - all these
servers are CentOS7 (fully updated):<br>
</div>
<div><br>
</div>
<div>Installed Packages<br>
Name : MariaDB-server<br>
Arch : x86_64<br>
Version : 10.2.9<br>
Release : 1.el7.centos<br>
Size : 456 M<br>
Repo : installed<br>
Summary : MariaDB: a very fast and robust SQL database
server<br>
<br>
Installed Packages<br>
Name : MariaDB-devel<br>
Arch : x86_64<br>
Version : 10.2.9<br>
Release : 1.el7.centos<br>
Size : 39 M<br>
Repo : installed<br>
<br>
# Percona cluster<br>
<br>
dnf info Percona-XtraDB-cluster-57<br>
Using metadata from Wed Oct 4 11:54:00 2017<br>
</div>
<div><br>
</div>
<div>The database was created as per the documentation and all
the tables and stored procedures exist, this is a single
server. However when a machine requests an IP I'm seeing the
following errors in the log file:<br>
</div>
<div><br>
</div>
<div>2017-10-05 18:16:10.273 INFO [kea-dhcp4.dhcp4/24862]
DHCP4_STARTED Kea DHCPv4 server version 1.3.0-beta started<br>
<br>
2017-10-05 18:16:19.020 INFO [kea-dhcp4.leases/24862]
DHCP4_LEASE_ADVERT [hwtype=1 00:0c:29:bc:bc:18],
cid=[01:00:0c:29:bc:bc:18], tid=0x2c0f9a70: lease
192.168.1.160 will be advertised<br>
2017-10-05 18:16:19.021 INFO [kea-dhcp4.leases/24862]
DHCP4_LEASE_ADVERT [hwtype=1 00:0c:29:bc:bc:18],
cid=[01:00:0c:29:bc:bc:18], tid=0x2c0f9a70: lease
192.168.1.161 will be advertised<br>
2017-10-05 18:16:19.029 ERROR [kea-dhcp4.alloc-engine/24862]
ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 00:0c:29:bc:bc:18],
cid=[01:00:0c:29:bc:bc:18], tid=0xa6d4566b: error during
attempt to allocate an IPv4 address: unable to bind parameters
for <INSERT INTO lease4(address, hwaddr, client_id,
valid_lifetime, expire, subnet_id, fqdn_fwd, fqdn_rev,
hostname, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)>,
reason: (error code 0)<br>
</div>
<div><br>
</div>
<div>I'm also trying to get this working with a Percona XtraDB
cluster and having the same problem, this a a five server
cluster:<br>
</div>
<div><br>
</div>
<div>Installed Packages<br>
Name : Percona-XtraDB-Cluster-57<br>
Arch : x86_64<br>
Epoch : 0<br>
Version : 5.7.19<br>
Release : 29.22.1.el7<br>
Size : 0.0 <br>
Repo : @System<br>
From repo : percona-release-x86_64<br>
</div>
<div><br>
</div>
<div>2017-10-05 18:06:44.996 INFO [kea-dhcp4.leases/16988]
DHCP4_INIT_REBOOT [hwtype=1 00:0c:29:bc:bc:18],
cid=[01:00:0c:29:bc:bc:18], tid=0x9ddd43c: client is in
INIT-REBOOT state and requests address 192.168.1.161<br>
2017-10-05 18:06:52.548 INFO [kea-dhcp4.leases/16988]
DHCP4_INIT_REBOOT [hwtype=1 da:d9:a8:4c:30:9d],
cid=[01:da:d9:a8:4c:30:9d], tid=0x1299a707: client is in
INIT-REBOOT state and requests address 192.168.1.170<br>
2017-10-05 18:07:00.225 INFO [kea-dhcp4.leases/16988]
DHCP4_LEASE_ADVERT [hwtype=1 00:0c:29:bc:bc:18],
cid=[01:00:0c:29:bc:bc:18], tid=0x989c660b: lease
192.168.1.160 will be advertised<br>
2017-10-05 18:07:00.227 INFO [kea-dhcp4.leases/16988]
DHCP4_LEASE_ADVERT [hwtype=1 00:0c:29:bc:bc:18],
cid=[01:00:0c:29:bc:bc:18], tid=0x989c660b: lease
192.168.1.161 will be advertised<br>
2017-10-05 18:07:00.228 ERROR [kea-dhcp4.alloc-engine/16988]
ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 00:0c:29:bc:bc:18],
cid=[01:00:0c:29:bc:bc:18], tid=0xed6a4f7f: error during
attempt to allocate an IPv4 address: unable to bind parameters
for <INSERT INTO lease4(address, hwaddr, client_id,
valid_lifetime, expire, subnet_id, fqdn_fwd, fqdn_rev,
hostname, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)>,
reason: (error code 0)<br>
</div>
<div><br>
</div>
<div>In both of those cases on the cluster and the single server
the error messages just keep repeating. There is also nothing
in the leases table.<br>
</div>
<div><br>
</div>
<div>Does anyone currently use a DB for lease data? Is there any
more information I can provide about this problem? Is this
likely to be something I've missed in building kea? Kea 1.3
beta does work OK using a file for lease storage. :)<br>
</div>
<div><br>
</div>
<div>Regards<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Bill<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Kea-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Kea-users@lists.isc.org" target="_blank">Kea-users@lists.isc.org</a>
<a class="moz-txt-link-freetext" href="https://lists.isc.org/mailman/listinfo/kea-users" target="_blank">https://lists.isc.org/mailman/listinfo/kea-users</a>
</pre>
</blockquote>
<br>
<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>