diff options
| author | David M. Syzdek <syzdek@bindlebinaries.com> | 2019-05-20 22:07:33 -0800 |
|---|---|---|
| committer | David M. Syzdek <syzdek@bindlebinaries.com> | 2019-05-20 22:07:33 -0800 |
| commit | 5185cbf5faf2763ceb0bf1dffb47a9b023ab2cf9 (patch) | |
| tree | 425833adca41332bf9fb3693ffb41f6641d43cfe /notes/projects/radius/sql/ippool-demo.sql | |
| parent | 5e50256fcdb96c6899fd5efd2dff5f824ae799a3 (diff) | |
| download | scratchpad-5185cbf5faf2763ceb0bf1dffb47a9b023ab2cf9.tar.gz scratchpad-5185cbf5faf2763ceb0bf1dffb47a9b023ab2cf9.tar.bz2 scratchpad-5185cbf5faf2763ceb0bf1dffb47a9b023ab2cf9.tar.xz scratchpad-5185cbf5faf2763ceb0bf1dffb47a9b023ab2cf9.zip | |
Checkpointing changes
Diffstat (limited to 'notes/projects/radius/sql/ippool-demo.sql')
| -rw-r--r-- | notes/projects/radius/sql/ippool-demo.sql | 40 |
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 | ); |
| 46 | SELECT netblock_add | 46 | SELECT 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 | -- |
| 52 | SELECT netblock_add | 52 | SELECT 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 | ); |
| 56 | SELECT netblock_add | 57 | SELECT 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 | ); |
| 61 | SELECT netblock_add | 62 | SELECT 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 | ); | ||
| 67 | SELECT netblock_add | ||
| 68 | ( netAddress := '209.193.4.64/28', | ||
| 69 | poolName := 'DHCP' | ||
| 70 | ); | ||
| 71 | SELECT netblock_add | ||
| 72 | ( netAddress := '209.193.4.80/28', | ||
| 73 | poolName := 'PPPoE' | ||
| 65 | ); | 74 | ); |
| 66 | SELECT netblock_add | 75 | SELECT 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 | ); |
| 73 | SELECT netblock_add | 81 | SELECT 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 | ); |
| 78 | SELECT netblock_add | 87 | SELECT 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 | |||
| 86 | SELECT ip_assign | 96 | SELECT 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 | ); |
| 92 | SELECT ip_assign | 101 | SELECT 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 | ); |
| 98 | SELECT ip_assign | 106 | SELECT ip_assign |
| 99 | ( assignIp := '209.193.4.10/32', | 107 | ( assignIp := '209.193.4.10/32', |