Resetting password from database - weird issue after MD5

sagar

Hey guys,

hate for my first post to be one asking of help but have spent all day wrapping my head around this - no way out.

I'm trying to reset the password via the database in phpmyadmin, selecting MD5 for the password encryption and saving it.

phpmyadmin shows the correct hash being saved for that user's password.

When I go to the site, and login - it doesn't work.

Then, when I go back to the db to check the hash, it has this instead:

$2a$08$TA1f0vOQYHJz1pqFVTfOr.3U8YaTLLAsguhXFl.MEdYMHehvaUEMe

Irrespective of the password I choose, '$2a$08$' is always at the beginning with a long string after it - changes for different passwords, the '$2a$08$' remains the same.

So am not able to login at all, to any account.

Any ideas on what may be happening here?

Sagar

ntozier

Not sure why you're seeing that, but you may find this article helpful to reset your password.

http://www.tmib.net/content/recover-reset-admin-account-passowrd-osticket(http://www.tmib.net/content/recover-reset-admin-account-passowrd-osticket)

sagar

Thanks, but that doesn't work either :(

I've tried running that query, and it resets the password, doesn't let me login when I try and then again puts that long string in the password field....

This just started happening on its own - when I installed it, it was working fine all day yesterday and I was able to log in and out easily.

Any ideas? Am really in a fix :)

Sagar

ntozier

have you tried stopping and starting your mysql instance? Then resetting the password again.

sagar

yes, I did.

Right now, I've disabled the bcrypt done when checking for the login and that (surprisingly) lets me login fine.

I do get the CSRF token required error everytime I login, and have to clear out cookies each time to get it to work, but at least am able to login for now.