aboutsummaryrefslogtreecommitdiffstats
path: root/src/libcharon/plugins/eap_simaka_sql/test.sql
diff options
context:
space:
mode:
authorMartin Willi <martin@revosec.ch>2010-06-02 15:55:58 +0200
committerMartin Willi <martin@revosec.ch>2010-06-02 15:59:44 +0200
commitd2c358742a975114b660c1743ce1561dd9f39a96 (patch)
treef8ff91af8102d50b3abdc218f6957e9e215c2f35 /src/libcharon/plugins/eap_simaka_sql/test.sql
parentc77f4b305e33116756478f42ca80a6b50ef6e253 (diff)
downloadstrongswan-d2c358742a975114b660c1743ce1561dd9f39a96.tar.bz2
strongswan-d2c358742a975114b660c1743ce1561dd9f39a96.tar.xz
Added a EAP-SIM/AKA backend reading triplets/quintuplets from a SQL database
Diffstat (limited to 'src/libcharon/plugins/eap_simaka_sql/test.sql')
-rw-r--r--src/libcharon/plugins/eap_simaka_sql/test.sql28
1 files changed, 28 insertions, 0 deletions
diff --git a/src/libcharon/plugins/eap_simaka_sql/test.sql b/src/libcharon/plugins/eap_simaka_sql/test.sql
new file mode 100644
index 000000000..0c5c22f39
--- /dev/null
+++ b/src/libcharon/plugins/eap_simaka_sql/test.sql
@@ -0,0 +1,28 @@
+DELETE FROM triplets;
+DELETE FROM quintuplets;
+
+INSERT INTO triplets
+ (id, use, rand, sres, kc) VALUES
+ ('moon@strongswan.org', 0,
+ X'00112233445566778899AABBCCDDEEFF', X'01234567', X'0123456789ABCDEF'
+ );
+INSERT INTO triplets
+ (id, use, rand, sres, kc) VALUES
+ ('moon@strongswan.org', 0,
+ X'112233445566778899AABBCCDDEEFF00', X'12345678', X'123456789ABCDEF0'
+ );
+INSERT INTO triplets
+ (id, use, rand, sres, kc) VALUES
+ ('moon@strongswan.org', 0,
+ X'2233445566778899AABBCCDDEEFF0011', X'23456789', X'23456789ABCDEF01'
+ );
+
+INSERT INTO quintuplets
+ (id, use, rand, autn, ck, ik, res) VALUES
+ ('moon@strongswan.org', 0,
+ X'00112233445566778899AABBCCDDEEFF',
+ X'112233445566778899AABBCCDDEEFF00',
+ X'2233445566778899AABBCCDDEEFF0011',
+ X'33445566778899AABBCCDDEEFF001122',
+ X'00112233445566778899'
+ );