Return to data.sql.in CVS log

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

Annotation of embedaddon/strongswan/testing/tests/sql/rw-rsa/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 ( /* carol@strongswan.org */
                      6:   3, X'6361726f6c407374726f6e677377616e2e6f7267'
                      7:  );
                      8: 
                      9: INSERT INTO identities (
                     10:   type, data
                     11: ) VALUES ( /* moon.strongswan.org */
                     12:   2, X'6d6f6f6e2e7374726f6e677377616e2e6f7267'
                     13:  );
                     14: 
                     15: INSERT INTO identities (
                     16:   type, data
                     17: ) VALUES ( /* subjkey of carol@strongswan.org */
                     18:   11, X'CAROL_SPK_HEX'
                     19:  );
                     20: 
                     21: INSERT INTO identities (
                     22:   type, data
                     23: ) VALUES ( /* subjkey of moon.strongswan.org */
                     24:   11, X'MOON_SPK_HEX'
                     25:  );
                     26: 
                     27: /* Certificates */
                     28: 
                     29: INSERT INTO certificates (
                     30:    type, keytype, data
                     31: ) VALUES ( /* carol@strongswan.org */
                     32:   6, 1, X'CAROL_PUB_HEX'
                     33: );
                     34: 
                     35: INSERT INTO certificates (
                     36:    type, keytype, data
                     37: ) VALUES ( /* moon.strongswan.org */
                     38:   6, 1, X'MOON_PUB_HEX'
                     39: );
                     40: 
                     41: INSERT INTO certificate_identity (
                     42:   certificate, identity
                     43: ) VALUES (
                     44:   1, 1
                     45: );
                     46: 
                     47: INSERT INTO certificate_identity (
                     48:   certificate, identity
                     49: ) VALUES (
                     50:   1, 3
                     51: );
                     52: 
                     53: INSERT INTO certificate_identity (
                     54:   certificate, identity
                     55: ) VALUES (
                     56:   2, 2
                     57: );
                     58: 
                     59: INSERT INTO certificate_identity (
                     60:   certificate, identity
                     61: ) VALUES (
                     62:   2, 4
                     63: );
                     64: 
                     65: /* Private Keys */
                     66: 
                     67: INSERT INTO private_keys (
                     68:    type, data
                     69: ) VALUES ( /* key of carol@strongswan.org' */
                     70:   1, X'CAROL_KEY_HEX'
                     71: );
                     72: 
                     73: INSERT INTO private_key_identity (
                     74:   private_key, identity
                     75: ) VALUES (
                     76:   1, 1
                     77: );
                     78: 
                     79: INSERT INTO private_key_identity (
                     80:   private_key, identity
                     81: ) VALUES (
                     82:   1, 3
                     83: );
                     84: 
                     85: /* Configurations */
                     86: 
                     87: INSERT INTO ike_configs (
                     88:   local, remote
                     89: ) VALUES (
                     90:   'PH_IP_CAROL', 'PH_IP_MOON'
                     91: );
                     92: 
                     93: INSERT INTO peer_configs (
                     94:   name, ike_cfg, local_id, remote_id
                     95: ) VALUES (
                     96:   'home', 1, 1, 2
                     97: );
                     98: 
                     99: INSERT INTO child_configs (
                    100:   name, updown
                    101: ) VALUES (
                    102:   'home', '/usr/local/libexec/ipsec/_updown iptables'
                    103: );
                    104: 
                    105: INSERT INTO peer_config_child_config (
                    106:   peer_cfg, child_cfg
                    107: ) VALUES (
                    108:   1, 1
                    109: );
                    110: 
                    111: INSERT INTO traffic_selectors (
                    112:   type, start_addr, end_addr
                    113: ) VALUES ( /* 10.1.0.0/16 */
                    114:   7, X'0a010000', X'0a01ffff'
                    115: );
                    116: 
                    117: INSERT INTO traffic_selectors (
                    118:   type
                    119: ) VALUES ( /* dynamic/32 */
                    120:   7
                    121: );
                    122: 
                    123: INSERT INTO child_config_traffic_selector (
                    124:   child_cfg, traffic_selector, kind
                    125: ) VALUES (
                    126:   1, 1, 1
                    127: );
                    128: 
                    129: INSERT INTO child_config_traffic_selector (
                    130:        child_cfg, traffic_selector, kind
                    131: ) VALUES (
                    132:   1, 2, 2
                    133: );
                    134: