Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...RESOLVED : Moved database/dev env to new machine - cannot loginRESOLVED : Moved database/dev env to new machine - cannot login
Previous
 
Next
New Post
9/22/2009 5:46 AM
 

Hi,

I moved a DNN 4.9.4 dev environment and its database from my old dev machine to my new dev machine.  I did not use a manually specified machine key so I'm not too suprised that I cannot login using existing passwords. EDIT It turns out that wasn't true - couldn't see it for looking.  I DID have a manually specified machine key and so *now I am surprised* that I could not login using existing ids/passwords.

I try this idea (http://www.onlydnn.com/blog/tabid/55/articleType/ArticleView/articleId/9/How-to-Reset-and-Recover-Host-Account-Password-using-Advanced-Methods.aspx) of registering a new account to get a known password/salt combo in the aspnet_Membership table.  The new account seems to register OK, but when it bounces me back to the home page *I am surprised because I am NOT logged in* (The login link is still in the top rhs).

The new account IS present in both the aspnet_Membership table and the dbo.Users table.

If I attempt to login with the new account the system seems aware of it (trying the new account and the wrong password gives the expected message ("Login Failed, remember that Passwords are case sensitive").  Logging in with the new account and the correct password, bounces me back to the home page (expected) but I am not logged in (unexpected).

I try copying the salt/password combo in the aspnetMembership table from the new account to the host account.  I now get the same behavior with the host account (error message if I use the wrong password; bounce to home page but not logged in if I use the correct password).

There are no interesting new rows in the dbo.EventLog table.  When I attempt a login with a bad password I get a LOGIN_FAILURE, when I login as the host using the correct password then I get a LOGIN_SUPERUSER event.

I'm sure I am missing something fundamental here but I cannot see it. 

How I can resurrect this environment?


Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
New Post
9/22/2009 9:36 AM
 

So you're saying the machine keys were copied from old to new, correct?  How about any change sin the database connection string?

Jeff

 
New Post
9/22/2009 10:54 AM
 

Hi Jeff,

Thanks for trying to help. 

I was so unbelieving of what I saw in front of me that I had another go...and it just worked properly.  For the record this is what I did second time around.

Action
Result
Recovered site (includes dev environment) files
 
 
Recovered DB
Attached DB to SQL Server (used the same DB name as before)
 
Could see data in SSMS
Browsed to homepage
Got “This site is currently Unavailable - Please check back later”
 
Event viewer gave me a message from SQL Server "Login failed for user 'IIS APPPOOL\DefaultAppPool'. [CLIENT: <local machine>]"
 
Added login for IIS APPPOOL\DefaultAppPool
 
Got homepage
 
Tried a Login
 
It worked (Doh!)

I cannot explain why I could not get this the first time.  As an excuse I'll observe that the settings dialogs for IIS (under Win7) are *WAY* different to those under XP.  (I've never tried Vista.)  I spent some time in there and maybe I broke somthing there.


Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
New Post
9/22/2009 1:32 PM
 

What may have been your issue is that IIS5 (Win XP) uses the ASPNET account as the default app pool identity, where IIS7 will normally use a custom account for each app pool (and an app pool for each site).  If you configured your database originally for the ASPNET account, what you describe could easily happen.

Glad to see it worked out.

Jeff

 
New Post
9/22/2009 2:38 PM
 

Jeff Cochran wrote
 

What may have been your issue is that IIS5 (Win XP) uses the ASPNET account as the default app pool identity, where IIS7 will normally use a custom account for each app pool (and an app pool for each site).  If you configured your database originally for the ASPNET account, what you describe could easily happen.

Glad to see it worked out.

Jeff

Interesting thought.  Sadly it could not have caused my original problem.  Adding the account was one of the step I had done.  Even when it was not working properly it was both able to read the database (it got to the home page) and write Event rows (it recorded the SUPERUSER_LOGINs).  When there is no suitable account you cannot even get to the home page.


Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...RESOLVED : Moved database/dev env to new machine - cannot loginRESOLVED : Moved database/dev env to new machine - cannot login


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out