Page MenuHomePhabricator

SQL
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

User Since
Jan 30 2016, 5:25 AM (442 w, 2 h)
Availability
Available
IRC Nick
SQL
LDAP User
SQL
MediaWiki User
SQL[Global Accounts]

Recent Activity

Dec 4 2023

SQLclosedT319820: Migrate isprangefinder from Toolforge GridEngine to Toolforge KubernetesasResolved.
Dec 4 2023, 11:41 PM·Grid-Engine-to-K8s-Migration
SQLclosedT319814: Migrate ipcheck from Toolforge GridEngine to Toolforge KubernetesasResolved.

The offending crontab entries have been disabled.

Dec 4 2023, 11:39 PM·Grid-Engine-to-K8s-Migration
SQLadded a comment toT319820: Migrate isprangefinder from Toolforge GridEngine to Toolforge Kubernetes.

Sorry - missed your email, and with the holidays this has slipped my mind. The offending crontab entry has been commented out.

Dec 4 2023, 11:36 PM·Grid-Engine-to-K8s-Migration

Oct 9 2022

SQLadded a comment toT319814: Migrate ipcheck from Toolforge GridEngine to Toolforge Kubernetes.

It's very spammy, and disruptive.

Oct 9 2022, 6:06 PM·Grid-Engine-to-K8s-Migration
SQLchanged the status ofT319814: Migrate ipcheck from Toolforge GridEngine to Toolforge KubernetesfromOpentoIn Progress.

This is due to two cron jobs. I'm not somewhere right now that I can update the simple jsub command to the more complicated new command. I will try to get to this in the next week.

Oct 9 2022, 4:14 PM·Grid-Engine-to-K8s-Migration
SQLchanged the status ofT319820: Migrate isprangefinder from Toolforge GridEngine to Toolforge KubernetesfromOpentoIn Progress.

This is due to a single cron job. I'm not somewhere right now that I can update the simple jsub command to the more complicated new command. I will try to get to this in the next week.

Oct 9 2022, 4:14 PM·Grid-Engine-to-K8s-Migration
SQLclosedT319606: Migrate botwatch from Toolforge GridEngine to Toolforge KubernetesasResolved.
Oct 9 2022, 4:08 PM·Grid-Engine-to-K8s-Migration
SQLadded a comment toT319606: Migrate botwatch from Toolforge GridEngine to Toolforge Kubernetes.

Tool has been shut down.

Oct 9 2022, 4:08 PM·Grid-Engine-to-K8s-Migration
SQLclosedT319489: Migrate aivanalysis from Toolforge GridEngine to Toolforge KubernetesasResolved.
Oct 9 2022, 4:08 PM·Grid-Engine-to-K8s-Migration
SQLadded a comment toT319489: Migrate aivanalysis from Toolforge GridEngine to Toolforge Kubernetes.

Tool has been shut down.

Oct 9 2022, 4:07 PM·Grid-Engine-to-K8s-Migration
SQLadded a comment toT319820: Migrate isprangefinder from Toolforge GridEngine to Toolforge Kubernetes.

Why send a task for every last tool, instead of sending one task per user? I'm up to 8 emails already because of this.

Oct 9 2022, 4:06 PM·Grid-Engine-to-K8s-Migration
SQLadded a comment toT319606: Migrate botwatch from Toolforge GridEngine to Toolforge Kubernetes.

Why send a task for every last tool, instead of sending one task per user? I'm up to 8 emails already because of this.

Oct 9 2022, 4:06 PM·Grid-Engine-to-K8s-Migration
SQLadded a comment toT319489: Migrate aivanalysis from Toolforge GridEngine to Toolforge Kubernetes.

Why send a task for every last tool, instead of sending one task per user? I'm up to 8 emails already because of this.

Oct 9 2022, 4:06 PM·Grid-Engine-to-K8s-Migration
SQLadded a comment toT319814: Migrate ipcheck from Toolforge GridEngine to Toolforge Kubernetes.

Why send a task for every last tool, instead of sending one task per user? I'm up to 8 emails already because of this.

Oct 9 2022, 4:06 PM·Grid-Engine-to-K8s-Migration

Apr 24 2022

SQLcreatedT306751: Cookie block exception option for hard IP blocks.
Apr 24 2022, 2:15 AM·MediaWiki-Blocks

May 12 2021

SQLadded a comment toT282624: Limit IA granting/revoking to stewards only.

@jrbsthe problem, as I see it, is that this is being presented as afait accompli- the decision has been made, but if you want to complain, you may submit your concerns, to partially quote Douglas Adams, "in the bottom of a locked filing cabinet stuck in a disused lavatory with a sign on the door saying 'Beware of the Leopard.'" (in all seriousness - I think we all know that there exist no "questions or concerns" someone could raise that would actually change the outcome here). There have been discussions with the steward team, yes but not with the people who previously granted the right. It's too late now, but next time this sort of thing happens, I suggest at least talking to the impacted partiesbeforethe change is submitted for merge rather than blindsiding them such that they find out at the same time as everyone else.

May 12 2021, 12:54 AM·Community-consensus-needed,Tech Ambassadors & Translators,[DEPRECATED] wdwb-tech,Chinese-Sites,Wikidata,Serbian-Sites,Commons,Wiktionary-fr,Stewards-and-global-tools,User-notice,Trust-and-Safety,Wikimedia-Site-requests

Nov 25 2020

SQLawardedT268701: Ability to thank blocksa Stroopwafel token.
Nov 25 2020, 1:18 AM·Growth-Team-Filtering,Growth-Team,Thanks,MediaWiki-Blocks

Oct 18 2020

SQLadded a comment toT265810: mw-ext-FileImporter uses a WMF IP address, does not include XFF for users using this extension (CVE-2020-27621).

Non-ideal at best. This should report the user's address.

Oct 18 2020, 4:48 AM·Vuln-Misconfiguration,MW-1.36-notes (1.36.0-wmf.13; 2020-10-12),WMDE-QWERTY-Sprint-2020-10-07,Unplanned-Sprint-Work,Move-Files-To-Commons,Security,Security-Team

Jun 17 2020

SQLadded a comment toT255161: Poll stewards and admins on spam-fighting efforts.

I appreciate +sub, but I don't think that this is an appropriate place to discuss what's going on with my tools. Please feel free to reach out to me on IRC if you'd like to talk.

Jun 17 2020, 4:06 AM·user-sbassett,Security-Team,Security

May 2 2020

SQLadded a comment toT251602: Draft: Build a prototype for the IP info feature.

Just FYI, a cursory glance at thedocumentationindicates that the free plan does not include the "connection type", and only really exposes data available via whois. Real, usable data begins with the $249/mo "standard" plan.

May 2 2020, 2:16 AM·Anti-Harassment
SQLadded a comment toT248525: Investigate services to fetch underlying information about IP addresses [8 Hours].

@Niharika,I've emailed you directly with the costs and limits - and explained why in the email.

May 2 2020, 2:08 AM·Anti-Harassment (The Letter Song)

Apr 21 2020

SQLadded a comment toT248525: Investigate services to fetch underlying information about IP addresses [8 Hours].

I think most people accessing this information know that it is never 100% accurate. We heard that several times when we pitched these tools. The way they currently deal with this is either by having a single website they trust that they go to or checking multiple websites. One commonly used tool isipcheck on ToolForgewhich coalesces this information from several websites.

Ironically I can't access the tool with my staff account, but I was able to use my personal account. We may need to update the access of the tool to allow(WMF)accounts.

Apr 21 2020, 4:13 AM·Anti-Harassment (The Letter Song)
SQLadded a comment toT248525: Investigate services to fetch underlying information about IP addresses [8 Hours].

Thanks for putting this together. Lots of stuff to consider.

It's looking more and more like we'll be collating data from a few different sources. A question I have about that is whether we want to store the collated data somewhere so that we don't always have to rebuild it. How would that work with caching or when the data needs to change? Is it even a valid concern?

I just worry that hitting 4 APIs and pulling the data together for hundreds of IPs in an investigation could get very expensive.

Apr 21 2020, 4:11 AM·Anti-Harassment (The Letter Song)

Apr 19 2020

SQLrenamedT250625: tools.wmflabs.org to Toolforge.org redirect query / post string propagationfromToolforge.org redirect query / post string propagationtotools.wmflabs.org to Toolforge.org redirect query / post string propagation.
Apr 19 2020, 7:47 PM·cloud-services-team (Kanban),Toolforge
SQLrenamedT250625: tools.wmflabs.org to Toolforge.org redirect query / post string propagationfromToolforge.org query / post string propagationtoToolforge.org redirect query / post string propagation.
Apr 19 2020, 7:46 PM·cloud-services-team (Kanban),Toolforge
SQLcreatedT250625: tools.wmflabs.org to Toolforge.org redirect query / post string propagation.
Apr 19 2020, 7:45 PM·cloud-services-team (Kanban),Toolforge

Apr 16 2020

SQLadded a comment toT248525: Investigate services to fetch underlying information about IP addresses [8 Hours].

Thanks@SQL.This is helpful information.

Apr 16 2020, 2:38 AM·Anti-Harassment (The Letter Song)

Apr 10 2020

SQLadded a comment toT248525: Investigate services to fetch underlying information about IP addresses [8 Hours].

Whether the IP address is known to be a VPN or Tor node

Apr 10 2020, 9:06 PM·Anti-Harassment (The Letter Song)

Mar 10 2020

SQLclosedT247352: Can't resolve local database hostnames inside containers running on the Toolforge 2020 Kubernetes clusterasResolved.

Looks good to me, and StalkToy is back too. Thanks all!

Mar 10 2020, 10:14 PM·Toolforge,Data-Services,cloud-services-team (Kanban)
SQLadded a comment toT247352: Can't resolve local database hostnames inside containers running on the Toolforge 2020 Kubernetes cluster.

I've resolved this for my tool by not using the meta db anymore. We haven't needed the information I was pulling from that db for some time now in any case.

Mar 10 2020, 9:13 PM·Toolforge,Data-Services,cloud-services-team (Kanban)
SQLupdated the task description forT247352: Can't resolve local database hostnames inside containers running on the Toolforge 2020 Kubernetes cluster.
Mar 10 2020, 8:56 PM·Toolforge,Data-Services,cloud-services-team (Kanban)
SQLcreatedT247352: Can't resolve local database hostnames inside containers running on the Toolforge 2020 Kubernetes cluster.
Mar 10 2020, 8:50 PM·Toolforge,Data-Services,cloud-services-team (Kanban)

Jan 13 2020

SQLmerged taskT242633: Partial blocks prevent blockingintoT208965: Partially blocked admins should be able to access Special:Block.
Jan 13 2020, 4:59 PM·MediaWiki-User-management
SQLmergedT242633: Partial blocks prevent blockingintoT208965: Partially blocked admins should be able to access Special:Block.
Jan 13 2020, 4:59 PM·MediaWiki-Blocks,MW-1.35-notes (1.35.0-wmf.27; 2020-04-07)
SQLadded a comment toT242633: Partial blocks prevent blocking.

Self-unblocks seem to work, and Special:Unblock will load, but you get a permission error when attempting to unblock another user.

Jan 13 2020, 4:35 PM·MediaWiki-User-management
SQLadded a project toT242633: Partial blocks prevent blocking:MediaWiki-User-management.
Jan 13 2020, 4:32 PM·MediaWiki-User-management
SQLupdated subscribers ofT242633: Partial blocks prevent blocking.
Jan 13 2020, 4:32 PM·MediaWiki-User-management
SQLcreatedT242633: Partial blocks prevent blocking.
Jan 13 2020, 4:30 PM·MediaWiki-User-management

Dec 17 2019

SQLadded a comment toT218626: [Epic] Partial block rollout.

@Niharika- I noticed in the tech news today, that we should contact you if our wiki should be delayed for deployment. As we're still discussing enabling this feature (RFC is linked above), I think it would be best to hold off on deploying to enwiki.

Dec 17 2019, 12:23 AM·User-notice-archive,Patch-For-Review,Epic,MediaWiki-User-management,Wikimedia-Site-requests,Anti-Harassment

Dec 12 2019

SQLadded a project toT240615: Range block not working on English Wikiquote (other projects?):MediaWiki-User-management.
Dec 12 2019, 8:51 PM·Security,MediaWiki-User-management
SQLadded a comment toT240615: Range block not working on English Wikiquote (other projects?).

Related discussion:https://en.wikipedia.org/wiki/Wikipedia:Village_pump_(technical)#Range_block_not_working%3F

Dec 12 2019, 8:49 PM·Security,MediaWiki-User-management

Nov 4 2019

SQLadded a comment toT236955: Lift IP cap for edit-a-thon at Bard College Nov. 11, 2019.

The student whose screenshots I used, Meledit2089 tried turning her VPN off and filed an unblock appeal, but as of Friday, her account was still blocked.

Thank you again for your help on this.

Nov 4 2019, 8:07 PM·User-Urbanecm,Wikimedia-Site-requests

Nov 2 2019

SQLadded a comment toT236955: Lift IP cap for edit-a-thon at Bard College Nov. 11, 2019.

Hm. It's plausible, albeit strange that the college routes it's outbound traffic via 24SHELLS for some reason. If it gets in the way of the edit-a-thon, and there's no way around it, I'm fine with dropping the block for a week or two - either by me, or any other admin.

Nov 2 2019, 1:04 AM·User-Urbanecm,Wikimedia-Site-requests

Jul 11 2019

Richard_Nevell_WMUKawardedT189362: ipblock-exempt does not allow account creation when blockeda Like token.
Jul 11 2019, 2:04 PM·MediaWiki-Platform-Team (Radar),IP-Blocking-Impacts,Patch-For-Review,MediaWiki-Blocks,MediaWiki-User-login-and-signup,MediaWiki-Core-AuthManager

Jun 30 2019

SQLclosedT226918: Disable two factor authentication for Wikimedia account "SQL"asResolved.

Resolved, thank you for your help.

Jun 30 2019, 7:04 AM·User-Urbanecm,Trust-and-Safety
SQLadded a comment toT226918: Disable two factor authentication for Wikimedia account "SQL".

Done, thank you.

Jun 30 2019, 5:38 AM·User-Urbanecm,Trust-and-Safety
SQLadded a comment toT226918: Disable two factor authentication for Wikimedia account "SQL".

I'm not sure if it helps, but I made an edit referencing this ticket while logged in:https://en.wikipedia.org/w/index.php?title=User_talk:SQL&type=revision&diff=904132284&oldid=904037182&diffmode=source

Jun 30 2019, 5:26 AM·User-Urbanecm,Trust-and-Safety
SQLcreatedT226918: Disable two factor authentication for Wikimedia account "SQL".
Jun 30 2019, 5:25 AM·User-Urbanecm,Trust-and-Safety

Jun 20 2019

SQLclosedT224809: Enwiki beta cluster: Interface Admin rights requestasResolved.

Done.

Jun 20 2019, 8:20 PM·User-DannyS712,Beta-Cluster-Infrastructure

Mar 24 2019

SQLadded a comment toT219051: whois tool: 500 - Internal Server Error.

I've had to restart the webservice on a couple of my tools recently - possibly needs done here too?

Mar 24 2019, 5:08 PM·Tools

Feb 8 2019

SQLadded a comment toT215673: action=raw does not work with a period in the page title.

This works when manually specifying the title via URL, e.g.:https://en.wikipedia.org/wiki?title=User:SQL/Testing.Bug&action=raw

Feb 8 2019, 10:46 PM·MediaWiki-General
SQLcreatedT215673: action=raw does not work with a period in the page title.
Feb 8 2019, 10:41 PM·MediaWiki-General

Feb 5 2019

SQLclosedT215132: Requesting bot rights on enwiki betaasResolved.

Erm, meant to resolve.

Feb 5 2019, 3:34 AM·User-DannyS712,Beta-Cluster-Infrastructure
SQLclaimedT215132: Requesting bot rights on enwiki beta.

I've got this, seehttps://en.wikipedia.org/wiki/User_talk:SQL#Beta_cluster_bot

Feb 5 2019, 3:33 AM·User-DannyS712,Beta-Cluster-Infrastructure

Nov 30 2018

SQLadded a comment toT150826: Remove unblockself right on wikimedia wikis (but allow blocked admins to block their blocker).
InT150826#4784223,@Ankit-Maitywrote:
InT150826#4778848,@Adotcharwrote:

There's discussion on enwiki about also having a rate limit on blocking users. Seems like a reasonable enough idea, but we'd want it high, as we really only want it in cases of truly malicious users.

Please, please, please do not do this globally without a meta RfC or some form of other discussion. (and should require every wiki’s community to be notified, or for it to be handled on a wiki-by-wiki basis)

I am strongly opposed to this, and I’m sure many others are as well who are not watching this ticket.

What is the downside? Why would any admin need to block more than let's say 5-10 admins in one single sitting.

Nov 30 2018, 5:54 AM·User-notice-archive,MW-1.33-notes (1.33.0-wmf.8; 2018-12-11),MediaWiki-User-management,Community-consensus-needed,Wikimedia-Site-requests

Oct 25 2018

SQLadded a comment toT207609: Rangeblocks applying to IP's not in the range.

The latest blocked editor has updated us -https://en.wikipedia.org/w/index.php?title=User_talk:188.118.96.39&type=revision&diff=865600821&oldid=865112519&diffmode=source.It sounds like it was a cookie block.

Oct 25 2018, 12:08 AM·MediaWiki-User-management

Oct 21 2018

SQLadded a comment toT207609: Rangeblocks applying to IP's not in the range.

For it to be XFF, wouldn't the proxy (The IP in the range that shows up as being blocked) need to be in trusted-hosts (https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/TrustedXFF/+/refs/heads/master/trusted-hosts.txt) / trusted-xff (https://noc.wikimedia.org/conf/highlight.php?file=trusted-xff.php/ decoded:https://tools.wmflabs.org/aivanalysis/trusted-xff.txt)?

Oct 21 2018, 8:09 PM·MediaWiki-User-management
SQLcreatedT207609: Rangeblocks applying to IP's not in the range.
Oct 21 2018, 7:16 PM·MediaWiki-User-management

Mar 18 2018

SQLupdated the task description forT189362: ipblock-exempt does not allow account creation when blocked.
Mar 18 2018, 3:49 PM·MediaWiki-Platform-Team (Radar),IP-Blocking-Impacts,Patch-For-Review,MediaWiki-Blocks,MediaWiki-User-login-and-signup,MediaWiki-Core-AuthManager

Mar 10 2018

SQLadded a project toT189362: ipblock-exempt does not allow account creation when blocked:MediaWiki-User-management.
Mar 10 2018, 5:00 AM·MediaWiki-Platform-Team (Radar),IP-Blocking-Impacts,Patch-For-Review,MediaWiki-Blocks,MediaWiki-User-login-and-signup,MediaWiki-Core-AuthManager
SQLupdated the task description forT189362: ipblock-exempt does not allow account creation when blocked.
Mar 10 2018, 4:44 AM·MediaWiki-Platform-Team (Radar),IP-Blocking-Impacts,Patch-For-Review,MediaWiki-Blocks,MediaWiki-User-login-and-signup,MediaWiki-Core-AuthManager
SQLcreatedT189362: ipblock-exempt does not allow account creation when blocked.
Mar 10 2018, 4:37 AM·MediaWiki-Platform-Team (Radar),IP-Blocking-Impacts,Patch-For-Review,MediaWiki-Blocks,MediaWiki-User-login-and-signup,MediaWiki-Core-AuthManager

Dec 21 2017

SQLadded a comment toT181873: Recover "SQL" svn account for use as a modern developer account.

Worked like a charm, thank you!

Dec 21 2017, 9:27 PM·cloud-services-team (Kanban),LDAP,wikitech.wikimedia.org

Dec 19 2017

SQLadded a comment toT181873: Recover "SQL" svn account for use as a modern developer account.

Is there any further information needed on my end for this request? (I hope this isn't a bother!)

Dec 19 2017, 3:57 AM·cloud-services-team (Kanban),LDAP,wikitech.wikimedia.org

Dec 2 2017

SQLadded a comment toT181873: Recover "SQL" svn account for use as a modern developer account.

Relevant details:

Dec 2 2017, 4:46 AM·cloud-services-team (Kanban),LDAP,wikitech.wikimedia.org
SQLcreatedT181873: Recover "SQL" svn account for use as a modern developer account.
Dec 2 2017, 4:35 AM·cloud-services-team (Kanban),LDAP,wikitech.wikimedia.org