nsmaster: extend signature rollovers over time (~days)

Open
#535 3 comments 0 reactions 0 assignees View on GitHub

Maintainers usually reply within 14 days

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
20/100
Issue type
Feature
Clarity
Needs clarification
Activity status
Stale
Tech stack
sql
Domain
security

Research direction

Start by locating nsmaster's signature-rollover handling and checking how domains.last_check is used; the issue does not name files or tests. Use the provided UPDATE to spread check times and the SELECT to inspect their distribution. Done means rollovers are spread over days and the query confirms the intended distribution.

Written by the indexing model from the issue text.

Description

Query for stretching:

UPDATE domains SET last_check = CEIL(UNIX_TIMESTAMP() - rand() * 86400) WHERE last_check IS NOT NULL;

Check:

SELECT count(*) AS lc_count, ceil(lc_mod/3600) MOD 24 AS lc_ceil FROM (SELECT *, last_check AS lc_mod FROM domains) AS b GROUP BY lc_ceil ORDER BY lc_ceil;
Dominant language
Python
Stars
678
Forks
74
Avg merge
7d 23h
Merged PRs (30d)
1

Getting set up

  • Ships a Dockerfile or Docker Compose file
  • No pull request template
  • No contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from desec-io/desec-stack

All issues in desec-io/desec-stack

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.