Skip to content

Instantly share code, notes, and snippets.

@towo
Created February 16, 2024 13:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save towo/4a1a738ff1da758713ecd1aa6fed0232 to your computer and use it in GitHub Desktop.
Save towo/4a1a738ff1da758713ecd1aa6fed0232 to your computer and use it in GitHub Desktop.
Adding entries to kea database with audit

ISC's Kea is gating "comfortable" database management for the configuration backend via a service subscription, so I'll gather what you need to add miscellaneous entries to the database.

At the end, there might be an importer.

start transaction;
set @timestamp = current_timestamp();
call createAuditRevisionDHCP4(@timestamp, $SERVER_TAG, 'Adding server', 0);
insert into dhcp4_server (tag, description, modification_ts) values ($SERVER_TAG, 'DHCP server name, fqdn, whatever', @timestamp);
commit;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment