Return to data.sql.in CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / strongswan / testing / tests / sql / ip-split-pools-db-restart / hosts / carol / etc / ipsec.d

Annotation of embedaddon/strongswan/testing/tests/sql/ip-split-pools-db-restart/hosts/carol/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 ( /* 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: INSERT INTO private_key_identity (
                     91:   private_key, identity
                     92: ) VALUES (
                     93:   1, 4
                     94: );
                     95: 
                     96: INSERT INTO private_key_identity (
                     97:   private_key, identity
                     98: ) VALUES (
                     99:   1, 5
                    100: );
                    101: 
                    102: /* Configurations */
                    103: 
                    104: INSERT INTO ike_configs (
                    105:   local, remote
                    106: ) VALUES (
                    107:   'PH_IP_CAROL', 'PH_IP_MOON'
                    108: );
                    109: 
                    110: INSERT INTO peer_configs (
                    111:   name, ike_cfg, local_id, remote_id, virtual
                    112: ) VALUES (
                    113:   'home', 1, 4, 6, '0.0.0.0'
                    114: );
                    115: 
                    116: INSERT INTO child_configs (
                    117:   name, updown
                    118: ) VALUES (
                    119:   'home', '/usr/local/libexec/ipsec/_updown iptables'
                    120: );
                    121: 
                    122: INSERT INTO peer_config_child_config (
                    123:   peer_cfg, child_cfg
                    124: ) VALUES (
                    125:   1, 1
                    126: );
                    127: 
                    128: INSERT INTO traffic_selectors (
                    129:   type, start_addr, end_addr
                    130: ) VALUES ( /* 10.1.0.0/16 */
                    131:   7, X'0a010000', X'0a01ffff'
                    132: );
                    133: 
                    134: INSERT INTO traffic_selectors (
                    135:   type
                    136: ) VALUES ( /* dynamic/32 */
                    137:   7
                    138: );
                    139: 
                    140: INSERT INTO child_config_traffic_selector (
                    141:   child_cfg, traffic_selector, kind
                    142: ) VALUES (
                    143:   1, 1, 1
                    144: );
                    145: 
                    146: INSERT INTO child_config_traffic_selector (
                    147:        child_cfg, traffic_selector, kind
                    148: ) VALUES (
                    149:   1, 2, 2
                    150: );
                    151: