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 } \ int update_or_rebuild_nvts(int)
Update or rebuild NVT db.
Definition: manage_sql_nvts.c:2100
int check_config_families()
Ensure that all configs refer to the right NVT families.
Definition: manage_sql_configs.c:1671
int family_count()
Get the number of families.
Definition: manage_sql_nvts.c:1081
int manage_update_nvt_cache_osp(const gchar *)
Update VTs via OSP.
Definition: manage_sql_nvts.c:2045
void manage_sync_nvts(int(*)())
Sync NVTs if newer NVTs are available.
Definition: manage_sql_nvts.c:2084
void check_db_nvts()
Ensures the sanity of nvts cache in DB.
Definition: manage_sql_nvts.c:123
char * nvt_family(const char *)
Get the family of an NVT.
Definition: manage_sql_nvts.c:1035
const char * get_osp_vt_update_socket()
Get the current file socket for OSP NVT update.
Definition: manage_sql_nvts.c:67
int nvts_feed_version_status()
Check VTs feed version status.
Definition: manage_sql_nvts.c:2028
int check_osp_vt_update_socket()
Check the files socket used for OSP NVT update.
Definition: manage_sql_nvts.c:93
void set_osp_vt_update_socket(const char *new_socket)
Set the file socket for OSP NVT update.
Definition: manage_sql_nvts.c:78