27 #ifndef _GVMD_MANAGE_SQL_SECINFO_H 28 #define _GVMD_MANAGE_SQL_SECINFO_H 33 #define SECINFO_SQL_RESULT_HAS_CERT_BUNDS \ 34 "(SELECT EXISTS (SELECT * FROM cert_bund_cves" \ 35 " WHERE cve_name IN (SELECT cve_name" \ 37 " WHERE oid = results.nvt)))" 42 #define SECINFO_SQL_RESULT_HAS_DFN_CERTS \ 43 "(SELECT EXISTS (SELECT * FROM dfn_cert_cves" \ 44 " WHERE cve_name IN (SELECT cve_name" \ 46 " WHERE oid = results.nvt)))" 51 #define CVE_INFO_ITERATOR_FILTER_COLUMNS \ 53 GET_ITERATOR_FILTER_COLUMNS, "vector", "complexity", "authentication", \ 54 "confidentiality_impact", "integrity_impact", "availability_impact", \ 55 "products", "cvss", "description", "severity", "published", NULL \ 61 #define CVE_INFO_ITERATOR_COLUMNS \ 63 GET_ITERATOR_COLUMNS_PREFIX (""), {"''", "_owner", KEYWORD_TYPE_STRING}, \ 64 {"0", NULL, KEYWORD_TYPE_INTEGER}, \ 65 {"vector", NULL, KEYWORD_TYPE_STRING}, \ 66 {"complexity", NULL, KEYWORD_TYPE_STRING}, \ 67 {"authentication", NULL, KEYWORD_TYPE_STRING}, \ 68 {"confidentiality_impact", NULL, KEYWORD_TYPE_STRING}, \ 69 {"integrity_impact", NULL, KEYWORD_TYPE_STRING}, \ 70 {"availability_impact", NULL, KEYWORD_TYPE_STRING}, \ 71 {"products", NULL, KEYWORD_TYPE_STRING}, \ 72 {"cvss", NULL, KEYWORD_TYPE_DOUBLE}, \ 73 {"description", NULL, KEYWORD_TYPE_STRING}, \ 74 {"cvss", "severity", KEYWORD_TYPE_DOUBLE}, \ 75 {"creation_time", "published", KEYWORD_TYPE_INTEGER}, \ 77 NULL, NULL, KEYWORD_TYPE_UNKNOWN \ 84 #define CPE_INFO_ITERATOR_FILTER_COLUMNS \ 86 GET_ITERATOR_FILTER_COLUMNS, "title", "status", "deprecated_by_id", \ 87 "max_cvss", "cves", "nvd_id", "severity", NULL \ 93 #define CPE_INFO_ITERATOR_COLUMNS \ 95 GET_ITERATOR_COLUMNS_PREFIX (""), {"''", "_owner", KEYWORD_TYPE_STRING}, \ 96 {"0", NULL, KEYWORD_TYPE_INTEGER}, {"title", NULL, KEYWORD_TYPE_STRING}, \ 97 {"status", NULL, KEYWORD_TYPE_STRING}, \ 98 {"deprecated_by_id", NULL, KEYWORD_TYPE_INTEGER}, \ 99 {"max_cvss", NULL, KEYWORD_TYPE_DOUBLE}, \ 100 {"cve_refs", "cves", KEYWORD_TYPE_INTEGER}, \ 101 {"nvd_id", NULL, KEYWORD_TYPE_INTEGER}, \ 102 {"max_cvss", "severity", KEYWORD_TYPE_DOUBLE}, \ 104 NULL, NULL, KEYWORD_TYPE_UNKNOWN \ 111 #define OVALDEF_INFO_ITERATOR_FILTER_COLUMNS \ 113 GET_ITERATOR_FILTER_COLUMNS, "version", "deprecated", "class", "title", \ 114 "description", "file", "status", "max_cvss", "cves", "severity", NULL \ 120 #define OVALDEF_INFO_ITERATOR_COLUMNS \ 122 GET_ITERATOR_COLUMNS_PREFIX (""), {"''", "_owner", KEYWORD_TYPE_STRING}, \ 123 {"0", NULL, KEYWORD_TYPE_INTEGER}, \ 124 {"version", NULL, KEYWORD_TYPE_INTEGER}, \ 125 {"deprecated", NULL, KEYWORD_TYPE_INTEGER}, \ 126 {"def_class", "class", KEYWORD_TYPE_STRING}, \ 127 {"title", NULL, KEYWORD_TYPE_STRING}, \ 128 {"description", NULL, KEYWORD_TYPE_STRING}, \ 129 {"xml_file", "file", KEYWORD_TYPE_STRING}, \ 130 {"status", NULL, KEYWORD_TYPE_STRING}, \ 131 {"max_cvss", NULL, KEYWORD_TYPE_DOUBLE}, \ 132 {"cve_refs", "cves", KEYWORD_TYPE_INTEGER}, \ 133 {"max_cvss", "severity", KEYWORD_TYPE_DOUBLE}, \ 135 NULL, NULL, KEYWORD_TYPE_UNKNOWN \ 142 #define CERT_BUND_ADV_INFO_ITERATOR_FILTER_COLUMNS \ 144 GET_ITERATOR_FILTER_COLUMNS, "title", "summary", "cves", "max_cvss", \ 151 #define CERT_BUND_ADV_INFO_ITERATOR_COLUMNS \ 153 GET_ITERATOR_COLUMNS_PREFIX (""), {"''", "_owner", KEYWORD_TYPE_STRING}, \ 154 {"0", NULL, KEYWORD_TYPE_INTEGER}, {"title", NULL, KEYWORD_TYPE_STRING}, \ 155 {"summary", NULL, KEYWORD_TYPE_STRING}, \ 156 {"cve_refs", "cves", KEYWORD_TYPE_INTEGER}, \ 157 {"max_cvss", NULL, KEYWORD_TYPE_DOUBLE}, \ 158 {"max_cvss", "severity", KEYWORD_TYPE_DOUBLE}, \ 160 NULL, NULL, KEYWORD_TYPE_UNKNOWN \ 167 #define DFN_CERT_ADV_INFO_ITERATOR_FILTER_COLUMNS \ 169 GET_ITERATOR_FILTER_COLUMNS, "title", "summary", "cves", "max_cvss", \ 176 #define DFN_CERT_ADV_INFO_ITERATOR_COLUMNS \ 178 GET_ITERATOR_COLUMNS_PREFIX (""), {"''", "_owner", KEYWORD_TYPE_STRING}, \ 179 {"0", NULL, KEYWORD_TYPE_INTEGER}, {"title", NULL, KEYWORD_TYPE_STRING}, \ 180 {"summary", NULL, KEYWORD_TYPE_STRING}, \ 181 {"cve_refs", "cves", KEYWORD_TYPE_INTEGER}, \ 182 {"max_cvss", NULL, KEYWORD_TYPE_DOUBLE}, \ 183 {"max_cvss", "severity", KEYWORD_TYPE_DOUBLE}, \ 185 NULL, NULL, KEYWORD_TYPE_UNKNOWN \ 192 #define ALL_INFO_ITERATOR_FILTER_COLUMNS \ 194 GET_ITERATOR_FILTER_COLUMNS, "type", "extra", "severity", NULL \ 200 #define ALL_INFO_ITERATOR_COLUMNS \ 202 {"id", NULL, KEYWORD_TYPE_INTEGER}, {"uuid", NULL, KEYWORD_TYPE_STRING}, \ 203 {"name", NULL, KEYWORD_TYPE_STRING}, \ 204 {"comment", NULL, KEYWORD_TYPE_STRING}, \ 205 {"iso_time (created)", NULL, KEYWORD_TYPE_STRING}, \ 206 {"iso_time (modified)", NULL, KEYWORD_TYPE_STRING}, \ 207 {"created", NULL, KEYWORD_TYPE_INTEGER}, \ 208 {"modified", NULL, KEYWORD_TYPE_INTEGER}, \ 209 {"''", "_owner", KEYWORD_TYPE_STRING}, \ 210 {"0", NULL, KEYWORD_TYPE_INTEGER}, {"type", NULL, KEYWORD_TYPE_STRING}, \ 211 {"extra", NULL, KEYWORD_TYPE_STRING}, \ 212 {"severity", NULL, KEYWORD_TYPE_DOUBLE}, \ 214 NULL, NULL, KEYWORD_TYPE_UNKNOWN \ 221 #define ALL_INFO_ITERATOR_COLUMNS_ARGS(type, extra, severity) \ 223 {"id", NULL, KEYWORD_TYPE_INTEGER}, {"uuid", NULL, KEYWORD_TYPE_STRING}, \ 224 {"name", NULL, KEYWORD_TYPE_STRING}, \ 225 {"comment", NULL, KEYWORD_TYPE_STRING}, \ 226 {"iso_time (created)", NULL, KEYWORD_TYPE_STRING}, \ 227 {"iso_time (modified)", NULL, KEYWORD_TYPE_STRING}, \ 228 {"created", NULL, KEYWORD_TYPE_INTEGER}, \ 229 {"modified", NULL, KEYWORD_TYPE_INTEGER}, \ 230 {"''", "_owner", KEYWORD_TYPE_STRING}, \ 231 {"0", NULL, KEYWORD_TYPE_INTEGER}, {type, "type", KEYWORD_TYPE_STRING}, \ 232 {extra, "extra", KEYWORD_TYPE_STRING}, \ 233 {severity, "severity", KEYWORD_TYPE_DOUBLE}, \ 235 NULL, NULL, KEYWORD_TYPE_UNKNOWN \ 242 #define ALL_INFO_UNION_COLUMNS \ 243 "(SELECT " GET_ITERATOR_COLUMNS_STRING ", '' AS _owner, 'cve' AS type," \ 244 " description AS extra, cvss AS severity" \ 246 " UNION ALL SELECT " GET_ITERATOR_COLUMNS_STRING ", '' AS _owner," \ 247 " 'cpe' AS type, title AS extra, max_cvss AS severity" \ 249 " UNION ALL SELECT " GET_ITERATOR_COLUMNS_STRING ", '' AS _owner," \ 250 " 'nvt' AS type, tag AS extra," \ 251 " CAST (cvss_base AS float) AS severity" \ 253 " UNION ALL SELECT " GET_ITERATOR_COLUMNS_STRING ", '' AS _owner," \ 254 " 'cert_bund_adv' AS type, title AS extra," \ 255 " max_cvss AS severity" \ 256 " FROM cert_bund_advs" \ 257 " UNION ALL SELECT " GET_ITERATOR_COLUMNS_STRING ", '' AS _owner," \ 258 " 'dfn_cert_adv' AS type, title AS extra," \ 259 " max_cvss AS severity" \ 260 " FROM dfn_cert_advs" \ 261 " UNION ALL SELECT " GET_ITERATOR_COLUMNS_STRING ", '' AS _owner," \ 262 " 'ovaldef' AS type, title AS extra, max_cvss AS severity" \ 269 #define ALL_INFO_UNION_COLUMNS_LIMIT \ 270 "(SELECT * FROM (SELECT " GET_ITERATOR_COLUMNS_STRING "," \ 271 " CAST ('' AS text) AS _owner," \ 272 " CAST ('cve' AS text) AS type," \ 273 " description as extra, cvss as severity" \ 280 " SELECT * FROM (SELECT " GET_ITERATOR_COLUMNS_STRING "," \ 281 " CAST ('' AS text) AS _owner," \ 282 " CAST ('cpe' AS text) AS type, title as extra," \ 283 " max_cvss as severity" \ 290 " SELECT * FROM (SELECT " GET_ITERATOR_COLUMNS_STRING "," \ 291 " CAST ('' AS text) AS _owner," \ 292 " CAST ('nvt' AS text) AS type," \ 294 " CAST (cvss_base AS float) as severity" \ 301 " SELECT * FROM (SELECT " GET_ITERATOR_COLUMNS_STRING "," \ 302 " CAST ('' AS text) AS _owner," \ 303 " CAST ('cert_bund_adv' AS text) AS type," \ 305 " max_cvss as severity" \ 306 " FROM cert_bund_advs" \ 312 " SELECT * FROM (SELECT " GET_ITERATOR_COLUMNS_STRING "," \ 313 " CAST ('' AS text) AS _owner," \ 314 " CAST ('dfn_cert_adv' AS text) AS type," \ 316 " max_cvss as severity" \ 317 " FROM dfn_cert_advs" \ 323 " SELECT * FROM (SELECT " GET_ITERATOR_COLUMNS_STRING "," \ 324 " CAST ('' AS text) AS _owner," \ 325 " CAST ('ovaldef' AS text) AS type, title as extra," \ 326 " max_cvss as severity" \ 337 #define SECINFO_COMMIT_SIZE_DEFAULT 0 352 get_secinfo_commit_size ();
int check_cert_db_version()
Ensure CERT db is at the right version, and in the right mode.
Definition: manage_sql_secinfo.c:3803
void manage_sync_scap(sigset_t *sigmask_current)
Sync the SCAP DB.
Definition: manage_sql_secinfo.c:4404
void manage_sync_cert(sigset_t *sigmask_current)
Sync the CERT DB.
Definition: manage_sql_secinfo.c:4078
int check_scap_db_version()
Ensure SCAP db is at the right version, and in the right mode.
Definition: manage_sql_secinfo.c:4092
void set_secinfo_commit_size(int new_commit_size)
Set the SecInfo update commit size.
Definition: manage_sql_secinfo.c:4416