Added ITA components to database
[strongswan.git] / src / libimcv / imv / data.sql
1 /* Products */
2
3 INSERT INTO products ( /* 1 */
4 name
5 ) VALUES (
6 'Debian 7.0'
7 );
8
9 INSERT INTO products ( /* 2 */
10 name
11 ) VALUES (
12 'Debian 7.0 i686'
13 );
14
15 INSERT INTO products ( /* 3 */
16 name
17 ) VALUES (
18 'Debian 7.0 x86_64'
19 );
20
21 INSERT INTO products ( /* 4 */
22 name
23 ) VALUES (
24 'Ubuntu 10.04'
25 );
26
27 INSERT INTO products ( /* 5 */
28 name
29 ) VALUES (
30 'Ubuntu 10.04 i686'
31 );
32
33 INSERT INTO products ( /* 6 */
34 name
35 ) VALUES (
36 'Ubuntu 10.04 x86_64'
37 );
38
39 INSERT INTO products ( /* 7 */
40 name
41 ) VALUES (
42 'Ubuntu 10.10'
43 );
44
45 INSERT INTO products ( /* 8 */
46 name
47 ) VALUES (
48 'Ubuntu 10.10 i686'
49 );
50
51 INSERT INTO products ( /* 9 */
52 name
53 ) VALUES (
54 'Ubuntu 10.10 x86_64'
55 );
56
57 INSERT INTO products ( /* 10 */
58 name
59 ) VALUES (
60 'Ubuntu 11.04'
61 );
62
63 INSERT INTO products ( /* 11 */
64 name
65 ) VALUES (
66 'Ubuntu 11.04 i686'
67 );
68
69 INSERT INTO products ( /* 12 */
70 name
71 ) VALUES (
72 'Ubuntu 11.04 x86_64'
73 );
74
75 INSERT INTO products ( /* 13 */
76 name
77 ) VALUES (
78 'Ubuntu 11.10'
79 );
80
81 INSERT INTO products ( /* 14 */
82 name
83 ) VALUES (
84 'Ubuntu 11.10 i686'
85 );
86
87 INSERT INTO products ( /* 15 */
88 name
89 ) VALUES (
90 'Ubuntu 11.10 x86_64'
91 );
92
93 INSERT INTO products ( /* 16 */
94 name
95 ) VALUES (
96 'Ubuntu 12.04'
97 );
98
99 INSERT INTO products ( /* 17 */
100 name
101 ) VALUES (
102 'Ubuntu 12.04 i686'
103 );
104
105 INSERT INTO products ( /* 18 */
106 name
107 ) VALUES (
108 'Ubuntu 12.04 x86_64'
109 );
110
111 INSERT INTO products ( /* 19 */
112 name
113 ) VALUES (
114 'Ubuntu 12.10'
115 );
116
117 INSERT INTO products ( /* 20 */
118 name
119 ) VALUES (
120 'Ubuntu 12.10 i686'
121 );
122
123 INSERT INTO products ( /* 21 */
124 name
125 ) VALUES (
126 'Ubuntu 12.10 x86_64'
127 );
128
129 INSERT INTO products ( /* 22 */
130 name
131 ) VALUES (
132 'Ubuntu 13.04'
133 );
134
135 INSERT INTO products ( /* 23 */
136 name
137 ) VALUES (
138 'Ubuntu 13.04 i686'
139 );
140
141 INSERT INTO products ( /* 24 */
142 name
143 ) VALUES (
144 'Ubuntu 13.04 x86_64'
145 );
146
147 INSERT INTO products ( /* 25 */
148 name
149 ) VALUES (
150 'Android 4.1.1'
151 );
152
153 INSERT INTO products ( /* 26 */
154 name
155 ) VALUES (
156 'Android 4.2.1'
157 );
158
159 /* Directories */
160
161 INSERT INTO directories ( /* 1 */
162 path
163 ) VALUES (
164 '/bin'
165 );
166
167 INSERT INTO directories ( /* 2 */
168 path
169 ) VALUES (
170 '/etc'
171 );
172
173 INSERT INTO directories ( /* 3 */
174 path
175 ) VALUES (
176 '/lib'
177 );
178
179 INSERT INTO directories ( /* 4 */
180 path
181 ) VALUES (
182 '/lib/i386-linux-gnu'
183 );
184
185 INSERT INTO directories ( /* 5 */
186 path
187 ) VALUES (
188 '/lib/x86_64-linux-gnu'
189 );
190
191 INSERT INTO directories ( /* 6 */
192 path
193 ) VALUES (
194 '/lib/xtables'
195 );
196
197 INSERT INTO directories ( /* 7 */
198 path
199 ) VALUES (
200 '/sbin'
201 );
202
203 INSERT INTO directories ( /* 8 */
204 path
205 ) VALUES (
206 '/usr/bin'
207 );
208
209 INSERT INTO directories ( /* 9 */
210 path
211 ) VALUES (
212 '/usr/lib'
213 );
214
215 INSERT INTO directories ( /* 10 */
216 path
217 ) VALUES (
218 '/usr/lib/i386-linux-gnu'
219 );
220
221 INSERT INTO directories ( /* 11 */
222 path
223 ) VALUES (
224 '/usr/lib/x86_64-linux-gnu'
225 );
226
227 INSERT INTO directories ( /* 12 */
228 path
229 ) VALUES (
230 '/usr/sbin'
231 );
232
233 /* Files */
234
235 INSERT INTO files ( /* 1 */
236 name, dir
237 ) VALUES (
238 'libcrypto.so.1.0.0', 5
239 );
240
241 INSERT INTO files ( /* 2 */
242 name, dir
243 ) VALUES (
244 'libcrypto.so.1.0.0', 11
245 );
246
247 INSERT INTO files ( /* 3 */
248 name, dir
249 ) VALUES (
250 'libssl.so.1.0.0', 5
251 );
252
253 INSERT INTO files ( /* 4 */
254 name, dir
255 ) VALUES (
256 'libssl.so.1.0.0', 11
257 );
258
259 INSERT INTO files ( /* 5 */
260 name, dir
261 ) VALUES (
262 'openssl', 8
263 );
264
265 INSERT INTO files ( /* 6 */
266 name, dir
267 ) VALUES (
268 'tnc_config', 2
269 );
270
271 /* Algorithms */
272
273 INSERT INTO algorithms (
274 id, name
275 ) VALUES (
276 65536, 'SHA1-IMA'
277 );
278
279 INSERT INTO algorithms (
280 id, name
281 ) VALUES (
282 32768, 'SHA1'
283 );
284
285 INSERT INTO algorithms (
286 id, name
287 ) VALUES (
288 16384, 'SHA256'
289 );
290
291 INSERT INTO algorithms (
292 id, name
293 ) VALUES (
294 8192, 'SHA384'
295 );
296
297 /* File Hashes */
298
299 INSERT INTO file_hashes (
300 product, file, algo, hash
301 ) VALUES (
302 3, 2, 32768, X'6c6f8e12f6cbfba612e780374c4cdcd40f20968a'
303 );
304
305 INSERT INTO file_hashes (
306 product, file, algo, hash
307 ) VALUES (
308 3, 2, 16384, X'dbcecd19d59310183cf5c31ddee29e8d7bec64d3f9583aad074330a1b3024b07'
309 );
310
311 INSERT INTO file_hashes (
312 product, file, algo, hash
313 ) VALUES (
314 3, 2, 8192, X'197c5385e5853003188833d4f991136c1b0875fa416a60b1159f64e57e457b3184762c884a802a2bda194c058e3bd953'
315 );
316
317 INSERT INTO file_hashes (
318 product, file, algo, hash
319 ) VALUES (
320 3, 4, 32768, X'3ad204f99eb7262efab79cfca02628870ea76361'
321 );
322
323 INSERT INTO file_hashes (
324 product, file, algo, hash
325 ) VALUES (
326 3, 4, 16384, X'3a2170aad92fdd58b55e0e199822bc873cf587b2d1eb1ed7ed8dcea97ae86376'
327 );
328
329 INSERT INTO file_hashes (
330 product, file, algo, hash
331 ) VALUES (
332 3, 4, 8192, X'f778076baa876b5e4b502494a3db081fb09dd870dee6991d54104a74b7e009c58fe261db5ffd13c11e08ef0cefcfa59f'
333 );
334
335 INSERT INTO file_hashes (
336 product, file, algo, hash
337 ) VALUES (
338 3, 5, 32768, X'ecd9c7076cc0572724c7a67db7f19c2831e0445f'
339 );
340
341 INSERT INTO file_hashes (
342 product, file, algo, hash
343 ) VALUES (
344 3, 5, 16384, X'28f3ea5afd34444c8232ea75003131e294a0c9b847de300e4b205d38c1a41305'
345 );
346
347 INSERT INTO file_hashes (
348 product, file, algo, hash
349 ) VALUES (
350 3, 5, 8192, X'51921a8b9322f2d3f06d55002ff40a79da67e70cb563b2a50977642d603dfac2ccbb68b3d32a8bb350769b75d6254208'
351 );
352
353 INSERT INTO file_hashes (
354 product, file, algo, hash
355 ) VALUES (
356 21, 1, 32768, X'd9309b9e45928239d7a7b18711e690792632cce4'
357 );
358
359 INSERT INTO file_hashes (
360 product, file, algo, hash
361 ) VALUES (
362 21, 1, 16384, X'dbfa1856d278d8707c4989b30dd065b4bcd309908f0f2e6e66ff2aa83ff93f59'
363 );
364
365 INSERT INTO file_hashes (
366 product, file, algo, hash
367 ) VALUES (
368 21, 1, 8192, X'fb8d027f03bb5ebb47741ed247eb9e174127b714d20229885feb37e0979aeb14a1b74020cded891d680441093625729c'
369 );
370
371 INSERT INTO file_hashes (
372 product, file, algo, hash
373 ) VALUES (
374 21, 3, 32768, X'3715f2f94016a91fab5bbc503f0f1d43c5a9fc2b'
375 );
376
377 INSERT INTO file_hashes (
378 product, file, algo, hash
379 ) VALUES (
380 21, 3, 16384, X'c03a5296b5decb87b01517f9927a8b2349dfb29ff9f5ba084f994c155ca5d4be'
381 );
382
383 INSERT INTO file_hashes (
384 product, file, algo, hash
385 ) VALUES (
386 21, 3, 8192, X'b8bc345f56115235cc6091f61e312ce43ea54a5b99e7295002ae7b415fd35e06ec4c731ab70ad00d784bb53a318a2fa0'
387 );
388
389 INSERT INTO file_hashes (
390 product, file, algo, hash
391 ) VALUES (
392 21, 5, 32768, X'e59602f4edf24c1b36199588886d06665d4adcd7'
393 );
394
395 INSERT INTO file_hashes (
396 product, file, algo, hash
397 ) VALUES (
398 21, 5, 16384, X'090e1b77bda7fe665e498c6b5e09dbb7ddc5cfe57f213de48f4fb6736484f500'
399 );
400
401 INSERT INTO file_hashes (
402 product, file, algo, hash
403 ) VALUES (
404 21, 5, 8192, X'7cbdb4612a13443dba910ecdef5161f2213e52c9b4a2eef14bcee5d287e9df931cd022e9e9715518ad9c9b6e3384a668'
405 );
406
407 /* Packages */
408
409 INSERT INTO packages ( /* 1 */
410 name
411 ) VALUES (
412 'libssl-dev'
413 );
414
415 INSERT INTO packages ( /* 2 */
416 name
417 ) VALUES (
418 'libssl1.0.0'
419 );
420
421 INSERT INTO packages ( /* 3 */
422 name
423 ) VALUES (
424 'libssl1.0.0-dbg'
425 );
426
427 INSERT INTO packages ( /* 4 */
428 name
429 ) VALUES (
430 'openssl'
431 );
432
433 /* Versions */
434
435 INSERT INTO versions (
436 package, product, release, time
437 ) VALUES (
438 1, 1, '1.0.1e-2', 1366531494
439 );
440
441 INSERT INTO versions (
442 package, product, release, time
443 ) VALUES (
444 2, 1, '1.0.1e-2', 1366531494
445 );
446
447 INSERT INTO versions (
448 package, product, release, time
449 ) VALUES (
450 3, 1, '1.0.1e-2', 1366531494
451 );
452
453 INSERT INTO versions (
454 package, product, release, time
455 ) VALUES (
456 4, 1, '1.0.1e-2', 1366531494
457 );
458
459 /* Components */
460
461 INSERT INTO components (
462 vendor_id, name, qualifier
463 ) VALUES (
464 36906, 1, 33 /* ITA TGRUB */
465 );
466
467 INSERT INTO components (
468 vendor_id, name, qualifier
469 ) VALUES (
470 36906, 2, 33 /* ITA TBOOT */
471 );
472
473 INSERT INTO components (
474 vendor_id, name, qualifier
475 ) VALUES (
476 36906, 3, 33 /* ITA IMA - Trusted Platform */
477 );
478
479 INSERT INTO components (
480 vendor_id, name, qualifier
481 ) VALUES (
482 36906, 3, 34 /* ITA IMA - Operating System */
483 );
484
485 /* Groups */
486
487 INSERT INTO groups ( /* 1 */
488 name, parent
489 ) VALUES (
490 'Debian i686', 6
491 );
492
493 INSERT INTO groups ( /* 2 */
494 name, parent
495 ) VALUES (
496 'Debian x86_64', 6
497 );
498
499 INSERT INTO groups ( /* 3 */
500 name, parent
501 ) VALUES (
502 'Ubuntu i686', 6
503 );
504
505 INSERT INTO groups ( /* 4 */
506 name, parent
507 ) VALUES (
508 'Ubuntu x86_64', 6
509 );
510
511 INSERT INTO groups ( /* 5 */
512 name, parent
513 ) VALUES (
514 'Android', 7
515 );
516
517 INSERT INTO groups ( /* 6 */
518 name, parent
519 ) VALUES (
520 'Linux', 7
521 );
522
523 INSERT INTO groups ( /* 7 */
524 name
525 ) VALUES (
526 'Default'
527 );
528
529 /* Default Product Groups */
530
531 INSERT INTO groups_product_defaults (
532 group_id, product_id
533 ) VALUES (
534 1, 2
535 );
536
537 INSERT INTO groups_product_defaults (
538 group_id, product_id
539 ) VALUES (
540 2, 3
541 );
542
543 INSERT INTO groups_product_defaults (
544 group_id, product_id
545 ) VALUES (
546 3, 5
547 );
548
549 INSERT INTO groups_product_defaults (
550 group_id, product_id
551 ) VALUES (
552 3, 8
553 );
554
555 INSERT INTO groups_product_defaults (
556 group_id, product_id
557 ) VALUES (
558 3, 11
559 );
560
561 INSERT INTO groups_product_defaults (
562 group_id, product_id
563 ) VALUES (
564 3, 14
565 );
566
567 INSERT INTO groups_product_defaults (
568 group_id, product_id
569 ) VALUES (
570 3, 17
571 );
572
573 INSERT INTO groups_product_defaults (
574 group_id, product_id
575 ) VALUES (
576 3, 20
577 );
578
579 INSERT INTO groups_product_defaults (
580 group_id, product_id
581 ) VALUES (
582 3, 23
583 );
584
585 INSERT INTO groups_product_defaults (
586 group_id, product_id
587 ) VALUES (
588 4, 6
589 );
590
591 INSERT INTO groups_product_defaults (
592 group_id, product_id
593 ) VALUES (
594 4, 9
595 );
596
597 INSERT INTO groups_product_defaults (
598 group_id, product_id
599 ) VALUES (
600 4, 12
601 );
602
603 INSERT INTO groups_product_defaults (
604 group_id, product_id
605 ) VALUES (
606 4, 15
607 );
608
609 INSERT INTO groups_product_defaults (
610 group_id, product_id
611 ) VALUES (
612 4, 18
613 );
614
615 INSERT INTO groups_product_defaults (
616 group_id, product_id
617 ) VALUES (
618 4, 21
619 );
620
621 INSERT INTO groups_product_defaults (
622 group_id, product_id
623 ) VALUES (
624 4, 24
625 );
626
627 INSERT INTO groups_product_defaults (
628 group_id, product_id
629 ) VALUES (
630 5, 25
631 );
632
633 INSERT INTO groups_product_defaults (
634 group_id, product_id
635 ) VALUES (
636 5, 26
637 );
638
639 /* Policies */
640
641 INSERT INTO policies ( /* 1 */
642 type, name, rec_fail, rec_noresult
643 ) VALUES (
644 1, 'Installed Packages', 2, 2
645 );
646
647 INSERT INTO policies ( /* 2 */
648 type, name, rec_fail, rec_noresult
649 ) VALUES (
650 2, 'Unknown Source', 2, 2
651 );
652
653 INSERT INTO policies ( /* 3 */
654 type, name, rec_fail, rec_noresult
655 ) VALUES (
656 3, 'IP Forwarding Enabled', 1, 1
657 );
658
659 INSERT INTO policies ( /* 4 */
660 type, name, rec_fail, rec_noresult
661 ) VALUES (
662 4, 'Default Factory Password Enabled', 1, 1
663 );
664
665 INSERT INTO policies ( /* 5 */
666 type, name, file, rec_fail, rec_noresult
667 ) VALUES (
668 6, 'Measure /lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 1, 2, 2
669 );
670
671 INSERT INTO policies ( /* 6 */
672 type, name, file, rec_fail, rec_noresult
673 ) VALUES (
674 6, 'Measure /lib/x86_64-linux-gnu/libssl.so.1.0.0', 3, 2, 2
675 );
676
677 INSERT INTO policies ( /* 7 */
678 type, name, file, rec_fail, rec_noresult
679 ) VALUES (
680 6, 'Measure /usr/bin/openssl', 5, 2, 2
681 );
682
683 INSERT INTO policies ( /* 8 */
684 type, name, rec_fail, rec_noresult
685 ) VALUES (
686 11, 'No Open TCP Ports', 1, 1
687 );
688
689 INSERT INTO policies ( /* 9 */
690 type, name, rec_fail, rec_noresult
691 ) VALUES (
692 12, 'No Open UDP Ports', 1, 1
693 );
694
695 INSERT INTO policies ( /* 10 */
696 type, name, file, rec_fail, rec_noresult
697 ) VALUES (
698 7, 'Metadata of /etc/tnc_config', 6, 0, 0
699 );
700
701 INSERT INTO policies ( /* 11 */
702 type, name, dir, rec_fail, rec_noresult
703 ) VALUES (
704 8, 'Measure as reference /bin', 1, 0, 0
705 );
706
707 INSERT INTO policies ( /* 12 */
708 type, name, file, rec_fail, rec_noresult
709 ) VALUES (
710 6, 'Measure /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0', 2, 2, 2
711 );
712
713 INSERT INTO policies ( /* 13 */
714 type, name, file, rec_fail, rec_noresult
715 ) VALUES (
716 6, 'Measure /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0', 4, 2, 2
717 );
718
719
720 /* Enforcements */
721
722 INSERT INTO enforcements (
723 policy, group_id, max_age
724 ) VALUES (
725 1, 7, 86400
726 );
727
728 INSERT INTO enforcements (
729 policy, group_id, max_age
730 ) VALUES (
731 2, 5, 0
732 );
733
734 INSERT INTO enforcements (
735 policy, group_id, max_age
736 ) VALUES (
737 3, 6, 0
738 );
739
740 INSERT INTO enforcements (
741 policy, group_id, max_age
742 ) VALUES (
743 5, 4, 86400
744 );
745
746 INSERT INTO enforcements (
747 policy, group_id, max_age
748 ) VALUES (
749 6, 4, 86400
750 );
751
752 INSERT INTO enforcements (
753 policy, group_id, max_age
754 ) VALUES (
755 7, 6, 86400
756 );
757
758 INSERT INTO enforcements (
759 policy, group_id, max_age
760 ) VALUES (
761 8, 7, 60
762 );
763
764 INSERT INTO enforcements (
765 policy, group_id, max_age
766 ) VALUES (
767 9, 7, 60
768 );
769
770 INSERT INTO enforcements (
771 policy, group_id, max_age
772 ) VALUES (
773 10, 6, 60
774 );
775
776 INSERT INTO enforcements (
777 policy, group_id, max_age
778 ) VALUES (
779 11, 6, 86400
780 );
781
782 INSERT INTO enforcements (
783 policy, group_id, max_age
784 ) VALUES (
785 12, 2, 86400
786 );
787
788 INSERT INTO enforcements (
789 policy, group_id, max_age
790 ) VALUES (
791 13, 2, 86400
792 );
793