how to decode varchar 255?

Discussion in 'Databases' started by arale, Jun 6, 2009.

0
  1. #1
    Hi,

    I have a string encrypted by varchar(255), I need to decode it. How to do that? :confused:

    arale
     
    arale, Jun 6, 2009 IP
  2. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #2
    varchar(255) is not a form of encryption, it is a data type and length. Can you provide additional information?
     
    Social.Network, Jun 6, 2009 IP
  3. arale

    arale Guest

    Messages:
    1,215
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I have a field on SQL, its password for user which use varchar(255) and it look like this e10adc3949ba59abbe56e057f20f883e

    I want to convert it to plain text, is it possible?
     
    arale, Jun 6, 2009 IP
  4. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #4
    It depends on the form of encryption. Is this a custom, open-source, or commercial application? The string you posted could be a MD5 hash; do you know what type of encryption is used?
     
    Social.Network, Jun 6, 2009 IP
  5. arale

    arale Guest

    Messages:
    1,215
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #5
    arale, Jun 6, 2009 IP
  6. Social.Network

    Social.Network Member

    Messages:
    517
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    35
    #6
    I cannot tell from the screenshot, sorry.
     
    Social.Network, Jun 6, 2009 IP
  7. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #7
    You would need to look at the application and see how the password is inserted. Most likely it is a hash, and cannot be decrypted. Normally you would use char 32 (at least for MD5) but a varchar field would work fine, although not ideal. If it is a hash, there is no way to decode it. You can only update the value in that field.
     
    jestep, Jun 7, 2009 IP
  8. arale

    arale Guest

    Messages:
    1,215
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I found this encoded by MD5, I tried some tools but not success. Any chance for me now? :(
     
    arale, Jun 8, 2009 IP
  9. veracious

    veracious Banned

    Messages:
    311
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #9
    You can always update the password if you have the privs, without trying to decrypt this one.
     
    veracious, Jun 9, 2009 IP
  10. sssharlasss

    sssharlasss Peon

    Messages:
    17
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #10
    The idea with password hashes is that they're one way only, which essentially means that you can't decrypt it. Now, you might be able to find a collision, but that is probably more technically involved than you'd like. And even then, you probably wouldn't get the password, but instead only a string that has the same hash.

    The best idea for you, depending on what you're trying to do, is to create an MD5 hash of a password you want to use, and replace THAT value with the new hash. Here's a site that'll work for you:

    http://www.xs4all.nl/~jlpoutre/BoT/Javascript/Utils/md5_hashing.html

    Something to also consider is the possible use of a salt, which would just throw an extra wrench in your cogs.
     
    sssharlasss, Jun 9, 2009 IP