Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 could someone decrypt this?

Author  Topic 

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-23 : 21:09:16
hi all,
i have this password column that i ve no idea how it's been encrypted... i need to come out with encrypt and decrypt function for this string :-
AE435A2BE08D1797362FF3CDD6E541AA6851819C

is it possible to decrypt this when i dont have the password string? if not possible then i will try to get the password string so that any experts here could help me to come out with the encryption and decryption function.

thanks guys

~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-07-23 : 21:29:49
You have to figure out if the binary value is

1) An encrypted text. If so, yes it is most proboably decryptable.
2) A hash sum. If so, no it is not decryptable.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-23 : 21:37:08
AE435A2BE08D1797362FF3CDD6E541AA6851819C this is encrypted from some text.. wait i will ask someone's password.. so once i found what is the text.. isit possible to do both function encrypt and decrypt?
let's say AE435A2BE08D1797362FF3CDD6E541AA6851819C = user123 isit possible?


~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-07-23 : 21:59:17
Everything is possible. Which encryption algorithm is used?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-23 : 22:46:05
i only have 2 samples.. hopefully we can work on it :-

1. ACC7B965EEA9C9EE12B52701DB5CCFC66F816D = glade
2. C16AAB9FE3288DF0FB8FC1D24990A30B6B8F299 = samuel

thanks... pliz help

~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-24 : 03:11:44
quote:
Originally posted by Peso

Everything is possible. Which encryption algorithm is used?


Peter Larsson
Helsingborg, Sweden

Very inspiring...
Which encryption algorithm is used? <--- no idea for now

~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2007-07-24 : 05:19:02
your words are hashed with SHA algorithm

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2007-07-24 : 05:24:37
quote:
Originally posted by spirit1

your words are hashed with SHA algorithm

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp


Wow ! you can tell that by just looking at the string of codes ?

KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2007-07-24 : 05:27:07
this is where "cybernetic" part comes in

i just ran these:

SELECT HashBytes('md2', 'samuel')
SELECT HashBytes('md4', 'samuel')
SELECT HashBytes('md5', 'samuel')
SELECT HashBytes('sha', 'samuel')


although glade doesn't match i'm assuming she missed a space or something

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-24 : 07:10:26
that's why... im not sure about the pattern.. i just have 2 samples in hand :(.. and i dun even know what algorithm is in use.. what they think im a hacker or something? cry cry cry.. is this a sensitive issue.. to be able to get some password decryptor?

~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2007-07-24 : 07:24:09
Note : SHA is not reversible, meaning you can't decrypt it. It is a one away conversion

KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2007-07-24 : 07:31:08
SHA is a hash not an encryption. you must differentiate between the two maya.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-07-24 : 12:03:33
Also see answer at 07/23/2007 : 21:29:49


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-24 : 12:49:17
quote:
Originally posted by Peso

You have to figure out if the binary value is

1) An encrypted text. If so, yes it is most proboably decryptable.
2) A hash sum. If so, no it is not decryptable.


Peter Larsson
Helsingborg, Sweden

excuse me, so my samples are type number (2), not type number (1)?
and what is SHA / hash?
so this is impossible unless if know what algorithm is in use?

~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2007-07-24 : 12:51:05
yes they are.
how about trying to put SHA algorithm in a google search and see what it finds.

if it's hashing than it's impossible even if you do know what the algorithm is.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-24 : 12:55:26
okay, wikipedia done the answer.. but how to differentiate between SHA and hash, or type (1) & type(2)..
thanks btw guys

~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2007-07-24 : 12:56:38
you can't by just looking at the data.

and SHA IS a hash.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-24 : 13:00:51
quote:
Originally posted by spirit1

this is where "cybernetic" part comes in

i just ran these:

SELECT HashBytes('md2', 'samuel')
SELECT HashBytes('md4', 'samuel')
SELECT HashBytes('md5', 'samuel')
SELECT HashBytes('sha', 'samuel')


although glade doesn't match i'm assuming she missed a space or something

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

sounds like some clue, do you want to try another word? maybe i mistype the 'glade'

~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2007-07-24 : 13:02:21
you try it

and this is not just looking, you have to have the original string that you need to convert and then compare values.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-24 : 13:04:52
thank u spirit..
ill try get some sample sets tomorrow.. will be back here tomorrow...
thank u so much btw

~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~
Go to Top of Page

maya_zakry
Constraint Violating Yak Guru

379 Posts
Posted - 2007-07-24 : 13:15:55
i still didnt get it, if SHA/hash is not even an encrypted text, then in your opinion, how is the user password input string is compared? how it validate 'samuel' is equal to the generated SHU string ?

~~~Focus on problem, not solution ¯\(º_o)/¯ ~~~
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site