Add SQL auth reject test
authorPhilippe Wooding <philippe.wooding@networkradius.com>
Sun, 17 May 2015 15:10:18 +0000 (17:10 +0200)
committerAlan T. DeKok <aland@freeradius.org>
Tue, 2 Jun 2015 18:35:59 +0000 (14:35 -0400)
src/tests/modules/sql/reject.attrs [new file with mode: 0644]
src/tests/modules/sql/reject.unlang [new file with mode: 0644]
src/tests/modules/sql_mysql/reject.attrs [new symlink]
src/tests/modules/sql_mysql/reject.unlang [new symlink]
src/tests/modules/sql_postgresql/reject.attrs [new symlink]
src/tests/modules/sql_postgresql/reject.unlang [new symlink]
src/tests/modules/sql_sqlite/reject.attrs [new symlink]
src/tests/modules/sql_sqlite/reject.unlang [new symlink]

diff --git a/src/tests/modules/sql/reject.attrs b/src/tests/modules/sql/reject.attrs
new file mode 100644 (file)
index 0000000..dee0543
--- /dev/null
@@ -0,0 +1,12 @@
+#
+#  Input packet
+#
+User-Name = "foo"
+User-Password = "password"
+NAS-IP-Address = "1.2.3.4"
+
+#
+#  Expected answer
+#
+Response-Packet-Type == Access-Reject
+Reply-Message == "Authentication failed"
diff --git a/src/tests/modules/sql/reject.unlang b/src/tests/modules/sql/reject.unlang
new file mode 100644 (file)
index 0000000..22ef221
--- /dev/null
@@ -0,0 +1,39 @@
+#
+#  Clear out old data
+#
+update {
+       Tmp-String-0 := "%{sql:DELETE FROM radcheck WHERE username = 'foo'}"
+}
+if (!&Tmp-String-0) {
+       test_fail
+}
+
+update {
+       Tmp-String-0 := "%{sql:INSERT INTO radcheck (username, attribute, op, value) VALUES ('foo', 'NAS-IP-Address', '==', '1.2.3.4')}"
+}
+if (!&Tmp-String-0) {
+       test_fail
+}
+
+update {
+       Tmp-String-0 := "%{sql:INSERT INTO radcheck (username, attribute, op, value) VALUES ('foo', 'Cleartext-Password', ':=', 'wrong-password')}"
+}
+if (!&Tmp-String-0) {
+       test_fail
+}
+
+update {
+       Tmp-String-0 := "%{sql:DELETE FROM radreply WHERE username = 'foo'}"
+}
+if (!&Tmp-String-0) {
+       test_fail
+}
+
+update {
+       Tmp-String-0 := "%{sql:INSERT INTO radreply (username, attribute, op, value) VALUES ('foo', 'Reply-Message', ':=', 'Authentication failed')}"
+}
+if (!&Tmp-String-0) {
+       test_fail
+}
+
+sql
diff --git a/src/tests/modules/sql_mysql/reject.attrs b/src/tests/modules/sql_mysql/reject.attrs
new file mode 120000 (symlink)
index 0000000..71a187f
--- /dev/null
@@ -0,0 +1 @@
+../sql/reject.attrs
\ No newline at end of file
diff --git a/src/tests/modules/sql_mysql/reject.unlang b/src/tests/modules/sql_mysql/reject.unlang
new file mode 120000 (symlink)
index 0000000..379839f
--- /dev/null
@@ -0,0 +1 @@
+../sql/reject.unlang
\ No newline at end of file
diff --git a/src/tests/modules/sql_postgresql/reject.attrs b/src/tests/modules/sql_postgresql/reject.attrs
new file mode 120000 (symlink)
index 0000000..71a187f
--- /dev/null
@@ -0,0 +1 @@
+../sql/reject.attrs
\ No newline at end of file
diff --git a/src/tests/modules/sql_postgresql/reject.unlang b/src/tests/modules/sql_postgresql/reject.unlang
new file mode 120000 (symlink)
index 0000000..379839f
--- /dev/null
@@ -0,0 +1 @@
+../sql/reject.unlang
\ No newline at end of file
diff --git a/src/tests/modules/sql_sqlite/reject.attrs b/src/tests/modules/sql_sqlite/reject.attrs
new file mode 120000 (symlink)
index 0000000..71a187f
--- /dev/null
@@ -0,0 +1 @@
+../sql/reject.attrs
\ No newline at end of file
diff --git a/src/tests/modules/sql_sqlite/reject.unlang b/src/tests/modules/sql_sqlite/reject.unlang
new file mode 120000 (symlink)
index 0000000..379839f
--- /dev/null
@@ -0,0 +1 @@
+../sql/reject.unlang
\ No newline at end of file