sql gurus : need help (simple q)
 

ive got an SQL base, the 2nd field is the password field, its encrypted, the guy who made this base isnt working for us anymore, I need to find a way to have these passwords decrypted, is that possible? and if so how?

thanks :thumbsup

nope, if its encrypted it stays encrypted, this is true for 99% of cases
if you dont know the passwords you will need to reset them

If it's encrypted with a password, you can decrypt it with the password, if it's MD5... forget about it.

That's what my programmers say.

well theyre user/password logins, but theres an encryption key somewhere I guess, cant it be reversed somehow, would save me a shitload of work...

uh ok so I have to look in the php if theres an encryption pass right ok cool thanks

What do the passwords look like? 32-character lines? If that's the case you're dealing with MD5-hashes and those don't actually contain the passwords, only a hash of the password.

they look like this

29dbcdd87fce5106

Looks like a 16-character MySQL password hash, you can't decrypt hashes.
If you're interested in knowing why i can type it up, lmk :)

Best solution in this case would be to reset the password to something you want.

Oh, find the programmer who used to work for you and did this and break his arms lol

Yeah, reset it and you're done.

Look around on your php files how encriptions are done and create a key for you with your new password... then replaces it with the old one.

its a membership base, so I cant just paste a new one... I need the actual password not the entrace so to speak...the guy who programmed it vanished... seems we gotta ask over a 1000 ppl again sigh... dont worry its not for dutchteencash :)

icq me 243680554

done

8 chars

Change the script so it records the password the user enters when they login before it encrypts it and compares it to what's in the database :2 cents:

- Az

its simple
remove the passwords
use a new encryption and accept the first password they type in as the new password. Will solve it in 99% of the cases.

I wish, its not an active base anymore.. seems Im stuck...

the key you posted seems to be hashed, Its gonna be near imposible to decrypt it, im not saying it can't be done but im not saying its gonna be easy either. If you need the help let me know and i will see what we can do for you.

There is no way you can translate a hash back to a password, that's the whole idea behind a hash..

solution is still the same, active or not active.

One of the first things I would try is the suggestion posted above, if it was my ass on the line

"Change the script so it records the password the user enters when they login before it encrypts it and compares it to what's in the database

- Az"