890077157fbdf83985ddf566885c63872efdd2b0
[strongswan.git] / src / libcharon / plugins / sql / sql_config.c
1 /*
2 * Copyright (C) 2006-2008 Martin Willi
3 * Copyright (C) 2010 Andreas Steffen
4 * Hochschule fuer Technik Rapperswil
5 *
6 * This program is free software; you can redistribute it and/or modify it
7 * under the terms of the GNU General Public License as published by the
8 * Free Software Foundation; either version 2 of the License, or (at your
9 * option) any later version. See <http://www.fsf.org/copyleft/gpl.txt>.
10 *
11 * This program is distributed in the hope that it will be useful, but
12 * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
14 * for more details.
15 */
16
17 #include <string.h>
18
19 #include "sql_config.h"
20
21 #include <daemon.h>
22
23 typedef struct private_sql_config_t private_sql_config_t;
24
25 /**
26 * Private data of an sql_config_t object
27 */
28 struct private_sql_config_t {
29
30 /**
31 * Public part
32 */
33 sql_config_t public;
34
35 /**
36 * database connection
37 */
38 database_t *db;
39 };
40
41 /**
42 * Forward declaration
43 */
44 static peer_cfg_t *build_peer_cfg(private_sql_config_t *this, enumerator_t *e,
45 identification_t *me, identification_t *other);
46
47 /**
48 * Build a traffic selector from an SQL query
49 */
50 static traffic_selector_t *build_traffic_selector(private_sql_config_t *this,
51 enumerator_t *e, bool *local)
52 {
53 int type, protocol, start_port, end_port;
54 chunk_t start_addr, end_addr;
55 traffic_selector_t *ts;
56 enum {
57 TS_LOCAL = 0,
58 TS_REMOTE = 1,
59 TS_LOCAL_DYNAMIC = 2,
60 TS_REMOTE_DYNAMIC = 3,
61 } kind;
62
63 while (e->enumerate(e, &kind, &type, &protocol,
64 &start_addr, &end_addr, &start_port, &end_port))
65 {
66 *local = FALSE;
67 switch (kind)
68 {
69 case TS_LOCAL:
70 *local = TRUE;
71 /* FALL */
72 case TS_REMOTE:
73 ts = traffic_selector_create_from_bytes(protocol, type,
74 start_addr, start_port, end_addr, end_port);
75 break;
76 case TS_LOCAL_DYNAMIC:
77 *local = TRUE;
78 /* FALL */
79 case TS_REMOTE_DYNAMIC:
80 ts = traffic_selector_create_dynamic(protocol,
81 start_port, end_port);
82 break;
83 default:
84 continue;
85 }
86 if (ts)
87 {
88 return ts;
89 }
90 }
91 return NULL;
92 }
93
94 /**
95 * Add traffic selectors to a child config
96 */
97 static void add_traffic_selectors(private_sql_config_t *this,
98 child_cfg_t *child, int id)
99 {
100 enumerator_t *e;
101 traffic_selector_t *ts;
102 bool local;
103
104 e = this->db->query(this->db,
105 "SELECT kind, type, protocol, "
106 "start_addr, end_addr, start_port, end_port "
107 "FROM traffic_selectors JOIN child_config_traffic_selector "
108 "ON id = traffic_selector WHERE child_cfg = ?",
109 DB_INT, id,
110 DB_INT, DB_INT, DB_INT,
111 DB_BLOB, DB_BLOB, DB_INT, DB_INT);
112 if (e)
113 {
114 while ((ts = build_traffic_selector(this, e, &local)))
115 {
116 child->add_traffic_selector(child, local, ts);
117 }
118 e->destroy(e);
119 }
120 }
121
122 /**
123 * Add ESP proposals to a child config
124 */
125 static void add_esp_proposals(private_sql_config_t *this,
126 child_cfg_t *child, int id)
127 {
128 enumerator_t *e;
129 proposal_t *proposal;
130 char *prop;
131 bool use_default = TRUE;
132
133 e = this->db->query(this->db,
134 "SELECT proposal "
135 "FROM proposals JOIN child_config_proposal ON id = prop "
136 "WHERE child_cfg = ? ORDER BY prio",
137 DB_INT, id, DB_TEXT);
138 if (e)
139 {
140 while (e->enumerate(e, &prop))
141 {
142 proposal = proposal_create_from_string(PROTO_ESP, prop);
143 if (!proposal)
144 {
145 DBG1(DBG_CFG, "could not create ESP proposal from '%s'", prop);
146 break;
147 }
148 child->add_proposal(child, proposal);
149 use_default = FALSE;
150 }
151 e->destroy(e);
152 }
153 if (use_default)
154 {
155 child->add_proposal(child, proposal_create_default(PROTO_ESP));
156 }
157 }
158
159 /**
160 * Build a child config from an SQL query
161 */
162 static child_cfg_t *build_child_cfg(private_sql_config_t *this, enumerator_t *e)
163 {
164 int id, lifetime, rekeytime, jitter, hostaccess, mode, ipcomp, reqid;
165 int start, dpd, close;
166 char *name, *updown;
167 child_cfg_t *child_cfg;
168
169 if (e->enumerate(e, &id, &name, &lifetime, &rekeytime, &jitter, &updown,
170 &hostaccess, &mode, &start, &dpd, &close, &ipcomp, &reqid))
171 {
172 lifetime_cfg_t lft = {
173 .time = { .life = lifetime, .rekey = rekeytime, .jitter = jitter }
174 };
175 child_cfg = child_cfg_create(name, &lft, updown, hostaccess, mode,
176 start, dpd, close, ipcomp, 0, reqid,
177 NULL, NULL, 0);
178 add_esp_proposals(this, child_cfg, id);
179 add_traffic_selectors(this, child_cfg, id);
180 return child_cfg;
181 }
182 return NULL;
183 }
184
185 /**
186 * Add child configs to peer config
187 */
188 static void add_child_cfgs(private_sql_config_t *this, peer_cfg_t *peer, int id)
189 {
190 enumerator_t *e;
191 child_cfg_t *child_cfg;
192
193 e = this->db->query(this->db,
194 "SELECT id, name, lifetime, rekeytime, jitter, updown, hostaccess, "
195 "mode, start_action, dpd_action, close_action, ipcomp, reqid "
196 "FROM child_configs JOIN peer_config_child_config ON id = child_cfg "
197 "WHERE peer_cfg = ?",
198 DB_INT, id,
199 DB_INT, DB_TEXT, DB_INT, DB_INT, DB_INT, DB_TEXT, DB_INT,
200 DB_INT, DB_INT, DB_INT, DB_INT, DB_INT, DB_INT);
201 if (e)
202 {
203 while ((child_cfg = build_child_cfg(this, e)))
204 {
205 peer->add_child_cfg(peer, child_cfg);
206 }
207 e->destroy(e);
208 }
209 }
210
211 /**
212 * Add IKE proposals to an IKE config
213 */
214 static void add_ike_proposals(private_sql_config_t *this,
215 ike_cfg_t *ike_cfg, int id)
216 {
217 enumerator_t *e;
218 proposal_t *proposal;
219 char *prop;
220 bool use_default = TRUE;
221
222 e = this->db->query(this->db,
223 "SELECT proposal "
224 "FROM proposals JOIN ike_config_proposal ON id = prop "
225 "WHERE ike_cfg = ? ORDER BY prio",
226 DB_INT, id, DB_TEXT);
227 if (e)
228 {
229 while (e->enumerate(e, &prop))
230 {
231 proposal = proposal_create_from_string(PROTO_IKE, prop);
232 if (!proposal)
233 {
234 DBG1(DBG_CFG, "could not create IKE proposal from '%s'", prop);
235 break;
236 }
237 ike_cfg->add_proposal(ike_cfg, proposal);
238 use_default = FALSE;
239 }
240 e->destroy(e);
241 }
242 if (use_default)
243 {
244 ike_cfg->add_proposal(ike_cfg, proposal_create_default(PROTO_IKE));
245 }
246 }
247
248 /**
249 * Build an IKE config from an SQL query
250 */
251 static ike_cfg_t *build_ike_cfg(private_sql_config_t *this, enumerator_t *e,
252 host_t *my_host, host_t *other_host)
253 {
254 int id, certreq, force_encap;
255 char *local, *remote;
256
257 while (e->enumerate(e, &id, &certreq, &force_encap, &local, &remote))
258 {
259 ike_cfg_t *ike_cfg;
260
261 ike_cfg = ike_cfg_create(certreq, force_encap,
262 local, FALSE, charon->socket->get_port(charon->socket, FALSE),
263 remote, FALSE, IKEV2_UDP_PORT);
264 add_ike_proposals(this, ike_cfg, id);
265 return ike_cfg;
266 }
267 return NULL;
268 }
269
270 /**
271 * Query an IKE config by its id
272 */
273 static ike_cfg_t* get_ike_cfg_by_id(private_sql_config_t *this, int id)
274 {
275 enumerator_t *e;
276 ike_cfg_t *ike_cfg = NULL;
277
278 e = this->db->query(this->db,
279 "SELECT id, certreq, force_encap, local, remote "
280 "FROM ike_configs WHERE id = ?",
281 DB_INT, id,
282 DB_INT, DB_INT, DB_INT, DB_TEXT, DB_TEXT);
283 if (e)
284 {
285 ike_cfg = build_ike_cfg(this, e, NULL, NULL);
286 e->destroy(e);
287 }
288 return ike_cfg;
289 }
290
291 /**
292 * Query a peer config by its id
293 */
294 static peer_cfg_t *get_peer_cfg_by_id(private_sql_config_t *this, int id)
295 {
296 enumerator_t *e;
297 peer_cfg_t *peer_cfg = NULL;
298
299 e = this->db->query(this->db,
300 "SELECT c.id, name, ike_cfg, l.type, l.data, r.type, r.data, "
301 "cert_policy, uniqueid, auth_method, eap_type, eap_vendor, "
302 "keyingtries, rekeytime, reauthtime, jitter, overtime, mobike, "
303 "dpd_delay, virtual, pool, "
304 "mediation, mediated_by, COALESCE(p.type, 0), p.data "
305 "FROM peer_configs AS c "
306 "JOIN identities AS l ON local_id = l.id "
307 "JOIN identities AS r ON remote_id = r.id "
308 "LEFT JOIN identities AS p ON peer_id = p.id "
309 "WHERE id = ?",
310 DB_INT, id,
311 DB_INT, DB_TEXT, DB_INT, DB_INT, DB_BLOB, DB_INT, DB_BLOB,
312 DB_INT, DB_INT, DB_INT, DB_INT, DB_INT,
313 DB_INT, DB_INT, DB_INT, DB_INT, DB_INT, DB_INT,
314 DB_INT, DB_TEXT, DB_TEXT,
315 DB_INT, DB_INT, DB_INT, DB_BLOB);
316 if (e)
317 {
318 peer_cfg = build_peer_cfg(this, e, NULL, NULL);
319 e->destroy(e);
320 }
321 return peer_cfg;
322 }
323
324 /**
325 * Build a peer config from an SQL query
326 */
327 static peer_cfg_t *build_peer_cfg(private_sql_config_t *this, enumerator_t *e,
328 identification_t *me, identification_t *other)
329 {
330 int id, ike_cfg, l_type, r_type,
331 cert_policy, uniqueid, auth_method, eap_type, eap_vendor, keyingtries,
332 rekeytime, reauthtime, jitter, overtime, mobike, dpd_delay,
333 mediation, mediated_by, p_type;
334 chunk_t l_data, r_data, p_data;
335 char *name, *virtual, *pool;
336
337 while (e->enumerate(e,
338 &id, &name, &ike_cfg, &l_type, &l_data, &r_type, &r_data,
339 &cert_policy, &uniqueid, &auth_method, &eap_type, &eap_vendor,
340 &keyingtries, &rekeytime, &reauthtime, &jitter, &overtime, &mobike,
341 &dpd_delay, &virtual, &pool,
342 &mediation, &mediated_by, &p_type, &p_data))
343 {
344 identification_t *local_id, *remote_id, *peer_id = NULL;
345 peer_cfg_t *peer_cfg, *mediated_cfg;
346 ike_cfg_t *ike;
347 host_t *vip = NULL;
348 auth_cfg_t *auth;
349
350 local_id = identification_create_from_encoding(l_type, l_data);
351 remote_id = identification_create_from_encoding(r_type, r_data);
352 if ((me && !me->matches(me, local_id)) ||
353 (other && !other->matches(other, remote_id)))
354 {
355 local_id->destroy(local_id);
356 remote_id->destroy(remote_id);
357 continue;
358 }
359 ike = get_ike_cfg_by_id(this, ike_cfg);
360 mediated_cfg = mediated_by ? get_peer_cfg_by_id(this, mediated_by) : NULL;
361 if (p_type)
362 {
363 peer_id = identification_create_from_encoding(p_type, p_data);
364 }
365 if (virtual)
366 {
367 vip = host_create_from_string(virtual, 0);
368 }
369 if (ike)
370 {
371 peer_cfg = peer_cfg_create(
372 name, IKEV2, ike, cert_policy, uniqueid,
373 keyingtries, rekeytime, reauthtime, jitter, overtime,
374 mobike, FALSE, dpd_delay, 0, vip, pool,
375 mediation, mediated_cfg, peer_id);
376 auth = auth_cfg_create();
377 auth->add(auth, AUTH_RULE_AUTH_CLASS, auth_method);
378 auth->add(auth, AUTH_RULE_IDENTITY, local_id);
379 peer_cfg->add_auth_cfg(peer_cfg, auth, TRUE);
380 auth = auth_cfg_create();
381 auth->add(auth, AUTH_RULE_IDENTITY, remote_id);
382 if (eap_type)
383 {
384 auth->add(auth, AUTH_RULE_AUTH_CLASS, AUTH_CLASS_EAP);
385 auth->add(auth, AUTH_RULE_EAP_TYPE, eap_type);
386 if (eap_vendor)
387 {
388 auth->add(auth, AUTH_RULE_EAP_VENDOR, eap_vendor);
389 }
390 }
391 peer_cfg->add_auth_cfg(peer_cfg, auth, FALSE);
392 add_child_cfgs(this, peer_cfg, id);
393 return peer_cfg;
394 }
395 DESTROY_IF(ike);
396 DESTROY_IF(mediated_cfg);
397 DESTROY_IF(peer_id);
398 DESTROY_IF(local_id);
399 DESTROY_IF(remote_id);
400 }
401 return NULL;
402 }
403
404 METHOD(backend_t, get_peer_cfg_by_name, peer_cfg_t*,
405 private_sql_config_t *this, char *name)
406 {
407 enumerator_t *e;
408 peer_cfg_t *peer_cfg = NULL;
409
410 e = this->db->query(this->db,
411 "SELECT c.id, name, ike_cfg, l.type, l.data, r.type, r.data, "
412 "cert_policy, uniqueid, auth_method, eap_type, eap_vendor, "
413 "keyingtries, rekeytime, reauthtime, jitter, overtime, mobike, "
414 "dpd_delay, virtual, pool, "
415 "mediation, mediated_by, COALESCE(p.type, 0), p.data "
416 "FROM peer_configs AS c "
417 "JOIN identities AS l ON local_id = l.id "
418 "JOIN identities AS r ON remote_id = r.id "
419 "LEFT JOIN identities AS p ON peer_id = p.id "
420 "WHERE ike_version = ? AND name = ?",
421 DB_INT, 2, DB_TEXT, name,
422 DB_INT, DB_TEXT, DB_INT, DB_INT, DB_BLOB, DB_INT, DB_BLOB,
423 DB_INT, DB_INT, DB_INT, DB_INT, DB_INT,
424 DB_INT, DB_INT, DB_INT, DB_INT, DB_INT, DB_INT,
425 DB_INT, DB_TEXT, DB_TEXT,
426 DB_INT, DB_INT, DB_INT, DB_BLOB);
427 if (e)
428 {
429 peer_cfg = build_peer_cfg(this, e, NULL, NULL);
430 e->destroy(e);
431 }
432 return peer_cfg;
433 }
434
435 typedef struct {
436 /** implements enumerator */
437 enumerator_t public;
438 /** reference to context */
439 private_sql_config_t *this;
440 /** filtering own host */
441 host_t *me;
442 /** filtering remote host */
443 host_t *other;
444 /** inner SQL enumerator */
445 enumerator_t *inner;
446 /** currently enumerated peer config */
447 ike_cfg_t *current;
448 } ike_enumerator_t;
449
450 /**
451 * Implementation of ike_enumerator_t.public.enumerate
452 */
453 static bool ike_enumerator_enumerate(ike_enumerator_t *this, ike_cfg_t **cfg)
454 {
455 DESTROY_IF(this->current);
456 this->current = build_ike_cfg(this->this, this->inner, this->me, this->other);
457 if (this->current)
458 {
459 *cfg = this->current;
460 return TRUE;
461 }
462 return FALSE;
463 }
464
465 /**
466 * Implementation of ike_enumerator_t.public.destroy
467 */
468 static void ike_enumerator_destroy(ike_enumerator_t *this)
469 {
470 DESTROY_IF(this->current);
471 this->inner->destroy(this->inner);
472 free(this);
473 }
474
475 METHOD(backend_t, create_ike_cfg_enumerator, enumerator_t*,
476 private_sql_config_t *this, host_t *me, host_t *other)
477 {
478 ike_enumerator_t *e = malloc_thing(ike_enumerator_t);
479
480 e->this = this;
481 e->me = me;
482 e->other = other;
483 e->current = NULL;
484 e->public.enumerate = (void*)ike_enumerator_enumerate;
485 e->public.destroy = (void*)ike_enumerator_destroy;
486
487 e->inner = this->db->query(this->db,
488 "SELECT id, certreq, force_encap, local, remote "
489 "FROM ike_configs",
490 DB_INT, DB_INT, DB_INT, DB_TEXT, DB_TEXT);
491 if (!e->inner)
492 {
493 free(e);
494 return NULL;
495 }
496 return &e->public;
497 }
498
499
500 typedef struct {
501 /** implements enumerator */
502 enumerator_t public;
503 /** reference to context */
504 private_sql_config_t *this;
505 /** filtering own identity */
506 identification_t *me;
507 /** filtering remote identity */
508 identification_t *other;
509 /** inner SQL enumerator */
510 enumerator_t *inner;
511 /** currently enumerated peer config */
512 peer_cfg_t *current;
513 } peer_enumerator_t;
514
515 /**
516 * Implementation of peer_enumerator_t.public.enumerate
517 */
518 static bool peer_enumerator_enumerate(peer_enumerator_t *this, peer_cfg_t **cfg)
519 {
520 DESTROY_IF(this->current);
521 this->current = build_peer_cfg(this->this, this->inner, this->me, this->other);
522 if (this->current)
523 {
524 *cfg = this->current;
525 return TRUE;
526 }
527 return FALSE;
528 }
529
530 /**
531 * Implementation of peer_enumerator_t.public.destroy
532 */
533 static void peer_enumerator_destroy(peer_enumerator_t *this)
534 {
535 DESTROY_IF(this->current);
536 this->inner->destroy(this->inner);
537 free(this);
538 }
539
540 METHOD(backend_t, create_peer_cfg_enumerator, enumerator_t*,
541 private_sql_config_t *this, identification_t *me, identification_t *other)
542 {
543 peer_enumerator_t *e = malloc_thing(peer_enumerator_t);
544
545 e->this = this;
546 e->me = me;
547 e->other = other;
548 e->current = NULL;
549 e->public.enumerate = (void*)peer_enumerator_enumerate;
550 e->public.destroy = (void*)peer_enumerator_destroy;
551
552 /* TODO: only get configs whose IDs match exactly or contain wildcards */
553 e->inner = this->db->query(this->db,
554 "SELECT c.id, name, ike_cfg, l.type, l.data, r.type, r.data, "
555 "cert_policy, uniqueid, auth_method, eap_type, eap_vendor, "
556 "keyingtries, rekeytime, reauthtime, jitter, overtime, mobike, "
557 "dpd_delay, virtual, pool, "
558 "mediation, mediated_by, COALESCE(p.type, 0), p.data "
559 "FROM peer_configs AS c "
560 "JOIN identities AS l ON local_id = l.id "
561 "JOIN identities AS r ON remote_id = r.id "
562 "LEFT JOIN identities AS p ON peer_id = p.id "
563 "WHERE ike_version = ?",
564 DB_INT, 2,
565 DB_INT, DB_TEXT, DB_INT, DB_INT, DB_BLOB, DB_INT, DB_BLOB,
566 DB_INT, DB_INT, DB_INT, DB_INT, DB_INT,
567 DB_INT, DB_INT, DB_INT, DB_INT, DB_INT, DB_INT,
568 DB_INT, DB_TEXT, DB_TEXT,
569 DB_INT, DB_INT, DB_INT, DB_BLOB);
570 if (!e->inner)
571 {
572 free(e);
573 return NULL;
574 }
575 return &e->public;
576 }
577
578 METHOD(sql_config_t, destroy, void,
579 private_sql_config_t *this)
580 {
581 free(this);
582 }
583
584 /**
585 * Described in header.
586 */
587 sql_config_t *sql_config_create(database_t *db)
588 {
589 private_sql_config_t *this;
590
591 INIT(this,
592 .public = {
593 .backend = {
594 .create_peer_cfg_enumerator = _create_peer_cfg_enumerator,
595 .create_ike_cfg_enumerator = _create_ike_cfg_enumerator,
596 .get_peer_cfg_by_name = _get_peer_cfg_by_name,
597 },
598 .destroy = _destroy,
599 },
600 .db = db
601 );
602
603 return &this->public;
604 }
605