Return to data.sql.in CVS log

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

Annotation of embedaddon/strongswan/testing/tests/sql/ip-split-pools-db/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 ( /* 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 ( /* dave@strongswan.org */
        !            24:   3, X'64617665407374726f6e677377616e2e6f7267'
        !            25:  );
        !            26: 
        !            27: INSERT INTO identities (
        !            28:   type, data
        !            29: ) VALUES ( /* subjkey of 'C=CH, O=strongSwan Project, CN=dave@strongswan.org' */
        !            30:   11, X'DAVE_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=dave@strongswan.org */
        !            50:   1, 1, X'DAVE_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=dave@strongswan.org' */
        !            88:   1, X'DAVE_KEY_HEX'
        !            89: );
        !            90: 
        !            91: INSERT INTO private_key_identity (
        !            92:   private_key, identity
        !            93: ) VALUES (
        !            94:   1, 4
        !            95: );
        !            96: 
        !            97: INSERT INTO private_key_identity (
        !            98:   private_key, identity
        !            99: ) VALUES (
        !           100:   1, 5
        !           101: );
        !           102: 
        !           103: /* Configurations */
        !           104: 
        !           105: INSERT INTO ike_configs (
        !           106:   local, remote
        !           107: ) VALUES (
        !           108:   'PH_IP_DAVE', 'PH_IP_MOON'
        !           109: );
        !           110: 
        !           111: INSERT INTO peer_configs (
        !           112:   name, ike_cfg, local_id, remote_id, virtual
        !           113: ) VALUES (
        !           114:   'home', 1, 4, 6, '0.0.0.0'
        !           115: );
        !           116: 
        !           117: INSERT INTO child_configs (
        !           118:   name, updown
        !           119: ) VALUES (
        !           120:   'home', '/usr/local/libexec/ipsec/_updown iptables'
        !           121: );
        !           122: 
        !           123: INSERT INTO peer_config_child_config (
        !           124:   peer_cfg, child_cfg
        !           125: ) VALUES (
        !           126:   1, 1
        !           127: );
        !           128: 
        !           129: INSERT INTO traffic_selectors (
        !           130:   type, start_addr, end_addr
        !           131: ) VALUES ( /* 10.1.0.0/16 */
        !           132:   7, X'0a010000', X'0a01ffff'
        !           133: );
        !           134: 
        !           135: INSERT INTO traffic_selectors (
        !           136:   type
        !           137: ) VALUES ( /* dynamic/32 */
        !           138:   7
        !           139: );
        !           140: 
        !           141: INSERT INTO child_config_traffic_selector (
        !           142:   child_cfg, traffic_selector, kind
        !           143: ) VALUES (
        !           144:   1, 1, 1
        !           145: );
        !           146: 
        !           147: INSERT INTO child_config_traffic_selector (
        !           148:        child_cfg, traffic_selector, kind
        !           149: ) VALUES (
        !           150:   1, 2, 2
        !           151: );
        !           152: