<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hi all<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></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 data-mce-bogus="1"></div><div><br data-mce-bogus="1"></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 data-mce-bogus="1"></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 data-mce-bogus="1"></div><div><br data-mce-bogus="1"></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 data-mce-bogus="1"></div><div><br data-mce-bogus="1"></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 data-mce-bogus="1"></div><div><br data-mce-bogus="1"></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 data-mce-bogus="1"></div><div><br data-mce-bogus="1"></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 data-mce-bogus="1"></div><div><br data-mce-bogus="1"></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 data-mce-bogus="1"></div><div><br data-mce-bogus="1"></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 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 data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div></div></body></html>