Sample schema && queries for WiMAX MIP keys

diff --git a/raddb/sql/mysql/wimax.conf b/raddb/sql/mysql/wimax.conf
new file mode 100644 (file)
index 0000000..57a3b21
--- /dev/null
+++ b/raddb/sql/mysql/wimax.conf
@@ -0,0 +1,40 @@
+# -*- text -*-
+##
+## wimax.conf -- MySQL configuration for WiMAX keying
+##
+##     $Id$
+
+       # Safe characters list for sql queries. Everything else is replaced
+       # with their mime-encoded equivalents.
+       # The default list should be ok
+       #safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
+
+       #######################################################################
+       #  Query config:  Username
+       #######################################################################
+       # This is the username that will get substituted, escaped, and added
+       # as attribute 'SQL-User-Name'.  '%{SQL-User-Name}' should be used below
+       # everywhere a username substitution is needed so you you can be sure
+       # the username passed from the client is escaped properly.
+       #
+       #  Uncomment the next line, if you want the sql_user_name to mean:
+       #
+       #    Use Stripped-User-Name, if it's there.
+       #    Else use User-Name, if it's there,
+       #    Else use hard-coded string "DEFAULT" as the user name.
+       #sql_user_name = "%{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}}"
+       #
+       sql_user_name = "%{User-Name}"
+
+       #######################################################################
+       # Logging of WiMAX SPI -> key mappings
+       #######################################################################
+       # postauth_query                - Insert some info after authentication
+       #######################################################################
+
+       postauth_query = "INSERT INTO wimax \
+                          (username, authdate, spi, mipkey, lifetime) \
+                          VALUES ( \
+                          '%{User-Name}', '%S' \
+                          '%{%{reply:WiMAX-MN-hHA-MIP4-SPI}:-%{reply:WiMAX-MN-hHA-MIP6-SPI}}', \
+                          '%{%{reply:WiMAX-MN-hHA-MIP4-Key}:-%{reply:WiMAX-MN-hHA-MIP6-Key}}', '%{%{reply:Session-Timeout}:-86400}' )"

diff --git a/raddb/sql/mysql/wimax.sql b/raddb/sql/mysql/wimax.sql
new file mode 100644 (file)
index 0000000..7ea8dcf
--- /dev/null
+++ b/raddb/sql/mysql/wimax.sql
@@ -0,0 +1,16 @@
+#
+# WiMAX Table structure for table 'wimax',
+# which replaces the "radpostauth" table.
+#
+
+CREATE TABLE wimax (
+  id int(11) NOT NULL auto_increment,
+  username varchar(64) NOT NULL default '',
+  authdate timestamp(14) NOT NULL,
+  spi varchar(16) NOT NULL default '',
+  mipkey varchar(400) NOT NULL default '',
+  lifetime int(12) default NULL,
+  PRIMARY KEY  (id),
+  KEY username (username),
+  KEY spi (spi)
+) ;