aboutsummaryrefslogtreecommitdiffstats
path: root/notes/projects/radius/sql/ippool.md
diff options
context:
space:
mode:
Diffstat (limited to 'notes/projects/radius/sql/ippool.md')
-rw-r--r--notes/projects/radius/sql/ippool.md14
1 files changed, 8 insertions, 6 deletions
diff --git a/notes/projects/radius/sql/ippool.md b/notes/projects/radius/sql/ippool.md
index d5c1223..ce39c38 100644
--- a/notes/projects/radius/sql/ippool.md
+++ b/notes/projects/radius/sql/ippool.md
@@ -12,12 +12,13 @@ Objectives
12Files 12Files
13---- 13----
14 14
15 * ippool.md - This file 15 * ippool.md - This file
16 * ippool-database.sql - Creates database 16 * ippool-database.sql - Creates database
17 * ippool-schema.sql - Creates database schema (tables, indexes, etc) 17 * ippool-schema.sql - Creates database schema (tables, indexes, etc)
18 * ippool-demo.sql - Loads demo data 18 * ippool-functions.sql - Creates end-user/end-application functions
19 * ippool-queries.sql - Common or useful queries 19 * ippool-demo.sql - Loads demo data
20 * radius-roles.sql - Common database roles for RADIUS 20 * ippool-queries.sql - Common or useful queries
21 * radius-roles.sql - Common database roles for RADIUS
21 22
22 23
23Initializing New Database 24Initializing New Database
@@ -31,6 +32,7 @@ Initializing New Database
31 32
32 psql -h raddbtest.prv.acsalaska.net -f ippool-database.sql 33 psql -h raddbtest.prv.acsalaska.net -f ippool-database.sql
33 psql -h raddbtest.prv.acsalaska.net -f ippool-schema.sql radius_ippool 34 psql -h raddbtest.prv.acsalaska.net -f ippool-schema.sql radius_ippool
35 psql -h raddbtest.prv.acsalaska.net -f ippool-functions.sql radius_ippool
34 36
35 * Create RADIUS pools using `pool_add()`. 37 * Create RADIUS pools using `pool_add()`.
36 * Create RADIUS regions using `region_add()`. 38 * Create RADIUS regions using `region_add()`.