Annotation of embedaddon/strongswan/testing/tests/sql/ip-split-pools-db-restart/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 ( /* 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 ( /* moon.strongswan.org */
                     24:   2, X'6d6f6f6e2e7374726f6e677377616e2e6f7267'
                     25:  );
                     26: 
                     27: INSERT INTO identities (
                     28:   type, data
                     29: ) VALUES ( /* subjkey of 'C=CH, O=strongSwan Project, CN=moon.strongswan.org' */
                     30:   11, X'MOON_SPK_HEX'
                     31:  );
                     32: 
                     33: INSERT INTO identities (
                     34:   type, data
                     35: ) VALUES ( /* %any */
                     36:   0, '%any'
                     37: );
                     38: 
                     39: INSERT INTO identities (
                     40:   type, data
                     41: ) VALUES ( /* carol@strongswan.org */
                     42:   3, X'6361726f6c407374726f6e677377616e2e6f7267'
                     43:  );
                     44: 
                     45: INSERT INTO identities (
                     46:   type, data
                     47: ) VALUES ( /* dave@strongswan.org */
                     48:   3, X'64617665407374726f6e677377616e2e6f7267'
                     49:  );
                     50: 
                     51: /* Certificates */
                     52: 
                     53: INSERT INTO certificates (
                     54:    type, keytype, data
                     55: ) VALUES ( /* C=CH, O=strongSwan Project, CN=strongSwan Root CA */
                     56:   1, 1, X'CA_CERT_HEX'
                     57: );
                     58: 
                     59: INSERT INTO certificates (
                     60:    type, keytype, data
                     61: ) VALUES ( /* C=CH, O=strongSwan Project, CN=moon.strongswan.org */
                     62:   1, 1, X'MOON_CERT_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, 2
                     75: );
                     76: 
                     77: INSERT INTO certificate_identity (
                     78:   certificate, identity
                     79: ) VALUES (
                     80:   1, 3
                     81: );
                     82: 
                     83: INSERT INTO certificate_identity (
                     84:   certificate, identity
                     85: ) VALUES (
                     86:   2, 4
                     87: );
                     88: 
                     89: INSERT INTO certificate_identity (
                     90:   certificate, identity
                     91: ) VALUES (
                     92:   2, 5
                     93: );
                     94: 
                     95: /* Private Keys */
                     96: 
                     97: INSERT INTO private_keys (
                     98:    type, data
                     99: ) VALUES ( /* key of 'C=CH, O=strongSwan Project, CN=moon.strongswan.org' */
                    100:   1, X'MOON_KEY_HEX'
                    101: );
                    102: 
                    103: INSERT INTO private_key_identity (
                    104:   private_key, identity
                    105: ) VALUES (
                    106:   1, 4
                    107: );
                    108: 
                    109: INSERT INTO private_key_identity (
                    110:   private_key, identity
                    111: ) VALUES (
                    112:   1, 5
                    113: );
                    114: 
                    115: /* Configurations */
                    116: 
                    117: INSERT INTO ike_configs (
                    118:   local, remote
                    119: ) VALUES (
                    120:   'PH_IP_MOON', '0.0.0.0'
                    121: );
                    122: 
                    123: INSERT INTO peer_configs (
                    124:   name, ike_cfg, local_id, remote_id, pool
                    125: ) VALUES (
                    126:   'rw', 1, 4, 6, 'pool0,pool1'
                    127: );
                    128: 
                    129: INSERT INTO child_configs (
                    130:   name, updown
                    131: ) VALUES (
                    132:   'rw', '/usr/local/libexec/ipsec/_updown iptables'
                    133: );
                    134: 
                    135: INSERT INTO peer_config_child_config (
                    136:   peer_cfg, child_cfg
                    137: ) VALUES (
                    138:   1, 1
                    139: );
                    140: 
                    141: INSERT INTO traffic_selectors (
                    142:   type, start_addr, end_addr
                    143: ) VALUES ( /* 10.1.0.0/16 */
                    144:   7, X'0a010000', X'0a01ffff'
                    145: );
                    146: 
                    147: INSERT INTO traffic_selectors (
                    148:   type
                    149: ) VALUES ( /* dynamic/32 */
                    150:   7
                    151: );
                    152: 
                    153: INSERT INTO child_config_traffic_selector (
                    154:   child_cfg, traffic_selector, kind
                    155: ) VALUES (
                    156:   1, 1, 0
                    157: );
                    158: 
                    159: INSERT INTO child_config_traffic_selector (
                    160:   child_cfg, traffic_selector, kind
                    161: ) VALUES (
                    162:   1, 2, 3
                    163: );
                    164: 
                    165: /* Pools */
                    166: 
                    167: INSERT INTO pools (
                    168:   name, start, end, timeout
                    169: ) VALUES (
                    170:   'pool0', X'0a030001', X'0a030002', 0
                    171: );
                    172: 
                    173: INSERT INTO pools (
                    174:   name, start, end, timeout
                    175: ) VALUES (
                    176:   'pool1', X'0a030101', X'0a030102', 0
                    177: );
                    178: 
                    179: INSERT INTO addresses (
                    180:   pool, address, identity, acquired, released
                    181: ) VALUES (
                    182:   1, X'0a030001', 7, 1247817255, 1247817277
                    183: );
                    184: 
                    185: INSERT INTO addresses (
                    186:   pool, address
                    187: ) VALUES (
                    188:   1, X'0a030002'
                    189: );
                    190: 
                    191: INSERT INTO addresses (
                    192:   pool, address, identity, acquired, released
                    193: ) VALUES (
                    194:   2, X'0a030101', 8, 1247817257, 1247817278
                    195: );
                    196: 
                    197: INSERT INTO addresses (
                    198:   pool, address
                    199: ) VALUES (
                    200:   2, X'0a030102'
                    201: );
                    202: 
                    203: INSERT INTO leases (
                    204:   address, identity, acquired, released
                    205: ) VALUES (
                    206:   1, 7, 1247817255, 1247817277
                    207: );
                    208: 
                    209: INSERT INTO leases (
                    210:   address, identity, acquired, released
                    211: ) VALUES (
                    212:   3, 8, 1247817257, 1247817278
                    213: );

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>