aboutsummaryrefslogtreecommitdiffstats
path: root/notes/projects/radius/sql/ippool-demo.sql
diff options
context:
space:
mode:
Diffstat (limited to 'notes/projects/radius/sql/ippool-demo.sql')
-rw-r--r--notes/projects/radius/sql/ippool-demo.sql40
1 files changed, 24 insertions, 16 deletions
diff --git a/notes/projects/radius/sql/ippool-demo.sql b/notes/projects/radius/sql/ippool-demo.sql
index e6eb48a..3693c7a 100644
--- a/notes/projects/radius/sql/ippool-demo.sql
+++ b/notes/projects/radius/sql/ippool-demo.sql
@@ -41,7 +41,7 @@ SELECT netblock_add
41 poolName := 'DHCP', 41 poolName := 'DHCP',
42 regionName := 'Soldotna', 42 regionName := 'Soldotna',
43 netDesc := 'Reserved for engineering test accounts', 43 netDesc := 'Reserved for engineering test accounts',
44 netActive := FALSE 44 netAssignable := FALSE
45 ); 45 );
46SELECT netblock_add 46SELECT netblock_add
47 ( netAddress := '209.193.4.4/30', 47 ( netAddress := '209.193.4.4/30',
@@ -51,7 +51,8 @@ SELECT netblock_add
51-- 51--
52SELECT netblock_add 52SELECT netblock_add
53 ( netAddress := '209.193.4.16/28', 53 ( netAddress := '209.193.4.16/28',
54 poolName := 'DHCP' 54 poolName := 'PPPoE',
55 regionName := 'Soldotna'
55 ); 56 );
56SELECT netblock_add 57SELECT netblock_add
57 ( netAddress := '209.193.4.32/28', 58 ( netAddress := '209.193.4.32/28',
@@ -60,25 +61,34 @@ SELECT netblock_add
60 ); 61 );
61SELECT netblock_add 62SELECT netblock_add
62 ( netAddress := '209.193.4.48/28', 63 ( netAddress := '209.193.4.48/28',
63 poolName := 'DHCP', 64 poolName := 'PPPoE',
64 regionName := 'Fairbanks' 65 regionName := 'Anchorage'
66 );
67SELECT netblock_add
68 ( netAddress := '209.193.4.64/28',
69 poolName := 'DHCP'
70 );
71SELECT netblock_add
72 ( netAddress := '209.193.4.80/28',
73 poolName := 'PPPoE'
65 ); 74 );
66SELECT netblock_add 75SELECT netblock_add
67 ( netAddress := '209.193.4.64/26', 76 ( netAddress := '209.193.4.96/28',
68 poolName := 'DHCP', 77 poolName := 'DHCP',
69 netDesc := 'Reserved for documentation', 78 netAssignable := FALSE,
70 netActive := FALSE,
71 addIpEntries := FALSE 79 addIpEntries := FALSE
72 ); 80 );
73SELECT netblock_add 81SELECT netblock_add
74 ( netAddress := '209.193.4.128/26', 82 ( netAddress := '209.193.4.112/28',
75 poolName := 'PPPoE', 83 poolName := 'PPPoE',
76 regionName := 'Soldotna' 84 netAssignable := FALSE,
85 addIpEntries := FALSE
77 ); 86 );
78SELECT netblock_add 87SELECT netblock_add
79 ( netAddress := '209.193.4.192/26', 88 ( netAddress := '209.193.4.128/25',
80 poolName := 'PPPoE', 89 poolName := 'Reserved',
81 regionName := 'Anchorage' 90 netAssignable := FALSE,
91 addIpEntries := FALSE
82 ); 92 );
83 93
84 94
@@ -86,14 +96,12 @@ SELECT netblock_add
86SELECT ip_assign 96SELECT ip_assign
87 ( assignIp := '209.193.4.8/32', 97 ( assignIp := '209.193.4.8/32',
88 assignNas := 'br1.sol', 98 assignNas := 'br1.sol',
89 assignUser := 'jdoe8@example.net', 99 assignUser := 'jdoe8@example.net'
90 assignSess := 'aqaqqaasdqweaasdqa8'
91 ); 100 );
92SELECT ip_assign 101SELECT ip_assign
93 ( assignIp := '209.193.4.9/32', 102 ( assignIp := '209.193.4.9/32',
94 assignNas := 'br1.sol', 103 assignNas := 'br1.sol',
95 assignUser := 'jdoe9@aexample.net', 104 assignUser := 'jdoe9@aexample.net'
96 assignSess := 'qweadszcxqweasdzcx9'
97 ); 105 );
98SELECT ip_assign 106SELECT ip_assign
99 ( assignIp := '209.193.4.10/32', 107 ( assignIp := '209.193.4.10/32',