https://bugzilla.wikimedia.org/show_bug.cgi?id=25925

--- Comment #8 from Aryeh Gregor <simetrical+wikib...@gmail.com> 2010-11-16 
00:20:15 UTC ---
(In reply to comment #7)
> (BTW, I tried running a query as root on the toolserver to see how many users
> had ' ' as a password, but it's taking an awfully long time.  It's possible to
> do, but I doubt it's worth it except for sysops.)

r...@sql-s2:dewiki> SELECT COUNT(*) FROM user WHERE (user_password LIKE ':B:%'
AND SUBSTR(user_password, 13) = MD5(CONCAT(SUBSTR(user_password, 4, 8), '-',
MD5(' ')))) OR (user_password LIKE ':A:%' AND SUBSTR(user_password, 4) = MD5('
')) OR (user_password NOT LIKE ':%' AND user_password = MD5(CONCAT(user_id,
'-', MD5(' '))));
+----------+
| COUNT(*) |
+----------+
|       62 |
+----------+
1 row in set (33.86 sec)

Not actually that long, it would be easily doable to detect such users with a
maintenance script.  But what would we want to do with them?

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to