User/Pass recovery

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
8/20/2010 8:07:16 AM
Gravatar
Total Posts 116

User/Pass recovery - rather urgent!

I am rather embarrased to have to ask this question - but I was rushing through a long list of jobs today, one of which was changing the admin login details for a site which I did, then signed out and tried to sign back in and couldn't........ went to the password recovery screen and put the email address is to be told username not found blush can only assume I typed the email address in wrong and made a typo - argghh!  How do I get back in?

The install is done on the 2.3.5.1 using SQLCE and I haven't changed any default settings for the db / security.

OK, after my initial flapping I logged onto the server and opened the sdf file in notepad++ and did some searching and came across this line (in 2 seperate locations):

Adminadminandrewcrystal@googlemail.comandrewcrystal@googlemail.comWhat is your user name?xxxxxxxxxx (where the x's are my password)

- thought great so I used googlemail instead of gmail - typo just as I thought ........ tried again though and it still won't let me in, also touched the web config to see if that worked which it didn't - not sure on the settings for tries etc. or if they are tied to an IP address or a user so am hoping when I get home and to a different IP address I can login then, if it is due to max tries does that reset periodically?

Regards

Andrew

8/20/2010 9:09:36 AM
Gravatar
Total Posts 18439

Re: User/Pass recovery

Hi Andrew,

You would need to get into the database in the mp_Users table to either get the correct info to login or change it directly in the table.

The only tool I know of to help with that is WebMatrix, you could download the whole site to your local machine and then open it with WebMatrix and find the mojodb.sdf file in App_Data, then use WebMatrix to access the table.

Hope it helps,

Joe

8/20/2010 9:11:28 AM
Gravatar
Total Posts 116

Re: User/Pass recovery

Oops, sorry Joe, must have been typing at the same time there - does the info above help?

8/20/2010 9:21:04 AM
Gravatar
Total Posts 18439

Re: User/Pass recovery

ip address doesn't affect it, but if you had a bunch of failed password attempts it will say please try again later, if the message says that then wait about 15 minutes or so before trying again.

8/20/2010 9:55:29 AM
Gravatar
Total Posts 116

Re: User/Pass recovery

Hi Joe,

I gave it 30 mins or so and tried again and all I am getting is the error - won't let me login.

I will open the site is webmatrix tonight and see if anything looks different than it appears to be in the .sdf file using notepad++ and whether I can see any problem in the user table........ I have changed passwords etc on MSSQL based mojo sites without any trouble and am wondering whether I need to do anything else such as start and stop the website, recycle the app pool etc.  the main problem is the site went live today and they want some tweaks making......

Might also be worth noting that I never had any please try later notifications.

Regards

Andrew

8/20/2010 1:03:07 PM
Gravatar
Total Posts 18439

Re: User/Pass recovery

The try later message only happens if you enter correct credentials and the account is temporarily locked due to password attempt failures.

I'm not convinced you are entering correct credentials based on inspecting a database file with Notepad. I would download the .sdf file and try to inspect the data with WebMatrix.

As far as I know there is no difference in behavior for SQL CE vs SQL Server, the only difference in solving this problem is how you get to the data, with SQL CE you need a tool like WebMatrix with SQL Server you use SQL Management Studio.

Hope it helps,

Joe

8/20/2010 4:28:01 PM
Gravatar
Total Posts 116

Re: User/Pass recovery

Hi Joe,

You were of course completely correct, once I got home where I have WebMatrix installed I took a copy of the site off the server and looked the database and realised in my haste I had confused the password with the security question answer! blush

Thanks for the pointers and patience!

Regards

Andrew

8/20/2010 5:24:36 PM
Gravatar
Total Posts 116

Re: User/Pass recovery

........and its the first time I used WebMatrix which looks like a very useful tool - certainly much easier than installing IIS and a nice clean interface and very easy to use, had the site up and running locally in 2 mins flat :-) 

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