OTC Login not working

[m4ndo]

Issue Summary

• Member sign in via OTC hangs for one minute, then times out.
• The member login using magic link works immediately.

Steps to Reproduce

1. Member enters email to login.
2. Ghost sends member an email.
3. Member copies the one time code (OTC) and enters that into the original login page.
4. The site shows a spinning wheel for one minute if OTC was used to sign in.
5. The docker container logs Invalid OTC verification hash after one minute.
6. The login attempt times out at this time and member is left to try again.

---

Setup information

Ghost Version
Tried 6.9.1-Alpine, 6.9-Alpine, and 6.8.3-Alpine

Node.js Version
Self hosted, node 23.11

How did you install Ghost?
Yesterday I updated Ghost from v5 to v6.

Provide details of your host & operating system
Include further details about your hosting and OS.

Database type
SQLite3

Browser & OS version
macOS, Google Chrome

Relevant log / error output
Invalid OTC verification hash

[Cathy_Sarisky]

I saw this yesterday on a local install. I’m pretty sure it’s related to sqlite3.

[m4ndo]

Is sqlite3 not supported? I think last I read was MySQL for production.

[Cathy_Sarisky]

SQLite is only supported for development, and bugs happen…