I have a Ghost app instance running on Open Shift. For some reason when I try to login into
myapp.domain/ghost it is no longer able to find my email.
How do I change the admin email settings?
I've adapted the following from the reference given by @niharvey in his step 5, which is unluckily offline. The complete procedure including the missing steps would be as follows:
What you need:
SSH to your app:
rhc ssh appname
Start sqlite with appropriate database path:
$ cd $OPENSHIFT_REPO_DIR/content/data $ sqlite3 ghost.db
Display data, such as email address used and column names (optional):
sqlite> PRAGMA table_info(users); sqlite> select * from users; sqlite> select email from users;
Unlock account and reset password:
sqlite> update users set status = 'active' ; sqlite> UPDATE users SET password = 'bcrypt-hash' WHERE email = '[email protected]';
The process to reset the password is relatively simple.
rhc ssh <yourappname>