[Kea-users] 1.3.0 beta not working with mysql

[Thomas Markwalder]

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