testing/tests/sql/rw-rsa/hosts/carol/etc/ipsec.d/data.sql

   1 /* Identities */
   2
   3 INSERT INTO identities (
   4   type, data
   5 ) VALUES ( /* carol@strongswan.org */
   6   3, X'6361726f6c407374726f6e677377616e2e6f7267'
   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 carol@strongswan.org */
  18   11, X'1fa1a988d9648cb5a0a2546439b4f23d745d6e7c'
  19  );
  20
  21 INSERT INTO identities (
  22   type, data
  23 ) VALUES ( /* subjkey of moon.strongswan.org */
  24   11, X'6a9c74d1f8897989f65a94e989f1fac3649d292e'
  25  );
  26
  27 /* Certificates */
  28
  29 INSERT INTO certificates (
  30    type, keytype, data
  31 ) VALUES ( /* carol@strongswan.org */
  32   6, 1, X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100d05d594f8117bc78972a3ec479ebe1400e53cf72410b93e6f74fa17cf1ea444fb23600bae92d81747e49a2e4407c3f6118033d22a3e67ce69a53907ffad646bfbc3b6abe0bdd9a5080a690dbd919a9a8e70d9694e319e93e5d9361eff9033ac53fc6cd6c95af574c62effbb72c03d41c3b696fc7aa4444483bbaabde555aef8bce0e9797108d11ecf462c66b37f7c2e812f6ab3280a8c05b207156f0e3a787e9c4638205e40ce466716bc35d8623bd99f3cda9c3dee5c8ac19852cff18c405049c7eae735dc393f5209c13946e4f51da030ad7bf31caf58a203eccea2fc79e71d46a06c5dba85d65397a0adfd4cb5a9517fd3dcf17af8ab7584293026b19ad510203010001'
  33 );
  34
  35 INSERT INTO certificates (
  36    type, keytype, data
  37 ) VALUES ( /* moon.strongswan.org */
  38   6, 1, X'30820122300d06092a864886f70d01010105000382010f003082010a0282010100ca2f633dd4bbba0586215b15a0312f73f533124f0b339b9ae13bb648b02b4c468e0f01e630fbef92197b7708f5dbffea7e496286966d75acf13bd5e4377a1821d82de102eadf9963b489041a0b0f9f76b79e2150aa39020e3fa52a677dbb879c986291e4f1542fe2f0494e9c5c954d4faa75a17aa7b56652f1b16efbdcb46697f7d0b7f520bc990205365938d2cd31f2beed30e761a56c02d9dc82f0cdefc9d43447b6a98f7628aed2ac127a4a9504838f66e7517e5e0b0672c8165474bce689f73a6fc6e3c72b2c45498ddbbc0b17b04915606fe94f256cc777c42c534560ffbbe5aacdd944cc8db4d2abaf8a294af55b03a6a01a54d78430ab78389753c2870203010001'
  39 );
  40
  41 INSERT INTO certificate_identity (
  42   certificate, identity
  43 ) VALUES (
  44   1, 1
  45 );
  46
  47 INSERT INTO certificate_identity (
  48   certificate, identity
  49 ) VALUES (
  50   1, 3
  51 );
  52
  53 INSERT INTO certificate_identity (
  54   certificate, identity
  55 ) VALUES (
  56   2, 2
  57 );
  58
  59 INSERT INTO certificate_identity (
  60   certificate, identity
  61 ) VALUES (
  62   2, 4
  63 );
  64
  65 /* Private Keys */
  66
  67 INSERT INTO private_keys (
  68    type, data
  69 ) VALUES ( /* key of carol@strongswan.org' */
  70   1, X'308204a40201000282010100d05d594f8117bc78972a3ec479ebe1400e53cf72410b93e6f74fa17cf1ea444fb23600bae92d81747e49a2e4407c3f6118033d22a3e67ce69a53907ffad646bfbc3b6abe0bdd9a5080a690dbd919a9a8e70d9694e319e93e5d9361eff9033ac53fc6cd6c95af574c62effbb72c03d41c3b696fc7aa4444483bbaabde555aef8bce0e9797108d11ecf462c66b37f7c2e812f6ab3280a8c05b207156f0e3a787e9c4638205e40ce466716bc35d8623bd99f3cda9c3dee5c8ac19852cff18c405049c7eae735dc393f5209c13946e4f51da030ad7bf31caf58a203eccea2fc79e71d46a06c5dba85d65397a0adfd4cb5a9517fd3dcf17af8ab7584293026b19ad51020301000102820101008a86f560a12fd9b2c6b5646395b757db116b7108c1ebe399f3a43275f213d0f4b743a5fa9e1a0dee1823f6b30f984b3ecf0b20330e8aa7515d1adf7fe6915d1a0e17e6a0911cf4823ef5fe6adb8c6f3a86da86d9579f1b6dc622bd4320e79fc411e1a72360e4e1023ce8d60df2aa5cf3a420361ba5bc9b34f6d8e578fc8067aef457ff2a5a91f7c7c8a4f242cc46ab1cff18d6d1a4d8b82b5791df1f18a04b8cb2da235c3a795900fa7ffbbcb4b1d079a504673794eeca5e75c8c16ad2558965453515f57180b8dc518710aa874cd3bcdeddf109d5b553c27a351437f9c1bcdf8940f3ff8632dd59f6c8e01107b4bbf49c6c5409b6e9ecb29eada333800fa5d102818100f5537045d067df4d786df67e1cfea01ce3ca6de3f06be48efd8b4dc48c1ec19a711003875ee202343c851c8f970d2160a2e4d1108da6437af6bccfae803f61fc450582a89aa0906cba65fc7033aa584c1a2a17e96b2f368951aedaa5261f6e1c14999cfa7f4c4091890eff281cb4e6f37209f4b6d5778607caeca0a15137746d02818100d96e379ba5b4ed604d84a7ed71678a1f23391b749a697289bd3bee5d17985af89264f5ec35d3e37b1e44d6fdafec8a78ae199e0bb680f59f9800bb894ba5b31ee964f3ddc142f361835cf49a1edb75330f44f33c26c56e0752ae3fe0df760838b6437b99a131cb544d64da996baf3bc3f5709cc75f134b048cdebbf8bed1a5f502818017e2d8e2a34909cff432d8b62cc289fa661f7695a3fa0d55f2cfd67195a704f8b19b7a8c7aab8cc563431ea5c87249d6abe595898411352ecac9557b4b1760c5fc3e6e1b567addb5086d17a8210fabeb34fcf6390eeb98e6c3e23f7da6f99671fb7b7d725264ad40be548c796e5a1ac6874afaddb6691dceb26e59b17b43e7fd02818100ac90cb559f089fb56510b9eebba8bf78c30dd9fa8b6ad15afc738a551c1af1688357d9cea5520c2374fc91dd3a38f4159fa7f945b68d576458d18c0605a1f72dbb734211680768fea5b1aaf87f31122d7a1af12976640f55848b836b482f778afb2d47f5c077b2b6afce31a8be4c8f949141d54c6eeaf309237ccb973a6b4dd902818025ec4178c7f7c017c46a93fbdb72e2e3b199ae33c9fa6834f81b75b481cd6756124c744c821b126b07ea9852dc58de40cc87f160209d8af3b4bac4862778d3e21cbfdfcdbbfaad8911500f43a43041b88eefb27c66adfffeb9c8add95d1a4ed05f0bd81a4eda79fd4a0885a4a3bad0dcddecf83401c19df721d6cc7163c4125e'
  71 );
  72
  73 INSERT INTO private_key_identity (
  74   private_key, identity
  75 ) VALUES (
  76   1, 1
  77 );
  78
  79 INSERT INTO private_key_identity (
  80   private_key, identity
  81 ) VALUES (
  82   1, 3
  83 );
  84
  85 /* Configurations */
  86
  87 INSERT INTO ike_configs (
  88   local, remote
  89 ) VALUES (
  90   'PH_IP_CAROL', 'PH_IP_MOON'
  91 );
  92
  93 INSERT INTO peer_configs (
  94   name, ike_cfg, local_id, remote_id
  95 ) VALUES (
  96   'home', 1, 1, 2
  97 );
  98
  99 INSERT INTO child_configs (
 100   name, updown
 101 ) VALUES (
 102   'home', 'ipsec _updown iptables'
 103 );
 104
 105 INSERT INTO peer_config_child_config (
 106   peer_cfg, child_cfg
 107 ) VALUES (
 108   1, 1
 109 );
 110
 111 INSERT INTO traffic_selectors (
 112   type, start_addr, end_addr
 113 ) VALUES ( /* 10.1.0.0/16 */
 114   7, X'0a010000', X'0a01ffff'
 115 );
 116
 117 INSERT INTO traffic_selectors (
 118   type
 119 ) VALUES ( /* dynamic/32 */
 120   7
 121 );
 122
 123 INSERT INTO child_config_traffic_selector (
 124   child_cfg, traffic_selector, kind
 125 ) VALUES (
 126   1, 1, 1
 127 );
 128
 129 INSERT INTO child_config_traffic_selector (
 130         child_cfg, traffic_selector, kind
 131 ) VALUES (
 132   1, 2, 2
 133 );
 134