Kea DHCP: Difference between revisions
(→Leases) |
|||
| Line 22: | Line 22: | ||
==IPv4 Reservations - Insert Statement== | ==IPv4 Reservations - Insert Statement== | ||
SELECT host_id,dhcp_identifier,dhcp4_subnet_id,ipv4_address,hostname FROM hosts; | SELECT host_id,dhcp_identifier,dhcp4_subnet_id,ipv4_address,hostname FROM hosts; | ||
START TRANSACTION; | START TRANSACTION; | ||
SET @ipv4_reservation='10. | SET @ipv4_reservation='10.1.70.11'; | ||
SET @hostname = ' | SET @hostname = 'windows-pc'; | ||
SET @identifier_type='hw-address'; | SET @identifier_type='hw-address'; | ||
SET @identifier_value=' | SET @identifier_value='be:ef:be:ef:be:ef'; | ||
SET @dhcp4_subnet_id=70; | SET @dhcp4_subnet_id=70; | ||
Revision as of 01:23, 2 March 2024
Links
- ISC-Kea
- https://kea.readthedocs.io/en/latest/arm/config.html
- Stork
- https://stork.readthedocs.io/en/v1.8.0/
- https://gitlab.isc.org/isc-projects/stork/-/wikis/Screenshots
Leases
Leases are stored in memfile, by default. But you can also have them written to a CSV file:
"lease-database": {
"type": "memfile", // write leases to memfile...
"persist": true,
"name": "/tmp/kea-leases4.csv", // ...but also write them to csv
"lfc-interval": 3600,
"max-row-errors": 100
},
MySQL Integration
To use host reservations from MySQL, you need to add the "hosts-database" section to the "Dhcp4" section of the config file. Subnet-Ids need to be defined in your subnet declarations, too.
IPv4 Reservations - Insert Statement
SELECT host_id,dhcp_identifier,dhcp4_subnet_id,ipv4_address,hostname FROM hosts;
START TRANSACTION;
SET @ipv4_reservation='10.1.70.11';
SET @hostname = 'windows-pc';
SET @identifier_type='hw-address';
SET @identifier_value='be:ef:be:ef:be:ef';
SET @dhcp4_subnet_id=70;
INSERT INTO hosts (dhcp_identifier,
dhcp_identifier_type,
dhcp4_subnet_id,
ipv4_address,
hostname)
VALUES (UNHEX(REPLACE(@identifier_value, ':', )),
(SELECT type FROM host_identifier_type WHERE name=@identifier_type),
@dhcp4_subnet_id,
INET_ATON(@ipv4_reservation),
@hostname);
COMMIT;
MySQL Performance Tuning
Configure in /etc/mysql/my.cnf:
[mysqld] innodb_flush_log_at_trx_commit=2
Control-Agent Commands
[ { "arguments": [ "build-report", "config-backend-pull", "config-get", "config-reload", "config-set", "config-test", "config-write", "dhcp-disable", "dhcp-enable", "ha-continue", "ha-heartbeat", "ha-maintenance-cancel", "ha-maintenance-notify", "ha-maintenance-start", "ha-reset", "ha-scopes", "ha-sync", "ha-sync-complete-notify", "lease4-add", "lease4-del", "lease4-get", "lease4-get-all", "lease4-get-by-client-id", "lease4-get-by-hostname", "lease4-get-by-hw-address", "lease4-get-page", "lease4-resend-ddns", "lease4-update", "lease4-wipe", "lease6-add", "lease6-bulk-apply", "lease6-del", "lease6-get", "lease6-get-all", "lease6-get-by-duid", "lease6-get-by-hostname", "lease6-get-page", "lease6-resend-ddns", "lease6-update", "lease6-wipe", "leases-reclaim", "libreload", "list-commands", "server-tag-get", "shutdown", "statistic-get", "statistic-get-all", "statistic-remove", "statistic-remove-all", "statistic-reset", "statistic-reset-all", "statistic-sample-age-set", "statistic-sample-age-set-all", "statistic-sample-count-set", "statistic-sample-count-set-all", "status-get", "version-get" ], "result": 0 } ]