internal/vulndbreqs: add table with counts by IP

In addition to the table that holds daily request counts,
add a second that breaks the counts down by IP.

We obfuscate the IPs so no one can view them.
If we just hashed them, then someone could guess an IP and
easily check their guess. So we use an HMAC instead, which
hashes, and then encrypts the hash with a secret key that
is only stored in the GCP Secret Manager.

Change-Id: I99dfa16567154c8869b21f97a7edd9083817bbf0
Reviewed-on: https://go-review.googlesource.com/c/pkgsite-metrics/+/483615
Run-TryBot: Jonathan Amsterdam <jba@google.com>
Auto-Submit: Jonathan Amsterdam <jba@google.com>
Reviewed-by: Zvonimir Pavlinovic <zpavlinovic@google.com>
TryBot-Result: Gopher Robot <gobot@golang.org>
6 files changed
tree: 11ff6f442de5ddc62fe2148adbcbcf134523ad33
  1. cmd/
  2. deploy/
  3. devtools/
  4. internal/
  5. terraform/
  6. .dockerignore
  7. .gitignore
  8. all_test.go
  9. checks.bash
  10. config.json.commented
  11. CONTRIBUTING.md
  12. go.mod
  13. go.sum
  14. LICENSE
  15. Makefile
  16. PATENTS
  17. README.md
  18. tools.go
README.md

pkgsite-metrics

This repository contains code that serves pkg.go.dev/metrics.

Report Issues / Send Patches

This repository uses Gerrit for code changes. To learn how to submit changes to this repository, see https://golang.org/doc/contribute.html.

The main issue tracker for the time repository is located at https://github.com/golang/go/issues. Prefix your issue with “x/pkgsite-metrics:” in the subject line, so it is easy to find.