Annotation of embedaddon/strongswan/testing/tests/sql/ip-pool-db-expired/hosts/moon/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 ( /* 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: INSERT INTO identities (
! 52: type, data
! 53: ) VALUES ( /* alice@strongswan.org */
! 54: 3, X'616c696365407374726f6e677377616e2e6f7267'
! 55: );
! 56:
! 57: /* Certificates */
! 58:
! 59: INSERT INTO certificates (
! 60: type, keytype, data
! 61: ) VALUES ( /* C=CH, O=strongSwan Project, CN=strongSwan Root CA */
! 62: 1, 1, X'CA_CERT_HEX'
! 63: );
! 64:
! 65: INSERT INTO certificates (
! 66: type, keytype, data
! 67: ) VALUES ( /* C=CH, O=strongSwan Project, CN=moon.strongswan.org */
! 68: 1, 1, X'MOON_CERT_HEX'
! 69: );
! 70:
! 71: INSERT INTO certificate_identity (
! 72: certificate, identity
! 73: ) VALUES (
! 74: 1, 1
! 75: );
! 76:
! 77: INSERT INTO certificate_identity (
! 78: certificate, identity
! 79: ) VALUES (
! 80: 1, 2
! 81: );
! 82:
! 83: INSERT INTO certificate_identity (
! 84: certificate, identity
! 85: ) VALUES (
! 86: 1, 3
! 87: );
! 88:
! 89: INSERT INTO certificate_identity (
! 90: certificate, identity
! 91: ) VALUES (
! 92: 2, 4
! 93: );
! 94:
! 95: INSERT INTO certificate_identity (
! 96: certificate, identity
! 97: ) VALUES (
! 98: 2, 5
! 99: );
! 100:
! 101: /* Private Keys */
! 102:
! 103: INSERT INTO private_keys (
! 104: type, data
! 105: ) VALUES ( /* key of 'C=CH, O=strongSwan Project, CN=moon.strongswan.org' */
! 106: 1, X'MOON_KEY_HEX'
! 107: );
! 108:
! 109: INSERT INTO private_key_identity (
! 110: private_key, identity
! 111: ) VALUES (
! 112: 1, 4
! 113: );
! 114:
! 115: INSERT INTO private_key_identity (
! 116: private_key, identity
! 117: ) VALUES (
! 118: 1, 5
! 119: );
! 120:
! 121: /* Configurations */
! 122:
! 123: INSERT INTO ike_configs (
! 124: local, remote
! 125: ) VALUES (
! 126: 'PH_IP_MOON', '0.0.0.0'
! 127: );
! 128:
! 129: INSERT INTO peer_configs (
! 130: name, ike_cfg, local_id, remote_id, pool
! 131: ) VALUES (
! 132: 'rw', 1, 4, 6, 'bigpool'
! 133: );
! 134:
! 135: INSERT INTO child_configs (
! 136: name, updown
! 137: ) VALUES (
! 138: 'rw', '/usr/local/libexec/ipsec/_updown iptables'
! 139: );
! 140:
! 141: INSERT INTO peer_config_child_config (
! 142: peer_cfg, child_cfg
! 143: ) VALUES (
! 144: 1, 1
! 145: );
! 146:
! 147: INSERT INTO traffic_selectors (
! 148: type, start_addr, end_addr
! 149: ) VALUES ( /* 10.1.0.0/16 */
! 150: 7, X'0a010000', X'0a01ffff'
! 151: );
! 152:
! 153: INSERT INTO traffic_selectors (
! 154: type
! 155: ) VALUES ( /* dynamic/32 */
! 156: 7
! 157: );
! 158:
! 159: INSERT INTO child_config_traffic_selector (
! 160: child_cfg, traffic_selector, kind
! 161: ) VALUES (
! 162: 1, 1, 0
! 163: );
! 164:
! 165: INSERT INTO child_config_traffic_selector (
! 166: child_cfg, traffic_selector, kind
! 167: ) VALUES (
! 168: 1, 2, 3
! 169: );
! 170:
! 171: /* Pools */
! 172:
! 173: INSERT INTO pools (
! 174: name, start, end, timeout
! 175: ) VALUES (
! 176: 'bigpool', X'0a030001', X'0a030006', 3600
! 177: );
! 178:
! 179: INSERT INTO addresses (
! 180: pool, address, identity, acquired, released
! 181: ) VALUES (
! 182: 1, X'0a030001', 8, 1211299013 , 1211299205
! 183: );
! 184:
! 185: INSERT INTO addresses (
! 186: pool, address, identity, acquired, released
! 187: ) VALUES (
! 188: 1, X'0a030002', 9, 1211299031, 1211299187
! 189: );
! 190:
! 191: INSERT INTO addresses (
! 192: pool, address
! 193: ) VALUES (
! 194: 1, X'0a030003'
! 195: );
! 196:
! 197: INSERT INTO addresses (
! 198: pool, address
! 199: ) VALUES (
! 200: 1, X'0a030004'
! 201: );
! 202:
! 203: INSERT INTO addresses (
! 204: pool, address
! 205: ) VALUES (
! 206: 1, X'0a030005'
! 207: );
! 208:
! 209: INSERT INTO addresses (
! 210: pool, address
! 211: ) VALUES (
! 212: 1, X'0a030006'
! 213: );
! 214:
! 215: INSERT INTO leases (
! 216: address, identity, acquired, released
! 217: ) VALUES (
! 218: 1, 8, 1211299013 , 1211299205
! 219: );
! 220:
! 221: INSERT INTO leases (
! 222: address, identity, acquired, released
! 223: ) VALUES (
! 224: 2, 9, 1211299031, 1211299187
! 225: );
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>