Page MenuHomePhabricator
Create Task
Maniphest T71077

Database access to spam-blacklist log
Closed, DeclinedPublic
Actions

Description

For extending one of my tool (bot), i would like to have access to log entries caused by local and global spam-blacklist blocking. On wikipedia these logs are visible to all local admins only. I am admin on dewiki, so i have read access to http://de.wikipedia.org/w/index.php?title=Spezial%3ALogbuch&type=spamblacklist.

I need this info to know which articles were affected by a block in the past. With this i can inform affected wikiproject about an ongoing whitelist discussion. Not any part of the log entry itself is reproducible from the created reports.

Spamblock log entries are currently hidden from logging table. In mediawiki the code for this log was added in https://gerrit.wikimedia.org/r/#/c/69303/8/SpamBlacklist_body.php

Is it possible for my tool to get access to this data on toollabs db?

Version: unspecified
Severity: enhancement
URL: http://de.wikipedia.org/w/index.php?title=Spezial%3ALogbuch&type=spamblacklist

Details

Reference
bz69077

Related Objects
Search...

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:32 AM
• bzimport added a project: Toolforge.
• bzimport set Reference to bz69077.
Merl created this task.Aug 3 2014, 6:47 PM
Legoktm added a comment.Aug 3 2014, 6:49 PM

eMariaDB [enwiki_p]> select * from logging where log_type="spamblacklist" limit 2;
+----------+---------------+------------+----------------+----------+---------------+-------------+-------------+--------------------------------------------------------+-------------+---------------+----------+

log_idlog_typelog_actionlog_timestamplog_userlog_namespacelog_titlelog_commentlog_paramslog_deletedlog_user_textlog_page

+----------+---------------+------------+----------------+----------+---------------+-------------+-------------+--------------------------------------------------------+-------------+---------------+----------+

51115134spamblacklisthit201309191848362158450JD_Meatyarda:1:{s:6:"4::url";s:27:"http://www.reverbnation.com";}0Runarb40575851
51115150spamblacklisthit201309191849092158450JD_Meatyarda:1:{s:6:"4::url";s:27:"http://www.reverbnation.com";}0Runarb40575851

+----------+---------------+------------+----------------+----------+---------------+-------------+-------------+--------------------------------------------------------+-------------+---------------+----------+
2 rows in set (0.03 sec)

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits