Locked out of Ghost Blog on OpenShift -

Locked out of Ghost Blog on OpenShift -

i have ghost app instance running on open shift. reason when seek login myapp.domain/ghost no longer able find email.

how alter admin email settings?

i've adapted next reference given @niharvey in step 5, unluckily offline. finish procedure including missing steps follows:

what need:

root (not really, writing permissions) path database ($openshift_repo_dir/content/data) bcrypt hash of desired password (we'll phone call it bcrypt-hash) email address used (select statement below)

ssh app:

rhc ssh appname

start sqlite appropriate database path:

$ cd $openshift_repo_dir/content/data $ sqlite3 ghost.db

display data, such email address used , column names (optional):

sqlite> pragma table_info(users); sqlite> select * users; sqlite> select email users;

unlock business relationship , reset password:

sqlite> update users set status = 'active' ; sqlite> update users set password = 'bcrypt-hash' email = 'youremail@gmail.com';

openshift ghost-blog