Return to data.sql.in CVS log

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

Annotation of embedaddon/strongswan/testing/tests/sql/rw-rsa/hosts/dave/etc/ipsec.d/data.sql.in, revision 1.1

1.1     ! misho       1: /* Identities */
        !             2: 
        !             3: INSERT INTO identities (
        !             4:   type, data
        !             5: ) VALUES ( /* dave@strongswan.org */
        !             6:   3, X'64617665407374726f6e677377616e2e6f7267'
        !             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 dave@strongswan.org */
        !            18:   11, X'DAVE_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 ( /* dave@strongswan.org */
        !            32:   6, 1, X'DAVE_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: $INSERT INTO certificate_identity (
        !            47:   certificate, identity
        !            48: ) VALUES (
        !            49:   1, 3
        !            50: );
        !            51: 
        !            52: INSERT INTO certificate_identity (
        !            53:   certificate, identity
        !            54: ) VALUES (
        !            55:   2, 2
        !            56: );
        !            57: 
        !            58: INSERT INTO certificate_identity (
        !            59:   certificate, identity
        !            60: ) VALUES (
        !            61:   2, 4
        !            62: );
        !            63: 
        !            64: /* Private Keys */
        !            65: 
        !            66: INSERT INTO private_keys (
        !            67:    type, data
        !            68: ) VALUES ( /* key of dave@strongswan.org */
        !            69:   1, X'DAVE_KEY_HEX'
        !            70: );
        !            71: 
        !            72: INSERT INTO private_key_identity (
        !            73:   private_key, identity
        !            74: ) VALUES (
        !            75:   1, 1
        !            76: );
        !            77: 
        !            78: INSERT INTO private_key_identity (
        !            79:   private_key, identity
        !            80: ) VALUES (
        !            81:   1, 3
        !            82: );
        !            83: 
        !            84: /* Configurations */
        !            85: 
        !            86: INSERT INTO ike_configs (
        !            87:   local, remote
        !            88: ) VALUES (
        !            89:   'PH_IP_DAVE', 'PH_IP_MOON'
        !            90: );
        !            91: 
        !            92: INSERT INTO peer_configs (
        !            93:   name, ike_cfg, local_id, remote_id
        !            94: ) VALUES (
        !            95:   'home', 1, 1, 2
        !            96: );
        !            97: 
        !            98: INSERT INTO child_configs (
        !            99:   name, updown
        !           100: ) VALUES (
        !           101:   'home', '/usr/local/libexec/ipsec/_updown iptables'
        !           102: );
        !           103: 
        !           104: INSERT INTO peer_config_child_config (
        !           105:   peer_cfg, child_cfg
        !           106: ) VALUES (
        !           107:   1, 1
        !           108: );
        !           109: 
        !           110: INSERT INTO traffic_selectors (
        !           111:   type, start_addr, end_addr
        !           112: ) VALUES ( /* 10.1.0.0/16 */
        !           113:   7, X'0a010000', X'0a01ffff'
        !           114: );
        !           115: 
        !           116: INSERT INTO traffic_selectors (
        !           117:   type
        !           118: ) VALUES ( /* dynamic/32 */
        !           119:   7
        !           120: );
        !           121: 
        !           122: INSERT INTO child_config_traffic_selector (
        !           123:   child_cfg, traffic_selector, kind
        !           124: ) VALUES (
        !           125:   1, 1, 1
        !           126: );
        !           127: 
        !           128: INSERT INTO child_config_traffic_selector (
        !           129:        child_cfg, traffic_selector, kind
        !           130: ) VALUES (
        !           131:   1, 2, 2
        !           132: );
        !           133: