[Kea-users] Kea 1.6 Configuration Backend

[Victoria Risk]

The schema for the configuration backend is documented in the code, here: https://gitlab.isc.org/isc-projects/kea/blob/master/src/share/database/scripts/mysql/dhcpdb_create.mysql <https://gitlab.isc.org/isc-projects/kea/blob/master/src/share/database/scripts/mysql/dhcpdb_create.mysql>  We also have some related design documents in our public Gitlab - https://gitlab.isc.org/isc-projects/kea/wikis/designs/configuration-in-db-design <https://gitlab.isc.org/isc-projects/kea/wikis/designs/configuration-in-db-design>. 

So, a do-it-yourselfer can certainly populate the tables directly or develop their own system for modifying the tables. This is not recommended because, as Thomas pointed out, it is easy to screw things up directly modifying the database.  But, the feature enabling the configuration backend is open source, and you are welcome to modify the open source however you like for your deployment. 

We did just do a webinar on using the subscription CB-cmds hook library to manage the config backend. The recording is on the ISC channel at https://www.youtube.com/watch?v=gnVEO4ThE10 <https://www.youtube.com/watch?v=gnVEO4ThE10>. This is the way we recommend you manage the config backend.

Vicky

> On Sep 5, 2019, at 3:54 AM, Thomas Markwalder <tmark at isc.org> wrote:
> 
> Hello:
> 
> The Configuration Backend is a Kea Support Subscriber-level hook library which provides RESTful commands for managing the configuration elements.  It is described in the Administration Reference Manual here:
> 
> https://kea.readthedocs.io/en/v1_6_0/arm/hooks.html#cb-cmds-configuration-backend-commands <https://kea.readthedocs.io/en/v1_6_0/arm/hooks.html#cb-cmds-configuration-backend-commands>
> 
> We do not recommend (nor support) people directly manipulating the data in the our schema. The CB library provides application logic to make sure things stay sane and isolates users from future schema changes.
> 
> For more information on Kea support subscriptions, start here:
> 
> https://www.isc.org/kea/ <https://www.isc.org/kea/>
> 
> 
> Cheers,
> 
> Thomas Markwalder
> 
> On 9/5/19 4:41 AM, Cristian Lemnaru wrote:
>> Yes, a tutorial about this would be greatly appreciated.
>> 
>> CB sound delicious, but without data on how to populate the tables, ( and which tables ) , it's like  a beautiful car and no keys to it .
>> 
>> Cris
>> 
>> On 9/5/19 8:57 AM, Marc Boisis wrote:
>>> No in 1.6 we can declare subnet and global parameters in MYSQL : https://kea.readthedocs.io/en/v1_6_0/arm/config.html?highlight=workbench#kea-configuration-backend <https://kea.readthedocs.io/en/v1_6_0/arm/config.html?highlight=workbench#kea-configuration-backend>
>>> 
>>> But there is no doc like "INSERT new-subnet INTO ...
>>> 
>>>> On 5 Sep 2019, at 05:02, Klaus Steden <klausfiend at gmail.com <mailto:klausfiend at gmail.com>> wrote:
>>>> 
>>>> 
>>>> You want something like this:
>>>> 
>>>> {
>>>>   "Dhcp4":
>>>>   {
>>>>     ...
>>>> 
>>>> # Use MySQL lease database backend to store leases in a database.
>>>>   "lease-database": {
>>>>     "type": "mysql",
>>>>     "host": "__MYSQL_HOST__",
>>>>     "name": "__MYSQL_DB__",
>>>>     "user": "__MYSQL_USER__",
>>>>     "password": "__MYSQL_PASSWORD__"
>>>>   },
>>>> 
>>>> # Use MySQL hosts database backend to store reservations in a database.
>>>>   "hosts-database": {
>>>>     "type": "mysql",
>>>>     "host": "__MYSQL_HOST__",
>>>>     "name": "__MYSQL_DB__",
>>>>     "user": "__MYSQL_USER__",
>>>>     "password": "__MYSQL_PASSWORD__"
>>>>   },
>>>>   ...
>>>>   }
>>>> }
>>>> 
>>>> where the tokens are whatever your SQL credential/database parameters are.
>>>> 
>>>> hth,
>>>> Klaus
>>>> 
>>>> On Wed, Sep 4, 2019 at 3:39 AM Marc Boisis <marc.boisis at univ-lr.fr <mailto:marc.boisis at univ-lr.fr>> wrote:
>>>> 
>>>> Where can I find where to put dhcp4 parameters in mysql configuration backend ? (which table ? values...).
>>>> _______________________________________________
>>>> 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 <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 <https://lists.isc.org/mailman/listinfo/kea-users>
>> -- 
>> ----------------------------------------------------------------------
>> Cristian Lemnaru
>> GPON Engineer
>> RCS & RDS - Brasov Branch
>> Mobil : 0770056815
>> cristian.lemnaru at rcs-rds.ro <mailto:cristian.lemnaru at rcs-rds.ro>
>> ----------------------------------------------------------------------
>> Privileged/Confidential Information may be contained in this message. 
>> If you are not the addressee indicated in this message(or responsible 
>> for delivery of the message to such person),you may not copy or deliver 
>> this message to anyone. In such a case, you should destroy this message 
>> and kindly notify the sender by reply e-mail.
>> 
>> 
>> 
>> _______________________________________________
>> 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 <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

Victoria Risk
Product Manager
Internet Systems Consortium
vicky at isc.org





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20190905/41fb19eb/attachment.htm>