Member Avatar for Pranesh_Ashrit

Dear Users,

I have used SHA1 encryption method to encrypt password and stored in login table as a blob field.

Now, to authenticate the password, i need to decrypt it. I am not able to decrypt.

Please help me to decrypt password

  • 2 Contributors
  • 3 Replies
  • 89 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by nav33n
Member Avatar for nav33n

You *cannot* decrypt it. If you store sha1 of a string, while authenticating, convert the string to sha1 and compare it with the value in the table.

Member Avatar for Pranesh_Ashrit

The problem i have right now is,
I have updated the database table passwords with SHA1 encryption algorithm. Since its a hash algorithm which cannot be re-converted back to string, i need to get the original table with string format password content back.

I tried with rollback option, but its not getting back. I think this is because rollback works fine only when the application is alive. Once we close the application, the database engine does the auto-commit.

Please help me to resolve my problem. I need some guidelines to start with.

Thanks in advance.

Member Avatar for nav33n

Sorry man. That's just not my area of expertise. :) Lets see if someone else can help you with this. Cheers!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.