Page MenuHomeMiraheze

John (John Lewis)
Engineering Manager, InfrastructureAdministrator

Projects (23)

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

User Since
Apr 17 2016, 19:20 (283 w, 6 d)
Roles
Administrator
Availability
Available
IRC Nickname
JohnLewis
GitHub User
JohnFLewis
Miraheze User
John [ Global Accounts ]

Hi I'm John. I'm the Co-Founder of Miraheze and the Engineering Manager for the Infrastructure team.

Recent Activity

Today

John triaged T8078: No access to images of Wikimedia commons as Normal priority.
Sat, Sep 25, 04:14 · MediaWiki, MediaWiki (SRE)
John added a comment to T8031: php-fpm does not restart cleanly post OOM.

High priority task with no sign of work being done on it. @Reception123 can we get someone assign or this task properly prioritised/closed?

Sat, Sep 25, 04:13 · MediaWiki (SRE), MediaWiki

Thu, Sep 23

John added a comment to T8077: [New] Server Resource Request for ns1.

No objections from me either - would need co-ordination with domain registrar access which I do not have.

Thu, Sep 23, 11:46 · Infrastructure (SRE)
John added a comment to T8076: [New] Server Resource Request for cp15.

Another cp was my originally recommendation, this is approved from me as described.

Thu, Sep 23, 11:45 · Infrastructure (SRE)

Tue, Sep 21

John added a comment to T5877: Revise MariaDB backup strategy.

@Southparkfan Any updates on this task? If there isn't an update provided in a week, I'll reassign the task to ensure it gets completed.

Tue, Sep 21, 20:14 · Goal-2021-Jul-Dec, Infrastructure (SRE), Goal-2021-Jan-Jun, Database, Goal-2020-Jul-Dec

Mon, Sep 20

John edited P386 Resources Table.
Mon, Sep 20, 15:58 · Cloud Infrastructure, Infrastructure (SRE)
John closed T8055: [Existing] Server Resource Request for gluster as Resolved.
Mon, Sep 20, 15:58 · Infrastructure (SRE)

Sun, Sep 19

John updated subscribers of T8055: [Existing] Server Resource Request for gluster.

Needs endorsement from another SRE/@Reception123

Sun, Sep 19, 19:51 · Infrastructure (SRE)

Thu, Sep 16

John closed T8028: Force logging me out and in as Resolved.

https://phabricator.wikimedia.org/T291127 - split clustering should not be happening now.

Thu, Sep 16, 13:36 · MediaWiki (SRE), MediaWiki
John triaged T8040: Repeated forced logouts on All The Tropes as Normal priority.
Thu, Sep 16, 13:35 · MediaWiki (SRE), MediaWiki
John closed T8040: Repeated forced logouts on All The Tropes as Resolved.

https://phabricator.wikimedia.org/T291127 - split clustering should not be happening now.

Thu, Sep 16, 13:35 · MediaWiki (SRE), MediaWiki

Tue, Sep 14

John closed T8014: Extension PDFEmbed shows empty page as Resolved.
Tue, Sep 14, 09:33 · Puppet, MediaWiki (SRE), Universal Omega

Sun, Sep 12

John added a comment to T8024: Prevent large objects from being cached within varnish.

What are example of large objects? Are they infrequently requested? Frequently requested large objects would make more sense to cache than smaller infrequently requested objects

Sun, Sep 12, 20:01 · Varnish, Infrastructure (SRE)
John edited P386 Resources Table.
Sun, Sep 12, 18:13 · Cloud Infrastructure, Infrastructure (SRE)
John closed T8020: [Existing] Server Resource Request for db as Resolved.

Approved.

Sun, Sep 12, 18:13 · Database, Infrastructure (SRE)
John closed T8019: [Existing] Server Resource Request for mail as Declined.

I have cleared up 1.5G and another 1G could be saved by yourself and @Southparkfan deleting unnecessary emails/spam in the inbox. Currently I see no reason to extend the disk space.

Sun, Sep 12, 18:12 · Infrastructure (SRE)
John updated the task description for T8020: [Existing] Server Resource Request for db.
Sun, Sep 12, 17:44 · Database, Infrastructure (SRE)

Sat, Sep 11

John closed T7874: Review Dropbox family of domains as Resolved.
Sat, Sep 11, 10:19 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7902: Review openlayers.org CSP Entry as Resolved.
Sat, Sep 11, 10:19 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7830: CSP Whitelist Additions for Extension:EmbedVideo Support (archive.org and soundcloud.org) as Resolved.
Sat, Sep 11, 10:19 · Trust & Safety, CSP Review, MediaWiki (SRE)
John closed T7906: Review onlinewebfonts CSP Entry as Resolved.
Sat, Sep 11, 10:19 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7699: CSP Whitelist request: cdn.smutstone.com as Resolved.
Sat, Sep 11, 10:19 · Trust & Safety, CSP Review, MediaWiki (SRE)
John closed T7880: Review Imgbox CSP Entry as Resolved.
Sat, Sep 11, 10:19 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7962: CSP review: wiki.hausos.co as Resolved.
Sat, Sep 11, 10:19 · MediaWiki (SRE), CSP Review
John closed T7905: Review nicovideo.jp CSP Entry as Resolved.
Sat, Sep 11, 10:19 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7862: Add newspapers.com to whitelist as Resolved.
Sat, Sep 11, 10:19 · Trust & Safety, CSP Review, MediaWiki (SRE)
John closed T7913: Review pixabay CSP Entry as Resolved.
Sat, Sep 11, 10:19 · Trust & Safety, MediaWiki (SRE), CSP Review
John moved T7567: Enable Extension:EmbedSpotify on mediterraneanvision.miraheze.org (+CSP whitelist request for spotify) from Actions Needed (Review) to Reviewed, Approved on the Extensions board.
Sat, Sep 11, 10:01 · Trust & Safety, CSP Review, MediaWiki (SRE), Universal Omega, Extensions
John moved T7567: Enable Extension:EmbedSpotify on mediterraneanvision.miraheze.org (+CSP whitelist request for spotify) from EM Review to Completed on the CSP Review board.
Sat, Sep 11, 10:00 · Trust & Safety, CSP Review, MediaWiki (SRE), Universal Omega, Extensions

Sun, Sep 5

John claimed T7750: Decom cp3.
Sun, Sep 5, 21:33 · Infrastructure (SRE)
John moved T7984: Redesign DNS Geo-location from Incoming to Long Term on the Infrastructure (SRE) board.
Sun, Sep 5, 21:33 · DNS, Infrastructure (SRE)
John added a comment to T7984: Redesign DNS Geo-location.

I am open to suggestions and opinions from MediaWiki (SRE) as to what people think likely be the best investment proposal by Infrastructure in this regard.

Sun, Sep 5, 21:31 · DNS, Infrastructure (SRE)
John added a comment to T7984: Redesign DNS Geo-location.

In the above scenarios, I'm looking at potential user/population counts each PoP would be responsible for based on a 24 hour period of rough access.

Sun, Sep 5, 21:28 · DNS, Infrastructure (SRE)
John added a comment to T7984: Redesign DNS Geo-location.
ContinentCountry-> CA-> GB-> SG (hist)->AU (OVH)Best DC?
AFEG14254195298GB
AFZA221144311398GB
AFKE245171231412GB
AFGH175103331344GB
AFTZ216136298403GB
AFMA14263249305GB
AFNG21797396335GB
ASTH25522229122SG
ASIN23114234355SG
ASAE193136266405GB
ASVN28822136132SG
ASID23820225118SG
ASKZ19095252362GB
ASPK274145110199SG
ASMY457294145240SG
ASPH26922966227SG
ASSA18697233258GB
ASKP19626682289SG
ASCN281?66349SG
ASJP16822374217SG
EUGR12755212279GB
EURO11537184271GB
EUIE7816257262GB
EUGB8811171263GB
EUFI11131182300GB
EUTR12551271288GB
EUUA11740177295GB
EUPT11548192282GB
EUSI10638191274GB
EUES10227253252GB
EURU12049207308GB
EUDE9619159251GB
EUNO10236190276GB
EUFR8312151248GB
EUIS12438196294GB
EUIT9919144242GB
NAUS2583236210CA
NACA685235210CA
NAMX71136228197CA
OCAU26026010016AU
OCNZ26030211726AU
SABR133213369345CA
SAAR175221368344CA
SAGT250277490478CA
SAPE107171307277CA
SAUY149227385335CA
SACL138198332306CA
Sun, Sep 5, 20:22 · DNS, Infrastructure (SRE)
John updated the task description for T7984: Redesign DNS Geo-location.
Sun, Sep 5, 20:22 · DNS, Infrastructure (SRE)
John triaged T7984: Redesign DNS Geo-location as Normal priority.
Sun, Sep 5, 14:34 · DNS, Infrastructure (SRE)
John closed T7960: [phabricator-extensions] Create better CI with PHPCS as Resolved.
Sun, Sep 5, 14:02 · Infrastructure (SRE), Phabricator, Technical-Debt, Universal Omega
John moved T7964: Setup icinga webhook listener for grafana from Incoming to Short Term on the Infrastructure (SRE) board.
Sun, Sep 5, 14:01 · Infrastructure (SRE), Monitoring

Sat, Sep 4

John committed rPUPCe886d6c9b9b8: add unsafe-inline for style-src (authored by John).
add unsafe-inline for style-src
Sat, Sep 4, 20:33
John committed rPUPC7952c25206e5: add unsafe-inline for script-src (authored by John).
add unsafe-inline for script-src
Sat, Sep 4, 20:31
John committed rPUPC5071008eb5e5: remove frame_whitelist (authored by John).
remove frame_whitelist
Sat, Sep 4, 20:25
John committed rPUPC1a5478ccf25e: re-write CSP to be more secure (authored by John).
re-write CSP to be more secure
Sat, Sep 4, 20:10
John committed rPUPC8867d9b5fa7f: re-write CSP to be more secure (authored by John).
re-write CSP to be more secure
Sat, Sep 4, 20:07
John closed T7900: Review billibilli.com CSP Entry as Declined.

Procedurally, use case no longer exists for this domain (widgets ext)

Sat, Sep 4, 19:39 · MediaWiki (SRE), CSP Review
John closed T7901: Review 163.com CSP Entry as Declined.

Procedurally, use case no longer exists for this domain (widgets ext)

Sat, Sep 4, 19:39 · MediaWiki (SRE), CSP Review

Fri, Sep 3

John moved T7960: [phabricator-extensions] Create better CI with PHPCS from Incoming to Short Term on the Infrastructure (SRE) board.
Fri, Sep 3, 07:58 · Infrastructure (SRE), Phabricator, Technical-Debt, Universal Omega
John edited projects for T7960: [phabricator-extensions] Create better CI with PHPCS, added: Phabricator, Infrastructure (SRE); removed MediaWiki (SRE), Configuration.

Retagging as Phabricator is Infra-primacy

Fri, Sep 3, 07:57 · Infrastructure (SRE), Phabricator, Technical-Debt, Universal Omega

Thu, Sep 2

John moved T5869: Whitelist postimages.org & imgbb.com (& their domains) for image display from EM Review to Pending Addition on the CSP Review board.
Thu, Sep 2, 15:55 · Trust & Safety, CSP Review, MediaWiki (SRE)
John added a comment to T5869: Whitelist postimages.org & imgbb.com (& their domains) for image display.

Moving this to 'Pending Addition' while we await proper CSP whitelisting by media/access type.

Thu, Sep 2, 15:55 · Trust & Safety, CSP Review, MediaWiki (SRE)
John closed T7883: Review bootstrapcdn.com CSP Entry as Resolved.
Thu, Sep 2, 15:55 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7894: Review ea.com CSP Entry as Resolved.
Thu, Sep 2, 15:54 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7896: Review tmdb.org CSP Entry as Resolved.
Thu, Sep 2, 15:54 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7898: Review Fastly CSP Entry as Resolved.
Thu, Sep 2, 15:54 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7926: Review Libera.chat CSP entry as Resolved.
Thu, Sep 2, 15:54 · Trust & Safety, CSP Review, MediaWiki (SRE)
John placed T6800: Create SLOs/SLIs for services up for grabs.
Thu, Sep 2, 15:50 · Site Reliability Engineering
John closed T4017: Reconfigure TLS settings inside MariaDB, a subtask of T4016: Encrypt all traffic inside Miraheze Cluster, as Resolved.
Thu, Sep 2, 15:46 · Infrastructure (SRE), Goal-2019-Jul-Dec, Goal-2020-Jan-Jun
John closed T4017: Reconfigure TLS settings inside MariaDB as Resolved.
Thu, Sep 2, 15:46 · Goal-2021-Jul-Dec, Infrastructure (SRE), Goal-2019-Jul-Dec, Goal-2020-Jan-Jun
John committed rPUPC5f87568219e5: Merge branch 'master' of github.com:/miraheze/puppet (authored by John).
Merge branch 'master' of github.com:/miraheze/puppet
Thu, Sep 2, 15:39
John committed rPUPC21a8ca9d554d: mariadb: REQUIRE SSL for icinga accounts (authored by John).
mariadb: REQUIRE SSL for icinga accounts
Thu, Sep 2, 15:39
John closed T4166: Animated Feet at Miraheze as Resolved.

This should now be fully resolved.

Thu, Sep 2, 14:25 · MediaWiki (SRE), MediaWiki
John added a comment to T7939: Add better CI for MediaWiki standards.
In T7939#160062, @John wrote:

One task - one end objective is a standard purpose. Why do we have a task for 9 separate objectives?

It's one end objective that all Miraheze maintained extensions have mediawiki-standard CI

Thu, Sep 2, 08:05 · Technical-Debt, WikiDiscover, IncidentReporting, RottenLinks, DataDump, RemovePII, GlobalNewFiles, MatomoAnalytics, CreateWiki, MediaWiki (SRE), Universal Omega, ManageWiki
John added a comment to T7939: Add better CI for MediaWiki standards.

One task - one end objective is a standard purpose. Why do we have a task for 9 separate objectives?

Thu, Sep 2, 07:59 · Technical-Debt, WikiDiscover, IncidentReporting, RottenLinks, DataDump, RemovePII, GlobalNewFiles, MatomoAnalytics, CreateWiki, MediaWiki (SRE), Universal Omega, ManageWiki

Wed, Sep 1

John committed rPUPC192901134aad: mariadb: REQUIRE SSL for most users (authored by John).
mariadb: REQUIRE SSL for most users
Wed, Sep 1, 21:17
John added a comment to T4017: Reconfigure TLS settings inside MariaDB.

Phabricator can not be done as it does not support MySQL SSL connections at all in the code.

Wed, Sep 1, 21:15 · Goal-2021-Jul-Dec, Infrastructure (SRE), Goal-2019-Jul-Dec, Goal-2020-Jan-Jun
John committed rPUPC91c2f1180c1f: Merge branch 'master' of github.com:/miraheze/puppet (authored by John).
Merge branch 'master' of github.com:/miraheze/puppet
Wed, Sep 1, 20:50
John committed rPUPCc1babe76ca60: enable TLS for roundcubeemail (authored by John).
enable TLS for roundcubeemail
Wed, Sep 1, 20:50
John committed R9:ceb8e6da9980: add wgCargoDBuser (authored by John).
add wgCargoDBuser
Wed, Sep 1, 20:12
John closed T7918: Problem with directory as Resolved.
Reception123> !log reception@mwtask1:/mnt/mediawiki-static$ sudo chown -R www-data:www-data companhiaballwiki
Wed, Sep 1, 17:26 · MediaWiki (SRE), MediaWiki, Production Error
John committed rPUPC5678f6615aa2: prometheus: allow mysqld_exporter over SSL (authored by John).
prometheus: allow mysqld_exporter over SSL
Wed, Sep 1, 16:08
John added a comment to T4017: Reconfigure TLS settings inside MariaDB.

TLS is now configured so only 1.2 and 1.3 can be used, and root has SSL encryption:

Wed, Sep 1, 13:30 · Goal-2021-Jul-Dec, Infrastructure (SRE), Goal-2019-Jul-Dec, Goal-2020-Jan-Jun
John committed rPUPC67820796cdf4: remove TLSv1.1 and add SSL support for root connection (authored by John).
remove TLSv1.1 and add SSL support for root connection
Wed, Sep 1, 13:23
Redmin awarded T7897: Review Facebook CSP Entry a Party Time token.
Wed, Sep 1, 13:12 · Trust & Safety, MediaWiki (SRE), CSP Review
John added a comment to T4017: Reconfigure TLS settings inside MariaDB.

TLS setup is mostly well-defined for MariaDB. The length this task has been opened has meant it has lost its original purpose and the constant recycling of it has meant the purpose and end target is undefined.

Wed, Sep 1, 13:04 · Goal-2021-Jul-Dec, Infrastructure (SRE), Goal-2019-Jul-Dec, Goal-2020-Jan-Jun
John placed T7634: Alert on low php-fpm workers up for grabs.
Wed, Sep 1, 10:49 · MediaWiki (SRE), Monitoring

Tue, Aug 31

John added a comment to T4166: Animated Feet at Miraheze.

About 50% of files should have been imported by now, this should go up to 60-65% overnight.

Tue, Aug 31, 22:33 · MediaWiki (SRE), MediaWiki
John added a comment to T4166: Animated Feet at Miraheze.

I haven't forgotten this task, it just turned out more complicated than originally anticipated as all file names are in the form of revision grabber and not direct filenames - so I have had to create a script to not only rename them, but also categorise them by author to ensure attribution is retained.

Tue, Aug 31, 18:06 · MediaWiki (SRE), MediaWiki
John closed T7891: Review fontawesome.com CSP Entry as Resolved.
Tue, Aug 31, 17:26 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7887: Review sciencedaily CSP Entry as Resolved.
Tue, Aug 31, 17:26 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7881: Review Imgur CSP Entry as Resolved.
Tue, Aug 31, 17:26 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7888: Review openstreetmap.org CSP Entry as Resolved.
Tue, Aug 31, 17:26 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7908: Review vimeo CSP Entry as Resolved.
Tue, Aug 31, 17:25 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7903: Review cloudflare CSP Entry as Resolved.
Tue, Aug 31, 17:25 · Trust & Safety, MediaWiki (SRE), CSP Review
John closed T7914: Review flickr CSP Entry as Resolved.
Tue, Aug 31, 17:25 · MediaWiki (SRE), CSP Review
John closed T7872: Review Google family of domains as Resolved.
Tue, Aug 31, 17:25 · MediaWiki (SRE), CSP Review
John closed T7860: I would like to create emails for my wiki domain as Resolved.
Tue, Aug 31, 14:44 · Infrastructure (SRE), DNS
John moved T7750: Decom cp3 from Incoming to Long Term on the Infrastructure (SRE) board.
Tue, Aug 31, 14:43 · Infrastructure (SRE)
John closed T7634: Alert on low php-fpm workers, a subtask of T7633: Persistent resource consumption is causing all sorts, as Resolved.
Tue, Aug 31, 07:59 · MediaWiki (SRE), Cloud Infrastructure, Monitoring, MediaWiki
John closed T7634: Alert on low php-fpm workers as Resolved.

You’ve stated numerous time you get the email alerts - so the alerting works. No need for a task to update a description of an alert.

Tue, Aug 31, 07:59 · MediaWiki (SRE), Monitoring

Mon, Aug 30

John closed T7884: Review creativecommons CSP Entry as Resolved.
Mon, Aug 30, 18:25 · MediaWiki (SRE), CSP Review
John closed T7879: Review Twitch CSP Entry as Resolved.
Mon, Aug 30, 18:25 · MediaWiki (SRE), CSP Review
John closed T7877: Review Twitter CSP Entry as Resolved.
Mon, Aug 30, 18:25 · MediaWiki (SRE), CSP Review
John closed T7873: Review Reddit family of domains as Resolved.
Mon, Aug 30, 18:25 · MediaWiki (SRE), CSP Review
John closed T7878: Review Stripe CSP Entry as Resolved.
Mon, Aug 30, 18:25 · MediaWiki (SRE), CSP Review
John closed T7875: Review Discord family of domains as Resolved.
Mon, Aug 30, 18:25 · MediaWiki (SRE), CSP Review
John closed T7871: Review Wikimedia Foundation family of domains as Resolved.
Mon, Aug 30, 18:25 · MediaWiki (SRE), CSP Review
Ugochimobi awarded T7892: Review nenawiki CSP Entry a Pterodactyl token.
Mon, Aug 30, 03:58 · MediaWiki (SRE), CSP Review

Sun, Aug 29

Ugochimobi awarded T7879: Review Twitch CSP Entry a Manufacturing Defect? token.
Sun, Aug 29, 17:29 · MediaWiki (SRE), CSP Review
Ugochimobi awarded T7884: Review creativecommons CSP Entry a Manufacturing Defect? token.
Sun, Aug 29, 17:28 · MediaWiki (SRE), CSP Review
Ugochimobi awarded T7877: Review Twitter CSP Entry a Manufacturing Defect? token.
Sun, Aug 29, 15:56 · MediaWiki (SRE), CSP Review

Sat, Aug 28

John added a project to T7874: Review Dropbox family of domains: MediaWiki (SRE).
Sat, Aug 28, 19:42 · Trust & Safety, MediaWiki (SRE), CSP Review