Hi Bill: Ok, thanks. I'm building out a Centos 7 VM with MariaDB. I personally have have tested 1.3 agains MySQL and Postgres. Not MariaDB though. I know the latter is "supposed to be binary replacement for MySQL" ... but sometimes reality is less than ideal ;).
Can you tell me if there is any substantial amount of time elapsing between server startup and the first client attempt? Thanks Thomas On 10/6/17 10:57 AM, Bill Pye wrote: > 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 _______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
