[Kea-users] 1.3.0 beta not working with mysql

[Bill Pye]

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" <tmark at isc.org>
> To: "kea-users" <kea-users at lists.isc.org>
> 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" <tmark at isc.org>
>>> To: "kea-users" <kea-users at lists.isc.org>
>>> 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
>>> Kea-users at lists.isc.org
>>> 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
> 
> 
> _______________________________________________
> Kea-users mailing list
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users