bd808 (Bryan Davis)Administrator
Engineering Manager, Wikimedia Cloud Services

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

User Since
Oct 3 2014, 2:36 PM (185 w, 9 h)
Roles
Administrator
Availability
Available
IRC Nick
bd808
LDAP User
BryanDavis
MediaWiki User
BDavis (WMF)

I'm BDavis (WMF) on wiki, bd808 on irc, and BryanDavis on Gerrit and Wikitech.

I've got a thing for ๐Ÿฆ„s. Don't judge.

I work for or provide services to the Wikimedia Foundation, but this is my only Phabricator account. Edits, statements, or other contributions made from this account are my own, and may not reflect the views of the Foundation.

Recent Activity

Yesterday

bd808 added a comment to T185606: wikistream.wmflabs.org 502 Varnish Error.

@edsu Looking back at your comment in T185606#3925395, I think what you did was to edit the Varnish package provided systemd unit file. This will be overwritten when the package is upgraded. There are a couple of ways to create a proper override that will not be changed by the package. The easy one is to run sudo systemctl edit --full varnish, make the changes you want, and save this file. This will create a file at /etc/systemd/system/varnish for you and reload the units from disk. You can read a bit more about this technique at https://wiki.archlinux.org/index.php/systemd#Editing_provided_units

Fri, Apr 20, 10:01 PM ยท Cloud-VPS
bd808 added a comment to T185606: wikistream.wmflabs.org 502 Varnish Error.

The easiest fix for this would be to make sure that port 6081 is open for a security group applied to the host and then change the domain proxy to point to http://ws-web.wikistream.eqiad.wmflabs:6081 instead of http://ws-web.wikistream.eqiad.wmflabs:80. There is no direct way to edit an existing domain proxy, so you actually accomplish this by deleting the existing proxy and then creating a new proxy using the same name which points to the new host & port.

Your other option would be create a systemd override that applies your custom port 80 binding, but since you are already behind the domain proxy this seems like unnecessary work.

Fri, Apr 20, 1:25 PM ยท Cloud-VPS
bd808 moved T184375: Prepare and check storage layer for inhwiki from Inbox to On-call on the cloud-services-team (Kanban) board.
Fri, Apr 20, 1:22 PM ยท cloud-services-team (Kanban), Cloud-Services, User-Urbanecm, DBA
bd808 moved T187774: Prepare and check storage layer for romdwikimedia from Inbox to On-call on the cloud-services-team (Kanban) board.
Fri, Apr 20, 1:22 PM ยท cloud-services-team (Kanban), User-Urbanecm, Cloud-Services, DBA
bd808 moved T188490: Prepare and check storage layer for hiwikimedia from Inbox to On-call on the cloud-services-team (Kanban) board.
Fri, Apr 20, 1:22 PM ยท cloud-services-team (Kanban), Cloud-Services, DBA, Hindi-Sites, User-Jayprakash12345
bd808 moved T189112: Prepare and check storage layer for gorwiki from Inbox to On-call on the cloud-services-team (Kanban) board.
Fri, Apr 20, 1:22 PM ยท cloud-services-team (Kanban), User-Urbanecm, Cloud-Services, DBA
bd808 added a comment to T189112: Prepare and check storage layer for gorwiki.

Ready for the steps described at https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services

Fri, Apr 20, 1:22 PM ยท cloud-services-team (Kanban), User-Urbanecm, Cloud-Services, DBA
bd808 moved T189466: Prepare storage layer for euwikisource from Inbox to On-call on the cloud-services-team (Kanban) board.
Fri, Apr 20, 1:21 PM ยท cloud-services-team (Kanban), Cloud-Services, DBA
bd808 edited projects for T188490: Prepare and check storage layer for hiwikimedia, added: cloud-services-team (Kanban); removed cloud-services-team.

Ready for the steps described at https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services

Fri, Apr 20, 1:21 PM ยท cloud-services-team (Kanban), Cloud-Services, DBA, Hindi-Sites, User-Jayprakash12345

Thu, Apr 19

bd808 moved T183566: Prepare storage layer for lfnwiki from Inbox to On-call on the cloud-services-team (Kanban) board.
Thu, Apr 19, 8:28 PM ยท cloud-services-team (Kanban), User-Urbanecm, Cloud-Services, DBA
bd808 edited projects for T183566: Prepare storage layer for lfnwiki, added: cloud-services-team (Kanban); removed cloud-services-team.

Ready for the steps described at https://wikitech.wikimedia.org/wiki/Add_a_wiki#Cloud_Services

Thu, Apr 19, 8:28 PM ยท cloud-services-team (Kanban), User-Urbanecm, Cloud-Services, DBA
bd808 added a project to T192577: tools.wmflabs.org/versions shows incorrect data for group1: Tools.

The version tool apparently just checks the first alphasorted wiki in each group (sensible, where else would you stop?).

Thu, Apr 19, 8:20 PM ยท Tools, Release-Engineering-Team (Watching / External)

Wed, Apr 18

bd808 created T192487: Update for Django 1.11.
Wed, Apr 18, 7:22 PM ยท Striker
bd808 added a comment to T185574: toolsadmin removed rush from admin tool and can't find the user.

Here's a very manual hack to fix @chasemp's rights:

T185574-fix-rush-admin.ldif
dn: cn=tools.admin,ou=servicegroups,dc=wikimedia,dc=org
changetype: modify
add: member
member: uid=rush,ou=people,dc=wikimedia,dc=org
$ ldapmodify -v -D 'uid=novaadmin,ou=people,dc=wikimedia,dc=org' -W -f T185574-fix-rush-admin.ldif
ldap_initialize( <DEFAULT> )
Enter LDAP Password:
add member:
        uid=rush,ou=people,dc=wikimedia,dc=org
modifying entry "cn=tools.admin,ou=servicegroups,dc=wikimedia,dc=org"
modify complete

After doing this, I purged the cache in Striker again:

$ ssh labweb1001.wikimedia.org
$ sudo -u www-data venv/bin/python deploy/striker/manage.py shell
Python 3.5.3 (default, Jan 19 2017, 14:11:04)
[GCC 6.3.0 20170118] on linux
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> from striker.tools.models import Maintainer
>>> from striker.tools import cache
>>> cache.purge_openstack_users()
>>> 'rush' in Maintainer.objects._get_tool_users()
True
Wed, Apr 18, 3:37 PM ยท cloud-services-team (Kanban), Toolforge
bd808 closed T185273: Onboarding Chicocvenancio for Cloud IRC support as Resolved.
Wed, Apr 18, 3:22 PM ยท Patch-For-Review, cloud-services-team
bd808 added a comment to T185574: toolsadmin removed rush from admin tool and can't find the user.

This happened again today. This time multiple rounds of purging did not help. Is this maybe caused by faulty paging of the LDAP query that collects the list of all Toolforge members?

Wed, Apr 18, 3:21 PM ยท cloud-services-team (Kanban), Toolforge
bd808 merged task T192450: Create a new tool page is returning 403 for users who are not logged in into T177407: https://toolsadmin.wikimedia.org/tools/create/ returns 403 rather than redirecting to login.
Wed, Apr 18, 2:51 PM ยท Striker
bd808 merged T192450: Create a new tool page is returning 403 for users who are not logged in into T177407: https://toolsadmin.wikimedia.org/tools/create/ returns 403 rather than redirecting to login.
Wed, Apr 18, 2:51 PM ยท Patch-For-Review, Striker

Tue, Apr 17

bd808 added a comment to T192093: Create Technical Writing Project.

I am interested in any recommendations.

Tue, Apr 17, 8:58 PM ยท Project-Admins
bd808 moved T162654: Record hangout of basic Tool Labs access and use from Backlog to Cloud Services on the Documentation board.
Tue, Apr 17, 7:38 PM ยท Documentation, User-bd808, Toolforge
bd808 moved T174084: Update [[Help:Toolforge/Developing]] docs from Backlog to Cloud Services on the Documentation board.
Tue, Apr 17, 7:38 PM ยท cloud-services-team (Kanban), Documentation, Toolforge, User-bd808
bd808 moved T177632: Document policy on Cloud VPS project scope from Backlog to Cloud Services on the Documentation board.
Tue, Apr 17, 7:37 PM ยท cloud-services-team (Kanban), Documentation, Cloud-VPS
bd808 moved T187659: Document virtualenv creation in Toolforge from Backlog to Cloud Services on the Documentation board.
Tue, Apr 17, 7:35 PM ยท Documentation, Toolforge
bd808 moved T188397: Document node.js in toolforge from Backlog to Cloud Services on the Documentation board.
Tue, Apr 17, 7:35 PM ยท Documentation, Toolforge
bd808 moved T188449: Get wikitech search logs from hadoop for documentation research from Backlog to Cloud Services on the Documentation board.
Tue, Apr 17, 7:35 PM ยท Documentation, cloud-services-team
bd808 moved T191445: Document clear guidelines for what is and is not a good Cloud VPS project from Backlog to Cloud Services on the Documentation board.
Tue, Apr 17, 7:34 PM ยท cloud-services-team (Kanban), Documentation, Cloud-VPS
bd808 moved T190895: Request increased quota for toolsbeta from Inbox to Approved on the Cloud-VPS (Quota-requests) board.
Tue, Apr 17, 3:34 PM ยท Cloud-VPS (Quota-requests)
bd808 updated the task description for T189542: Update updatequerypages::cronjob and refreshlinks::cronjob now that silver no longer has a database.
Tue, Apr 17, 3:02 PM ยท Patch-For-Review, cloud-services-team (Kanban), wikitech.wikimedia.org
bd808 moved T187954: Cloud VPS upgrade to Openstack Mitaka release from Backlog to Q4 on the cloud-services-team (FY2017-18) board.
Tue, Apr 17, 2:48 PM ยท cloud-services-team (FY2017-18), Patch-For-Review, Cloud-VPS
bd808 added a project to T187954: Cloud VPS upgrade to Openstack Mitaka release: cloud-services-team (FY2017-18).
Tue, Apr 17, 2:48 PM ยท cloud-services-team (FY2017-18), Patch-For-Review, Cloud-VPS
bd808 closed T192192: 502 error for https://tools.wmflabs.org/enwp10 as Resolved.

@Kelson yes, I restarted the webservice and that seems to have fixed some issue with the connect between it and the front end proxy server. Restarting the service requires doing something like this:

Tue, Apr 17, 4:58 AM ยท Tools

Mon, Apr 16

bd808 added a comment to T192192: 502 error for https://tools.wmflabs.org/enwp10.

I think the Web server accessing this is not run by us as I do not see any configuration for that (I have no nginx installed and apache2 is installed but seems not to be configured). Could someone confirm?

Mon, Apr 16, 5:49 PM ยท Tools
bd808 renamed T192192: 502 error for https://tools.wmflabs.org/enwp10 from 502 error for a tools.wmflabs.org service to 502 error for https://tools.wmflabs.org/enwp10.
Mon, Apr 16, 5:34 PM ยท Tools
bd808 closed T191727: Add mr_IN locale to toolsforge as Resolved.
Mon, Apr 16, 5:26 PM ยท cloud-services-team (Kanban), Patch-For-Review, Toolforge
bd808 closed T191727: Add mr_IN locale to toolsforge, a subtask of T60500: Add more locales to tool labs, as Resolved.
Mon, Apr 16, 5:26 PM ยท Toolforge
bd808 added a project to T192098: Add tmpreaper to all tools execute nodes, if appropriate: Toolforge.
Mon, Apr 16, 5:24 PM ยท Toolforge, cloud-services-team
bd808 added a project to T192156: Review encoding of all OpenStack databases: Cloud-VPS.
Mon, Apr 16, 5:24 PM ยท Cloud-VPS, cloud-services-team
bd808 added a comment to T192156: Review encoding of all OpenStack databases.

utfmb4 is probably the more appropriate encoding for anything that needs to store non-ascii characters in MySQL/MariaDB. This encoding leads to needing other changes however to support indexing more than 767 bytes. See http://bd808.com/blog/2017/04/17/making-django-migrations-that-work-with-mysql-55-and-utf8mb4/ for some related ramblings.

Mon, Apr 16, 5:24 PM ยท Cloud-VPS, cloud-services-team
bd808 added a project to T192182: Horizon instance list: Sorting should work regardless of paging: Upstream.
Mon, Apr 16, 5:19 PM ยท Upstream, Horizon
bd808 renamed T192183: Horizon only saves user user settings in browser cookies from Horizon doesn't save user user settings to Horizon only saves user user settings in browser cookies.
Mon, Apr 16, 5:19 PM ยท Upstream, Horizon
bd808 added a project to T192183: Horizon only saves user user settings in browser cookies: Upstream.
Mon, Apr 16, 5:18 PM ยท Upstream, Horizon
bd808 added a comment to T192244: Provide a consistent way to identify operation in toolforge (including k8s).

One solution, although its a bit indirect, is checking for /etc/novaobserver.yaml. That's not a really obvious solution, but it is on par with /etc/wmcs-instancename and actually mounted into the containers that webservice manages with the current configuration.

Mon, Apr 16, 5:17 PM ยท Toolforge
bd808 added a comment to T192225: Add option to hide unwanted tool accounts from Striker UI.

@Harej I don't think we need a dummy account, just remove yourself from the maintainers list.

Mon, Apr 16, 5:09 PM ยท Striker
bd808 added a project to T192302: Tooforge membership requests approved, but LDAP not updated: cloud-services-team (Kanban).
Mon, Apr 16, 5:02 PM ยท cloud-services-team (Kanban), Toolforge
bd808 closed T192302: Tooforge membership requests approved, but LDAP not updated as Resolved.

Fixed with T192304: keystone hooks not being loaded in mitaka config.

Mon, Apr 16, 5:02 PM ยท cloud-services-team (Kanban), Toolforge
bd808 removed a project from T182142: Diffusion repository creation fails via toolsadmin: Patch-For-Review.
Mon, Apr 16, 4:58 PM ยท Diffusion, Striker
bd808 reassigned T192302: Tooforge membership requests approved, but LDAP not updated from bd808 to Andrew.
Mon, Apr 16, 4:51 PM ยท cloud-services-team (Kanban), Toolforge
bd808 updated subscribers of T192302: Tooforge membership requests approved, but LDAP not updated.

After the manual LDAP fix, @IagoQnsi reports on irc that they can ssh to tools-login and see the tool creation interface. The account for @tdombos should be fixed now too. They will need to log out of https://toolsadmin.wikimedia.org/ and log back in for their new group status to be seen there (see T144943: Groups and tools only refreshed at login).

Mon, Apr 16, 4:46 PM ยท cloud-services-team (Kanban), Toolforge
bd808 added a project to T192304: keystone hooks not being loaded in mitaka config: Cloud-VPS.

Seems to be a likely root cause for T192302: Tooforge membership requests approved, but LDAP not updated.

Mon, Apr 16, 4:45 PM ยท Patch-For-Review, Cloud-VPS, cloud-services-team (Kanban)
bd808 added a comment to T192302: Tooforge membership requests approved, but LDAP not updated.

I have manually applied this LDIF to fix the two normal users who were initially effected by the bug:

dn: cn=project-tools,ou=groups,dc=wikimedia,dc=org
changetype: modify
add: member
member: uid=tdombos,ou=people,dc=wikimedia,dc=org
Mon, Apr 16, 4:39 PM ยท cloud-services-team (Kanban), Toolforge
bd808 added a comment to T192302: Tooforge membership requests approved, but LDAP not updated.

Keystone is being updated:

$ openstack role assignment list  --user T192302
+----------------------------------+---------+-------+---------+--------+-----------+
| Role                             | User    | Group | Project | Domain | Inherited |
+----------------------------------+---------+-------+---------+--------+-----------+
| f473273fac7146b3bdbf22e5d4504f95 | t192302 |       | tools   |        | False     |
+----------------------------------+---------+-------+---------+--------+-----------+
$ openstack role assignment list  --user tdombos
+----------------------------------+---------+-------+---------+--------+-----------+
| Role                             | User    | Group | Project | Domain | Inherited |
+----------------------------------+---------+-------+---------+--------+-----------+
| f473273fac7146b3bdbf22e5d4504f95 | tdombos |       | tools   |        | False     |
+----------------------------------+---------+-------+---------+--------+-----------+
$ openstack role assignment list  --user iagoqnsi
+----------------------------------+----------+-------+---------+--------+-----------+
| Role                             | User     | Group | Project | Domain | Inherited |
+----------------------------------+----------+-------+---------+--------+-----------+
| f473273fac7146b3bdbf22e5d4504f95 | iagoqnsi |       | tools   |        | False     |
+----------------------------------+----------+-------+---------+--------+-----------+
Mon, Apr 16, 4:30 PM ยท cloud-services-team (Kanban), Toolforge
bd808 added a comment to T192302: Tooforge membership requests approved, but LDAP not updated.

When approving a new account, the Wikitech talk page post is being made, but LDAP is not being updated

Mon, Apr 16, 4:23 PM ยท cloud-services-team (Kanban), Toolforge
bd808 created T192302: Tooforge membership requests approved, but LDAP not updated.
Mon, Apr 16, 4:09 PM ยท cloud-services-team (Kanban), Toolforge
bd808 renamed T174444: Convert to SPDX v3 license identifiers & add GPL*-or-later license variants from Add GPL+ license variants to Convert to SPDX v3 license identifiers & add GPL*-or-later license variants.
Mon, Apr 16, 3:37 AM ยท Software-Licensing, Striker

Fri, Apr 13

bd808 created P6990 (An Untitled Masterwork).
Fri, Apr 13, 9:54 PM
bd808 committed R2073:b71a890094fb: flake8 fixes (authored by bd808).
flake8 fixes
Fri, Apr 13, 9:51 PM
bd808 committed R2073:78f0557ddc68: Run tox with any python3 that is available locally (authored by bd808).
Run tox with any python3 that is available locally
Fri, Apr 13, 9:51 PM
bd808 committed R2073:4524dc9191c9: Add ability to flush all caches (authored by bd808).
Add ability to flush all caches
Fri, Apr 13, 9:51 PM
bd808 added a comment to T192093: Create Technical Writing Project.

@srodlund I think @Aklapper has some valid points here, but I can also see the benefit to a consolidated workboard for a group that is trying to selectively attack these problems.

Fri, Apr 13, 4:32 PM ยท Project-Admins

Thu, Apr 12

bd808 created T192119: eqiad: (2) systems for labvirt expansion (labvirt1023 & labvirt1024).
Thu, Apr 12, 11:10 PM ยท hardware-requests, Operations
bd808 edited projects for T192059: CloudVPS: VMs created with non-allowed characters in the hostname fail to be autosigned by puppet, added: Horizon; removed Cloud-VPS.

Return a clear error in horizon when someone tries to create an instance with an invalid hostname

Thu, Apr 12, 2:40 PM ยท Horizon, cloud-services-team

Tue, Apr 10

bd808 added a comment to T190895: Request increased quota for toolsbeta.

+1 and approved in team meeting

Tue, Apr 10, 3:56 PM ยท Cloud-VPS (Quota-requests)

Mon, Apr 9

bd808 moved T190543: Update UI to use term "Wikimedia developer account" from Inbox to Doing on the cloud-services-team (Kanban) board.
Mon, Apr 9, 10:17 PM ยท cloud-services-team (Kanban), Patch-For-Review, Striker
bd808 moved T191727: Add mr_IN locale to toolsforge from Inbox to On-call on the cloud-services-team (Kanban) board.
Mon, Apr 9, 10:17 PM ยท cloud-services-team (Kanban), Patch-For-Review, Toolforge
bd808 claimed T191727: Add mr_IN locale to toolsforge.
Mon, Apr 9, 10:16 PM ยท cloud-services-team (Kanban), Patch-For-Review, Toolforge
bd808 edited projects for T184259: labspuppetmaster1001: have consistency in owner of git repos, added: cloud-services-team (Kanban); removed cloud-services-team.
Mon, Apr 9, 9:28 PM ยท cloud-services-team (Kanban), Patch-For-Review
bd808 added a project to T181523: labtest puppetmaster is not working for clients: cloud-services-team (Kanban).
Mon, Apr 9, 9:27 PM ยท cloud-services-team (Kanban), Cloud-VPS, Epic
bd808 edited projects for T184261: labspuppetmaster1001: alert if git sync fails, added: cloud-services-team (Kanban); removed cloud-services-team.
Mon, Apr 9, 9:27 PM ยท cloud-services-team (Kanban)
bd808 added a project to T188681: Maintain-dbusers should handle failures due to replicas being in maintenance: cloud-services-team (Kanban).
Mon, Apr 9, 9:26 PM ยท cloud-services-team (Kanban), Data-Services
bd808 edited projects for T190512: labmon: syncronize whisper files between labmon1001 and labmon1002, added: cloud-services-team (Kanban); removed cloud-services-team.
Mon, Apr 9, 9:26 PM ยท cloud-services-team (Kanban), Patch-For-Review, Cloud-VPS
bd808 added a project to T191790: Figure out how to migrate an instance from a nova-network region to a neutron region: cloud-services-team (Kanban).
Mon, Apr 9, 9:26 PM ยท cloud-services-team (Kanban), Cloud-Services
bd808 added a project to T191791: Make same glance images available to multiple regions: cloud-services-team (Kanban).
Mon, Apr 9, 9:26 PM ยท cloud-services-team (Kanban), Cloud-Services
bd808 edited projects for T189871: labmon1002 as cold standby for labmon1001, added: cloud-services-team (Kanban); removed cloud-services-team.
Mon, Apr 9, 9:26 PM ยท cloud-services-team (Kanban), Patch-For-Review, Cloud-VPS
bd808 edited projects for T183937: rack/setup/install labvirt102[12], added: cloud-services-team (Kanban); removed cloud-services-team.
Mon, Apr 9, 9:25 PM ยท cloud-services-team (Kanban), Operations
bd808 added a project to T184872: LDAP data not correctly provisioned when building new Striker VM with Vagrant: cloud-services-team (Kanban).
Mon, Apr 9, 9:25 PM ยท cloud-services-team (Kanban), MediaWiki-Vagrant, Striker
bd808 edited projects for T191814: labtest: instance creation via horizon, added: cloud-services-team (Kanban); removed cloud-services-team.
Mon, Apr 9, 9:25 PM ยท cloud-services-team (Kanban)
bd808 moved T190788: Request increased quota for rcm Cloud VPS project (merge two projects) from Inbox to Discussion needed on the Cloud-VPS (Quota-requests) board.
Mon, Apr 9, 9:15 PM ยท Cloud-VPS (Quota-requests)
bd808 added a comment to T190788: Request increased quota for rcm Cloud VPS project (merge two projects).

@Luke081515 can you explain a bit more about the rcm and codereview projects and how merging their instances into a single project makes sense? I see that these are both projects with you as a sole maintainer. Rcm is advertised as a project that "Looks up the recent changes of a wiki, and does other analysis, like analysis of user contributions." Codereview's description says it "Allows you to test gerrit patches at a wiki cluster for a quick and save review."

Mon, Apr 9, 9:15 PM ยท Cloud-VPS (Quota-requests)
bd808 added a comment to T187373: Rebuild raids on labvirt1019 and 1020.

Discussed briefly in the 2018-04-09 SRE team meeting. @RobH mentioned that he would look into getting a quote from HP on a RAID card that can support all 10 drives.

Mon, Apr 9, 8:47 PM ยท cloud-services-team (Kanban), Operations, Cloud-Services
bd808 added a comment to T191828: Jouncebot can die without people knowing from appearantly unauthorized die command.

Removed by https://gerrit.wikimedia.org/r/#/c/425120/

Mon, Apr 9, 8:03 PM ยท Jouncebot, Security
bd808 closed T191828: Jouncebot can die without people knowing from appearantly unauthorized die command as Resolved.
Mon, Apr 9, 8:02 PM ยท Jouncebot, Security
bd808 claimed T191828: Jouncebot can die without people knowing from appearantly unauthorized die command.
Mon, Apr 9, 8:02 PM ยท Jouncebot, Security
bd808 added a comment to T191828: Jouncebot can die without people knowing from appearantly unauthorized die command.

I think we can just rip this "feature" out of the codebase. I thought it was guarded by a debug mode flag, but may it is not (or maybe the main deployment is in debug mode).

Mon, Apr 9, 7:48 PM ยท Jouncebot, Security
bd808 reassigned T191380: Drop unused views for: localisation and localisation_file_hash from bd808 to Bstorm.

Assigning to @Bstorm so she can run the maintain-views --clean step that is needed while each server is depooled.

Mon, Apr 9, 7:29 PM ยท cloud-services-team (Kanban), Patch-For-Review, Data-Services
zhuyifei1999 awarded Blog Post: Cloud Services team Q3 FY17/18 highlights a Love token.
Mon, Apr 9, 7:23 PM ยท Cloud-Services, cloud-services-team
mmodell awarded Blog Post: Cloud Services team Q3 FY17/18 highlights a Love token.
Mon, Apr 9, 8:24 AM ยท Cloud-Services, cloud-services-team
bd808 published Blog Post: Cloud Services team Q3 FY17/18 highlights.
Mon, Apr 9, 3:44 AM ยท Cloud-Services, cloud-services-team

Fri, Apr 6

bd808 closed T191387: Drop unused views for: flaggedrevs tables from mediawikiwiki_p as Resolved.
Fri, Apr 6, 7:13 PM ยท cloud-services-team (Kanban), Patch-For-Review, Data-Services
bd808 added a comment to T191387: Drop unused views for: flaggedrevs tables from mediawikiwiki_p.
$ sudo maintain-views --database mediawikiwiki --clean --replace-all
2018-04-06 19:10:54,811 INFO Full views for mediawikiwiki:
...
2018-04-06 19:10:56,374 INFO cleanup is enabled
2018-04-06 19:10:56,375 INFO cleaning 9 tables
2018-04-06 19:10:56,376 INFO Dropping view flaggedrevs_tracking
2018-04-06 19:10:56,377 INFO Dropping view mark_as_helpful
2018-04-06 19:10:56,379 INFO Dropping view flaggedrevs_statistics
2018-04-06 19:10:56,382 INFO Dropping view flaggedrevs_promote
2018-04-06 19:10:56,384 INFO Dropping view flaggedrevs_stats
2018-04-06 19:10:56,386 INFO Dropping view flaggedrevs_stats2
2018-04-06 19:10:56,388 INFO Dropping view updates
2018-04-06 19:10:56,390 INFO Dropping view wikilove_image_log
2018-04-06 19:10:56,392 INFO Dropping view flaggedrevs
Fri, Apr 6, 7:13 PM ยท cloud-services-team (Kanban), Patch-For-Review, Data-Services
bd808 added a comment to T191648: uwsgi::app sorts config keys, but the .ini file behavior depends on order.

I wonder if the specific ordering issue is the callable and plugins lines?

Fri, Apr 6, 6:02 PM ยท Patch-For-Review, Operations, Puppet
bd808 moved T191488: Deploy Telegram Translation bot to a tool forge server, and make it available for testing from Backlog to Project on the Wikimedia-Hackathon-2018 board.
Fri, Apr 6, 2:43 AM ยท Wikimedia-Hackathon-2018, Wikimedia-Israel-Hackers, translatewiki.net
bd808 added a project to T187319: Documentation sprint @Hackathon 2018: Documentation.
Fri, Apr 6, 2:39 AM ยท Documentation, Wikimedia-Hackathon-2018
bd808 awarded T191025: Structured Data on Wikimedia Commons track a Goat token.
Fri, Apr 6, 2:33 AM ยท Wikidata, Structured-Data-Commons, Wikimedia-Hackathon-2018
bd808 added a comment to T165795: Ldap auth extension vs. ldap vs. username Case.

This might be horrible in practice, but it looks like in theory we could change the lookup attribute to cn:caseExactMatch: instead of cn and the LDAP server would enforce a case-sensitive search:

$ ldap cn=bryandavis cn
dn: uid=bd808,ou=people,dc=wikimedia,dc=org
cn: BryanDavis
$ ldap cn=BryanDavis cn
dn: uid=bd808,ou=people,dc=wikimedia,dc=org
cn: BryanDavis
$ ldap cn:caseExactMatch:=bryandavis cn
$ ldap cn:caseExactMatch:=BryanDavis cn
dn: uid=bd808,ou=people,dc=wikimedia,dc=org
cn: BryanDavis
Fri, Apr 6, 12:09 AM ยท Cloud-Services, MediaWiki-Authentication-and-authorization, wikitech.wikimedia.org, MediaWiki-extensions-LdapAuthentication

Thu, Apr 5

bd808 closed T143939: Request creation of labs-vpn labs project, a subtask of T76375: [DO NOT USE] New Labs project requests (tracking) [superseded by #cloud-vps-project-requests], as Declined.
Thu, Apr 5, 5:02 PM ยท User-bd808, Tracking, Cloud-Services
bd808 closed T143939: Request creation of labs-vpn labs project as Declined.

Closing as declined not because this is a bad idea, but because there has been no discussion or status change in a very long time. This can and should be reopened when there is a more concrete plan about how to move the idea forward.

Thu, Apr 5, 5:02 PM ยท Cloud-VPS (Project-requests)
bd808 moved T190952: Delete VPS project 'editor-engagement' on or after 2018-04-15 from Inbox to Discussion needed on the Cloud-VPS (Project-requests) board.
Thu, Apr 5, 4:59 PM ยท Cloud-VPS (Project-requests), Collaboration-Team-Triage, cloud-services-team (Kanban)
bd808 added a project to T190952: Delete VPS project 'editor-engagement' on or after 2018-04-15: Cloud-VPS (Project-requests).
Thu, Apr 5, 4:59 PM ยท Cloud-VPS (Project-requests), Collaboration-Team-Triage, cloud-services-team (Kanban)
bd808 updated the task description for T191445: Document clear guidelines for what is and is not a good Cloud VPS project.
Thu, Apr 5, 2:42 PM ยท cloud-services-team (Kanban), Documentation, Cloud-VPS
bd808 assigned T190470: Add a new user to labsdb servers for maintain-indexes to Bstorm.
Thu, Apr 5, 12:03 AM ยท Data-Services, cloud-services-team (Kanban)