sql gurus : need help (simple q) - GoFuckYourself.com

DutchTeenCash · 05-18-2005, 02:21 AM

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

arnette · 05-18-2005, 02:28 AM

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

absix · 05-18-2005, 02:50 AM

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.

DutchTeenCash · 05-18-2005, 02:51 AM

Quote:

Originally Posted by arnette

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

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...

DutchTeenCash · 05-18-2005, 02:52 AM

Quote:

Originally Posted by absix

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.

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

Weppel · 05-18-2005, 02:55 AM

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.

DutchTeenCash · 05-18-2005, 03:00 AM

Quote:

Originally Posted by Weppel

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

Weppel · 05-18-2005, 03:05 AM

Quote:

Originally Posted by thinkx

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.

absix · 05-18-2005, 03:07 AM

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

xfalmp · 05-18-2005, 03:08 AM

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.

DutchTeenCash · 05-18-2005, 03:11 AM

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

arnette · 05-18-2005, 03:21 AM

icq me 243680554

DutchTeenCash · 05-18-2005, 03:23 AM

Quote:

Originally Posted by arnette

icq me 243680554

done

8 chars

Azathoth · 05-18-2005, 04:12 AM

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

grumpy · 05-18-2005, 04:53 AM

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.

DutchTeenCash · 05-18-2005, 04:55 AM

Quote:

Originally Posted by grumpy

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...

Pete-KT · 05-18-2005, 05:01 AM

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.

Weppel · 05-18-2005, 05:03 AM

Quote:

Originally Posted by Pete-KT

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..

grumpy · 05-18-2005, 05:09 AM

Quote:

Originally Posted by thinkx

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

solution is still the same, active or not active.

chadglni · 05-18-2005, 06:24 AM

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"

05-18-2005, 02:21 AM	#1
DutchTeenCash I like Dutch Girls Join Date: Feb 2003 Location: dutchteencash.com Posts: 21,684	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 __________________ ICQ 16 91 547 - SKYPE dutchteencash bob AT dutchteencash DOT com ... did you see our newest Sweet Natural Girl Priscilla (18)?

05-18-2005, 02:50 AM	#3
absix Confirmed User Join Date: Aug 2003 Posts: 484	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. __________________ ICQ: 59eleven5623, ab at zoig dot com

05-18-2005, 03:07 AM	#9
absix Confirmed User Join Date: Aug 2003 Posts: 484	Oh, find the programmer who used to work for you and did this and break his arms lol __________________ ICQ: 59eleven5623, ab at zoig dot com

05-18-2005, 03:08 AM	#10
xfalmp Confirmed User Join Date: Aug 2002 Location: Brazil Posts: 1,474	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. __________________ Trust the "WOW" effect.

05-18-2005, 03:11 AM	#11
DutchTeenCash I like Dutch Girls Join Date: Feb 2003 Location: dutchteencash.com Posts: 21,684	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 16 91 547 - SKYPE dutchteencash bob AT dutchteencash DOT com ... did you see our newest Sweet Natural Girl Priscilla (18)?

05-18-2005, 02:28 AM	#2
arnette Confirmed User Join Date: Feb 2005 Posts: 283	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

05-18-2005, 02:55 AM	#6
Weppel Confirmed User Join Date: Aug 2003 Location: Netherlands Posts: 2,190	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.

05-18-2005, 03:21 AM	#12
arnette Confirmed User Join Date: Feb 2005 Posts: 283	icq me 243680554

05-18-2005, 04:12 AM	#14
Azathoth Confirmed User Join Date: Nov 2002 Location: Blah Posts: 217	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

05-18-2005, 04:53 AM	#15
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	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. __________________ Don't let greediness blur your vision \| You gotta let some shit slide icq - 441-456-888

05-18-2005, 05:01 AM	#17
Pete-KT Workin With The Devil Industry Role: Join Date: Oct 2004 Location: West Bloomfield, MI Posts: 51,532	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.

05-18-2005, 06:24 AM	#20
chadglni Confirmed User Join Date: Dec 2002 Location: PEI, Canada Posts: 6,924	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"