9a36c2c377b8381edefe36cffd6901150093325f
[strongswan.git] / testing / tests / sql / rw-rsa-keyid / hosts / dave / etc / ipsec.d / data.sql
1 /* Identities */
2
3 INSERT INTO identities (
4 type, data
5 ) VALUES ( /* dave@strongswan.org */
6 3, X'64617665407374726f6e677377616e2e6f7267'
7 );
8
9 INSERT INTO identities (
10 type, data
11 ) VALUES ( /* moon.strongswan.org */
12 2, X'6d6f6f6e2e7374726f6e677377616e2e6f7267'
13 );
14
15 INSERT INTO identities (
16 type, data
17 ) VALUES ( /* subjkey of dave@strongswan.org */
18 11, X'ee7f38daeea1b81a41777f78f2674be8439d8e0e'
19 );
20
21 INSERT INTO identities (
22 type, data
23 ) VALUES ( /* subjkey of moon.strongswan.org */
24 11, X'6a9c74d1f8897989f65a94e989f1fac3649d292e'
25 );
26
27 /* Certificates */
28
29 INSERT INTO certificates (
30 type, keytype, data
31 ) VALUES ( /* dave@strongswan.org */
32 6, 1, X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100c007f2536f0558e68345d3ef017a175b73434e797f9b97448e720a5985aea76cc0503b8d63b4e239af95db83db0af65f8360e9d941912c121215643a0af32188fc520413e81645ff8e2e623c9362be1b57649530bf54fdad6563106105ace949d7de2895a4771c237090aaa2567bd7d9b08b2ad09f63f61bba87d7462046e89fa4570cb3c8e4322220a737af48c31cd0ec2140f3723b94742c4a14232e1d409f6b53c18aaa63e693fa5d3d06808e948db8273563d33dbd9ac44ecfd71e60426570885898b3e5538767eaf4ef713719e7fd89b32e4e3f60d972ef1617437d4dba14af4691fb8ec275a78552bae9d8aaf71c3d42aca793ef0ad09e1af353daab750203010001'
33 );
34
35 INSERT INTO certificates (
36 type, keytype, data
37 ) VALUES ( /* moon.strongswan.org */
38 6, 1, X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100ca2f633dd4bbba0586215b15a0312f73f533124f0b339b9ae13bb648b02b4c468e0f01e630fbef92197b7708f5dbffea7e496286966d75acf13bd5e4377a1821d82de102eadf9963b489041a0b0f9f76b79e2150aa39020e3fa52a677dbb879c986291e4f1542fe2f0494e9c5c954d4faa75a17aa7b56652f1b16efbdcb46697f7d0b7f520bc990205365938d2cd31f2beed30e761a56c02d9dc82f0cdefc9d43447b6a98f7628aed2ac127a4a9504838f66e7517e5e0b0672c8165474bce689f73a6fc6e3c72b2c45498ddbbc0b17b04915606fe94f256cc777c42c534560ffbbe5aacdd944cc8db4d2abaf8a294af55b03a6a01a54d78430ab78389753c2870203010001'
39 );
40
41 INSERT INTO certificate_identity (
42 certificate, identity
43 ) VALUES (
44 1, 1
45 );
46
47 INSERT INTO certificate_identity (
48 certificate, identity
49 ) VALUES (
50 1, 3
51 );
52
53 INSERT INTO certificate_identity (
54 certificate, identity
55 ) VALUES (
56 2, 2
57 );
58
59 INSERT INTO certificate_identity (
60 certificate, identity
61 ) VALUES (
62 2, 4
63 );
64
65 /* Private Keys */
66
67 INSERT INTO private_keys (
68 type, data
69 ) VALUES ( /* key of dave@strongswan.org */
70 1, X'308204a50201000282010100c007f2536f0558e68345d3ef017a175b73434e797f9b97448e720a5985aea76cc0503b8d63b4e239af95db83db0af65f8360e9d941912c121215643a0af32188fc520413e81645ff8e2e623c9362be1b57649530bf54fdad6563106105ace949d7de2895a4771c237090aaa2567bd7d9b08b2ad09f63f61bba87d7462046e89fa4570cb3c8e4322220a737af48c31cd0ec2140f3723b94742c4a14232e1d409f6b53c18aaa63e693fa5d3d06808e948db8273563d33dbd9ac44ecfd71e60426570885898b3e5538767eaf4ef713719e7fd89b32e4e3f60d972ef1617437d4dba14af4691fb8ec275a78552bae9d8aaf71c3d42aca793ef0ad09e1af353daab750203010001028201010081e2de1d60f294f715c39d5e03f9b8e2ba4bc44099f77b917b67d76845eba48302714256982239021ba99918ce87d3ad3707ce248d1ccc5a4cb0fb61e7161c90b35a2637f0bb600d42f64cabfc64c58168d337b609344b81851a4471db8ce11e794c62d714af1bf13caa1d40408ef3a8e2a8bf04ed4a87a4a9be47f5becf3777d7254cf6ab0ff4f3e109235334796b030a1e03951a0ae64e224b3226a8e99174825eaa877efbc5cde0cd075687a9086f645654bda547f8927433f8eecd9ecfcb9b30ed6ff66bb4e5b7341f9626095798e279338e554045d0ae3ee94a1f10644ad88f10e7e7199923d45d5f8df2283859c3f4c41262426e654a04e895a21bb40102818100ea2e632ed6d314655c64eb6a18d4f492fea379ca091426bd7f381f1cbd7f1f79b73d694b9538ec693b245992f6a2a1b292279db9698eac40e43df3aa83b682ca5ab60ed07d02692e16c65cba91ee9aa9f768db2be9a1e0a213a93651a6886dcd35aa3f116ea73287a39a830cc2779bc02b9c8566c4cf8cd25ce99fa030ab965502818100d1ec351dafa33fff13a64c4a980a6f697735e705c1dc2a410b738210f4c059cd058579e4324d46e5bb0c1e6df4476d1a00206f66cf1be23645db193c69cbd04539f87e2b3f4617046031a1575a16a8e71b998844df2601d9d67958421f75c19943f53857b56a08583320b48a85def15b75c9ac5e4a232363824ab666b60ca0a102818100879dbf8083960fccb75a165f05ec658aaefe7aec3e9fb5e3adc611767263291632c0d4b699bf3261aa875d7c576a4d5bfd7a05c4375611792ef495a4dccc182819aa2f201c15065653882271454bb9b3ce7ca1d8675f80983bec95716990be8dc593471cd048f1614da4905a1650701934e85af4edeb083156ef50aad324bb5502818100814232ca9eb5a4d8499f2266e40bb8e275f708d3b0b502879ea777353d9f9b2bf4f46543affd896437b294a21bc24759b52e43aa4868e0f78e3804e80034f17f4edcc5c397686f0fd0b37ea72cdfbb0ce31fbc9abbd4c95afb0728e33e3fe1ff9faac510acb2278537a631c501fd6f1c6400d45412ce642207be3d662d3ec54102818055a928e09d9801f683ebb625e6ed97396ac1cd55b358d7aa06c8801759c2a51d517de1f88c537f532fea6cf563766d7818dc1de70b48d31c0102cad3562b7bf03a310b631428c22eabdc5555a90a5fc5310660a795d916ba1b57c09587f697d09dc092ac469e71f0e42fc6153c35ffe177898ea1e92aa6f28d3b86bfe30ad58c'
71 );
72
73 INSERT INTO private_key_identity (
74 private_key, identity
75 ) VALUES (
76 1, 1
77 );
78
79 INSERT INTO private_key_identity (
80 private_key, identity
81 ) VALUES (
82 1, 3
83 );
84
85 /* Configurations */
86
87 INSERT INTO ike_configs (
88 local, remote
89 ) VALUES (
90 'PH_IP_DAVE', 'PH_IP_MOON'
91 );
92
93 INSERT INTO peer_configs (
94 name, ike_cfg, local_id, remote_id
95 ) VALUES (
96 'home', 1, 3, 4
97 );
98
99 INSERT INTO child_configs (
100 name, updown
101 ) VALUES (
102 'home', 'ipsec _updown iptables'
103 );
104
105 INSERT INTO peer_config_child_config (
106 peer_cfg, child_cfg
107 ) VALUES (
108 1, 1
109 );
110
111 INSERT INTO traffic_selectors (
112 type, start_addr, end_addr
113 ) VALUES ( /* 10.1.0.0/16 */
114 7, X'0a010000', X'0a01ffff'
115 );
116
117 INSERT INTO traffic_selectors (
118 type
119 ) VALUES ( /* dynamic/32 */
120 7
121 );
122
123 INSERT INTO child_config_traffic_selector (
124 child_cfg, traffic_selector, kind
125 ) VALUES (
126 1, 1, 1
127 );
128
129 INSERT INTO child_config_traffic_selector (
130 child_cfg, traffic_selector, kind
131 ) VALUES (
132 1, 2, 2
133 );
134