View Issue Details

IDProjectCategoryView StatusLast Update
0006572Anastasisauthentication methodspublic2021-04-11 17:48
ReporterChristian Grothoff Assigned ToChristian Grothoff  
PriorityhighSeverityfeatureReproducibilityN/A
Status closedResolutionfixed 
Platformi7OSDebian GNU/LinuxOS Versionsqueeze
Product VersionGit master 
Target Version0.0.0Fixed in Version0.0.0 
Summary0006572: need to update database schema to store transmitted codes and retry counters during authorization process
DescriptionThe database schema needs to store per truth (!) a "code", a retry counter (reduced per failed attempt), timestamp (creation time) and an expiration time (when the code expires regardless of authentication attempts). We need:
- insert (create new code)
- select to verify code (select on truth + code + retry > 0 + expires > now)
- select (check if *recent* code already exists, based on truth + timestamp > now - DELTA)
- update (reduce retry counter, based on truth + retry > 0)
- delete (garbage collect, expiration < now)
TagsNo tags attached.

Activities

Christian Grothoff

2021-02-13 21:38

manager   ~0017528

This is in particular needed to rate limit answering of security questions. FIXME added in code.

Issue History

Date Modified Username Field Change
2020-09-05 01:57 Christian Grothoff New Issue
2020-09-05 01:57 Christian Grothoff Status new => assigned
2020-09-05 01:57 Christian Grothoff Assigned To => Dominik Meister
2021-02-13 21:38 Christian Grothoff Note Added: 0017528
2021-02-13 21:38 Christian Grothoff Assigned To Dominik Meister => Christian Grothoff
2021-02-13 21:39 Christian Grothoff Target Version => 0.0.0
2021-02-13 21:39 Christian Grothoff Severity block => feature
2021-03-13 19:26 Christian Grothoff Status assigned => resolved
2021-03-13 19:26 Christian Grothoff Resolution open => fixed
2021-03-13 19:26 Christian Grothoff Fixed in Version => 0.0.0
2021-04-11 17:48 Christian Grothoff Status resolved => closed