[Kea-users] 1.3.0 beta not working with mysql

[Bill Pye]

Hi all 

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): 

Installed Packages 
Name : MariaDB-server 
Arch : x86_64 
Version : 10.2.9 
Release : 1.el7.centos 
Size : 456 M 
Repo : installed 
Summary : MariaDB: a very fast and robust SQL database server 

Installed Packages 
Name : MariaDB-devel 
Arch : x86_64 
Version : 10.2.9 
Release : 1.el7.centos 
Size : 39 M 
Repo : installed 

# Percona cluster 

dnf info Percona-XtraDB-cluster-57 
Using metadata from Wed Oct 4 11:54:00 2017 

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: 

2017-10-05 18:16:10.273 INFO [kea-dhcp4.dhcp4/24862] DHCP4_STARTED Kea DHCPv4 server version 1.3.0-beta started 

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 
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 
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) 

I'm also trying to get this working with a Percona XtraDB cluster and having the same problem, this a a five server cluster: 

Installed Packages 
Name : Percona-XtraDB-Cluster-57 
Arch : x86_64 
Epoch : 0 
Version : 5.7.19 
Release : 29.22.1.el7 
Size : 0.0 
Repo : @System 
>From repo : percona-release-x86_64 

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 
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 
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 
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 
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) 

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. 

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. :) 

Regards 


Bill 







-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20171005/eda49927/attachment.htm>