Return to data.sql.in CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / strongswan / testing / tests / sql / rw-rsa / hosts / moon / etc / ipsec.d

Annotation of embedaddon/strongswan/testing/tests/sql/rw-rsa/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 ( /* moon.strongswan.org */
                      6:   2, X'6d6f6f6e2e7374726f6e677377616e2e6f7267'
                      7:  );
                      8: 
                      9: INSERT INTO identities (
                     10:   type, data
                     11: ) VALUES ( /* carol@strongswan.org */
                     12:   3, X'6361726f6c407374726f6e677377616e2e6f7267'
                     13:  );
                     14: 
                     15: INSERT INTO identities (
                     16:   type, data
                     17: ) VALUES ( /* dave@strongswan.org */
                     18:   3, X'64617665407374726f6e677377616e2e6f7267'
                     19:  );
                     20: 
                     21: INSERT INTO identities (
                     22:   type, data
                     23: ) VALUES ( /* %any */
                     24:   0, '%any'
                     25: );
                     26: 
                     27: INSERT INTO identities (
                     28:   type, data
                     29: ) VALUES ( /* subjkey of moon.strongswan.org */
                     30:   11, X'MOON_SPK_HEX'
                     31:  );
                     32: 
                     33: INSERT INTO identities (
                     34:   type, data
                     35: ) VALUES ( /* subjkey of carol@strongswan.org */
                     36:   11, X'CAROL_SPK_HEX'
                     37:  );
                     38: 
                     39: INSERT INTO identities (
                     40:   type, data
                     41: ) VALUES ( /* subjkey of dave@strongswan.org */
                     42:   11, X'DAVE_SPK_HEX'
                     43:  );
                     44: 
                     45: /* Raw RSA public keys */
                     46: 
                     47: INSERT INTO certificates (
                     48:    type, keytype, data
                     49: ) VALUES ( /* moon.strongswan.org */
                     50:   6, 1, X'MOON_PUB_HEX'
                     51: );
                     52: 
                     53: INSERT INTO certificates (
                     54:    type, keytype, data
                     55: ) VALUES ( /* carol@strongswan.org */
                     56:   6, 1, X'CAROL_PUB_HEX'
                     57: );
                     58: 
                     59: INSERT INTO certificates (
                     60:    type, keytype, data
                     61: ) VALUES ( /* dave@strongswan.org */
                     62:   6, 1, X'DAVE_PUB_HEX'
                     63: );
                     64: 
                     65: INSERT INTO certificate_identity (
                     66:   certificate, identity
                     67: ) VALUES (
                     68:   1, 1
                     69: );
                     70: 
                     71: INSERT INTO certificate_identity (
                     72:   certificate, identity
                     73: ) VALUES (
                     74:   1, 5
                     75: );
                     76: 
                     77: INSERT INTO certificate_identity (
                     78:   certificate, identity
                     79: ) VALUES (
                     80:   2, 2
                     81: );
                     82: 
                     83: INSERT INTO certificate_identity (
                     84:   certificate, identity
                     85: ) VALUES (
                     86:   2, 6
                     87: );
                     88: 
                     89: INSERT INTO certificate_identity (
                     90:   certificate, identity
                     91: ) VALUES (
                     92:   3, 3
                     93: );
                     94: 
                     95: INSERT INTO certificate_identity (
                     96:   certificate, identity
                     97: ) VALUES (
                     98:   3, 7
                     99: );
                    100: 
                    101: /* Private Keys */
                    102: 
                    103: INSERT INTO private_keys (
                    104:    type, data
                    105: ) VALUES ( /* key of 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, 1
                    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
                    131: ) VALUES (
                    132:   'rw', 1, 1, 4
                    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: