[Kea-users] 1.3.0 beta not working with mysql

[Thomas Markwalder]

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