import KEV Catalog

[hogehuga]

I would like to import the KEV Catalog as a list of vulnerabilities that have a large impact.

• https://www.cisa.gov/known-exploited-vulnerabilities-catalog
• Probably just download it as a CSV list and put it into your database.
  • https://www.cisa.gov/sites/default/files/csv/known_exploited_vulnerabilities.csv

JUST DO IT.

[hogehuga]

If one line has 1cveID, the line size is too large.

• ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

Summarizes the current maximum length.

• vendorProject
  • max 28
• product
  • max 28
• vulnerabilityName
  • max 27
• shortDescription
  • max 101
• requiredAction
  • max 134 (URL)
  • non URL max 26
• knownRansomewareCampaignUse
  • max 10
  • "Known" or "Unknown" only

[hogehuga]

I do #17 .