The clients.token column stores the raw 64-character hex token. If the database file is compromised, all active session tokens are immediately usable.
Suggested fix: Store SHA-256(token) in the database; compare against the hash on lookup.
## From QA Audit ([#25 comment](https://git.eeqj.de/sneak/chat/issues/25#issuecomment-10914))
**Severity: SHOULD-FIX**
The `clients.token` column stores the raw 64-character hex token. If the database file is compromised, all active session tokens are immediately usable.
**Suggested fix:** Store `SHA-256(token)` in the database; compare against the hash on lookup.
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
From QA Audit (#25 comment)
Severity: SHOULD-FIX
The
clients.tokencolumn stores the raw 64-character hex token. If the database file is compromised, all active session tokens are immediately usable.Suggested fix: Store
SHA-256(token)in the database; compare against the hash on lookup.