Version bump to 5.9.4
[strongswan.git] / testing / tests / sql / ip-pool-db-expired / hosts / carol / etc / ipsec.d / data.sql.in
1 /* Identities */
2
3 INSERT INTO identities (
4 type, data
5 ) VALUES ( /* C=CH, O=strongSwan Project, CN=strongSwan Root CA */
6 9, X'3047310b3009060355040613024348311b3019060355040a13127374726f6e675377616e2050726f6a656374311b3019060355040313127374726f6e675377616e20526f6f74204341'
7 );
8
9 INSERT INTO identities (
10 type, data
11 ) VALUES ( /* subjkey of 'C=CH, O=strongSwan Project, CN=strongSwan Root CA' */
12 11, X'CA_SPK_HEX'
13 );
14
15 INSERT INTO identities (
16 type, data
17 ) VALUES ( /* keyid of 'C=CH, O=strongSwan Project, CN=strongSwan Root CA' */
18 11, X'CA_SPKI_HEX'
19 );
20
21 INSERT INTO identities (
22 type, data
23 ) VALUES ( /* carol@strongswan.org */
24 3, X'6361726f6c407374726f6e677377616e2e6f7267'
25 );
26
27 INSERT INTO identities (
28 type, data
29 ) VALUES ( /* subjkey of 'C=CH, O=strongSwan Project, CN=carol@strongswan.org' */
30 11, X'CAROL_SPK_HEX'
31 );
32
33 INSERT INTO identities (
34 type, data
35 ) VALUES ( /* moon.strongswan.org */
36 2, X'6d6f6f6e2e7374726f6e677377616e2e6f7267'
37 );
38
39 /* Certificates */
40
41 INSERT INTO certificates (
42 type, keytype, data
43 ) VALUES ( /* C=CH, O=strongSwan Project, CN=strongSwan Root CA */
44 1, 1, X'CA_CERT_HEX'
45 );
46
47 INSERT INTO certificates (
48 type, keytype, data
49 ) VALUES ( /* C=CH, O=strongSwan Project, CN=carol@strongswan.org */
50 1, 1, X'CAROL_CERT_HEX'
51 );
52
53 INSERT INTO certificate_identity (
54 certificate, identity
55 ) VALUES (
56 1, 1
57 );
58
59 INSERT INTO certificate_identity (
60 certificate, identity
61 ) VALUES (
62 1, 2
63 );
64
65 INSERT INTO certificate_identity (
66 certificate, identity
67 ) VALUES (
68 1, 3
69 );
70
71 INSERT INTO certificate_identity (
72 certificate, identity
73 ) VALUES (
74 2, 4
75 );
76
77 INSERT INTO certificate_identity (
78 certificate, identity
79 ) VALUES (
80 2, 5
81 );
82
83 /* Private Keys */
84
85 INSERT INTO private_keys (
86 type, data
87 ) VALUES ( /* key of 'C=CH, O=strongSwan Project, CN=carol@strongswan.org' */
88 1, X'CAROL_KEY_HEX'
89 );
90
91 INSERT INTO private_key_identity (
92 private_key, identity
93 ) VALUES (
94 1, 4
95 );
96
97 INSERT INTO private_key_identity (
98 private_key, identity
99 ) VALUES (
100 1, 5
101 );
102
103 /* Configurations */
104
105 INSERT INTO ike_configs (
106 local, remote
107 ) VALUES (
108 'PH_IP_CAROL', 'PH_IP_MOON'
109 );
110
111 INSERT INTO peer_configs (
112 name, ike_cfg, local_id, remote_id, virtual
113 ) VALUES (
114 'home', 1, 4, 6, '0.0.0.0'
115 );
116
117 INSERT INTO child_configs (
118 name, updown
119 ) VALUES (
120 'home', '/usr/local/libexec/ipsec/_updown iptables'
121 );
122
123 INSERT INTO peer_config_child_config (
124 peer_cfg, child_cfg
125 ) VALUES (
126 1, 1
127 );
128
129 INSERT INTO traffic_selectors (
130 type, start_addr, end_addr
131 ) VALUES ( /* 10.1.0.0/16 */
132 7, X'0a010000', X'0a01ffff'
133 );
134
135 INSERT INTO traffic_selectors (
136 type
137 ) VALUES ( /* dynamic/32 */
138 7
139 );
140
141 INSERT INTO child_config_traffic_selector (
142 child_cfg, traffic_selector, kind
143 ) VALUES (
144 1, 1, 1
145 );
146
147 INSERT INTO child_config_traffic_selector (
148 child_cfg, traffic_selector, kind
149 ) VALUES (
150 1, 2, 2
151 );
152