You need to Register for free and Login to post a message in the forum.

Forum

Forums > Users Lounge > Everything Else
Subject: Can not login as host or admin after live database restoration
Prev Next
You are not authorized to post a reply.

Author Messages
Kimchi
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:7
29 Nov 2007 3:29 PM  
Hi, all.

What would be the problem if I can not login as host or admin after live hoster restored my locally generated database file?
There is no possibility that I lose the passwords for the host and admin because I use the same name and password combination all the time.
My localhost works just fine, but I have difficulty uploading to a live host; I guess the hoster do not seem to have DNN support or exprerience.

Does it have to do "setup permission" thing after database restore request?
I just asked them to restore my locally generated database backup file.

Thank you.

Kimchi
Joseph Craig
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:6139
29 Nov 2007 8:10 PM  
Are you having trouble logging into the DotNetNuke site, or are you having trouble logging into the database as a database user?

If everything is working fine, but you can't log in as host or admin to the DotNetNuke site, did you make any changes to your web.config file? Your web.config file must have the same machineKey setting as when you created the database. If they are different (compare the web.config file on localhost with the remote one) you must change your remote web.config to match the local one.
Joe Craig
DNN Creative Support
Subscribe to the website
Kimchi
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:7
29 Nov 2007 11:24 PM  
jncraig,

Thank you for your response. To describe what is happening with my hosting service, here is the sequence that I followed.

(1) Downloaded DNN 4.5.5 and followed wizard to install onto my localhost running MS SQL Server 2005 Express. It works fine in everything. The host and admin let me log in and just fine.
(2) I made a backup flie after I attached the App_Data\Database.mdf file. The backup default name is Database.mdf.BAK.
(3) After I changed local web.config I was able to login back to my localhost. That means I now direct the DNN to use the MS SQL Server 2005 Express. See my attachment at the end of this posting for my local web.config file's ConnectionString part.
(4) I created a datbase file for a hoster's remote MS SQL Server 2005. Of course I have created Login user for the server and assigned roles (asp_net.* and db_owner). Again the uid and pwd in the ConnectionString is appended at the end for your reference.
(5) After I uploaded the DNN 455 installation files and the backup file, I request a restoration service for my database backup file. They said "It is complete," which, I guess they mean they restored my backup file to my remote, hoster's SQL Server 2005.

Now, when I login to the hoster (http://www.woogonchung.net) the home page comes up. BUT, THE PROBLEM is that I can NOT login as host or admin. Again, trust me. I know my passwords for the host and admin account, because I use them all the time.

Below I have appened two web.config files; the first for the localhost version of my computer and the second is for the remote, live host version.

I will appreciate your help on this long-lasting trouble.

(Note: I blocked the password part of my web.config file with xxxxxxxxx .)




--------------- localhost, web.config ------------------


   
   
   
 
 
   
   
   


----------- remote, live host; web.config  ----------------------

 
   
   
          name="SiteSqlServer"
      connectionString="Server=67.36.254.131;Database=woogonchung_dnndb2;uid=dnndbuser2;pwd=xxxxxxxx;"/>
 
 
 
   
   
   

Joseph Craig
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:6139
30 Nov 2007 8:37 AM  
The web.config files didn't post correctly because of the < and > in all of the tags.

You need to check the machineKey setting in each of the two web.config files. They should be the same. Having the wrong machineKey setting is the most common reason that you can't log in. Do you get a message that the password is wrong when you try to login?

The fact that your site is running on the host system indicates that the connection strings are correct.
Joe Craig
DNN Creative Support
Subscribe to the website
Kimchi
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:7
30 Nov 2007 6:40 PM  
I made it. Thank you for your info. The machineKey values and their persistancy have been mentioned in the Video turorial series, though.

Kimchi
proarch123
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:4
02 Nov 2009 7:18 AM  
Hi,
Thanks alot it solved my problem.

Me also hosted my published files on intranet server. After hosting everything is woring fine except DNN login.
After copting the same machinekey which I used for development version it worked

Thanks,
ProArch.
You are not authorized to post a reply.
Forums > Users Lounge > Everything Else > Can not login as host or admin after live database restoration


ActiveForums 3.7

Latest Forum Posts

Request Tutorial For Forms and List by Allen6195
If you have already produced a tutorial for Forms and List, would you please let me know where it is...
RE: Skin Header by mcmanta
ok I edited the home.ascx and inner.ascx and uploaded the skin again. thanks for the help.
RE: "Good" hosting providers by jtgreg77
Hello AJ, I can't say anything about the other two hosting providers, but we at PowerDNN have ha...
Where is the tutorial for the Reports Module? by Allen6195
I'm sorry but I can't find a tutorial on the Reports module.  When I do a search for 'Reports module...
RE: calender and events registration module by jncraig
I'm not aware of any.
RE: Missing blog entries by jncraig
I have not seen or heard of that particular problem before.
RE: Module Installation Error by jncraig
In email I suggested that you manually install one of the modules that failed.  See if errors are re...
RE: DotNetNuke User Profile v5.4 - Issue 58 by jncraig
In the file manager, set the permissions so that logged in users (registered users) have write permi...
RE: Module Installation Error by ollep
Thanks for your prompt reply Joe.I tried the logfile yesterday but had problem saving current (today...
RE: Skin Header by WinXnet
You need to add the link to the button. Right now it is just an image - no link at all! open it with...
RE: Skin Header by mcmanta
sure my web site is twinsprucepa.com if you look I have the header in place but when you click the c...
RE: NAV Menu not showing up correctly... by WinXnet
Try putting something in the separator html, like a div with a class you can work with. Also, y...
RE: Missing blog entries by WinXnet
I never use the dnn blog - it always seems to have issues. If possible, you might want to move to a ...
RE: CSS Skin Height Problem by WinXnet
100% height divs are a bit more complicated than it seems it should be. First - what browsers are...
RE: Skin Header by WinXnet
Not sure what you are asking - you should be able to just create an image button link... Then you...
RE: DotNetNuke User Profile v5.4 - Issue 58 by jerimiahpettigrew
How do you make the "my folder" option the only visible option for the profile image upload....inste...
RE: Tab startdate/enddate by brian_strickland
Thanks tons Joseph... I was actually trying to simplify my explanation so I wouldn't over complicat...
Skin Header by mcmanta
Hello All, I have a DNN5 site and my customer has asked me to create a Contact us button and Dire...
RE: Slow login by jncraig
Make sure that you have uninstalled modules that you aren't actually using.  That will reduce the me...
RE: Customising Registration form by jncraig
You might also look at these:How to Create a Portal Signup Module with OWSHow to Create a Custom...
AppTheory
RSS Feeds