Hi Thomas Done that and built it on a CentOS7 server, installed it and pointed the DB to a single MariaDB server with the same results:
2017-10-06 16:51:48.304 ERROR [kea-dhcp4.alloc-engine/2899] ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 00:0c:29:bc:bc:18], cid=[01:00:0c:29:bc:bc:18], tid=0xf8e3db07: 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) Details off the build: kea-dhcp4 -V 1.3.0-beta tarball linked with: log4cplus 1.1.3 OpenSSL 1.0.2k-fips 26 Jan 2017 database: MySQL backend 5.1, library 10.2.9 PostgreSQL backend 3.1, library 90223 Memfile backend 2.0 If there is anything else you want me to try then just shout. Regards Bill ----- Original Message ----- > From: "Thomas Markwalder" <[email protected]> > To: "kea-users" <[email protected]> > Sent: Friday, 6 October, 2017 15:54:57 > Subject: Re: [Kea-users] 1.3.0 beta not working with mysql > Hey Bill: > > Sure, rather than try to use git apply, you can just make the alteration > by editing the file with any text editor. You would then need to rerun > make and make install. > > 1. Edit this file: <wherever you unrolled kea tar > ball>src/lib/dhcpsrv/mysql_connection.cc > > Change line 175 from this: > > const char *wait_time = "SET SESSION wait_timeout = 30 * 86400"; > > to this: > > const char *wait_time = "SET SESSION wait_timeout = 214000"; > > Save it, then rerun make and make install. > > Thanks, > > Thomas > > On 10/6/17 9:06 AM, Bill Pye wrote: >> Hi Thomas >> >> Yes, I'll give that a go but I'm afraid you'll have to give me the steps to >> apply it. >> >> >> Regards >> >> >> Bill >> >> ----- Original Message ----- >>> From: "Thomas Markwalder" <[email protected]> >>> To: "kea-users" <[email protected]> >>> Sent: Friday, 6 October, 2017 14:00:36 >>> Subject: Re: [Kea-users] 1.3.0 beta not working with mysql >>> Hi Bill: >>> >>> I've attached a test patch if you're willing. Per MariaDB the max >>> value for --wait-timeout is 2147483, and we are exceeding that. I'm >>> wondering if our attempt to set it is failing silently. The patch I >>> sent you attempts to set it to a number well under their max but much >>> larger than their default. >>> >>> Thanks, >>> >>> Thomas >>> >>> >>> >>> >>> _______________________________________________ >>> 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 > > > _______________________________________________ > 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
