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