Thread

Quick background, My login password for CP stopped working and would not after clicking “login” after each attempt, the field would just go blank so, using my Workbench MySQL admin tool, I editd the table data for exp_members and first commited a blank password (null),
then put in a simple password…unencypted, and got the Error:  “Fatal Error: No matching hash algorithm”

I need guidance on how to really reset the password so ee 2.2 accepts it…

I’ve been locked out of my ee house for a day now… :down:

Thank you in advance

Hi JP,

Are you using EE 1 or EE 2? This is posted in the EE 1 Technical Support forum, but you’re referencing EE 2 in your post, so I’m not sure.

Passwords are hashed rather than stored as a plain-text value which is why your DB trick didn’t work. Have you tried following this wiki guide to get back into your EE CP?

Hi Kevin,
I am using EE2, and yes, I have used a SHA1/hashed password as outlined in the wiki guide with no success yet, getting the same fatal error.

Ok, well since passwords are now salted and hashed with a SHA-2 hash function as of EE 2.2.0, that workaround in the wiki article will no longer work.

Since you’re on EE 2.2+, have you tried using the Forgot Password feature? It appears as a link on the CP login page right below the login fields.

Ok, I’m in edit table data in MySQL and looking at the following fields wondering what field should I enter the SHA2 hash code?

password:  Should I enter the actual human readable password here?  (e.g. “admin”)

salt:  VE$Ey1)!htmy|~A@{7oVE6;j8y\.........&~WQ(f0*bCb&%)2zznZ] (leave unchanged?)

crypt_key: c6976e5b…..................15dfb167a9c8 (is this where I put the SHA256 hash generated key from the password?)

Is the crypt_key or password field where I should insert the newly generate SHA2 (256) hash code?

Please advise…thank you!

JP, I really can’t advise messing around directly in the database now that we’re hashing passwords. Please give the forgotten password function a try on the CP login page. What kind of results are you seeing there?

I’m having a similar issue after upgrading to 2. The salt column in the exp_members is empty.

After resetting the password, I can login successfully, but it only works for one login.

Hi boci,

Welcome to the forums! It looks like that might not be the exact same issue. I’m going to close this thread up since we haven’t heard back on this from JP, but would you mind posting a new thread to the forums with details about your experience? What version did you upgrade from? What version are you now running? Did you have any problems upgrading? Did you experience any problems beforehand?

Just click the button below to start a new, related thread, and give us plenty of details about your issue so that we can help you out!