Annotation of embedaddon/strongswan/testing/tests/sql/ip-pool-db-expired/hosts/moon/etc/ipsec.d/data.sql.in, revision 1.1.1.1
1.1 misho 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 ( /* moon.strongswan.org */
24: 2, X'6d6f6f6e2e7374726f6e677377616e2e6f7267'
25: );
26:
27: INSERT INTO identities (
28: type, data
29: ) VALUES ( /* subjkey of 'C=CH, O=strongSwan Project, CN=moon.strongswan.org' */
30: 11, X'MOON_SPK_HEX'
31: );
32:
33: INSERT INTO identities (
34: type, data
35: ) VALUES ( /* %any */
36: 0, '%any'
37: );
38:
39: INSERT INTO identities (
40: type, data
41: ) VALUES ( /* carol@strongswan.org */
42: 3, X'6361726f6c407374726f6e677377616e2e6f7267'
43: );
44:
45: INSERT INTO identities (
46: type, data
47: ) VALUES ( /* dave@strongswan.org */
48: 3, X'64617665407374726f6e677377616e2e6f7267'
49: );
50:
51: INSERT INTO identities (
52: type, data
53: ) VALUES ( /* alice@strongswan.org */
54: 3, X'616c696365407374726f6e677377616e2e6f7267'
55: );
56:
57: /* Certificates */
58:
59: INSERT INTO certificates (
60: type, keytype, data
61: ) VALUES ( /* C=CH, O=strongSwan Project, CN=strongSwan Root CA */
62: 1, 1, X'CA_CERT_HEX'
63: );
64:
65: INSERT INTO certificates (
66: type, keytype, data
67: ) VALUES ( /* C=CH, O=strongSwan Project, CN=moon.strongswan.org */
68: 1, 1, X'MOON_CERT_HEX'
69: );
70:
71: INSERT INTO certificate_identity (
72: certificate, identity
73: ) VALUES (
74: 1, 1
75: );
76:
77: INSERT INTO certificate_identity (
78: certificate, identity
79: ) VALUES (
80: 1, 2
81: );
82:
83: INSERT INTO certificate_identity (
84: certificate, identity
85: ) VALUES (
86: 1, 3
87: );
88:
89: INSERT INTO certificate_identity (
90: certificate, identity
91: ) VALUES (
92: 2, 4
93: );
94:
95: INSERT INTO certificate_identity (
96: certificate, identity
97: ) VALUES (
98: 2, 5
99: );
100:
101: /* Private Keys */
102:
103: INSERT INTO private_keys (
104: type, data
105: ) VALUES ( /* key of 'C=CH, O=strongSwan Project, CN=moon.strongswan.org' */
106: 1, X'MOON_KEY_HEX'
107: );
108:
109: INSERT INTO private_key_identity (
110: private_key, identity
111: ) VALUES (
112: 1, 4
113: );
114:
115: INSERT INTO private_key_identity (
116: private_key, identity
117: ) VALUES (
118: 1, 5
119: );
120:
121: /* Configurations */
122:
123: INSERT INTO ike_configs (
124: local, remote
125: ) VALUES (
126: 'PH_IP_MOON', '0.0.0.0'
127: );
128:
129: INSERT INTO peer_configs (
130: name, ike_cfg, local_id, remote_id, pool
131: ) VALUES (
132: 'rw', 1, 4, 6, 'bigpool'
133: );
134:
135: INSERT INTO child_configs (
136: name, updown
137: ) VALUES (
138: 'rw', '/usr/local/libexec/ipsec/_updown iptables'
139: );
140:
141: INSERT INTO peer_config_child_config (
142: peer_cfg, child_cfg
143: ) VALUES (
144: 1, 1
145: );
146:
147: INSERT INTO traffic_selectors (
148: type, start_addr, end_addr
149: ) VALUES ( /* 10.1.0.0/16 */
150: 7, X'0a010000', X'0a01ffff'
151: );
152:
153: INSERT INTO traffic_selectors (
154: type
155: ) VALUES ( /* dynamic/32 */
156: 7
157: );
158:
159: INSERT INTO child_config_traffic_selector (
160: child_cfg, traffic_selector, kind
161: ) VALUES (
162: 1, 1, 0
163: );
164:
165: INSERT INTO child_config_traffic_selector (
166: child_cfg, traffic_selector, kind
167: ) VALUES (
168: 1, 2, 3
169: );
170:
171: /* Pools */
172:
173: INSERT INTO pools (
174: name, start, end, timeout
175: ) VALUES (
176: 'bigpool', X'0a030001', X'0a030006', 3600
177: );
178:
179: INSERT INTO addresses (
180: pool, address, identity, acquired, released
181: ) VALUES (
182: 1, X'0a030001', 8, 1211299013 , 1211299205
183: );
184:
185: INSERT INTO addresses (
186: pool, address, identity, acquired, released
187: ) VALUES (
188: 1, X'0a030002', 9, 1211299031, 1211299187
189: );
190:
191: INSERT INTO addresses (
192: pool, address
193: ) VALUES (
194: 1, X'0a030003'
195: );
196:
197: INSERT INTO addresses (
198: pool, address
199: ) VALUES (
200: 1, X'0a030004'
201: );
202:
203: INSERT INTO addresses (
204: pool, address
205: ) VALUES (
206: 1, X'0a030005'
207: );
208:
209: INSERT INTO addresses (
210: pool, address
211: ) VALUES (
212: 1, X'0a030006'
213: );
214:
215: INSERT INTO leases (
216: address, identity, acquired, released
217: ) VALUES (
218: 1, 8, 1211299013 , 1211299205
219: );
220:
221: INSERT INTO leases (
222: address, identity, acquired, released
223: ) VALUES (
224: 2, 9, 1211299031, 1211299187
225: );
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>