[Kea-users] 1.3.0 beta not working with mysql

[Bill Pye]

Hi 

Am I missing something that obvious and basic, do I need to create something in the lease table? 

Regards 

Bill 

> From: "Wlodek Wencel" <wlodek at isc.org>
> To: "kea-users" <kea-users at lists.isc.org>
> Sent: Thursday, 5 October, 2017 19:27:06
> Subject: Re: [Kea-users] 1.3.0 beta not working with mysql

> Hello,

> can you show us reservation you put into database?

> Wlodek

> On 05/10/2017 18:52, Bill Pye wrote:

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

>> _______________________________________________
>> Kea-users mailing list [ mailto:Kea-users at lists.isc.org |
>> Kea-users at lists.isc.org ] [ https://lists.isc.org/mailman/listinfo/kea-users |
>> https://lists.isc.org/mailman/listinfo/kea-users ]

> _______________________________________________
> Kea-users mailing list
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20171005/258a9303/attachment.htm>