View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006572Anastasisauthentication methodspublic2020-09-04 23:572021-04-11 15:48
ReporterChristian Grothoff Assigned ToChristian Grothoff Due Date
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 20:38

manager   ~0017528

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

Issue History

Date ModifiedUsernameFieldChange
2020-09-04 23:57Christian GrothoffNew Issue
2020-09-04 23:57Christian GrothoffStatusnew => assigned
2020-09-04 23:57Christian GrothoffAssigned To => Dominik Meister
2021-02-13 20:38Christian GrothoffNote Added: 0017528
2021-02-13 20:38Christian GrothoffAssigned ToDominik Meister => Christian Grothoff
2021-02-13 20:39Christian GrothoffTarget Version => 0.0.0
2021-02-13 20:39Christian GrothoffSeverityblock => feature
2021-03-13 18:26Christian GrothoffStatusassigned => resolved
2021-03-13 18:26Christian GrothoffResolutionopen => fixed
2021-03-13 18:26Christian GrothoffFixed in Version => 0.0.0
2021-04-11 15:48Christian GrothoffStatusresolved => closed