diff options
Diffstat (limited to 'notes/projects/radius/sql/ippool.md')
| -rw-r--r-- | notes/projects/radius/sql/ippool.md | 14 |
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 | |||
| 12 | Files | 12 | Files |
| 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 | ||
| 23 | Initializing New Database | 24 | Initializing 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()`. |
