[Kea-users] 1.3.0 beta not working with mysql

[Bill Pye]

Hi Thomas

One glaring omission, I'm afraid. I don't use the standard kernel on CentOS but this one from ELrepo: 4.13.4-1.el7.elrepo.x86_64 The kea 1.2 version that I built was using the standard centos7 repository and therefore the kernel that came with it, it's only in the last few months I've moved to the newer kernel. I mentioned earlier that kea 1.1 from the epel repo works on this server with the current kernel that I'm using.

The longest time between start kea and a client request is probably about ten minutes and just in case it matters, all the machines (apart from one workstation) are VMs either on ESXi or VMware Workstation. I've been doing these client tests with an openSUSE & a Win10 workstations on VMware workstation. 


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 17:16:15
> Subject: Re: [Kea-users] 1.3.0 beta not working with mysql

> 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" <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
>> _______________________________________________
>> 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