testing: Use absolute path to the _updown script in SQL scenarios
[strongswan.git] / testing / tests / sql / rw-rsa / 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 $INSERT INTO certificate_identity (
47 certificate, identity
48 ) VALUES (
49 1, 3
50 );
51
52 INSERT INTO certificate_identity (
53 certificate, identity
54 ) VALUES (
55 2, 2
56 );
57
58 INSERT INTO certificate_identity (
59 certificate, identity
60 ) VALUES (
61 2, 4
62 );
63
64 /* Private Keys */
65
66 INSERT INTO private_keys (
67 type, data
68 ) VALUES ( /* key of dave@strongswan.org */
69 1, X'308204a50201000282010100c007f2536f0558e68345d3ef017a175b73434e797f9b97448e720a5985aea76cc0503b8d63b4e239af95db83db0af65f8360e9d941912c121215643a0af32188fc520413e81645ff8e2e623c9362be1b57649530bf54fdad6563106105ace949d7de2895a4771c237090aaa2567bd7d9b08b2ad09f63f61bba87d7462046e89fa4570cb3c8e4322220a737af48c31cd0ec2140f3723b94742c4a14232e1d409f6b53c18aaa63e693fa5d3d06808e948db8273563d33dbd9ac44ecfd71e60426570885898b3e5538767eaf4ef713719e7fd89b32e4e3f60d972ef1617437d4dba14af4691fb8ec275a78552bae9d8aaf71c3d42aca793ef0ad09e1af353daab750203010001028201010081e2de1d60f294f715c39d5e03f9b8e2ba4bc44099f77b917b67d76845eba48302714256982239021ba99918ce87d3ad3707ce248d1ccc5a4cb0fb61e7161c90b35a2637f0bb600d42f64cabfc64c58168d337b609344b81851a4471db8ce11e794c62d714af1bf13caa1d40408ef3a8e2a8bf04ed4a87a4a9be47f5becf3777d7254cf6ab0ff4f3e109235334796b030a1e03951a0ae64e224b3226a8e99174825eaa877efbc5cde0cd075687a9086f645654bda547f8927433f8eecd9ecfcb9b30ed6ff66bb4e5b7341f9626095798e279338e554045d0ae3ee94a1f10644ad88f10e7e7199923d45d5f8df2283859c3f4c41262426e654a04e895a21bb40102818100ea2e632ed6d314655c64eb6a18d4f492fea379ca091426bd7f381f1cbd7f1f79b73d694b9538ec693b245992f6a2a1b292279db9698eac40e43df3aa83b682ca5ab60ed07d02692e16c65cba91ee9aa9f768db2be9a1e0a213a93651a6886dcd35aa3f116ea73287a39a830cc2779bc02b9c8566c4cf8cd25ce99fa030ab965502818100d1ec351dafa33fff13a64c4a980a6f697735e705c1dc2a410b738210f4c059cd058579e4324d46e5bb0c1e6df4476d1a00206f66cf1be23645db193c69cbd04539f87e2b3f4617046031a1575a16a8e71b998844df2601d9d67958421f75c19943f53857b56a08583320b48a85def15b75c9ac5e4a232363824ab666b60ca0a102818100879dbf8083960fccb75a165f05ec658aaefe7aec3e9fb5e3adc611767263291632c0d4b699bf3261aa875d7c576a4d5bfd7a05c4375611792ef495a4dccc182819aa2f201c15065653882271454bb9b3ce7ca1d8675f80983bec95716990be8dc593471cd048f1614da4905a1650701934e85af4edeb083156ef50aad324bb5502818100814232ca9eb5a4d8499f2266e40bb8e275f708d3b0b502879ea777353d9f9b2bf4f46543affd896437b294a21bc24759b52e43aa4868e0f78e3804e80034f17f4edcc5c397686f0fd0b37ea72cdfbb0ce31fbc9abbd4c95afb0728e33e3fe1ff9faac510acb2278537a631c501fd6f1c6400d45412ce642207be3d662d3ec54102818055a928e09d9801f683ebb625e6ed97396ac1cd55b358d7aa06c8801759c2a51d517de1f88c537f532fea6cf563766d7818dc1de70b48d31c0102cad3562b7bf03a310b631428c22eabdc5555a90a5fc5310660a795d916ba1b57c09587f697d09dc092ac469e71f0e42fc6153c35ffe177898ea1e92aa6f28d3b86bfe30ad58c'
70 );
71
72 INSERT INTO private_key_identity (
73 private_key, identity
74 ) VALUES (
75 1, 1
76 );
77
78 INSERT INTO private_key_identity (
79 private_key, identity
80 ) VALUES (
81 1, 3
82 );
83
84 /* Configurations */
85
86 INSERT INTO ike_configs (
87 local, remote
88 ) VALUES (
89 'PH_IP_DAVE', 'PH_IP_MOON'
90 );
91
92 INSERT INTO peer_configs (
93 name, ike_cfg, local_id, remote_id
94 ) VALUES (
95 'home', 1, 1, 2
96 );
97
98 INSERT INTO child_configs (
99 name, updown
100 ) VALUES (
101 'home', '/usr/local/libexec/ipsec/_updown iptables'
102 );
103
104 INSERT INTO peer_config_child_config (
105 peer_cfg, child_cfg
106 ) VALUES (
107 1, 1
108 );
109
110 INSERT INTO traffic_selectors (
111 type, start_addr, end_addr
112 ) VALUES ( /* 10.1.0.0/16 */
113 7, X'0a010000', X'0a01ffff'
114 );
115
116 INSERT INTO traffic_selectors (
117 type
118 ) VALUES ( /* dynamic/32 */
119 7
120 );
121
122 INSERT INTO child_config_traffic_selector (
123 child_cfg, traffic_selector, kind
124 ) VALUES (
125 1, 1, 1
126 );
127
128 INSERT INTO child_config_traffic_selector (
129 child_cfg, traffic_selector, kind
130 ) VALUES (
131 1, 2, 2
132 );
133