Project

General

Profile

SQLite HOWTO » History » Version 5

Martin Willi, 29.06.2008 13:32

1 1 Martin Willi
= SQLite HOWTO =
2 2 Martin Willi
3 3 Martin Willi
SQLite tables defined in [browser:trunk/testing/hosts/default/etc/ipsec.d/tables.sql tables.sql]
4 3 Martin Willi
5 3 Martin Willi
== TABLE identities ==
6 3 Martin Willi
7 3 Martin Willi
'''type''' defined in [browser:trunk/src/libstrongswan/utils/identification.h#L58 identification.h]
8 3 Martin Willi
9 3 Martin Willi
||  0||ID_ANY             ||matches any id                      ||right=''%any''                                            ||
10 3 Martin Willi
||  1||ID_IPV4_ADDR       ||IPv4 address                        ||right=''192.168.0.1''                                     ||
11 3 Martin Willi
||  2||ID_FQDN            ||fully qualified domain name         ||right=''@moon.strongswan.org''                            ||
12 3 Martin Willi
||  3||ID_RFC822_ADDR     ||RFC822 email address                ||right=''carol@strongswan.org''                            ||
13 3 Martin Willi
||  5||ID_IPV6_ADDR       ||IPv6 address                        ||right=''fec0::1''                                         ||
14 3 Martin Willi
||  9||ID_DER_ASN1_DN     ||ASN.1 distinguished name            ||right=''C=CH, O=Linux strongSwan, CN=moon.strongswan.org''||
15 3 Martin Willi
|| 11||ID_KEY_ID          ||opaque octet string                 ||right=''@#                                                ||
16 3 Martin Willi
||202||ID_PUBKEY_INFO_SHA1||SHA-1 hash over subjectPublicKeyInfo||                                                          ||
17 3 Martin Willi
||203||ID_PUBKEY_SHA1     ||SHA-1 hash over subjectPublicKey    ||                                                          ||
18 3 Martin Willi
19 5 Martin Willi
'''ID_IPV4_ADDR'''
20 5 Martin Willi
21 5 Martin Willi
id2sql "192.168.0.1"
22 5 Martin Willi
23 5 Martin Willi
{{{
24 5 Martin Willi
  INSERT INTO identities (
25 5 Martin Willi
    type, data
26 5 Martin Willi
  ) VALUES (
27 5 Martin Willi
    1 , X'c0a80001'
28 5 Martin Willi
   );
29 5 Martin Willi
}}}
30 5 Martin Willi
31 3 Martin Willi
== TABLE private_keys ==
32 3 Martin Willi
33 3 Martin Willi
'''type''' defined in [browser:trunk/src/libstrongswan/credentials/keys/public_key.h#L37 public_key.h]
34 3 Martin Willi
35 3 Martin Willi
||1||KEY_RSA  ||RSA key in PKCS!#1 format     ||
36 3 Martin Willi
||2||KEY_ECDSA||ECDSA key in ANSI X9.62 format||
37 3 Martin Willi
38 3 Martin Willi
== TABLE certificates ==
39 3 Martin Willi
40 3 Martin Willi
'''type''' defined in [browser:trunk/src/libstrongswan/credentials/certificates/certificate.h#L35 certificate.h]
41 3 Martin Willi
42 3 Martin Willi
||1||CERT_X509          ||X.509 certificate                ||
43 3 Martin Willi
||2||CERT_X509_CRL      ||X.509 certificate revocation list||
44 3 Martin Willi
||5||CERT_X509_AC       ||X.509 attribute certificate      ||
45 3 Martin Willi
||6||CERT_TRUSTED_PUBKEY||trusted public key               ||
46 3 Martin Willi
47 3 Martin Willi
'''keytype''' defined in [browser:trunk/src/libstrongswan/credentials/keys/public_key.h#L37 public_key.h]
48 3 Martin Willi
49 4 Martin Willi
== TABLE shared_secrets ==
50 4 Martin Willi
51 4 Martin Willi
'''type''' defined in [browser:trunk/src/libstrongswan/credentials/keys/shared_key.h#L33 shared_key.h]
52 4 Martin Willi
53 4 Martin Willi
||1||SHARED_IKE||: PSK <secret>                       ||
54 4 Martin Willi
||2||SHARED_EAP||: EAP <secret>                       ||
55 4 Martin Willi
||3||SHARED_PRIVATE_KEY_PASS||: RSA <keyfile> <secret>||
56 4 Martin Willi
||4||SHARED_PIN||: PIN <secret>                       ||
57 4 Martin Willi
58 3 Martin Willi
== TABLE peer_configs ==
59 3 Martin Willi
60 3 Martin Willi
'''auth_method''' defined in [browser:trunk/src/charon/config/peer_cfg.h#L87 peer_cfg.h]
61 1 Martin Willi
62 4 Martin Willi
||1||CONF_AUTH_PUBKEY||authentication using public key       ||authby=''rsasig'', authby=''ecdsasig''||
63 3 Martin Willi
||2||CONF_AUTH_PSK   ||authentication using pre-shared secret||authby=''psk''                       ||
64 1 Martin Willi
||3||CONF_AUTH_EAP   ||authentication using EAP              ||authby=''eap''                       ||
65 4 Martin Willi
66 4 Martin Willi
== TABLE traffic_selectors ==
67 4 Martin Willi
68 4 Martin Willi
'''type''' defined in [browser:trunk/src/charon/config/traffic_selector.h#L37 traffic_selector.h]
69 4 Martin Willi
70 4 Martin Willi
||7||TS_IPV4_ADDR_RANGE||
71 4 Martin Willi
||8||TS_IPV6_ADDR_RANGE||