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 ! 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>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to data.sql.in CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / strongswan / testing / tests / sql / ip-split-pools-db-restart / hosts / moon / etc / ipsec.d