[Kea-users] MySQL Error

[Marcin Siodelski]

David,

Since you're currently running Kea 1.6.0, I should make it clear that
currently Stork works only with Kea versions 1.7.3 and later. This is
because it makes heavy use of the status-get control command which was
introduced in 1.7.3.

We're aware that it causes trouble for people running stable Kea 1.6.0.
The 1.7.x branch of Kea is a development/experimental branch and is
basically meant for testing rather than running in production. However,
please note that Stork is also on its early version and there are still
many things to be ironed out before we can fully support it. We're still
to make some decisions whether Kea 1.8.0 will be required to run Stork
or we will back port some necessary changes to 1.6.0 to work with Stork.
For now, I can merely recommend testing Stork with the latest Kea 1.7.8
release.

Also, you mentioned that you need Kea with MySQL backend to allow it
running with Stork. Could you clarify? Stork can also run with the Kea
servers using Memfile backend as the lease storage and a regular
configuration file (not neccessarily the Kea Config Backend).

Marcin


W dniu 29.05.2020 o 11:17, Pizu pisze:
> Seems i missed something from the docs :(
> 
> Thanks for your help.
> 
> I need to use mysql as I would like to use stork.
> 
> Regards,
> 
> David
> 
> On Fri, 29 May 2020 at 10:59, Marcin Siodelski <marcin at isc.org
> <mailto:marcin at isc.org>> wrote:
> 
>     Hello David,
> 
>     Thanks for using Kea and reporting your issue. Looking at the
>     configuration snippet you provided it seems you didn't provide a name
>     for the lease database. Perhaps you intended to use the memfile (rather
>     than mysql) lease backend?
> 
>     Kind Regards,
>     Marcin Siodelski
>     Sr. Software Engineer
>     ISC
> 
>     W dniu 29.05.2020 o 10:54, Pizu pisze:
>     > Hi,
>     >
>     > Am having an issue on the 1.6.0.
>     >
>     > error:
>     >
>     > 2020-05-29 10:43:54.629 ERROR [kea-dhcp4.dhcp4/2524]
>     > DHCP4_CONFIG_LOAD_FAIL configuration error using file:
>     > /usr/local/etc/kea/kea-dhcp4.conf, reason: Unable to open
>     database: must
>     > specify a name for the database
>     > 2020-05-29 10:43:54.630 ERROR [kea-dhcp4.dhcp4/2524] DHCP4_INIT_FAIL
>     > failed to initialize Kea server: configuration error using file
>     > '/usr/local/etc/kea/kea-dhcp4.conf': Unable to open database: must
>     > specify a name for the database
>     >
>     > database name is set however am having this error :( can someone help?
>     > please
>     >
>     > {
>     >
>     > "Dhcp4": {
>     >     "server-tag": "Zejtun KEA DHCPv4 server",
>     >     "config-control": {
>     >         "config-databases": [{
>     >             "type": "mysql",
>     >             "name": "keadbname",
>     >             "user": "keadbuser",
>     >             "password": "passwordhere",
>     >             "host": "localhost",
>     >             "port": 3306
>     >         }],
>     >         "config-fetch-wait-time": 20
>     >         },
>     >         "interfaces-config": {
>     >             "interfaces": [ "ens192"]
>     >
>     >     },
>     >
>     >
>     >     "lease-database": {
>     >         "type": "mysql",
>     >         "lfc-interval": 3600
>     >     },
>     >
>     >
>     > Regards,
>     >
>     > David
>     >
>     > _______________________________________________
>     > ISC funds the development of this software with paid support
>     subscriptions. Contact us at https://www.isc.org/contact/ for more
>     information.
>     >
>     > To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users.
>     >
>     > Kea-users mailing list
>     > Kea-users at lists.isc.org <mailto:Kea-users at lists.isc.org>
>     > https://lists.isc.org/mailman/listinfo/kea-users
>     >
>