What is the status of the "account locked for 10 minutes"?

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
IndyTwoStep
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 23
Joined: Wed Dec 05, 2007 1:25 pm

What is the status of the "account locked for 10 minutes"?

Post by IndyTwoStep » Fri Jun 06, 2008 7:54 am

I still run into this problem way too often, and I am on the latest release. (and yes, I know my password - I am testing this due to concern... It returns 3 fails and then the "account locked" error that seems to only reset itself on occasion)

I have been able to duplicate this problem on general user accounts, testing as if I were a customer (we all know the three time login fail happens often), and I'd hate to go live and have to take customer calls when they run into this problem... The idea was to create less work for myself with ac7, not nonstop tech help calls from frustrated customers. Manually unlocking logins in a user table is not going to work when I migrate our current site, with over a thousand uniques daily, to this system. The law of averages is working against me here if I, the only user, have frequent problems... That's a 1 to 1 'user' vs. 'login problem' ratio, not too good IMO.

The only solution I found a couple times was to restore the backed up database (after an account remained locked for days), which is not going to work after the site goes live. I'm going to submit a ticket based on feedback here, but I'd like to know if anyone else is having this problem so I don't have to worry about our site not working correctly for customers and losing us business.

I'm aware of other threads on the issue, but there is no official definitive answer on them. Thanks...

User avatar
nickc
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Thu Nov 29, 2007 3:48 pm

Re: What is the status of the "account locked for 10 minutes"?

Post by nickc » Fri Jun 06, 2008 10:43 am

You can forcibly "unlock" by updating dbo.ac_Users.IsLockedOut.

I have encountered this situation several times; where the only way I could get logged in was to "unlock" and then reset my password - so keeping an extra admin account is a good idea.

-Nick

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: What is the status of the "account locked for 10 minutes"?

Post by Logan Rhodehamel » Fri Jun 06, 2008 10:52 am

I set up my test store with a customer password policy that allows 5 tries and a lockout period of 2 minutes. Then as a customer I entered the wrong password 5 times, until I received the account locked message. Then I waited 3 minutes and tried the correct password. I was allowed to log in, and a check of the database confirms the account locked flag was cleared and the failed password count was reset.

Possible solutions to reduce your involvement:
Decrease the lockout timeout
Increase the amount of tries before lockout occurs

The password page features a forgot password reset tool. If a customer sees they only have one or two tries left, out hope is that they will use that link to solve their password problem. This is why we alert them to the number of tries remaining.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

Mark Harris
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 37
Joined: Fri Mar 28, 2008 3:50 pm
Location: Perth, Western Australia
Contact:

Re: What is the status of the "account locked for 10 minutes"?

Post by Mark Harris » Sat Jun 07, 2008 10:28 am

As an admin, you can also keep a known password hash of something simple in a safe location. If you forget your new password the day after you change it (been there, done that) you can go and dump that known password hash into the database then login with the password.

Just as a matter of interest, i have also tried to login, failed 5 times, been locked out for 10 mins - come back the next day and still been locked out. I believe i even made a post about it :)

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: What is the status of the "account locked for 10 minutes"?

Post by jmestep » Sat Jun 07, 2008 10:47 am

How do you get a known password hash? From the database directly?
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: What is the status of the "account locked for 10 minutes"?

Post by Logan Rhodehamel » Sat Jun 07, 2008 1:52 pm

Easier than saving a password hash: find the password record for your user - set the password to something in plain text, and set the format to CLEAR. That saves you the trouble of copy/paste.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

Mark Harris
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 37
Joined: Fri Mar 28, 2008 3:50 pm
Location: Perth, Western Australia
Contact:

Re: What is the status of the "account locked for 10 minutes"?

Post by Mark Harris » Sat Jun 07, 2008 3:13 pm

Judy, yes just safe the hash for your user when you know what the password is. the Password column in ac_UsersPasswords. This still gives you a password you can restore without using the ResetAdmin.aspx tool (In the Install folder) and is secure. I'd prefer not to have my admin account with a plain text password.

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: What is the status of the "account locked for 10 minutes"?

Post by Logan Rhodehamel » Sat Jun 07, 2008 3:23 pm

Mark Harris wrote:I'd prefer not to have my admin account with a plain text password.
That's a good point. If I reset it with the CLEAR option I always change it right after. I didn't state that above and it's an important consideration.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: What is the status of the "account locked for 10 minutes"?

Post by AbleMods » Sat Jun 07, 2008 3:47 pm

Logan Rhodehamel wrote:Easier than saving a password hash: find the password record for your user - set the password to something in plain text, and set the format to CLEAR. That saves you the trouble of copy/paste.
Is this forum secure? I'm not comfortable with the posting of specific ways to compromise the security of a store db.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply