[Kea-users] 1.3.0 beta not working with mysql

[Thomas Markwalder]

It's stored as an unsigned integer, so in theory it's max is
|4294967295.  Certainly much larger than 604800.  For grins, I used that
value on a machine running MySQL and it inserts leases just fine.

Using the unsigned int max value, though  blows up time calculations
which manifests itself as this error:

2017-10-06 13:29:57.202 ERROR [kea-dhcp4.alloc-engine/1888]
ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 08:00:27:99:72:be], cid=[no info],
tid=0x489a9: error during attempt to allocate an IPv4 address: Could not
create bind array from Lease4: 178.16.1.100, reason: Time value is too
large: 5802278292

Clearly different from your whose reason is (error code 0).


|On 10/6/17 12:37 PM, Bill Pye wrote:||
> Hi Thomas||
>
> An update on my 'problem' but let me start with a question - is there any maximum value for the "valid-lifetime" setting? I ask this because I've just noticed a slightly odd number set for that option and it was set as "604800", I can't imagine why I set it that high or if it was a typing error. I've set that to a more reasonable value of "86400" and restarted my kea 1.3 servers and pointed them to my Percona cluster, lo and behold they came up with no errors (all three of them). They're all sitting there responding to DHCP requests, to say I'm surprised is an understatement!
>
> I'll leave these running overnight and see what happens, is it worth upping the loglevel a bit? I currently have logging at "INFO" and a debug level of zero, which is the best for reasonably detailed info but doesn't flood the server?
>
>
> 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:
> _______________________________________________
> Kea-users mailing list
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users