aboutsummaryrefslogtreecommitdiffstats
path: root/notes
diff options
context:
space:
mode:
authorDavid M. Syzdek <syzdek@bindlebinaries.com>2019-05-28 11:08:55 -0800
committerDavid M. Syzdek <syzdek@bindlebinaries.com>2019-05-28 11:08:55 -0800
commit16349808c113e221d528e0951e6e10b5021f185e (patch)
tree2df195a3a5f39b576833f1493678ed55d2eba462 /notes
parent68c9da80ceb8adad2dff8703c7fb02c5a491340a (diff)
downloadscratchpad-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.sql3
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;