Page MenuHomePhabricator

SQL
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

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

Recent Activity

Wed, Nov 25

SQL awarded T268701: Ability to thank blocks a Stroopwafel token.
Wed, Nov 25, 1:18 AM · Patch-For-Review, Growth-Team, Thanks, MediaWiki-Blocks

Oct 18 2020

SQL added a comment to T265810: 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 · 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

SQL added a comment to T255161: 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

SQL added a comment to T251602: Draft: Build a prototype for the IP info feature.

Just FYI, a cursory glance at the documentation indicates 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
SQL added a comment to T248525: 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

SQL added a comment to T248525: 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 is ipcheck on ToolForge which 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)
SQL added a comment to T248525: 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

SQL renamed T250625: tools.wmflabs.org to Toolforge.org redirect query / post string propagation from Toolforge.org redirect query / post string propagation to tools.wmflabs.org to Toolforge.org redirect query / post string propagation.
Apr 19 2020, 7:47 PM · cloud-services-team (Kanban), Toolforge
SQL renamed T250625: tools.wmflabs.org to Toolforge.org redirect query / post string propagation from Toolforge.org query / post string propagation to Toolforge.org redirect query / post string propagation.
Apr 19 2020, 7:46 PM · cloud-services-team (Kanban), Toolforge
SQL created T250625: 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

SQL added a comment to T248525: 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

SQL added a comment to T248525: 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

SQL closed T247352: Can't resolve local database hostnames inside containers running on the Toolforge 2020 Kubernetes cluster as Resolved.

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

Mar 10 2020, 10:14 PM · Toolforge, Data-Services, cloud-services-team (Kanban)
SQL added a comment to T247352: 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)
SQL updated the task description for T247352: 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)
SQL created T247352: 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

SQL merged task T242633: Partial blocks prevent blocking into T208965: Partially blocked admins should be able to access Special:Block.
Jan 13 2020, 4:59 PM · MediaWiki-User-management
SQL merged T242633: Partial blocks prevent blocking into T208965: 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)
SQL added a comment to T242633: 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
SQL added a project to T242633: Partial blocks prevent blocking: MediaWiki-User-management.
Jan 13 2020, 4:32 PM · MediaWiki-User-management
SQL updated subscribers of T242633: Partial blocks prevent blocking.
Jan 13 2020, 4:32 PM · MediaWiki-User-management
SQL created T242633: Partial blocks prevent blocking.
Jan 13 2020, 4:30 PM · MediaWiki-User-management

Dec 17 2019

SQL added a comment to T218626: [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 · Patch-For-Review, Epic, MediaWiki-User-management, User-notice, Wikimedia-Site-requests, Anti-Harassment

Dec 12 2019

SQL added a project to T240615: Range block not working on English Wikiquote (other projects?): MediaWiki-User-management.
Dec 12 2019, 8:51 PM · Security, MediaWiki-User-management
SQL added a comment to T240615: 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

SQL added a comment to T236955: 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

SQL added a comment to T236955: 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_WMUK awarded T189362: ipblock-exempt does not allow account creation when blocked a Like token.
Jul 11 2019, 2:04 PM · MediaWiki-Blocks, Platform Team Workboards (Clinic Duty Team), MediaWiki-User-login-and-signup, MediaWiki-Authentication-and-authorization

Jun 30 2019

SQL closed T226918: Disable two factor authentication for Wikimedia account "SQL" as Resolved.

Resolved, thank you for your help.

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

Done, thank you.

Jun 30 2019, 5:38 AM · User-Urbanecm, Trust-and-Safety
SQL added a comment to T226918: 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
SQL created T226918: Disable two factor authentication for Wikimedia account "SQL".
Jun 30 2019, 5:25 AM · User-Urbanecm, Trust-and-Safety

Jun 20 2019

SQL closed T224809: Enwiki beta cluster: Interface Admin rights request as Resolved.

Done.

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

Mar 24 2019

SQL added a comment to T219051: 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

SQL added a comment to T215673: 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
SQL created T215673: action=raw does not work with a period in the page title.
Feb 8 2019, 10:41 PM · MediaWiki-General

Feb 5 2019

SQL closed T215132: Requesting bot rights on enwiki beta as Resolved.

Erm, meant to resolve.

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

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

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

Nov 30 2018

SQL added a comment to T150826: Remove unblockself right on wikimedia wikis (but allow blocked admins to block their blocker).
In T150826#4784223, @Ankit-Maity wrote:
In T150826#4778848, @Adotchar wrote:

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 · MW-1.33-notes (1.33.0-wmf.8; 2018-12-11), MediaWiki-User-management, User-notice, Community-consensus-needed, Wikimedia-Site-requests

Oct 25 2018

SQL added a comment to T207609: 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

SQL added a comment to T207609: 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
SQL created T207609: Rangeblocks applying to IP's not in the range.
Oct 21 2018, 7:16 PM · MediaWiki-User-management

Mar 18 2018

SQL updated the task description for T189362: ipblock-exempt does not allow account creation when blocked.
Mar 18 2018, 3:49 PM · MediaWiki-Blocks, Platform Team Workboards (Clinic Duty Team), MediaWiki-User-login-and-signup, MediaWiki-Authentication-and-authorization

Mar 10 2018

SQL added a project to T189362: ipblock-exempt does not allow account creation when blocked: MediaWiki-User-management.
Mar 10 2018, 5:00 AM · MediaWiki-Blocks, Platform Team Workboards (Clinic Duty Team), MediaWiki-User-login-and-signup, MediaWiki-Authentication-and-authorization
SQL updated the task description for T189362: ipblock-exempt does not allow account creation when blocked.
Mar 10 2018, 4:44 AM · MediaWiki-Blocks, Platform Team Workboards (Clinic Duty Team), MediaWiki-User-login-and-signup, MediaWiki-Authentication-and-authorization
SQL created T189362: ipblock-exempt does not allow account creation when blocked.
Mar 10 2018, 4:37 AM · MediaWiki-Blocks, Platform Team Workboards (Clinic Duty Team), MediaWiki-User-login-and-signup, MediaWiki-Authentication-and-authorization

Dec 21 2017

SQL added a comment to T181873: 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

SQL added a comment to T181873: 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

SQL added a comment to T181873: 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
SQL created T181873: 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