diff options
| author | David M. Syzdek <syzdek@bindlebinaries.com> | 2019-05-28 11:08:55 -0800 |
|---|---|---|
| committer | David M. Syzdek <syzdek@bindlebinaries.com> | 2019-05-28 11:08:55 -0800 |
| commit | 16349808c113e221d528e0951e6e10b5021f185e (patch) | |
| tree | 2df195a3a5f39b576833f1493678ed55d2eba462 /notes | |
| parent | 68c9da80ceb8adad2dff8703c7fb02c5a491340a (diff) | |
| download | scratchpad-16349808c113e221d528e0951e6e10b5021f185e.tar.gz scratchpad-16349808c113e221d528e0951e6e10b5021f185e.tar.bz2 scratchpad-16349808c113e221d528e0951e6e10b5021f185e.tar.xz scratchpad-16349808c113e221d528e0951e6e10b5021f185e.zip | |
Updating ip_before_insert() to force /32 mask
Diffstat (limited to 'notes')
| -rw-r--r-- | notes/projects/radius/sql/ippool-schema.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/notes/projects/radius/sql/ippool-schema.sql b/notes/projects/radius/sql/ippool-schema.sql index 7348ca3..2baa8d3 100644 --- a/notes/projects/radius/sql/ippool-schema.sql +++ b/notes/projects/radius/sql/ippool-schema.sql | |||
| @@ -272,6 +272,9 @@ BEGIN | |||
| 272 | END IF; | 272 | END IF; |
| 273 | 273 | ||
| 274 | -- determines mask for single IP address | 274 | -- determines mask for single IP address |
| 275 | IF ( masklen(NEW.address) != 32 ) THEN | ||
| 276 | RAISE EXCEPTION 'only /32 addresses are supported'; | ||
| 277 | END IF; | ||
| 275 | IF ( family(NEW.address) != 4 ) THEN | 278 | IF ( family(NEW.address) != 4 ) THEN |
| 276 | RAISE EXCEPTION 'only IPv4 addresses are supported'; | 279 | RAISE EXCEPTION 'only IPv4 addresses are supported'; |
| 277 | END IF; | 280 | END IF; |
