Page MenuHomePhabricator
Create Task
Maniphest T415354

Record CDN/Backend api and IP reputation values in editattemptsblocked schema
Closed, ResolvedPublic
Actions

Description

Summary

The editattemptsblocked schema is one of our primary views into blocked edit attempts. If we enrich this schema with x_is_browser, x_trusted_request, x_provenance, and IP reputation variables, we'll be able to more easily filter out noise from bots, to understand the impact on humans from IP and IP range blocks.

Acceptance criteria

  • x_trusted_request, x_provenance and x_is_browser are recorded in the editattemptsblocked event logging stream
  • IP Reputation variables are recorded in the editattemptsblocked event logging stream

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
BlockUtils: Log ip_reputation_organizationmediawiki/extensions/WikimediaEventsmaster+4 -1
GetSecurityLogContextHandler: Add IP reputation organizationmediawiki/extensions/IPReputationmaster+4 -0
BlockUtils: Log x-provenance and IP reputation fieldsmediawiki/extensions/WikimediaEventswmf/1.46.0-wmf.13+31 -1
BlockUtils: Log x-provenance and IP reputation fieldsmediawiki/extensions/WikimediaEventsmaster+31 -1
BlockUtils: Remove x-provenancemediawiki/extensions/WikimediaEventsmaster+0 -3
BlockUtils: Remove x-provenancemediawiki/extensions/WikimediaEventswmf/1.46.0-wmf.13+0 -3
Customize query in gerrit

Related Objects

Event Timeline

kostajh created this task.Fri, Jan 23, 12:28 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFri, Jan 23, 12:28 PM
CodeReviewBot added a project: Patch-For-Review.Fri, Jan 23, 12:58 PM

kharlan opened https://gitlab.wikimedia.org/repos/data-engineering/schemas-event-secondary/-/merge_requests/107

editattemptsblocked: Add x_is_browser, x_provenance, and x_trusted_request

CodeReviewBot added a comment.Fri, Jan 23, 7:23 PM

catrope merged https://gitlab.wikimedia.org/repos/data-engineering/schemas-event-secondary/-/merge_requests/107

editattemptsblocked: Add x_is_browser, x_provenance, and x_trusted_request

Maintenance_bot removed a project: Patch-For-Review.Fri, Jan 23, 7:33 PM
kostajh added a comment.EditedThu, Jan 29, 6:51 AM

I didn't tag https://gerrit.wikimedia.org/r/c/mediawiki/extensions/WikimediaEvents/+/1230918 correctly with this task, but that's the patch that logs the values

gerritbot added a comment.Thu, Jan 29, 8:24 AM

Change #1234916 had a related patch set uploaded (by Kosta Harlan; author: Kosta Harlan):

[mediawiki/extensions/WikimediaEvents@master] BlockUtils: Remove x-provenance

https://gerrit.wikimedia.org/r/1234916

gerritbot added a project: Patch-For-Review.Thu, Jan 29, 8:24 AM
gerritbot added a comment.Thu, Jan 29, 8:30 AM

Change #1234918 had a related patch set uploaded (by Kosta Harlan; author: Kosta Harlan):

[mediawiki/extensions/WikimediaEvents@wmf/1.46.0-wmf.13] BlockUtils: Remove x-provenance

https://gerrit.wikimedia.org/r/1234918

gerritbot added a comment.Thu, Jan 29, 8:35 AM

Change #1234918 merged by jenkins-bot:

[mediawiki/extensions/WikimediaEvents@wmf/1.46.0-wmf.13] BlockUtils: Remove x-provenance

https://gerrit.wikimedia.org/r/1234918

Stashbot added a comment.Thu, Jan 29, 8:36 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-29T08:36:33Z] <kharlan@deploy2002> Started scap sync-world: Backport for [[gerrit:1234918|BlockUtils: Remove x-provenance (T415354)]]

Stashbot added a comment.Thu, Jan 29, 8:38 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-29T08:38:55Z] <kharlan@deploy2002> kharlan: Backport for [[gerrit:1234918|BlockUtils: Remove x-provenance (T415354)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Thu, Jan 29, 8:44 AM

Mentioned in SAL (#wikimedia-operations) [2026-01-29T08:44:18Z] <kharlan@deploy2002> Finished scap sync-world: Backport for [[gerrit:1234918|BlockUtils: Remove x-provenance (T415354)]] (duration: 07m 45s)

gerritbot added a comment.Thu, Jan 29, 8:46 AM

Change #1234916 merged by jenkins-bot:

[mediawiki/extensions/WikimediaEvents@master] BlockUtils: Remove x-provenance

https://gerrit.wikimedia.org/r/1234916

ReleaseTaggerBot added a project: MW-1.46-notes (1.46.0-wmf.14; 2026-02-03).Thu, Jan 29, 9:00 AM
Maintenance_bot removed a project: Patch-For-Review.Thu, Jan 29, 9:32 AM
CodeReviewBot added a project: Patch-For-Review.Thu, Jan 29, 1:37 PM

kharlan opened https://gitlab.wikimedia.org/repos/data-engineering/schemas-event-secondary/-/merge_requests/109

editattemptsblocked: Add CDN/Backend and IP reputation fields

gerritbot added a comment.Thu, Jan 29, 1:41 PM

Change #1235022 had a related patch set uploaded (by Kosta Harlan; author: Kosta Harlan):

[mediawiki/extensions/WikimediaEvents@master] BlockUtils: Log x-provenance and IP reputation fields

https://gerrit.wikimedia.org/r/1235022

gerritbot added a comment.Thu, Jan 29, 3:15 PM

Change #1235022 merged by jenkins-bot:

[mediawiki/extensions/WikimediaEvents@master] BlockUtils: Log x-provenance and IP reputation fields

https://gerrit.wikimedia.org/r/1235022

kostajh renamed this task from Record CDN/Backend api values in editattemptsblocked schema to Record CDN/Backend api and IP reputation values in editattemptsblocked schema.Thu, Jan 29, 7:53 PM
kostajh updated the task description. (Show Details)
kostajh updated the task description. (Show Details)
CodeReviewBot added a comment.Thu, Jan 29, 9:31 PM

dreamyjazz merged https://gitlab.wikimedia.org/repos/data-engineering/schemas-event-secondary/-/merge_requests/109

editattemptsblocked: Add CDN/Backend and IP reputation fields

Maintenance_bot removed a project: Patch-For-Review.Thu, Jan 29, 10:32 PM
gerritbot added a comment.Sat, Jan 31, 10:14 AM

Change #1235458 had a related patch set uploaded (by Kosta Harlan; author: Kosta Harlan):

[mediawiki/extensions/WikimediaEvents@wmf/1.46.0-wmf.13] BlockUtils: Log x-provenance and IP reputation fields

https://gerrit.wikimedia.org/r/1235458

gerritbot added a project: Patch-For-Review.Sat, Jan 31, 10:14 AM

Change #1235459 had a related patch set uploaded (by Kosta Harlan; author: Kosta Harlan):

[mediawiki/extensions/IPReputation@master] GetSecurityLogContextHandler: Add IP reputation organization

https://gerrit.wikimedia.org/r/1235459

gerritbot added a comment.Sat, Jan 31, 10:17 AM

Change #1235460 had a related patch set uploaded (by Kosta Harlan; author: Kosta Harlan):

[mediawiki/extensions/WikimediaEvents@master] BlockUtils: Log ip_reputation_organization

https://gerrit.wikimedia.org/r/1235460

CodeReviewBot added a comment.Sat, Jan 31, 10:21 AM

kharlan opened https://gitlab.wikimedia.org/repos/data-engineering/schemas-event-secondary/-/merge_requests/112

editattemptsblocked: Add ip_reputation_organization

kostajh edited projects, added Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)); removed Product Safety and Integrity.Sun, Feb 1, 8:50 PM
kostajh moved this task from Backlog to Needs review on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.
gerritbot added a comment.Mon, Feb 2, 8:26 AM

Change #1235458 merged by jenkins-bot:

[mediawiki/extensions/WikimediaEvents@wmf/1.46.0-wmf.13] BlockUtils: Log x-provenance and IP reputation fields

https://gerrit.wikimedia.org/r/1235458

Stashbot added a comment.Mon, Feb 2, 8:46 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-02T08:46:31Z] <kharlan@deploy2002> Started scap sync-world: Backport for [[gerrit:1235458|BlockUtils: Log x-provenance and IP reputation fields (T415354)]]

Stashbot added a comment.Mon, Feb 2, 8:48 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-02T08:48:27Z] <kharlan@deploy2002> kharlan: Backport for [[gerrit:1235458|BlockUtils: Log x-provenance and IP reputation fields (T415354)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Mon, Feb 2, 8:56 AM

Mentioned in SAL (#wikimedia-operations) [2026-02-02T08:56:36Z] <kharlan@deploy2002> Finished scap sync-world: Backport for [[gerrit:1235458|BlockUtils: Log x-provenance and IP reputation fields (T415354)]] (duration: 10m 05s)

ReleaseTaggerBot edited projects, added MW-1.46-notes (1.46.0-wmf.13; 2026-01-27); removed MW-1.46-notes (1.46.0-wmf.14; 2026-02-03).Mon, Feb 2, 9:00 AM
CodeReviewBot added a comment.Mon, Feb 2, 9:29 AM

harroyo-wmf merged https://gitlab.wikimedia.org/repos/data-engineering/schemas-event-secondary/-/merge_requests/112

editattemptsblocked: Add ip_reputation_organization

gerritbot added a comment.Mon, Feb 2, 9:57 AM

Change #1235459 merged by jenkins-bot:

[mediawiki/extensions/IPReputation@master] GetSecurityLogContextHandler: Add IP reputation organization

https://gerrit.wikimedia.org/r/1235459

ReleaseTaggerBot edited projects, added MW-1.46-notes (1.46.0-wmf.14; 2026-02-03); removed MW-1.46-notes (1.46.0-wmf.13; 2026-01-27).Mon, Feb 2, 10:00 AM
jenkins-bot mentioned this in rEIPR50234ea7b9af: GetSecurityLogContextHandler: Add IP reputation organization.Mon, Feb 2, 10:01 AM
gerritbot added a comment.Mon, Feb 2, 10:31 AM

Change #1235460 merged by jenkins-bot:

[mediawiki/extensions/WikimediaEvents@master] BlockUtils: Log ip_reputation_organization

https://gerrit.wikimedia.org/r/1235460

Maintenance_bot removed a project: Patch-For-Review.Mon, Feb 2, 10:37 AM
kostajh closed this task as Resolved.Thu, Feb 5, 12:54 PM
kostajh moved this task from Needs review to Done on the Product Safety and Integrity (Sprint Daffodil (Jan 19 - Feb 6)) board.
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