Locked users

Tárgy: Re: Tárgy: Re: Tárgy: Re: Locked users

by József Somogyi -
Number of replies: 4

No.
If I use (e.g.: in our moodle 3 times) invalid password my account will be suspended (locked).

In reply to József Somogyi

Tárgy: Re: Tárgy: Re: Tárgy: Re: Locked users

by József Somogyi -

Have somebody an idea?mixed

In reply to József Somogyi

Re: Tárgy: Re: Tárgy: Re: Tárgy: Re: Locked users

by Randy Thornton -
Picture of Documentation writers


József,

That's an interesting problem. I have never seen that lock out icon before and I could not see a way to filter for this in Browse list of users.

So, I made the following SQL query to show the list of currently locked out users.

(This assumes you are using MySQL since is uses the MySQL DATE_FORMAT function; if you have the Configurable Reports block or the Ad-hoc database queries plugin, you can use this with either of those.) 

When a user is locked out, several related entries are created in the user_preferences table for the user. When the time expires or the user is unlocked by the admin, the entries are removed. The 'login_lockout' column holds the timestamp when the user was locked out.


SELECT 
  u.username, u.firstname, u.lastname,
  DATE_FORMAT(FROM_UNIXTIME(up.value),'%Y-%m-%d %H:%i') AS 'Locked out at'
FROM prefix_user u
JOIN prefix_user_preferences up ON up.userid=u.id
WHERE up.name = 'login_lockout'


I tested this in 3.1. Hope this works for you.

Randy
Average of ratings: Useful (1)
In reply to Randy Thornton

Re: Tárgy: Re: Tárgy: Re: Tárgy: Re: Locked users

by Randy Thornton -
Picture of Documentation writers

Actually, this seems not to time out. It seems the lock entry stays there until either the admin clears it, or the user clicks the link in the email to let them log back in and they do so successfully.

In reply to Randy Thornton

Tárgy: Re: Tárgy: Re: Tárgy: Re: Tárgy: Re: Locked users

by József Somogyi -

This is the report what I looked for. Thank you so much smile