From 8fa72acb206d15e239652dfd2eb73e1a30a442d6 Mon Sep 17 00:00:00 2001 From: "David M. Syzdek" Date: Tue, 14 May 2019 11:06:51 -0800 Subject: renaming readme file --- notes/projects/radius/sql/README.ippool.md | 53 ++++++++++++++++++++++++++++++ notes/projects/radius/sql/ippool.md | 53 ------------------------------ 2 files changed, 53 insertions(+), 53 deletions(-) create mode 100644 notes/projects/radius/sql/README.ippool.md delete mode 100644 notes/projects/radius/sql/ippool.md (limited to 'notes') diff --git a/notes/projects/radius/sql/README.ippool.md b/notes/projects/radius/sql/README.ippool.md new file mode 100644 index 0000000..871889a --- /dev/null +++ b/notes/projects/radius/sql/README.ippool.md @@ -0,0 +1,53 @@ + +IP Engineering RADIUS IP Pool Database +====================================== + +Objectives +---------- + + * Psuedo static IP addresses + * Per NAS Preference for geographic regions + * Ability to deavtivate/busy out specific netblocks + +Files +---- + + * README.ippool.md - This file + * ippool-database.sql - Creates database + * ippool-schema.sql - Creates database schema (tables, indexes, etc) + * ippool-functions.sql - Creates end-user/end-application functions + * ippool-demo.sql - Loads demo data + * ippool-queries.sql - Common or useful queries + * radius-roles.sql - Common database roles for RADIUS + + +Initializing New Database +------------------------- + + * Create base database roles for RADIUS, not not already created: + + psql -h raddbtest.prv.acsalaska.net -f radius-roles.sql + + * Create database and load schema: + + psql -h raddbtest.prv.acsalaska.net -f ippool-database.sql + psql -h raddbtest.prv.acsalaska.net -f ippool-schema.sql radius_ippool + psql -h raddbtest.prv.acsalaska.net -f ippool-functions.sql radius_ippool + + * Create RADIUS pools using `pool_add()`. + * Create RADIUS regions using `region_add()`. + * Create RADIUS NAS clients using `nas_add()`. + * Create network blocks using `netblock_add()`. + * Add IP addresses with `ip_add_network()` if `netblock_add()` was not called + with `addIpEntries := TRUE`. + +For examples of using the above functions, please read `ippool-demo.sql`. + + +Network Block Management +------------------------ + + + +IP Address Assignments +---------------------- diff --git a/notes/projects/radius/sql/ippool.md b/notes/projects/radius/sql/ippool.md deleted file mode 100644 index ce39c38..0000000 --- a/notes/projects/radius/sql/ippool.md +++ /dev/null @@ -1,53 +0,0 @@ - -IP Engineering RADIUS IP Pool Database -====================================== - -Objectives ----------- - - * Psuedo static IP addresses - * Per NAS Preference for geographic regions - * Ability to deavtivate/busy out specific netblocks - -Files ----- - - * ippool.md - This file - * ippool-database.sql - Creates database - * ippool-schema.sql - Creates database schema (tables, indexes, etc) - * ippool-functions.sql - Creates end-user/end-application functions - * ippool-demo.sql - Loads demo data - * ippool-queries.sql - Common or useful queries - * radius-roles.sql - Common database roles for RADIUS - - -Initializing New Database -------------------------- - - * Create base database roles for RADIUS, not not already created: - - psql -h raddbtest.prv.acsalaska.net -f radius-roles.sql - - * Create database and load schema: - - psql -h raddbtest.prv.acsalaska.net -f ippool-database.sql - psql -h raddbtest.prv.acsalaska.net -f ippool-schema.sql radius_ippool - psql -h raddbtest.prv.acsalaska.net -f ippool-functions.sql radius_ippool - - * Create RADIUS pools using `pool_add()`. - * Create RADIUS regions using `region_add()`. - * Create RADIUS NAS clients using `nas_add()`. - * Create network blocks using `netblock_add()`. - * Add IP addresses with `ip_add_network()` if `netblock_add()` was not called - with `addIpEntries := TRUE`. - -For examples of using the above functions, please read `ippool-demo.sql`. - - -Network Block Management ------------------------- - - - -IP Address Assignments ----------------------- -- cgit v1.2.3