[Kea-users] 1.3.0 beta not working with mysql

[Wlodek Wencel]

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
> 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/4f811984/attachment.htm>