DBQ-63 List of indef blocked IP addresses on en.wiki with "proxy" or "tor" in the block message
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	JiraBugConverter
	Jan 3 2014, 3:46 PM

Description

This issue was converted from https://jira.toolserver.org/browse/DBQ-63.
Summary: List of indef blocked IP addresses on en.wiki with "proxy" or "tor" in the block message
Issue type: Task - A task that needs to be done.
Priority: Trivial
Status: Done
Assignee: (none)

From: Nakon <nakonwiki@gmail.com>

Date: Wed, 13 May 2009 15:30:43

I am attempting to compile a list of IP addresses on en.wiki that are blocked indef as a result of a proxy check or tor check. If a plaintext list could be generated with just an IP address on each line, I would appreciate it.

Version: unspecified
Severity: trivial

Details

Reference: bz59318

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 2:22 AM

• bzimport added a project: Tool-Database-Queries.

• bzimport set Reference to bz59318.

JiraBugConverter created this task.Jan 3 2014, 3:46 PM

From: MZMcBride <mzmcbride@gmail.com>

Date: Wed, 13 May 2009 17:19:31

I ran this query:

SELECT
  ipb_address,
  ipb_reason
FROM ipblocks
WHERE ipb_expiry = "infinity"
AND ipb_user = 0;

Output is available here: http://toolserver.org/~mzmcbride/dbq/dbq-63.txt.gz

It's 21422 rows. I would've filtered it for you, but the ipb_reason field is a bit difficult to tell if it was a proxy / Tor sometimes (things like administrator.net hit for "tor", etc.). By my count, about 18,000 entries will match your criteria.

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: (none)
CC list: nakonwiki@gmail.com, b@mzmcbride.com

DBQ-63 List of indef blocked IP addresses on en.wiki with "proxy" or "tor" in the block messageClosed, ResolvedPublicActions