testing: Use absolute path to the _updown script in SQL scenarios
[strongswan.git] / testing / tests / sql / rw-psk-rsa-split / hosts / dave / etc / ipsec.d / data.sql
1 /* Identities */
2
3 INSERT INTO identities (
4 type, data
5 ) VALUES ( /* C=CH, O=Linux strongSwan, CN=strongSwan Root CA */
6 9, X'3045310B300906035504061302434831193017060355040A13104C696E7578207374726F6E675377616E311B3019060355040313127374726F6E675377616E20526F6F74204341'
7 );
8
9 INSERT INTO identities (
10 type, data
11 ) VALUES ( /* subjkey of 'C=CH, O=Linux strongSwan, CN=strongSwan Root CA' */
12 11, X'5da7dd700651327ee7b66db3b5e5e060ea2e4def'
13 );
14
15 INSERT INTO identities (
16 type, data
17 ) VALUES ( /* keyid of 'C=CH, O=Linux strongSwan, CN=strongSwan Root CA' */
18 11, X'ae096b87b44886d3b820978623dabd0eae22ebbc'
19 );
20
21 INSERT INTO identities (
22 type, data
23 ) VALUES ( /* dave@strongswan.org */
24 3, X'64617665407374726f6e677377616e2e6f7267'
25 );
26
27 INSERT INTO identities (
28 type, data
29 ) VALUES ( /* moon.strongswan.org */
30 2, X'6d6f6f6e2e7374726f6e677377616e2e6f7267'
31 );
32
33 /* Certificates */
34
35 INSERT INTO certificates (
36 type, keytype, data
37 ) VALUES ( /* C=CH, O=Linux strongSwan, CN=strongSwan Root CA */
38 1, 1, X'308203b8308202a0a003020102020100300d06092a864886f70d01010b05003045310b300906035504061302434831193017060355040a13104c696e7578207374726f6e675377616e311b3019060355040313127374726f6e675377616e20526f6f74204341301e170d3034303931303130303131385a170d3139303930373130303131385a3045310b300906035504061302434831193017060355040a13104c696e7578207374726f6e675377616e311b3019060355040313127374726f6e675377616e20526f6f7420434130820122300d06092a864886f70d01010105000382010f003082010a0282010100bff25f62ea3d566e58b3c87a49caf3ac61cfa96377734d842db3f8fd6ea023f7b0132e66265012317386729c6d7c427a8d9f167be138e8ebae2b12b95933baef36a315c3ddf224cee4bb9bd578135d0467382629621ff96b8d45f6e002e5083662dce181805c140b3f2ce93f83aee3c861cff610a39f0189cb3a3c7cb9bf7e2a09544e2170efaa18fdd4ff20fa94be176d7fecff821f68d17152041d9b46f0cfcfc1e4cf43de5d3f3a587763afe9267f53b11699b3264fc55c5189f5682871166cb98307950569641fa30ffb50de134fed2f973cef1a392827862bc4ddaa97bbb01442e293c41070d07224d4be47ae2753eb2bed4bc1da91c68ec780c4620f0f0203010001a381b23081af30120603551d130101ff040830060101ff020101300b0603551d0f040403020106301d0603551d0e041604145da7dd700651327ee7b66db3b5e5e060ea2e4def306d0603551d230466306480145da7dd700651327ee7b66db3b5e5e060ea2e4defa149a4473045310b300906035504061302434831193017060355040a13104c696e7578207374726f6e675377616e311b3019060355040313127374726f6e675377616e20526f6f74204341820100300d06092a864886f70d01010b0500038201010023929aa101b412d1f5a577532088f209b34798a72ed7bd6945d74beaa2b3a1768764ad7f8b0df8d97a1a3ed1102e92a5f107e3059dc2250be49d02261ca83a342e0e5de7d43c37744e3fcea3197720ca1184d4ef94e6beeb0d241746b0b92b7fb1004c08e88bf9eb4ce60f3e149466f3e9fc3f98bce449f448f9d465e52b59f0101e6203cfad0d89e23509fa043d4c12021e8f32be7db8b2edbada641d64aa1a04af64a2ee5b814a753dd76b30e3de04f3c6b61166e632f8364d51cf3730a9564a4d93b9227c28b09b0f5595d92a632f72fe509a129ca9ee54df2b0edc6c3d38564f10256efcd8be82b2ec64977e3a6f5ef098eaa7f00662a6cded16cb80637c'
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, 2
51 );
52
53 INSERT INTO certificate_identity (
54 certificate, identity
55 ) VALUES (
56 1, 3
57 );
58
59 /* Shared Secrets */
60
61 INSERT INTO shared_secrets (
62 type, data
63 ) VALUES (
64 1, X'8d5cce342174da772c8224a59885deaa118d'
65 );
66
67 INSERT INTO shared_secret_identity (
68 shared_secret, identity
69 ) VALUES (
70 1, 4
71 );
72
73 INSERT INTO shared_secret_identity (
74 shared_secret, identity
75 ) VALUES (
76 1, 5
77 );
78
79
80 /* Configurations */
81
82 INSERT INTO ike_configs (
83 local, remote
84 ) VALUES (
85 'PH_IP_DAVE', 'PH_IP_MOON'
86 );
87
88 INSERT INTO peer_configs (
89 name, ike_cfg, local_id, remote_id, auth_method
90 ) VALUES (
91 'home', 1, 4, 5, 2
92 );
93
94 INSERT INTO child_configs (
95 name, updown
96 ) VALUES (
97 'home', '/usr/local/libexec/ipsec/_updown iptables'
98 );
99
100 INSERT INTO peer_config_child_config (
101 peer_cfg, child_cfg
102 ) VALUES (
103 1, 1
104 );
105
106 INSERT INTO traffic_selectors (
107 type, start_addr, end_addr
108 ) VALUES ( /* 10.1.0.0/16 */
109 7, X'0a010000', X'0a01ffff'
110 );
111
112 INSERT INTO traffic_selectors (
113 type
114 ) VALUES ( /* dynamic/32 */
115 7
116 );
117
118 INSERT INTO child_config_traffic_selector (
119 child_cfg, traffic_selector, kind
120 ) VALUES (
121 1, 1, 1
122 );
123
124 INSERT INTO child_config_traffic_selector (
125 child_cfg, traffic_selector, kind
126 ) VALUES (
127 1, 2, 2
128 );
129