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
[email protected]
https://lists.isc.org/mailman/listinfo/kea-users
_______________________________________________
Kea-users mailing list
[email protected]
https://lists.isc.org/mailman/listinfo/kea-users
