[Kea-users] MySQL Error

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[Kea-users] MySQL Error

Pizu
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
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] MySQL Error

Marcin Siodelski
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
> [hidden email]
> https://lists.isc.org/mailman/listinfo/kea-users
>

_______________________________________________
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
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] MySQL Error

Pizu
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 <[hidden email]> 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
> [hidden email]
> https://lists.isc.org/mailman/listinfo/kea-users
>


_______________________________________________
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
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [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 <[hidden email]
> <mailto:[hidden email]>> 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
>     > [hidden email] <mailto:[hidden email]>
>     > https://lists.isc.org/mailman/listinfo/kea-users
>     >
>

_______________________________________________
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
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users
Reply | Threaded
Open this post in threaded view
|

Re: [Kea-users] MySQL Error

Pizu
Hi,

Thanks again for your reply.

inline comments.

Regards,

David


On Fri, 29 May 2020 at 11:32, Marcin Siodelski <[hidden email]> wrote:
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.

For now we would like to work with the stable versions, I installed the 1.6.0 but willing to go to 1.6.2. 
We would like to have stork in order to have a GUI where we can manage the subnets rather then editing the config file manually since we we are going to have multiple servers.
 
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.


I understand now, I thought that i need a mysql backend in order to have the stork running together.
 
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 <[hidden email]
> <mailto:[hidden email]>> 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
>     > [hidden email] <mailto:[hidden email]>
>     > https://lists.isc.org/mailman/listinfo/kea-users
>     >
>


_______________________________________________
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
[hidden email]
https://lists.isc.org/mailman/listinfo/kea-users