diff options
| author | David M. Syzdek <syzdek@bindlebinaries.com> | 2019-05-09 14:53:09 -0800 |
|---|---|---|
| committer | David M. Syzdek <syzdek@bindlebinaries.com> | 2019-05-09 14:53:09 -0800 |
| commit | cba8d378bc150b269d50367fb42f0f249cb00682 (patch) | |
| tree | 33dc1ff9f6ad2b745ff8b1260d610362437de5eb /notes | |
| parent | b8ad5508cd2b6b7bcfb26d1374875b78c04bb1a6 (diff) | |
| download | scratchpad-cba8d378bc150b269d50367fb42f0f249cb00682.tar.gz scratchpad-cba8d378bc150b269d50367fb42f0f249cb00682.tar.bz2 scratchpad-cba8d378bc150b269d50367fb42f0f249cb00682.tar.xz scratchpad-cba8d378bc150b269d50367fb42f0f249cb00682.zip | |
updating demo data
Diffstat (limited to 'notes')
| -rw-r--r-- | notes/projects/radius/sql/ippool-demo.sql | 54 |
1 files changed, 34 insertions, 20 deletions
diff --git a/notes/projects/radius/sql/ippool-demo.sql b/notes/projects/radius/sql/ippool-demo.sql index 41fb90c..3875eed 100644 --- a/notes/projects/radius/sql/ippool-demo.sql +++ b/notes/projects/radius/sql/ippool-demo.sql | |||
| @@ -8,7 +8,7 @@ | |||
| 8 | */ | 8 | */ |
| 9 | 9 | ||
| 10 | 10 | ||
| 11 | SET ROLE radius_ippool; | 11 | SET ROLE radius; |
| 12 | 12 | ||
| 13 | 13 | ||
| 14 | -- create example pools | 14 | -- create example pools |
| @@ -34,37 +34,51 @@ SELECT nas_add( nasName := 'br1.sol', regionName := 'Soldotna' ); | |||
| 34 | SELECT netblock_add | 34 | SELECT netblock_add |
| 35 | ( netAddress := '209.193.4.0/28', | 35 | ( netAddress := '209.193.4.0/28', |
| 36 | poolName := 'DHCP', | 36 | poolName := 'DHCP', |
| 37 | regionName := 'Soldotna', | 37 | regionName := 'Soldotna' |
| 38 | netActive := TRUE, | ||
| 39 | addIpEntries := TRUE | ||
| 40 | ); | 38 | ); |
| 41 | SELECT netblock_add | 39 | SELECT netblock_add |
| 42 | ( netAddress := '209.193.4.0/29', | 40 | ( netAddress := '209.193.4.0/29', |
| 43 | poolName := 'DHCP', | 41 | poolName := 'DHCP', |
| 44 | regionName := 'Soldotna', | 42 | regionName := 'Soldotna', |
| 45 | netDesc := 'Reserved for engineering test accounts', | 43 | netDesc := 'Reserved for engineering test accounts', |
| 46 | netActive := FALSE, | 44 | netActive := FALSE |
| 47 | addIpEntries := TRUE | ||
| 48 | ); | 45 | ); |
| 49 | SELECT netblock_add | 46 | SELECT netblock_add |
| 50 | ( netAddress := '209.193.4.16/28', | 47 | ( netAddress := '209.193.4.4/30', |
| 51 | poolName := 'DHCP', | 48 | poolName := 'DHCP', |
| 52 | netActive := TRUE, | 49 | regionName := 'Soldotna' |
| 53 | addIpEntries := TRUE | 50 | ); |
| 51 | -- | ||
| 52 | SELECT netblock_add | ||
| 53 | ( netAddress := '209.193.4.16/28', | ||
| 54 | poolName := 'DHCP' | ||
| 54 | ); | 55 | ); |
| 55 | SELECT netblock_add | 56 | SELECT netblock_add |
| 56 | ( netAddress := '209.193.4.32/28', | 57 | ( netAddress := '209.193.4.32/28', |
| 57 | poolName := 'DHCP', | 58 | poolName := 'DHCP', |
| 58 | regionName := 'Anchorage', | 59 | regionName := 'Anchorage' |
| 59 | netActive := FALSE, | ||
| 60 | addIpEntries := TRUE | ||
| 61 | ); | 60 | ); |
| 62 | SELECT netblock_add | 61 | SELECT netblock_add |
| 63 | ( netAddress := '209.193.4.48/28', | 62 | ( netAddress := '209.193.4.48/28', |
| 64 | poolName := 'DHCP', | 63 | poolName := 'DHCP', |
| 65 | regionName := 'Fairbanks', | 64 | regionName := 'Fairbanks' |
| 65 | ); | ||
| 66 | SELECT netblock_add | ||
| 67 | ( netAddress := '209.193.4.64/26', | ||
| 68 | poolName := 'DHCP', | ||
| 69 | netDesc := 'Reserved for documentation', | ||
| 66 | netActive := FALSE, | 70 | netActive := FALSE, |
| 67 | addIpEntries := TRUE | 71 | addIpEntries := FALSE |
| 72 | ); | ||
| 73 | SELECT netblock_add | ||
| 74 | ( netAddress := '209.193.4.128/26', | ||
| 75 | poolName := 'PPPoE', | ||
| 76 | regionName := 'Soldotna' | ||
| 77 | ); | ||
| 78 | SELECT netblock_add | ||
| 79 | ( netAddress := '209.193.4.192/26', | ||
| 80 | poolName := 'PPPoE', | ||
| 81 | regionName := 'Anchorage' | ||
| 68 | ); | 82 | ); |
| 69 | 83 | ||
| 70 | 84 | ||
| @@ -72,34 +86,34 @@ SELECT netblock_add | |||
| 72 | SELECT ip_assign | 86 | SELECT ip_assign |
| 73 | ( assignIp := '209.193.4.8/32', | 87 | ( assignIp := '209.193.4.8/32', |
| 74 | assignNas := 'br1.sol', | 88 | assignNas := 'br1.sol', |
| 75 | assignUser := 'jdoe8@acsalaska.net', | 89 | assignUser := 'jdoe8@example.net', |
| 76 | assignSess := 'aqaqqaasdqweaasdqa8' | 90 | assignSess := 'aqaqqaasdqweaasdqa8' |
| 77 | ); | 91 | ); |
| 78 | SELECT ip_assign | 92 | SELECT ip_assign |
| 79 | ( assignIp := '209.193.4.9/32', | 93 | ( assignIp := '209.193.4.9/32', |
| 80 | assignNas := 'br1.sol', | 94 | assignNas := 'br1.sol', |
| 81 | assignUser := 'jdoe9@acsalaska.net', | 95 | assignUser := 'jdoe9@aexample.net', |
| 82 | assignSess := 'qweadszcxqweasdzcx9' | 96 | assignSess := 'qweadszcxqweasdzcx9' |
| 83 | ); | 97 | ); |
| 84 | SELECT ip_assign | 98 | SELECT ip_assign |
| 85 | ( assignIp := '209.193.4.10/32', | 99 | ( assignIp := '209.193.4.10/32', |
| 86 | assignNas := 'br1.sol', | 100 | assignNas := 'br1.sol', |
| 87 | assignUser := 'jdoe10@acsalaska.net' | 101 | assignUser := 'jdoe10@example.net' |
| 88 | ); | 102 | ); |
| 89 | SELECT ip_assign | 103 | SELECT ip_assign |
| 90 | ( assignIp := '209.193.4.11/32', | 104 | ( assignIp := '209.193.4.11/32', |
| 91 | assignNas := 'br1.sol', | 105 | assignNas := 'br1.sol', |
| 92 | assignUser := 'jdoe11@acsalaska.net' | 106 | assignUser := 'jdoe11@example.net' |
| 93 | ); | 107 | ); |
| 94 | SELECT ip_assign | 108 | SELECT ip_assign |
| 95 | ( assignIp := '209.193.4.12/32', | 109 | ( assignIp := '209.193.4.12/32', |
| 96 | assignNas := 'br1.sol', | 110 | assignNas := 'br1.sol', |
| 97 | assignUser := 'jdoe12@acsalaska.net' | 111 | assignUser := 'jdoe12@example.net' |
| 98 | ); | 112 | ); |
| 99 | SELECT ip_assign | 113 | SELECT ip_assign |
| 100 | ( assignIp := '209.193.4.13/32', | 114 | ( assignIp := '209.193.4.13/32', |
| 101 | assignNas := 'br1.sol', | 115 | assignNas := 'br1.sol', |
| 102 | assignUser := 'jdoe13@acsalaska.net' | 116 | assignUser := 'jdoe13@example.net' |
| 103 | ); | 117 | ); |
| 104 | 118 | ||
| 105 | 119 | ||