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

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: