Cannot sign in after upgraded to V2.3.8.1

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.
1/28/2012 9:27:06 PM
Gravatar
Total Posts 27

Cannot sign in after upgraded to V2.3.8.1

=======================================

Win XP Pro
MySQL & IIS7 & .NET 4.0 & MediumTrust
V2.3.8.1 (2012-01-27)

=======================================

After upgraded from V2.3.7.6 to V2.3.8.1, I cannot sign in.

In my sign in page, CAPTCHA is enabled. In my memory, the password is encrypted in database. Moreover, the option 'Sign In with Your Open ID Account' disappeared after upgrade.

Is there anybody see this problem?

Thank you.

1/29/2012 5:48:06 AM
Gravatar
Total Posts 18439

Re: Cannot sign in after upgraded to V2.3.8.1

Did you restore the machine key from the old web.config to the new one? Machine key must stay the same or it won't be able to decrypt the passwords so login will fail.

Hope that helps,

Joe

1/29/2012 2:50:11 PM
Gravatar
Total Posts 27

Re: Cannot sign in after upgraded to V2.3.8.1

I double checked that the machine key has been restored.

1/29/2012 3:28:55 PM
Gravatar
Total Posts 18439

Re: Cannot sign in after upgraded to V2.3.8.1

Are other users still able to login ie does it just affect one or some users?

Does registration and subsequent login work?

try adding this to user.config and then touch web.config:

<add key="CheckAllPasswordFormatsOnAuthFailure" value="true" />

if login fails after that try manually updating it in the database in mp_Users, type in a clear text password and then try again, the above config setting should then let you login and it will automatically encrypt the password that you entered as plain text.

If your machine key changed it will affect all  users and there will be no way to recover their passwords with a different machine key so you would need to reset the passwords on all users if the machine key is not correct for any reason though you may think it is restored this problem should not happen if it was restored.

I assume you are just seeing the "login failed" message and not something else like locked out.

Hope that helps,

Joe

1/29/2012 3:41:56 PM
Gravatar
Total Posts 18439

Re: Cannot sign in after upgraded to V2.3.8.1

forgot to mention if you do need to manually update your password(s) in the mp_Users table, its the Pwd field, you may also see a field named Password that exists for historical reasons but that one hasn't been used in many versions.

Hope that helps,

Joe

1/29/2012 3:43:15 PM
Gravatar
Total Posts 18439

Re: Cannot sign in after upgraded to V2.3.8.1

also, check the mojoPortal log for any erros that may be getting logged with the failed login attempts before changing anything.

1/29/2012 4:50:40 PM
Gravatar
Total Posts 27

Re: Cannot sign in after upgraded to V2.3.8.1

I restored the whole website back to V2.3.7.6, and changed the password format in database into plain text. This time the upgrade seems OK. I can sign in as admin and check the version is V2.3.8.1. But when I ran the setup, I got following information from the setup web page:

Running script mojoportal-core - 2.3.7.9 - 00:00:00.5304170
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'mp_PaymentLog' already exists at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySql.Data.MySqlClient.MySqlScript.Execute() at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.5772185

I don't see this message before from the setup web page. From system log, I got some error message:

2012-01-29 14:49:17,490 INFO 2012-01-29 14:51:11,062 ERROR 2012-01-29 14:51:48,643 INFO 2012-01-29 14:51:48,659 INFO 2012-01-29 15:09:26,174 INFO 2012-01-29 15:20:37,362 INFO 2012-01-29 15:20:40,420 ERROR 2012-01-29 15:21:21,808 ERROR 2012-01-29 15:27:05,739 INFO 2012-01-29 15:27:05,770 INFO 2012-01-29 15:28:33,961 ERROR 2012-01-29 15:30:22,727 INFO 2012-01-29 15:30:38,952 INFO 2012-01-29 15:31:23,398 INFO

Even though the version number is already V2.3.8.1, I feel the upgrade is not 100% successful.

Hope the above information is helpful.

1/30/2012 8:25:39 AM
Gravatar
Total Posts 18439

Re: Cannot sign in after upgraded to V2.3.8.1

Doesn't sound like you restored the db completely since that table already exists. My advice is drop that table then visit the setup page again.

Hope that helps,

Joe

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