Dispenser
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Apr 12 2015, 12:29 AM (144 w, 2 d)
Availability
Available
IRC Nick
Dispenser
LDAP User
Dispenser
MediaWiki User
Dispenser

Recent Activity

Sat, Jan 6

zhuyifei1999 awarded T167400: Disable serving unpatrolled new files to Wikipedia Zero users a Like token.
Sat, Jan 6, 1:31 PM · Reading-Infrastructure-Team-Backlog (Kanban), Patch-For-Review, User-Tgr, Traffic, Operations, media-storage, Commons, Multimedia, Zero

Fri, Dec 29

Dispenser updated the task description for T181651: Add the file hash value (sha1) to the action=info page for files uploaded in MediaWiki.
Fri, Dec 29, 11:36 AM · MW-1.31-release-notes (WMF-deploy-2018-01-09 (1.31.0-wmf.16)), Easy, MediaWiki-File-management, Multimedia, Commons

Thu, Dec 28

Dispenser triaged T183758: Create backups of user tables from decommissioned database servers as High priority.
Thu, Dec 28, 10:41 PM · cloud-services-team (Kanban), Data-Services, DBA

Sun, Dec 24

Dispenser added a subtask for T181932: Add SUL/CentralAuth variables to AbuseFilter: T130439: Add an AbuseFilter variable for global edit count of the user.
Sun, Dec 24, 1:48 AM · MediaWiki-extensions-CentralAuth, AbuseFilter, Commons
Dispenser added a parent task for T130439: Add an AbuseFilter variable for global edit count of the user: T181932: Add SUL/CentralAuth variables to AbuseFilter.
Sun, Dec 24, 1:48 AM · Patch-For-Review, MediaWiki-extensions-CentralAuth, AbuseFilter

Dec 16 2017

Dispenser added a comment to T181401: wikidatawiki_p.wb_items_per_site query is slower than expected on Wiki Replicas.

Query just now on ToolForge's analytics cluster (labsdb1010): 13 min 24.37 sec. It seems to be getting worse.

Dec 16 2017, 3:35 AM · Regression, Data-Services, Performance, Wikidata

Dec 15 2017

Dispenser added a comment to T182948: Create method for accessing user watchlists in database queries.

I mean literally just that. You can try out the aforementioned gimped tool which only joins against dplbot 's pre-generated results table for enwiki, The tool calls watchlistraw OAuth or Watchlist Token to create a TEMPORARY TABLE with all the pages that you currently watch.

Dec 15 2017, 1:42 PM · Data-Services, DBA
Dispenser updated subscribers of T134135: Bring Wikipedia Zero to the United States.

"Net neutrality vote: FCC repeals Obama-era Internet rules". There are now no obstacles from regulators for getting this implemented

Dec 15 2017, 8:44 AM · Zero
Dispenser lowered the priority of T182948: Create method for accessing user watchlists in database queries from High to Normal.
Dec 15 2017, 6:04 AM · Data-Services, DBA
Dispenser triaged T182948: Create method for accessing user watchlists in database queries as High priority.
Dec 15 2017, 6:03 AM · Data-Services, DBA
Dispenser added a project to T21153: Enable dng uploads on Commons: WMF-Legal.

DNG support was torpedoed in the 2016 Community Wishlist Survey due to patent concerns. I'm interested in legal's opinion since the WMF hosted Commons Archive accepts them.

Dec 15 2017, 1:11 AM · WMF-Legal, MediaWiki-extensions-PagedTiffHandler, Commons, Multimedia, MediaWiki-File-management

Dec 14 2017

Dispenser added a comment to T182822: Generate a list of files that are supposed to exist but 404s.

I did something similar years ago to pre-generate thumbnails for WikiMiniAtlas with its unusual sizes (48x48). Stored the content-length and response code. This was useful in multiple ways, we were able to identify corrupt files, missing files, rendering problems, and had a list of thumbnails that somehow were 2 MB in size--Those ended up being very large ICC Profiles.

Dec 14 2017, 11:28 PM · Operations, Multimedia, media-storage, Commons

Dec 12 2017

Dispenser added a comment to T180636: Make Dispenser's principle_links table accessible in new Wiki replica cluster.

@jcrespo The current pipeline is:

  1. A bash/python script on ToolForge which makes 275,000 MW API requests and bundles JSON responses in a .tar.gz on the last day of the month
  2. A python script on my server downloads that on the first of the month. Processes it which spits out a Tab-Separated Value then loads it into the database.
  3. (edit) The death_dabs.sql script then for 30 minutes creating a report for users to work off of. (Currently long running query)
Dec 12 2017, 7:39 PM · Data-Services, DBA

Dec 9 2017

Dispenser updated the task description for T166024: Once it's not patent-encumbered, enable MPEG-2 support for Commons uploads and TMH/etc. playback.
Dec 9 2017, 3:25 AM · UploadWizard, TimedMediaHandler, WMF-Legal, Commons, Multimedia

Dec 4 2017

Liuxinyu970226 awarded T132650: Copyright detection (acoustic fingerprint matching) for audio files a Like token.
Dec 4 2017, 11:07 AM · Possible-Tech-Projects, Commons

Dec 3 2017

Dispenser added a project to T181401: wikidatawiki_p.wb_items_per_site query is slower than expected on Wiki Replicas: Regression.
Dec 3 2017, 9:55 PM · Regression, Data-Services, Performance, Wikidata
Dispenser added a comment to T181401: wikidatawiki_p.wb_items_per_site query is slower than expected on Wiki Replicas.

I forgot to mention that this is a regression. That code was executing under 1 second 6+ months ago and only in late November I noticed queries failing constantly.

Dec 3 2017, 5:09 PM · Regression, Data-Services, Performance, Wikidata
Dispenser created T181932: Add SUL/CentralAuth variables to AbuseFilter.
Dec 3 2017, 2:11 PM · MediaWiki-extensions-CentralAuth, AbuseFilter, Commons

Dec 2 2017

Dispenser updated the task description for T132650: Copyright detection (acoustic fingerprint matching) for audio files.
Dec 2 2017, 5:03 AM · Possible-Tech-Projects, Commons

Nov 29 2017

Dispenser edited projects for T181651: Add the file hash value (sha1) to the action=info page for files uploaded in MediaWiki, added: MediaWiki-File-management, MediaWiki-Special-pages, Easy; removed media-storage.
Nov 29 2017, 5:36 PM · MW-1.31-release-notes (WMF-deploy-2018-01-09 (1.31.0-wmf.16)), Easy, MediaWiki-File-management, Multimedia, Commons
Dispenser created T181651: Add the file hash value (sha1) to the action=info page for files uploaded in MediaWiki.
Nov 29 2017, 5:26 PM · MW-1.31-release-notes (WMF-deploy-2018-01-09 (1.31.0-wmf.16)), Easy, MediaWiki-File-management, Multimedia, Commons

Nov 28 2017

Dispenser added a comment to T132650: Copyright detection (acoustic fingerprint matching) for audio files.

Rapid grant for hosting properitary tools?

Nov 28 2017, 8:55 PM · Possible-Tech-Projects, Commons

Nov 27 2017

Dispenser created T181401: wikidatawiki_p.wb_items_per_site query is slower than expected on Wiki Replicas.
Nov 27 2017, 2:03 PM · Regression, Data-Services, Performance, Wikidata

Nov 21 2017

Dispenser added a comment to T120288: Enable MP3 uploads on Wikimedia Commons and TMH playback.

@kaldari An AcoustID web interface for Commons.

Nov 21 2017, 6:32 PM · Patch-For-Review, Support-and-Safety, TimedMediaHandler, WMF-Legal, UploadWizard, Commons, User-notice, Multimedia

Nov 16 2017

Dispenser created T180723: Load .bashrc when using become.
Nov 16 2017, 6:20 PM · Toolforge
Dispenser added a comment to T174342: Missing IP addresses for Maroc Telecom .

@Aklapper The Checkuser information is irrecoverably gone and thus the task can no longer be completed and Invalid. You can change it to decline if you think that's more appropriate.

Nov 16 2017, 4:29 PM · Operations, Traffic, Phabricator, Zero
Dispenser closed T174342: Missing IP addresses for Maroc Telecom as Invalid.

The team squandered a perfect opportunity where a WP0 pirate broke the ISP blackholing, registered an account on mediawiki.org, and finally created an account on Phabricator to upload files. All on Maroc Telecom IP address missed by Wikipedia Zero Phabricator block and https://gerrit.wikimedia.org/r/#/c/368775/

Nov 16 2017, 4:18 PM · Operations, Traffic, Phabricator, Zero

Nov 15 2017

Dispenser added a comment to T180558: Include namespace IDs and their names to mysql wikireplicas (meta_p database).

I hope to see a namespace table added to meta_p. And with more thought. Domain isn't needed, dbname should lose _p per Labs convention, and maybe a gender flag to distinguish Benutzer and Benutzerin depending on future MW plans. Here's what it is currently (note: MediaWiki and MediaWiki Diskussion):

SELECT *
FROM s51892_toolserverdb_p.namespacename
WHERE dbname LIKE "dewiki_p"
ORDER BY FLOOR(ns_id/2), ns_is_favorite DESC, ns_type, ns_name;
dbnamedomainns_idns_namens_typens_is_favorite
dewiki_pde.wikipedia.org-2Mediumprimary1
dewiki_pde.wikipedia.org-1Spezialprimary1
dewiki_pde.wikipedia.org-2Mediacanonical0
dewiki_pde.wikipedia.org-1Specialcanonical0
dewiki_pde.wikipedia.org0primary1
dewiki_pde.wikipedia.org1Diskussionprimary1
dewiki_pde.wikipedia.org1Talkcanonical0
dewiki_pde.wikipedia.org2Benutzerprimary1
dewiki_pde.wikipedia.org3Benutzer Diskussionprimary1
dewiki_pde.wikipedia.org2Usercanonical0
dewiki_pde.wikipedia.org3User talkcanonical0
dewiki_pde.wikipedia.org3BDalias0
dewiki_pde.wikipedia.org2Benutzerinalias0
dewiki_pde.wikipedia.org3Benutzerin Diskussionalias0
dewiki_pde.wikipedia.org4Wikipediaprimary1
dewiki_pde.wikipedia.org5Wikipedia Diskussionprimary1
dewiki_pde.wikipedia.org4Projectcanonical0
dewiki_pde.wikipedia.org5Project talkcanonical0
dewiki_pde.wikipedia.org5WDalias0
dewiki_pde.wikipedia.org4WPalias0
dewiki_pde.wikipedia.org6Dateiprimary1
dewiki_pde.wikipedia.org7Datei Diskussionprimary1
dewiki_pde.wikipedia.org6Filecanonical0
dewiki_pde.wikipedia.org7File talkcanonical0
dewiki_pde.wikipedia.org6Bildalias0
dewiki_pde.wikipedia.org7Bild Diskussionalias0
dewiki_pde.wikipedia.org6Imagealias0
dewiki_pde.wikipedia.org7Image talkalias0
dewiki_pde.wikipedia.org9MediaWiki Diskussionprimary1
dewiki_pde.wikipedia.org8MediaWikicanonical1
dewiki_pde.wikipedia.org9MediaWiki talkcanonical0
dewiki_pde.wikipedia.org10Vorlageprimary1
dewiki_pde.wikipedia.org11Vorlage Diskussionprimary1
dewiki_pde.wikipedia.org10Templatecanonical0
dewiki_pde.wikipedia.org11Template talkcanonical0
dewiki_pde.wikipedia.org12Hilfeprimary1
dewiki_pde.wikipedia.org13Hilfe Diskussionprimary1
dewiki_pde.wikipedia.org12Helpcanonical0
dewiki_pde.wikipedia.org13Help talkcanonical0
dewiki_pde.wikipedia.org12Halias0
dewiki_pde.wikipedia.org13HDalias0
dewiki_pde.wikipedia.org14Kategorieprimary1
dewiki_pde.wikipedia.org15Kategorie Diskussionprimary1
dewiki_pde.wikipedia.org14Categorycanonical0
dewiki_pde.wikipedia.org15Category talkcanonical0
dewiki_pde.wikipedia.org100Portalcanonical1
dewiki_pde.wikipedia.org101Portal Diskussioncanonical1
dewiki_pde.wikipedia.org100Palias0
dewiki_pde.wikipedia.org101PDalias0
dewiki_pde.wikipedia.org828Modulprimary1
dewiki_pde.wikipedia.org829Modul Diskussionprimary1
dewiki_pde.wikipedia.org828Modulecanonical0
dewiki_pde.wikipedia.org829Module talkcanonical0
Nov 15 2017, 9:30 PM · Data-Services
Dispenser added a comment to T180636: Make Dispenser's principle_links table accessible in new Wiki replica cluster.

@Marostegui It is needed in the middle of JOINs. Similar to the pagelinks table.

Nov 15 2017, 9:12 PM · Data-Services, DBA
Dispenser created T180636: Make Dispenser's principle_links table accessible in new Wiki replica cluster.
Nov 15 2017, 8:59 PM · Data-Services, DBA
Dispenser created T180558: Include namespace IDs and their names to mysql wikireplicas (meta_p database).
Nov 15 2017, 4:22 AM · Data-Services
Dispenser added a comment to T179628: Consider granting `CREATE TEMPORARY TABLES` to labsdbuser.

@Dispenser Do you have a link to a code example?

missing_entries.sql

Nov 15 2017, 4:15 AM · DBA, Data-Services

Nov 13 2017

Dispenser added a comment to T179628: Consider granting `CREATE TEMPORARY TABLES` to labsdbuser.

An example from a recent created report:

  1. Table 1: Article titles with GROUP BY normalized titles HAVING COUNT(*) > 1
  2. Table 2: All links from disambiguation pages and set-index articles with redirects resolved, sorting and indexing by (target_page, dab_page)
  3. These tables are combined and outputted into the report

The initial version using a single query and was projected to be 12x slower (6-8 hours vs 30 minutes).

Nov 13 2017, 4:23 PM · DBA, Data-Services
Dispenser added a comment to T179922: Reports of global connection limit exhaustion for connections to labsdb1003.
SELECT @@hostname, @@version, @@max_user_connections, @@max_connections, "Notes       ";
hostnameversionmax_user_connectionsmax_connectionsNotes
labsdb100110.0.22-MariaDB01000Disk failure
labsdb100310.0.22-MariaDB01000Labsdb
labsdb100510.0.31-MariaDB01024tools.labsdb
labsdb100910.1.28-MariaDB101024analytics
labsdb101110.1.28-MariaDB101024web

Toolserver had max_user_connections set to 15. Firefox until June 2017 had 8 connection pipelining, so two users could saturate all your database connections. The new standard HTTP/2 uses no fewer than 100 streams, so eleven users could saturate all connections on the database server if there was no DB user limit.

Nov 13 2017, 12:13 AM · Data-Services, Toolforge

Nov 12 2017

Dispenser awarded T179628: Consider granting `CREATE TEMPORARY TABLES` to labsdbuser a Like token.
Nov 12 2017, 1:34 PM · DBA, Data-Services

Nov 6 2017

Dispenser added a comment to T174342: Missing IP addresses for Maroc Telecom .

7 days. In 7 days the IP information will start disappearing.

Nov 6 2017, 12:22 PM · Operations, Traffic, Phabricator, Zero

Nov 4 2017

Dispenser created T179767: Database replica drift on web and analytics clusters.
Nov 4 2017, 5:57 PM · Data-Services, DBA
Steinsplitter awarded P5972 Media files needing purging (WP0 related) a Yellow Medal token.
Nov 4 2017, 12:15 PM · media-storage

Nov 2 2017

Dispenser updated subscribers of T174342: Missing IP addresses for Maroc Telecom .

@Keegan You've got less than a fortnight!

Nov 2 2017, 7:08 PM · Operations, Traffic, Phabricator, Zero
Dispenser updated subscribers of T179599: Adoption of tb-dev Red Link Recovery tools.
Nov 2 2017, 6:46 PM · Toolforge-standards-committee
Dispenser created T179599: Adoption of tb-dev Red Link Recovery tools.
Nov 2 2017, 5:44 PM · Toolforge-standards-committee

Oct 20 2017

Dispenser added a comment to T178601: Add charset=utf-8 by default to lighttpd.

Here are the changes I made to that script on my server:

...
      # mime types
      next if $extensions{$_};
      $extensions{$_} = 1;
      if (substr($1, 0, 5) eq "text/" or $1 eq "application/javascript") {
         print "\".$_\" => \"$1; charset=utf-8\",\n";
      } else {
         print "\".$_\" => \"$1\",\n";
      }
    }
...

That still leaves out extensions .log, .conf, and README not listed in mime.types, but are covered by Bühler's script.

Oct 20 2017, 7:57 AM · Toolforge

Oct 19 2017

Dispenser created T178601: Add charset=utf-8 by default to lighttpd.
Oct 19 2017, 5:52 PM · Toolforge

Oct 13 2017

Dispenser edited P5972 Media files needing purging (WP0 related).
Oct 13 2017, 1:32 AM · media-storage

Oct 12 2017

Liuxinyu970226 awarded T167400: Disable serving unpatrolled new files to Wikipedia Zero users a Like token.
Oct 12 2017, 11:44 AM · Reading-Infrastructure-Team-Backlog (Kanban), Patch-For-Review, User-Tgr, Traffic, Operations, media-storage, Commons, Multimedia, Zero

Oct 6 2017

Dispenser added a comment to T171881: CL support for Wikipedia Zero piracy problems.

10 out of the 37 files deleted in the past 24 hours are still accessible (with the script I ran for @Keegan yesterday)

Oct 6 2017, 4:08 AM · Patch-For-Review, Community-Liaisons (Oct-Dec 2017), Zero

Oct 5 2017

Dispenser added a comment to T167400: Disable serving unpatrolled new files to Wikipedia Zero users.

Since this seems to be impossible. Would adding interstitial for Facebook referrers be doable? I imagine that we'd want to discourage people from thinking our content comes from Facebook.

Oct 5 2017, 8:55 PM · Reading-Infrastructure-Team-Backlog (Kanban), Patch-For-Review, User-Tgr, Traffic, Operations, media-storage, Commons, Multimedia, Zero
Steinsplitter awarded T174342: Missing IP addresses for Maroc Telecom a The World Burns token.
Oct 5 2017, 12:22 PM · Operations, Traffic, Phabricator, Zero

Sep 26 2017

Dispenser added a comment to T176647: Help English Wikivoyage restrict certain file type uploads to address illicit file uploads.

...Commons has a few filters for that, linked in the description of T129845 (unfortunately it seems that the filters are private...

Sep 26 2017, 12:23 AM · Community-Liaisons (Oct-Dec 2017), Wikimedia-Site-requests

Sep 25 2017

Dispenser added a comment to T176647: Help English Wikivoyage restrict certain file type uploads to address illicit file uploads.

These are all known WP0 abusers--The persistent type. They'll wait a week, make edits, whatever to get passed the filters.

Sep 25 2017, 9:50 PM · Community-Liaisons (Oct-Dec 2017), Wikimedia-Site-requests
Dispenser added a parent task for T176647: Help English Wikivoyage restrict certain file type uploads to address illicit file uploads: Unknown Object (Task).
Sep 25 2017, 9:43 PM · Community-Liaisons (Oct-Dec 2017), Wikimedia-Site-requests

Sep 21 2017

Dispenser closed T170231: Upload spam as Resolved.
Sep 21 2017, 12:50 PM

Sep 19 2017

Dispenser added a comment to T174342: Missing IP addresses for Maroc Telecom .

The account was registered on August 15 and blocked on August 23. According to CheckUser policy this IP information will start to disappear on November 13 (90 days). I'm afraid of inaction loosing this opportunity.

Sep 19 2017, 8:48 PM · Operations, Traffic, Phabricator, Zero

Sep 15 2017

Dispenser added a comment to T174342: Missing IP addresses for Maroc Telecom .

@Dzahn The issue demonstrated is that we cannot reliably filter for Wikipedia Zero connectivity. This can be remedied by:

  • By Ops continuously communicating with the ISP to get the current ranges, or
  • Documenting that WP0 identification is porous and the only guarantee is country wide blocking
Sep 15 2017, 10:16 PM · Operations, Traffic, Phabricator, Zero

Sep 14 2017

Dispenser updated subscribers of T174342: Missing IP addresses for Maroc Telecom .
Sep 14 2017, 8:52 PM · Operations, Traffic, Phabricator, Zero

Sep 12 2017

Dispenser added a comment to T173580: $wgMaxAnimatedGifArea is not honored by Thumbor.
SELECT img_name, img_width * img_height * SUBSTRING(img_metadata, LOCATE('"frameCount";i:', img_metadata) + 15, LOCATE(';', SUBSTRING(img_metadata, LOCATE('"frameCount";i:', img_metadata) + 15)) - 1 ) as pixels FROM image WHERE img_minor_mime = 'gif' HAVING pixels > 100000000
Sep 12 2017, 1:17 AM · Patch-For-Review, Performance-Team, Thumbor, Commons, MediaWiki-File-management, MediaWiki-extensions-VipsScaler, Multimedia

Sep 8 2017

Dispenser added a comment to T167815: Conduct MP3 patrol discussion.

@CKoerner_WMF The discussion has been kicked into the archives just shy of four weeks.

Sep 8 2017, 7:39 PM · Readers-Community-Engagement, Community-Liaisons (Jul-Sep 2017), Commons, Multimedia

Sep 7 2017

Dispenser edited P5972 Media files needing purging (WP0 related).
Sep 7 2017, 10:58 PM · media-storage
Dispenser created P5972 Media files needing purging (WP0 related).
Sep 7 2017, 6:22 PM · media-storage

Sep 6 2017

Dispenser added a comment to T138967: Labs database replica drift.

From arwiki: File:الله عز وجل.png. Deleted in Nov 2015.

$ sql arwiki_p -e 'SELECT 1 AS "Exists" FROM arwiki_p.image WHERE img_name="الله_عز_وجل.png";'
Exists
1
$ sql enwiki_p -e 'SELECT 1 AS "Exists" FROM arwiki_p.image WHERE img_name="الله_عز_وجل.png";'
$ # No results
Sep 6 2017, 11:18 PM · Data-Services, Epic, DBA

Sep 5 2017

Keegan awarded T167000: Extract video encoder metadata from WebM videos a Love token.
Sep 5 2017, 9:23 PM · MW-1.31-release-notes (WMF-deploy-2017-10-10 (1.31.0-wmf.3)), Patch-For-Review, TimedMediaHandler, Commons, Multimedia

Sep 4 2017

Dispenser updated the task description for T174518: Remove OO-UI from Special:NewFiles Media type field.
Sep 4 2017, 12:11 PM · MW-1.30-release-notes (WMF-deploy-2017-09-05 (1.30.0-wmf.17)), MediaWiki-Special-pages, Commons, Multimedia, Accessibility

Sep 2 2017

Dispenser added a comment to T167400: Disable serving unpatrolled new files to Wikipedia Zero users.

A media block was implemented into Phabricator to combat T168142 WP0 abuse. Since then, we've discovered T174342 that the WP0 configuration is inconsistent with issued IP ranges.

Sep 2 2017, 3:55 PM · Reading-Infrastructure-Team-Backlog (Kanban), Patch-For-Review, User-Tgr, Traffic, Operations, media-storage, Commons, Multimedia, Zero

Aug 30 2017

Dispenser added a comment to T167915: Disable media for Morocco Wikipedia Zero.

This was implemented for Phabricator by first disabling media for WP0 (gerrit 363264), followed by blackholing Moroccan IPs (gerrit 368775). Neither was completely effective since several ranges were missed (T174342).

Aug 30 2017, 11:11 AM · Zero

Aug 29 2017

Dispenser updated the task description for T174518: Remove OO-UI from Special:NewFiles Media type field.
Aug 29 2017, 11:51 PM · MW-1.30-release-notes (WMF-deploy-2017-09-05 (1.30.0-wmf.17)), MediaWiki-Special-pages, Commons, Multimedia, Accessibility
Dispenser created T174518: Remove OO-UI from Special:NewFiles Media type field.
Aug 29 2017, 11:26 PM · MW-1.30-release-notes (WMF-deploy-2017-09-05 (1.30.0-wmf.17)), MediaWiki-Special-pages, Commons, Multimedia, Accessibility

Aug 28 2017

Dispenser created T174391: 30 Audio WebM files on Commons marked as MEDIATYPE_VIDEO.
Aug 28 2017, 8:22 PM · Wikimedia-Incident, Multimedia-Team-Working-Board, Commons, TimedMediaHandler, Multimedia, MediaWiki-File-management
Dispenser added a comment to T174342: Missing IP addresses for Maroc Telecom .

I found those ranges in a GeoIP database for Morocco back in June (Z567#10320). We didn't include them for fear of blocking Orange Morocco (the only non-WP0 mobile carrier).

Aug 28 2017, 6:49 PM · Operations, Traffic, Phabricator, Zero
Dispenser added a comment to T174342: Missing IP addresses for Maroc Telecom .

@Aklapper The user loads 403 Phabricator, pulls down the notification bar with Wi-Fi disabled, Maroc Telecom, and disables/re-enables Mobile Data a few times and reloads for the full Phabricator website.

Aug 28 2017, 6:38 PM · Operations, Traffic, Phabricator, Zero
Dispenser created T174342: Missing IP addresses for Maroc Telecom .
Aug 28 2017, 12:52 PM · Operations, Traffic, Phabricator, Zero

Aug 18 2017

Dispenser added a subtask for T25063: Large GIF animations create errors: T173580: $wgMaxAnimatedGifArea is not honored by Thumbor.
Aug 18 2017, 4:41 PM · Commons, Multimedia, MediaWiki-File-management
Dispenser added a parent task for T173580: $wgMaxAnimatedGifArea is not honored by Thumbor: T25063: Large GIF animations create errors.
Aug 18 2017, 4:41 PM · Patch-For-Review, Performance-Team, Thumbor, Commons, MediaWiki-File-management, MediaWiki-extensions-VipsScaler, Multimedia
Dispenser added projects to T173580: $wgMaxAnimatedGifArea is not honored by Thumbor: Multimedia, MediaWiki-extensions-VipsScaler, MediaWiki-File-management, Commons.
Aug 18 2017, 4:37 PM · Patch-For-Review, Performance-Team, Thumbor, Commons, MediaWiki-File-management, MediaWiki-extensions-VipsScaler, Multimedia
Dispenser created T173580: $wgMaxAnimatedGifArea is not honored by Thumbor.
Aug 18 2017, 4:34 PM · Patch-For-Review, Performance-Team, Thumbor, Commons, MediaWiki-File-management, MediaWiki-extensions-VipsScaler, Multimedia

Aug 17 2017

Dispenser added a comment to T152297: Add state or city level geotargeting to CentralNotice.

At the October AfroCROWD I asked how people learned of the meetup. Most saw a flyer in the library. Clearly the general public did not see the watchlist notice.

Aug 17 2017, 5:45 PM · Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Privacy
Dispenser updated subscribers of T152297: Add state or city level geotargeting to CentralNotice.
Aug 17 2017, 5:31 PM · Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Privacy
zhuyifei1999 awarded T167400: Disable serving unpatrolled new files to Wikipedia Zero users a Love token.
Aug 17 2017, 11:32 AM · Reading-Infrastructure-Team-Backlog (Kanban), Patch-For-Review, User-Tgr, Traffic, Operations, media-storage, Commons, Multimedia, Zero
Vituzzu awarded T167400: Disable serving unpatrolled new files to Wikipedia Zero users a Like token.
Aug 17 2017, 9:29 AM · Reading-Infrastructure-Team-Backlog (Kanban), Patch-For-Review, User-Tgr, Traffic, Operations, media-storage, Commons, Multimedia, Zero

Aug 7 2017

Dispenser added a comment to T134135: Bring Wikipedia Zero to the United States.

The Amazon E-ink Kindles offer free Wikipedia over their 3G Whispernet system. We should consider incorporating it under the Wikipedia Zero umbrella.

Aug 7 2017, 2:34 AM · Zero

Jul 21 2017

Dispenser added a comment to T120288: Enable MP3 uploads on Wikimedia Commons and TMH playback.

@kaldari I tested python-acoustid to work with an MP3. The bot posts results to #wikimedia-commons-admin and ##wikimedia-commons-newbie-av on Freenode. Its hastily built (just to see if anyone wanted it), runs in anti-nuisance hourly updates, and I added Acoustid to see how well it works. It'll be converted it into a web tool so admins can delete and patrol without opening windows and at their convenience.

Jul 21 2017, 9:48 PM · Patch-For-Review, Support-and-Safety, TimedMediaHandler, WMF-Legal, UploadWizard, Commons, User-notice, Multimedia
Dispenser added a comment to T120288: Enable MP3 uploads on Wikimedia Commons and TMH playback.

@Keegan I've research and built tools for audio related uploads due to the Wikipedia Zero piracy problem. I have an IRC bot which fingerprints the audio track of audio and video files and lists acoustid.org matches. I also have an agreement with ACRCloud (strings attached) to scan music. I think that Wikipedia's use as a piracy host (for non-zero users) is lessened with easier free listening on YouTube (or Pandora or Spotify). This directly address @greg patrolling comment where he alludes to T167815.

Jul 21 2017, 7:02 PM · Patch-For-Review, Support-and-Safety, TimedMediaHandler, WMF-Legal, UploadWizard, Commons, User-notice, Multimedia
Dispenser added a comment to T120288: Enable MP3 uploads on Wikimedia Commons and TMH playback.

@greg We have been deleting an average of 260 uploads per week since January 1, 2017 from Wikipedia Zero pirates T129845. Many videos uploads are from YouTube. And frankly YouTube is a more convenient music listening experience.

Jul 21 2017, 5:55 PM · Patch-For-Review, Support-and-Safety, TimedMediaHandler, WMF-Legal, UploadWizard, Commons, User-notice, Multimedia
Dispenser added a comment to T120288: Enable MP3 uploads on Wikimedia Commons and TMH playback.

It been 7 months since MP3 decoding support dropped in RedHat Fedora Linux, Chromium (the FLOSS fork that doesn't support H.264) will now have MP3 support. Will Wikipedia be the last Open Source project to get MP3 support?

Jul 21 2017, 3:38 PM · Patch-For-Review, Support-and-Safety, TimedMediaHandler, WMF-Legal, UploadWizard, Commons, User-notice, Multimedia
Dispenser changed the status of T167815: Conduct MP3 patrol discussion, a subtask of T120288: Enable MP3 uploads on Wikimedia Commons and TMH playback, from Open to Stalled.
Jul 21 2017, 3:12 PM · Patch-For-Review, Support-and-Safety, TimedMediaHandler, WMF-Legal, UploadWizard, Commons, User-notice, Multimedia
Dispenser changed the status of T167815: Conduct MP3 patrol discussion from Open to Stalled.

It's been 4 weeks since any major work on the MP3 patrol discussion (draft). Due to WP0 abuse T129845 we already have tools functioning as being proposed by Phase II. This is 6 months to a year too late, I suggest we kill this before wasting time.

Jul 21 2017, 3:12 PM · Readers-Community-Engagement, Community-Liaisons (Jul-Sep 2017), Commons, Multimedia

Jul 18 2017

Dispenser updated the task description for T68337: Scaling of images should take place in a linear colour space.
Jul 18 2017, 11:58 PM · Commons, Multimedia, MediaWiki-File-management

Jul 17 2017

Dispenser updated the task description for T156135: Audio WebM file marked as MEDIATYPE_VIDEO.
Jul 17 2017, 6:55 PM · MW-1.30-release-notes, Patch-For-Review, Commons, TimedMediaHandler, Multimedia, MediaWiki-File-management
Dispenser added a comment to T156135: Audio WebM file marked as MEDIATYPE_VIDEO.
SELECT img_name
FROM image
WHERE img_media_type="VIDEO"
AND img_major_mime="video" AND img_minor_mime="webm"
/* Yes it was always properly detect in img_metadata */
AND img_metadata LIKE '%s:9:"mime_type";s:10:"audio/webm";%';
Jul 17 2017, 6:50 PM · MW-1.30-release-notes, Patch-For-Review, Commons, TimedMediaHandler, Multimedia, MediaWiki-File-management

Jul 11 2017

Dispenser updated the task description for T156135: Audio WebM file marked as MEDIATYPE_VIDEO.
Jul 11 2017, 4:30 PM · MW-1.30-release-notes, Patch-For-Review, Commons, TimedMediaHandler, Multimedia, MediaWiki-File-management

Jul 7 2017

Dispenser added a comment to T150548: Reduce watchlist_count threshold.
/* Most watched unstarted RfAs */
SELECT SUBSTRING(wl_title, 24, 50) AS RfA_subpage, Watchers
FROM watchlist_count
LEFT JOIN page ON wl_namespace=page_namespace AND wl_title=page_title
WHERE wl_namespace = 4
AND wl_title LIKE "Requests_for_adminship/%"
AND wl_title NOT LIKE "Requests_for_adminship/Archive_%"
AND page_id IS NULL
ORDER BY watchers DESC;
+----------------------------------------------------+----------+
| RfA_subpage                                        | Watchers |
+----------------------------------------------------+----------+
| Koavf_3                                            |      415 |
| Malleus_Fatuarum_3                                 |       40 |
| Daniel/August_2006Wikipedia:Requests_for_adminship |       39 |
| SandyGeorgia                                       |       35 |
| Daniel_2                                           |       35 |
| Kelly_Martin_(2)                                   |       32 |
+----------------------------------------------------+----------+

Compare to 2010 results from the Toolserver, much usefulness is removed.

Jul 7 2017, 10:42 PM · Wikimedia-Site-requests, Cloud-Services, DBA

Jun 23 2017

Dispenser added a comment to T132650: Copyright detection (acoustic fingerprint matching) for audio files.

@kaldari I've experimentally added AcoustID into an IRC bot notifying Commons admins of audio and video files uploaded by newbies. Three files were recognized in the past week of WP0 abuse, I'd say it's <10% effective.

Jun 23 2017, 1:24 AM · Possible-Tech-Projects, Commons

Jun 22 2017

Dispenser awarded T147667: Site and Gadget CSS should apply after core and skin CSS a Yellow Medal token.
Jun 22 2017, 3:12 AM · MW-1.30-release-notes (WMF-deploy-2017-06-27_(1.30.0-wmf.7)), MediaWiki-ResourceLoader, Performance-Team, Gadgets, Regression

Jun 21 2017

Dispenser created P5610 Newbie video uploads (+deleted uploads).
Jun 21 2017, 6:33 PM

Jun 19 2017

Jseddon awarded T152297: Add state or city level geotargeting to CentralNotice a Like token.
Jun 19 2017, 10:30 AM · Fundraising-Backlog, MediaWiki-extensions-CentralNotice, Privacy

Jun 17 2017

Dispenser added a comment to T132650: Copyright detection (acoustic fingerprint matching) for audio files.

Implementation update. See T132650#3273150 for the survey of technology.

Jun 17 2017, 4:11 PM · Possible-Tech-Projects, Commons
Dispenser created T168128: Install MP3 encoders and decoders on Tool Labs.
Jun 17 2017, 1:50 PM · Patch-For-Review, Toolforge, Cloud-Services
Poyekhali awarded T167400: Disable serving unpatrolled new files to Wikipedia Zero users a Like token.
Jun 17 2017, 1:37 AM · Reading-Infrastructure-Team-Backlog (Kanban), Patch-For-Review, User-Tgr, Traffic, Operations, media-storage, Commons, Multimedia, Zero
Poyekhali awarded T167915: Disable media for Morocco Wikipedia Zero a Like token.
Jun 17 2017, 1:07 AM · Zero
Dispenser added a comment to T167915: Disable media for Morocco Wikipedia Zero.

why do you want kill all Media served to Wikipedia Zero for Inwi and Maroc Telecom (IAM).

Jun 17 2017, 12:31 AM · Zero

Jun 15 2017

Dispenser added a project to T167400: Disable serving unpatrolled new files to Wikipedia Zero users: Traffic.

The ongoing abuse has costs: in disk space 1 TB wasted so far, for administrators blocking dozens of accounts and deleting a hundred files each day.

Jun 15 2017, 4:44 AM · Reading-Infrastructure-Team-Backlog (Kanban), Patch-For-Review, User-Tgr, Traffic, Operations, media-storage, Commons, Multimedia, Zero