[Kea-users] Kea server problem with MariaDB server

[Matija Turk]

Great thanks!

Real package name is default-libmysqlclient-dev.

On Wed, Oct 11, 2017 at 9:54 PM, Bill Pye <bill.pye at phoenix-systems.co.uk>
wrote:

> Hi
>
> I believe your missing package is now called default-mysqlclient-dev - it
> appears to have been renamed last year. Try that  and see if it fixes your
> problem.
>
>
> Regards
>
>
> Bill
>
> ------------------------------
>
> *From: *"Matija Turk" <mturk at ovis-software.com>
> *To: *"kea-users" <kea-users at lists.isc.org>
> *Sent: *Wednesday, 11 October, 2017 08:57:41
> *Subject: *[Kea-users] Kea server problem with MariaDB server
>
> Hi all,
> I've seen the problem I'm having described in thread "1.3.0 beta not
> working with mysql", but don't know how to reply to that thread.
>
> I'm running Debian 8 and 9 and trying to setup Kea 1.2 and 1.3 to work
> with Mysql/Maria. These are my observations, and I am able to do further
> tests as necessary.
>
> My config is working perfectly on Debian 9 with stock Kea 1.1 server and
> mysql and mariadb servers. I'm using both host reserveations and leases in
> mysql database.
>
> Problem is only when I'm compiling 1.2 stable or 1.3 beta from source.
> Error is the same as in beforementioned thread:
>
> ERROR [kea-dhcp4.alloc-engine/46030] ALLOC_ENGINE_V4_ALLOC_ERROR [hwtype=1
> 5c:35:3b:3f:2a:51],
> cid=[ff:3b:3f:2a:51:5c:35:3b:3f:2a:51], tid=0x364694e5: 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)
>
> The way to fix the problem is to install mysql-client and mysql-client-dev
> library through package manager instead mariadb before compiling kea. When
> this is done everything work even connecting to Mariadb and Mysql.
>
> My real issue is that on Debian 9 there is no mysql client library
> anymore, so it would be good to see why mariadb library is causing problems.
>
> Also,
>
> isc.lists.org gives NET::ERR_CERT_DATE_INVALID
>
> *Matija Turk*
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20171012/c9a919a0/attachment.htm>