24#ifndef _GVMD_MANAGE_SQL_NVTS_H
25#define _GVMD_MANAGE_SQL_NVTS_H
30#define NVT_INFO_ITERATOR_FILTER_COLUMNS \
31 { GET_ITERATOR_FILTER_COLUMNS, "version", "cve", \
32 "family", "cvss_base", "severity", "cvss", "script_tags", "qod", \
33 "qod_type", "solution_type", "solution", "summary", "insight", \
34 "affected", "impact", "detection", "solution_method", NULL }
39#define NVT_ITERATOR_COLUMNS \
41 GET_ITERATOR_COLUMNS_PREFIX (""), \
42 { "''", "_owner", KEYWORD_TYPE_STRING }, \
43 { "0", NULL, KEYWORD_TYPE_INTEGER }, \
44 { "oid", NULL, KEYWORD_TYPE_STRING }, \
45 { "modification_time", "version", KEYWORD_TYPE_INTEGER }, \
46 { "name", NULL, KEYWORD_TYPE_STRING }, \
47 { "cve", NULL, KEYWORD_TYPE_STRING }, \
48 { "tag", NULL, KEYWORD_TYPE_STRING }, \
49 { "category", NULL, KEYWORD_TYPE_STRING }, \
50 { "family", NULL, KEYWORD_TYPE_STRING }, \
51 { "cvss_base", NULL, KEYWORD_TYPE_DOUBLE }, \
52 { "cvss_base", "severity", KEYWORD_TYPE_DOUBLE }, \
53 { "cvss_base", "cvss", KEYWORD_TYPE_DOUBLE }, \
54 { "qod", NULL, KEYWORD_TYPE_INTEGER }, \
55 { "qod_type", NULL, KEYWORD_TYPE_STRING }, \
56 { "solution_type", NULL, KEYWORD_TYPE_STRING }, \
57 { "tag", "script_tags", KEYWORD_TYPE_STRING}, \
58 { "solution", NULL, KEYWORD_TYPE_STRING}, \
59 { "summary", NULL, KEYWORD_TYPE_STRING }, \
60 { "insight", NULL, KEYWORD_TYPE_STRING }, \
61 { "affected", NULL, KEYWORD_TYPE_STRING }, \
62 { "impact", NULL, KEYWORD_TYPE_STRING }, \
63 { "detection", NULL, KEYWORD_TYPE_STRING }, \
64 { "solution_method", NULL, KEYWORD_TYPE_STRING }, \
65 { NULL, NULL, KEYWORD_TYPE_UNKNOWN } \
71#define NVT_ITERATOR_COLUMNS_NVTS \
73 GET_ITERATOR_COLUMNS_PREFIX ("nvts."), \
74 { "''", "_owner", KEYWORD_TYPE_STRING }, \
75 { "0", NULL, KEYWORD_TYPE_STRING }, \
76 { "oid", NULL, KEYWORD_TYPE_STRING }, \
77 { "modification_time", "version", KEYWORD_TYPE_INTEGER }, \
78 { "nvts.name", NULL, KEYWORD_TYPE_STRING }, \
79 { "cve", NULL, KEYWORD_TYPE_STRING }, \
80 { "tag", NULL, KEYWORD_TYPE_STRING }, \
81 { "category", NULL, KEYWORD_TYPE_STRING }, \
82 { "nvts.family", NULL, KEYWORD_TYPE_STRING }, \
83 { "cvss_base", NULL, KEYWORD_TYPE_DOUBLE }, \
84 { "cvss_base", "severity", KEYWORD_TYPE_DOUBLE }, \
85 { "cvss_base", "cvss", KEYWORD_TYPE_DOUBLE }, \
86 { "qod", NULL, KEYWORD_TYPE_INTEGER }, \
87 { "qod_type", NULL, KEYWORD_TYPE_STRING }, \
88 { "solution_type", NULL, KEYWORD_TYPE_STRING }, \
89 { "tag", "script_tags", KEYWORD_TYPE_STRING }, \
90 { "solution", NULL, KEYWORD_TYPE_STRING }, \
91 { "summary", NULL, KEYWORD_TYPE_STRING }, \
92 { "insight", NULL, KEYWORD_TYPE_STRING }, \
93 { "affected", NULL, KEYWORD_TYPE_STRING }, \
94 { "impact", NULL, KEYWORD_TYPE_STRING }, \
95 { "detection", NULL, KEYWORD_TYPE_STRING }, \
96 { "solution_method", NULL, KEYWORD_TYPE_STRING }, \
97 { NULL, NULL, KEYWORD_TYPE_UNKNOWN } \
103#define VT_REF_INSERT_SIZE_DEFAULT 50000
113#define VT_SEV_INSERT_SIZE_DEFAULT 100000
int check_config_families()
Ensure that all configs refer to the right NVT families.
Definition: manage_sql_configs.c:1667
void set_vt_ref_insert_size(int)
Set the VT ref insert size.
Definition: manage_sql_nvts.c:141
void set_vt_sev_insert_size(int)
Set the VT severity insert size.
Definition: manage_sql_nvts.c:155
const char * get_osp_vt_update_socket()
Get the current file socket for OSP NVT update.
Definition: manage_sql_nvts.c:83
void set_osp_vt_update_socket(const char *new_socket)
Set the file socket for OSP NVT update.
Definition: manage_sql_nvts.c:94
int check_osp_vt_update_socket()
Check the files socket used for OSP NVT update.
Definition: manage_sql_nvts.c:109
char * nvt_family(const char *)
Get the family of an NVT.
Definition: manage_sql_nvts.c:1225
int family_count()
Get the number of families.
Definition: manage_sql_nvts.c:1271
int update_or_rebuild_nvts(int)
Update or rebuild NVT db.
Definition: manage_sql_nvts.c:2392
void manage_sync_nvts(int(*)())
Sync NVTs if newer NVTs are available.
Definition: manage_sql_nvts.c:2376
int nvts_feed_version_status()
Check VTs feed version status.
Definition: manage_sql_nvts.c:2320
int manage_update_nvt_cache_osp(const gchar *)
Update VTs via OSP.
Definition: manage_sql_nvts.c:2337
void check_db_nvts()
Ensures the sanity of nvts cache in DB.
Definition: manage_sql_nvts.c:167