Cannot login after switching password format

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
4/15/2008 5:28:12 AM
sherwinchu
Gravatar
Total Posts 18
View Posts

Cannot login after switching password format

Hi Joe,

I cannot login anymore (i.e. login control outputs "Login Failed!") after switching the password format from "Clear Text in db" to "Encrypted in db".  I tried resetting passwords and changing passwords through the member admin pages, but that doesn't seem to help.  I checked the mp_Users table and found that the passwords have indeed been encrypted automatically, so it seems as if the login control is not able to recognize the encyrpted passwords or something like that.

I tried the latest release (2.2.5.3) with a clean database, and get the same results...I'm using MSSQL 2000 and IIS 6 on Windows 2003 Server.

Am I missing a key step or configuration?

Please note that switching back to "Clear Text in db" allows me to login again (the passwords in the mp_Users table are also automatically decrypted properly).

Thanks in advance,

Sherwin

4/15/2008 7:34:19 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Cannot login after switching password format

Hi Sherwin,

This worked fine for me last time I tested it. I will look into as soon as I can. I'm at the MySql conference this week so fairly busy but maybe can look into it later today.

Best,

Joe

4/15/2008 9:38:22 AM
sherwinchu
Gravatar
Total Posts 18
View Posts

Re: Cannot login after switching password format

Thanks Joe!  Looking forward to your findings.

Sherwin

4/15/2008 11:04:58 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Cannot login after switching password format

Hi Sherwin,

I just tested and it still works fine for me. The only thing I can think of for you to check is that previously there was a bug in the mp_Users_Login or mp_Users_LoginByEmail stored procedure where the password variable was declared as nvarchar(20) when it should be nvarchar(128) so it was truncating the password on the way in and login would fail. But this has been fixed in recent releases so I can't think of why this problem occurs for you. I would look at those procedures though in case they somehow did not get corrected in your installation.

Hope it helps,

Joe

4/15/2008 11:24:25 AM
sherwinchu
Gravatar
Total Posts 18
View Posts

Re: Cannot login after switching password format

Hi Joe,

Thanks!  Your suggestion fixed the issue for my installation. 

Although I'm not sure why I encountered the errors on a fresh install/db, maybe I did something wrong.  But thanks!!!

Sherwin

You must sign in to post in the forums. This thread is closed to new posts.