Page MenuHomePhabricator
Create Task
Maniphest T39612

CheckUser displays 2001:6a0:200:121::2/128 and 127.0.0.1/32 on PostgreSQL
Closed, ResolvedPublic
Actions

Description

Sample result from the test wiki:

(diff) (hist) . . N Test . . 01:44 . . Saper (Talk | contribs | block) (test)

IP: 2001:6a0:200:121::2/128   XFF: 0   Mozilla/5.0 (X11; FreeBSD amd64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11

on MySQL:

(różn.) (hist.) . . N Test . . 02:24 . . Saper (dyskusja | edycje | zablokuj) (cu test)

IP: 2001:6A0:200:121:0:0:0:2   Mozilla/5.0 (X11; FreeBSD amd64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11

Bug 36780 proposes that the canonical form of the IP address should be "2001:6a0:200:121::2", but we might want to get rid of /128 for IPv6 and /32 for IPv4.

This is because PostgreSQL CIDR type always returns CIDR mask from the database.

Version: unspecified
Severity: minor

Details

Reference
bz37612

Related Objects
Search...

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
· · ·
InvalidNoneT2384 [REPLACED BY TAG] PostgreSQL/pgsql support (tracking)
ResolvedUmherirrenderT39612 CheckUser displays 2001:6a0:200:121::2/128 and 127.0.0.1/32 on PostgreSQL
· · ·

Event Timeline

• bzimport raised the priority of this task from to Low.Nov 22 2014, 12:24 AM
• bzimport added a project: CheckUser.
• bzimport set Reference to bz37612.
• bzimport added a subscriber: Unknown Object (MLST).
saper created this task.Jun 15 2012, 12:30 AM
MarcoAurelio mentioned this in T139810: RFC: Overhaul the CheckUser extension.Jul 23 2016, 1:26 PM
MarcoAurelio added a project: Stewards-and-global-tools.Jul 23 2016, 1:43 PM
MarcoAurelio removed a subscriber: • wikibugs-l-list.
Restricted Application added a subscriber: JEumerus. · View Herald TranscriptJul 23 2016, 1:43 PM
Peachey88 removed a project: Stewards-and-global-tools.Jul 24 2016, 2:50 AM
Peachey88 subscribed.
Jdforrester-WMF added a project: PostgreSQL.Nov 2 2016, 8:16 PM
Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.

Meno25 unsubscribed.Nov 4 2016, 7:19 AM
Umherirrender closed this task as Resolved.Jul 7 2022, 8:58 PM
Umherirrender claimed this task.
Umherirrender subscribed.

The database for CIDR column changed in https://gerrit.wikimedia.org/r/c/mediawiki/extensions/CheckUser/+/758077, the value from the database should be shown unchanged now on the special page

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