John Mitchell's (mostly DotNetNuke) Blog - DotNetNuke Login is not working!! How am I going to get back in?

Friday, December 08, 2006

DotNetNuke Login is not working!! How am I going to get back in?

This post is a follow up to a previous Can't Login to your DotNetNuke Portal?

This is still happening to people every day, and the core team can't agree on the best way to allow users to get back in. If you have inadvertantly set the LoginTabId setting to a different page but did not put a User Account SignIn module on that page, then you are probably wondering how you will get back in. After doing this some people usually realize that the "front door" to their website is locked and they don't even have a keyhole right away because the login link stops working.

In that last post, I created a side door to display the login prompt, so that you could get back in to change the setting. And that was working great until some recent versions of the ClientAPI changed the way controls are loaded which blocked the "side door".

The problem is easy enough to fix by changing the setting back directly in your DB, but some people don't have that luxury, or simply would rather not mess around in the database.

So now I have created a "window" where you can slip your hand in and put the knob back on your front door.

Download this "Open Sesame" page and upload it to the root of your website, then execute by calling it in the browser (http://www.yourwebsite.com/OpenSesame.aspx) . All it does is update your DB for you to change the LoginTabId back to what it was. Which should get you back to your login prompt.

OpenSesame.zip (.49 KB)

DotNetNuke

12/8/2006 3:47:56 PM (Central Standard Time, UTC-06:00)

Comments [60]

12/15/2006 12:10:31 AM (Central Standard Time, UTC-06:00)

Man, am I glad or not that I found your tips when I Googled. You made my day John by providing your OpenSesame script!

Thanks a lot and Happy Christmas!

/Johan

Johan |johan_bromanderAT NOSPAMhotmail dot com

12/15/2006 3:20:46 PM (Central Standard Time, UTC-06:00)

Excellent, glad I could help.

John M |blogAT NOSPAMsnapsis dot com

12/18/2006 3:08:04 PM (Central Standard Time, UTC-06:00)

I could kiss you! Thanks so much for the simple solution to the worst problem! I thought I was going to have to re-install!!

Monica |mgotelaereAT NOSPAMyahoo dot com

12/19/2006 12:10:11 PM (Central Standard Time, UTC-06:00)

Thank you very much!!!!!
Briliant solving of this problem!

Dennis |dennis dot 97254499450AT NOSPAMgmail dot com

12/20/2006 2:24:30 AM (Central Standard Time, UTC-06:00)

Thank you!
Your tip saved my day!

Eli

12/20/2006 2:35:38 PM (Central Standard Time, UTC-06:00)

Thank you so much for creating this script - you are a lifesaver!

Michal

12/20/2006 4:27:09 PM (Central Standard Time, UTC-06:00)

Thanks for the kind words everyone.

John M |blogAT NOSPAMsnapsis dot com

12/28/2006 5:02:33 PM (Central Standard Time, UTC-06:00)

Hi John,
FANTASTIC!!
I am still finding my way around DNN and locked myself out. Your tip saved me heaps of time, and possibly a hot ear!

Thanx a million and have a happy new year.

Regards
Anton

Anton |anton_alexAT NOSPAMananzi dot co dot za

12/30/2006 3:25:52 AM (Central Standard Time, UTC-06:00)

I LOVE YOU!!! Thanks so much for this!

jp |jimAT NOSPAMparadoxaz dot com

12/31/2006 9:28:20 PM (Central Standard Time, UTC-06:00)

Thanks! Is there any reason not to leave the opensesame.aspx file on your webserver after using it?

Rob Poston |robAT NOSPAMavatar-computer dot com

12/31/2006 11:19:52 PM (Central Standard Time, UTC-06:00)

I wouldn't leave it on the server since it doesn't really have a purpose other than changing that one setting in the DB.

There is no real risk if you want to leave it there though.

John M |blogAT NOSPAMsnapsis dot com

1/11/2007 6:29:38 AM (Central Standard Time, UTC-06:00)

Everyone else has said it and more, but you are a saviour!!

Bernie |administratorAT NOSPAMukcoalition dot org

1/23/2007 8:03:41 PM (Central Standard Time, UTC-06:00)

Man, you walk on water. Thanks for taking the time to publish this.

Dick Mallard

1/30/2007 6:27:59 AM (Central Standard Time, UTC-06:00)

After about 2 hours and about ready to give up.. What a saviour..

Perhaps core team could put this in the documentation folder under 'Rescue'

Thanks.. now I can sleep..

Anne Anderson |oakley dot maisAT NOSPAMbigpond dot com

2/7/2007 9:56:34 AM (Central Standard Time, UTC-06:00)

Thanks for this! It worked on my DNN 4.3. You saved my a$#!

Will |emailAT NOSPAMnospam dot org

2/12/2007 1:09:04 PM (Central Standard Time, UTC-06:00)

Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You! Thank You!

David Tolo |david dot toloAT NOSPAMgmail dot com

2/24/2007 2:49:48 PM (Central Standard Time, UTC-06:00)

Thanks, you really help me !!!

Yoel |yzumbadoAT NOSPAMgmail dot com

3/2/2007 4:01:19 AM (Central Standard Time, UTC-06:00)

It's a nice tip, we do understand this viewing.

Jan |bgxkAT NOSPAMgmx dot de

3/8/2007 12:23:42 PM (Central Standard Time, UTC-06:00)

You are a legend m8 thks for this fix!

Dan |dano_wAT NOSPAMhotmail dot com

3/21/2007 10:51:26 AM (Central Daylight Time, UTC-05:00)

I had such a hard time installing DNN and I thought I had to start over until I found your script. Thank you So MUCH!

Sheri |sheri dot herodAT NOSPAMgpisd dot org

4/11/2007 2:27:14 PM (Central Daylight Time, UTC-05:00)

WOW! I wish you could bottle up all the goodness you are creating with your script and sell it right beside the Coke and Pepsi on the soda shelf.

THANKS SO MUCH! This was a life saver.

Douglas

4/12/2007 11:38:08 PM (Central Daylight Time, UTC-05:00)

Thanks for doing this for our community!

Ron McMahon

4/16/2007 3:28:03 AM (Central Daylight Time, UTC-05:00)

hi. thanks for that! now it works. really helped us out there.

someone

4/19/2007 8:58:52 AM (Central Daylight Time, UTC-05:00)

All I can do is echo other comments and say THANKS.
Declan

Declan Ward |declanAT NOSPAMdws dot ie

5/5/2007 2:37:09 AM (Central Daylight Time, UTC-05:00)

Thank Holy Jesus... You saved my life!!!

Jay |jayvillaAT NOSPAMyahoo dot com

5/20/2007 4:39:27 PM (Central Daylight Time, UTC-05:00)

I would also like express my sincere thanks for this script. I was in the *final* throes of finishing up a website for a client when I set the login page to a page restricted to admins only - duh....

My sincere thanks to you - may the bluebird of happiness always shine upon you! grin grin...

Sarah Gonzales |macdoggie02AT NOSPAMyahoo dot com

5/27/2007 12:15:54 PM (Central Daylight Time, UTC-05:00)

I was going to be as enthusiastic when I found the opensesame.asspx file but unfortunately i still get error retrieving password !!! any ideas on this - upgrade from 4.3.6 to 4.5.1

Dave Lumley |DavidlumleyAT NOSPAMmsn dot com

5/27/2007 12:25:21 PM (Central Daylight Time, UTC-05:00)

Hey John
I managed to fix it - I had forgotten to copy the machine key over - Done it and it logs in a tread - Why cant this process be automated??

Dave Lumley |DavidlumleyAT NOSPAMmsn dot com

6/14/2007 6:00:38 AM (Central Daylight Time, UTC-05:00)

Thanks John,

I don't know what it did but it worked. I have been searching half a day.
You should be awarded some Nobel prize!

André

6/25/2007 11:32:17 PM (Central Daylight Time, UTC-05:00)

First, thanks a lot.

But I've in struck :(( my DNN 3.2.1 not working with your solution!

All I've get a nothing happen when I input username and password.

Can you help me?

My server:

- WindowsServer 2003 Std SP1
- SQL Server 2000 SP3
- Dotnetnuke v3.2.1

*Note: my DNN 3.3.7 working fine on same server!

CiF |thonvyvnAT NOSPAMyahoo dot com

6/26/2007 1:09:31 AM (Central Daylight Time, UTC-05:00)

Thank you - Thank you - Thank you!!!

David |dslovesAT NOSPAMs3ts dot com

7/5/2007 9:23:32 AM (Central Daylight Time, UTC-05:00)

Thankyou, worked a dream, not sure what my friend did the login link does not work, but I was able to but a login modlue on the home page so it works now..
Much appreciated.. next time im Melboune give me a call we can share a nice red... cheers Colin

Colin Dixon |colinAT NOSPAMservicebroker dot com dot au

7/9/2007 12:56:58 AM (Central Daylight Time, UTC-05:00)

I guess it worked for a lot of people, so I guess I'm just one of the lucky ones that it did not work for. I got this runtime error message. I tried refresh on my website, and nothing.

.... Thanks for any advise you can give me.
Jim

jim snow |jim012lvAT NOSPAMyahoo dot com

7/10/2007 5:34:27 AM (Central Daylight Time, UTC-05:00)

if the script does not work simply enter the database. open the table dbo.portals and set the value of LoginTabID manually to zero.

this works!

Best

Frank

frank |zimmer_sbAT NOSPAMhotmail dot com

7/17/2007 9:15:19 AM (Central Daylight Time, UTC-05:00)

You are wonderful...This scripted saved me!

Connie |indcmbAT NOSPAMcomcast dot net

7/20/2007 1:40:07 PM (Central Daylight Time, UTC-05:00)

Well that aspx does allow me to login but it has not fixed the issue on the home page, it still refreshes to the default.aspx. I checked the DB and LoginTabID is NULL. I am on DNN 04.05.03. Anyone have any ideas? I was just changing the skins from fixed to full, also tried to go to grey but didnt like it. When I got it to blue full using default skins is when this happened.

Justin

8/29/2007 9:11:33 PM (Central Daylight Time, UTC-05:00)

Me Too.

I am bowing in your general direction.

THANKS

Ian Marlow |ianAT NOSPAMmodularmedia dot co dot uk

8/31/2007 9:35:12 AM (Central Daylight Time, UTC-05:00)

THANKS It also works for 4.5.5...THANKS!!!!!!!

totally grateful

9/20/2007 9:46:37 PM (Central Daylight Time, UTC-05:00)

YOU ARE THE MAN!!!!

YOU ARE THE MAN!!!!

It worked!!

YOU ARE THE MAN!!

2 Months of work almost lost.

Dan

DaN

9/22/2007 7:28:58 PM (Central Daylight Time, UTC-05:00)

A lifesaver! Thank You!

Robert Donnell |bobdonnellAT NOSPAMyahoo dot com

9/27/2007 12:44:15 AM (Central Daylight Time, UTC-05:00)

People like you made the world better. Thanks.

Imanol Guirado |imanolguiradoAT NOSPAMhotmail dot com

10/9/2007 9:56:26 AM (Central Daylight Time, UTC-05:00)

Thank you! Thank you! Thank you! Finding this post has been a god send.

Steve |SSiricaAT NOSPAMProfitecInc dot com

10/18/2007 8:07:49 AM (Central Daylight Time, UTC-05:00)

Thank you. You saved me a ton of time. Great post, simple solution.
Thanks again,
Troy

Troy Schwartz

10/23/2007 8:53:40 PM (Central Daylight Time, UTC-05:00)

Works like a charm!

Great solution!

Vinny |vq57AT NOSPAMhotmail dot com

11/16/2007 10:29:47 AM (Central Standard Time, UTC-06:00)

I can't thank you enough! I ran into this in the past w/ a bad skin removing login allowance, and blew it all away. This time I had too much to lose, you are a Godsend.

Andrea Turner |andreaAT NOSPAMpromoso dot net

11/18/2007 10:28:38 AM (Central Standard Time, UTC-06:00)

I know your loved - but wanted to pass more along! Thanks for the solution. I set this up for an easy way for my children's school to communicate, and I was a little nervous. THANK YOU VERY MUCH
Tina

Tina Walker |tinaAT NOSPAMwalkerwebdesign dot net

12/5/2007 8:12:44 PM (Central Standard Time, UTC-06:00)

John,

Yours is a brilliant piece of work. Bout as easy a fix for a real problem as I've come across.

Very nice share!!

Pat

Pat Howlett |patAT NOSPAMintranetworx dot com

12/16/2007 10:55:17 AM (Central Standard Time, UTC-06:00)

YAY, a solution! Thanks so much - I have uninstalled and reinstalled in its entirety 3 times! But what was so weird for me was that it happened in 2 different sites, 2 different versions! It worked first time, was so quick, I am in a state of delighted bliss! Reiterate gratitude - thanks again!

Lori Lea |loriAT NOSPAMmindfocus dot co dot za

12/18/2007 9:20:28 AM (Central Standard Time, UTC-06:00)

Thank you!!

Chris Devereux

1/31/2008 1:26:48 PM (Central Standard Time, UTC-06:00)

You are great man!!!! My folks would have killed me if I had to ask them to reintall everything again. Thanks a ton.

Ravinder |ravinder_saggarAT NOSPAMhotmail dot com

2/11/2008 12:17:01 PM (Central Standard Time, UTC-06:00)

You made my day to, thanks!!!

roger |alarcon_rogerAT NOSPAMhotmail dot com

2/26/2008 4:19:06 PM (Central Standard Time, UTC-06:00)

AWESOME! worked like a champ !

Dave |dhughesAT NOSPAMstorevaulthelp dot com

4/8/2008 5:08:18 AM (Central Daylight Time, UTC-05:00)

Saved my day. Thank you for all your efforts.

Merete |merete_shawulAT NOSPAMyahoo dot com

4/21/2008 4:56:34 PM (Central Daylight Time, UTC-05:00)

I have tried this fix but am unable to login to my site. everything set to null but admin and host or any other login that was setup does not log in. Is there anything else I can try?

Paul |pvaldezAT NOSPAMwlshenv dot com

5/9/2008 12:17:06 AM (Central Daylight Time, UTC-05:00)

John, just tried your rescue on 4.7 - worked like a charm. Thank you for saving me from a wasted day of headaches and grief...

Best,

Will

will |willAT NOSPAMbluedog dot com

5/28/2008 5:07:48 PM (Central Daylight Time, UTC-05:00)

Hi John,

Once again thank goodness I found your page with a solution to this problem!

why oh...why on earth is it possible to so easily get locked out of DNN installations in this way??? - surely the DNN core development team could easily write a script to prevent this from happening....I do hope third party DNN consultants are not being paid to solve such problems!!

Thank's again

Karl

6/2/2008 9:44:02 AM (Central Daylight Time, UTC-05:00)

Thank you John,

I have version4.08.03 of DNN and your file works like a charm. For those of you that created a sub-folder for DNN put the file in the root of that folder and then type in the address to open it.

Thanks again,

Antonio |awilliamsAT NOSPAMani-solutions dot com

6/2/2008 11:23:21 AM (Central Daylight Time, UTC-05:00)

I've been a DNN admin for a couple years now...this is the first time I've had this problem.

My problem was actually with a subdomain parent portal - but this worked well. All I had to do was put it into the root of the DNN install, and reference just like you said.

Thanks for putting this out there!!

Chris |christbloomAT NOSPAMgmail dot com

6/11/2008 4:43:24 PM (Central Daylight Time, UTC-05:00)

Hello Man,

This post was realy useful for me.

Many thanxx.

Digitalrox

Digitalrox |digitalroxAT NOSPAMgmail dot com

6/23/2008 3:05:44 AM (Central Daylight Time, UTC-05:00)

MAN THIS WORKED A TREAT. THANKYOU SO MUCH

Michael |mikuruAT NOSPAMgmail dot com

Name
E-mail
Home page

	Remember Me
Comment (HTML not allowed)
Enter the code shown (prevents robots):

On this page....

Categories