diff options
| -rw-r--r-- | notes/projects/radius/sql/ippool-demo.sql | 8 | ||||
| -rw-r--r-- | notes/projects/radius/sql/ippool-schema.sql | 4 |
2 files changed, 9 insertions, 3 deletions
diff --git a/notes/projects/radius/sql/ippool-demo.sql b/notes/projects/radius/sql/ippool-demo.sql index 20659e3..1ad6f22 100644 --- a/notes/projects/radius/sql/ippool-demo.sql +++ b/notes/projects/radius/sql/ippool-demo.sql | |||
| @@ -82,7 +82,13 @@ UPDATE ip | |||
| 82 | SET nasid = ( SELECT id FROM nas WHERE name LIKE 'br1.sol' ), | 82 | SET nasid = ( SELECT id FROM nas WHERE name LIKE 'br1.sol' ), |
| 83 | username = 'jdoe1@acsalaska.net', | 83 | username = 'jdoe1@acsalaska.net', |
| 84 | acctSession = 'qqasasdqweasdasdqqas' | 84 | acctSession = 'qqasasdqweasdasdqqas' |
| 85 | WHERE address = '209.193.4.9/32'; | 85 | WHERE address = '209.193.4.9/32'; |
| 86 | UPDATE ip | ||
| 87 | SET nasid = ( SELECT id FROM nas WHERE name LIKE 'br1.sol' ), | ||
| 88 | username = 'jdoe1@acsalaska.net', | ||
| 89 | acctSession = 'qqasasdqweasdasdqqas' | ||
| 90 | WHERE address = '209.193.4.9/32'; | ||
| 91 | |||
| 86 | 92 | ||
| 87 | SELECT ip_add_network( ipNetwork := '209.112.192.0/19' ); | 93 | SELECT ip_add_network( ipNetwork := '209.112.192.0/19' ); |
| 88 | SELECT ip_add_network( ipNetwork := '209.112.128.0/18' ); | 94 | SELECT ip_add_network( ipNetwork := '209.112.128.0/18' ); |
diff --git a/notes/projects/radius/sql/ippool-schema.sql b/notes/projects/radius/sql/ippool-schema.sql index f3e41b2..ee12658 100644 --- a/notes/projects/radius/sql/ippool-schema.sql +++ b/notes/projects/radius/sql/ippool-schema.sql | |||
| @@ -400,7 +400,7 @@ BEGIN | |||
| 400 | regionId | 400 | regionId |
| 401 | ) | 401 | ) |
| 402 | VALUES ( lower(nasName), | 402 | VALUES ( lower(nasName), |
| 403 | nasRegionId | 403 | nasRegionId |
| 404 | ) | 404 | ) |
| 405 | RETURNING id INTO returnId; | 405 | RETURNING id INTO returnId; |
| 406 | 406 | ||
| @@ -422,7 +422,7 @@ $$; | |||
| 422 | * regionName := 'Soldotna', | 422 | * regionName := 'Soldotna', |
| 423 | * netActive := FALSE, | 423 | * netActive := FALSE, |
| 424 | * netDesc := 'Lab IP Pool', | 424 | * netDesc := 'Lab IP Pool', |
| 425 | * addIpEntries := TRUE | 425 | * addIpEntries := TRUE |
| 426 | * ); | 426 | * ); |
| 427 | * | 427 | * |
| 428 | * netAddress | 428 | * netAddress |
