This was just a quick check for obvious things, I have nor used database
backends. I am trying to learn because I see obvious advantages in my setting.
--
Best regards
Sten Carlsen
No improvements come from shouting:
"MALE BOVINE MANURE!!!"
> On 6 Jun 2019, at 18.24, Laurent Aubert (laaubert) <[email protected]> wrote:
>
> Thanks Sten for your reply.
>
> In our understanding the tool kea-admin lease-init, initialize the PostgresDB
> with the right schema defined for Kea
>
> The way data is stored in PostgresDB is defined by Kea schema, which is
> defined here:
> https://github.com/isc-projects/kea/blob/master/src/share/database/scripts/pgsql/dhcpdb_create.pgsql
>
> Where valid_lifetime is define as:
> valid_lifetime BIGINT,
>
> And according to PostgreSQL doc is:
> bigint 8 bytes large-range integer -9223372036854775808 to
> +9223372036854775807
>
> So is there a problem with the schema for PostgreSQL ?
>
> Thanks,
> Laurent.
>
> From: Kea-users <[email protected]> on behalf of Sten Carlsen
> <[email protected]>
> Date: Thursday, June 6, 2019 at 5:20 PM
> To: "[email protected]" <[email protected]>
> Subject: Re: [Kea-users] Infinite lease not stored in postgresql DB
>
>
>
> On 06/06/2019 13.02, Laurent Aubert (laaubert) wrote:
> Hi,
>
> We deployed KEA 1.5 with a postgresql DB without any issue. We have an
> application which asks for IP addresses with an infinite lease.
>
> When KEA receives the request, we see the following error:
>
> 2019-06-06 09:05:02.566 ERROR [kea-dhcp4.alloc-engine/259]
> ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1 00:00:00:00:00:00],
> cid=[ff:00:00:00:00:00:02:00:00:00:09:01:10:49:52:38:30:39:47:2d:4c:54:45:2d:47:41:2d:4b:39:02:0
> b:4a:4d:58:32:30:32:33:58:30:30:30], tid=0x8aed1f: error during attempt to
> allocate an IPv4 address: Could not create bind array from Lease4:
> 192.168.89.2, reason: Time value is too large: 5854779197
> How is your definition of the lease time field in the database? this value
> requires 33 bits to be stored.
>
>
> Everything works fine if we use csv file to store the leases instead of
> postgres.
> Yes, not limited by a fixed number of bits.
>
>
> Any idea why such leases can’t be stored in the DB ?
>
>
> Sten
>
_______________________________________________
Kea-users mailing list
[email protected]
https://lists.isc.org/mailman/listinfo/kea-users
