Encrypted password problem

After i followed the directions to encrypt the password i now can not log in to the site. I use a sha1 generator to verify the encrypted password in the database against the one sent in the email and converted to sha1 and they match however when i enter the password it does not allow me to continue. I have looked over all the settings and know that i am just over looking something.

If you are storing the sha1 version of the password in your db then you need to make sure that the field is a varchar type of at least 40 characters. It looks like you are correctly comparing the sha1 value for the password in your login server behavior. Do you know what the sha1 version of your password should be? If so you should be able to directly compare with what you have in the db to see if they match. So long as the value you are comparing matches the value in the db then you should be fine. Post back and let us know what you discover.

That's what it was. I had it set to VARCHAR (32). when i set it to 40 it worked fine.

Nice to hear, the length of the encrypted password is one of the more common issues that I see when the login is not working correctly.

I want to be able to authenticate users against a pre-existing database which stores passwords in an encrypted field. The type is varchar(64). Can this be done?

I think it depends on the type of encryption. Webassist supports SHA1.

There is a video tutorial here under solution recipes: http://www.webassist.com/support/securityassist/

it is pretty helpful and works very well. Hope this helps.

Thanks
My app uses SHA1, 64 characters, but I cannot seem to authenticate against it.
I'm not sure if what I'm doing is even possible but I think I've done everything correctly so maybe it is not.

the sha1() function will only return a 20 or 40 character string, by default the string length is 40:
function.sha1.php

if your password is being stored as 64 characters, it is using another encryption method. you will need to know the encryption method being used to be able to accomplish what you are trying to do.

Thank you. I read in another thread where it had to be at least 40 characters so I was hoping ....

The database I am using is the iDevAffiliate program. According to their documentation they use SHA1

idevaffiliate.php

I guess I will have to take another approach.

This post has been deleted.