XF 2.2 Password reset

[Realist]

Hi all,

I’ve ran the SQL query to reset my admin password and it’s still not letting me regain access to my account.

Any ideas?

 

[Deleted member 232995]

Hi all,

I’ve ran the SQL query to reset my admin password and it’s still not letting me regain access to my account.

Any ideas?

More info, error messages etc would be more helpful...

UPDATE xf_user_authenticate
SET data = BINARY
    CONCAT(
        CONCAT(
            CONCAT('a:3:{s:4:"hash";s:40:"', SHA1(CONCAT(SHA1('XXXXXXXXXXXXXX'), SHA1('salt')))),
            CONCAT('";s:4:"salt";s:40:"', SHA1('salt'))
        ),
        '";s:8:"hashFunc";s:4:"sha1";}'
    ),
scheme_class = 'XF:Core'
WHERE user_id = USER_ID;

Should be enough.

 

[Realist]

I’ve ran the above and it’s not changing anything?

 

[Realist]

Also no error messages coming back when the above is ran.

 

[Realist]

Right getting somewhere.

Ran the above code and it’s now asking me for my 2 step verification, which I don’t have so now I have to disable it.

 

[Deleted member 232995]

You have the TFA active u can deactivate via the config..
$config['enableTfa'] = false;

 

[Realist]

Yes all done access gained and new password.

Thanks.