Page MenuHomeMiraheze

Southparkfan (Southparkfan)
Technical Operations, MirahezeAdministrator

Projects (19)

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Friday

  • Clear sailing ahead.

User Details

User Since
Apr 17 2016, 19:18 (182 w, 2 d)
Roles
Administrator
Availability
Available
IRC Nickname
SPF|Cloud
GitHub User
Southparkfan
Miraheze User
Southparkfan [ Global Accounts ]

Hi! I am Southparkfan; co-founder, steward and system administrator for Miraheze. I am responsible for the smooth operation of Miraheze's servers, which includes applying configuration changes, conducting maintenance and incident investigations, performance tuning, monitoring the servers and other miscellaneous tasks.

You can usually find me on IRC in the #miraheze channel on chat.freenode.net.

Recent Activity

Yesterday

Southparkfan closed T4769: [Access Request] Zppix for mw-admin as Resolved.

And shell has been given as well.

Tue, Oct 15, 17:26 · Operations
Southparkfan added a comment to T4769: [Access Request] Zppix for mw-admin.

Staff wiki sysop, icinga and grafana given.

Tue, Oct 15, 17:06 · Operations
Southparkfan added a comment to T4769: [Access Request] Zppix for mw-admin.

Done:

  • On-wiki
  • Mail (password provided to Zppix)
  • Phabricator
  • IRC
  • GitHub
  • Matomo (reset password via mail)
Tue, Oct 15, 15:58 · Operations
Southparkfan added a comment to T4769: [Access Request] Zppix for mw-admin.

Granted so far:

  • Security access on Phabricator
  • IRC flags
Tue, Oct 15, 15:34 · Operations
Southparkfan added a member for Security: Zppix.
Tue, Oct 15, 15:31

Mon, Oct 14

Southparkfan moved T4790: Extension review: Preloader from Backlog to Reviewed on the Extensions board.
Mon, Oct 14, 20:03 · Extensions
Southparkfan edited projects for T4790: Extension review: Preloader, added: Extensions; removed Extension-Review.

Approved.

Mon, Oct 14, 20:03 · Extensions
Southparkfan moved T4793: Extension review: CreatePageUw from Backlog to Reviewed on the Extensions board.
Mon, Oct 14, 20:02 · Extensions
Southparkfan edited projects for T4793: Extension review: CreatePageUw, added: Extensions; removed Extension-Review.

Approved.

Mon, Oct 14, 20:01 · Extensions
Southparkfan moved T4783: Extension review: LastModified from Backlog to Reviewed on the Extensions board.
Mon, Oct 14, 19:59 · Extensions
Southparkfan edited projects for T4783: Extension review: LastModified, added: Extensions; removed Extension-Review.
Mon, Oct 14, 19:59 · Extensions
Southparkfan added a comment to T4783: Extension review: LastModified.

Approved.

Mon, Oct 14, 19:59 · Extensions
Southparkfan moved T4786: Extension review: RecentChangesLogFilter from Backlog to Reviewed on the Extensions board.
Mon, Oct 14, 19:56 · Extensions
Southparkfan edited projects for T4786: Extension review: RecentChangesLogFilter, added: Extensions; removed Extension-Review.

Approved.

Mon, Oct 14, 19:56 · Extensions
Southparkfan added a comment to T4787: Extension review: WhosOnline.

This sounds like a privacy issue.

Mon, Oct 14, 19:47 · Extension-Review
Southparkfan moved T4792: Extension review: AutoCreatePage from Backlog to Reviewed on the Extensions board.
Mon, Oct 14, 19:46 · Extensions
Southparkfan edited projects for T4792: Extension review: AutoCreatePage, added: Extensions; removed Extension-Review.

Approved.

Mon, Oct 14, 19:46 · Extensions
Southparkfan removed a project from T4419: Request Extension TreeAndMenu: Extension-Review.
Mon, Oct 14, 19:35 · Extensions, Configuration
Southparkfan moved T4419: Request Extension TreeAndMenu from Other to Reviewed on the Extensions board.
Mon, Oct 14, 19:35 · Extensions, Configuration
Southparkfan moved T4419: Request Extension TreeAndMenu from Pending security review to Other on the Extensions board.
Mon, Oct 14, 19:35 · Extensions, Configuration
Southparkfan moved T4419: Request Extension TreeAndMenu from Blocked by security review to Blocked by upstream on the Configuration board.
Mon, Oct 14, 19:35 · Extensions, Configuration
Southparkfan changed the status of T4419: Request Extension TreeAndMenu from Open to Stalled.

Hi @Mike138, I am very sorry for the delay. I have reviewed the extension and unfortunately, we cannot enable this extension yet, due to issues described in T4806 (this is a private task due to security sensitive information). Changes are required from the author before we can enable this extension for you. We cannot give an ETA on this, that depends on the author.

Mon, Oct 14, 19:34 · Extensions, Configuration
Southparkfan claimed T4419: Request Extension TreeAndMenu.
Mon, Oct 14, 18:57 · Extensions, Configuration

Sun, Oct 13

Southparkfan added a comment to T4769: [Access Request] Zppix for mw-admin.

Approved.

Sun, Oct 13, 23:18 · Operations

Sat, Oct 5

Southparkfan added a comment to T4504: Renew *.miraheze.org cert.

Sent another mail.

Sat, Oct 5, 10:09 · SSL

Fri, Sep 27

Southparkfan added a comment to T4504: Renew *.miraheze.org cert.

And yet again invalid.

Fri, Sep 27, 08:47 · SSL

Sun, Sep 22

Southparkfan added a comment to T4504: Renew *.miraheze.org cert.

Sent me another code but still invalid.

Sun, Sep 22, 10:06 · SSL

Sat, Sep 21

Southparkfan closed T4724: Migrate wikis off db4 to db5 as Resolved.

Done!

Sat, Sep 21, 10:46 · Amanda Catherine, Database, Operations

Fri, Sep 20

Southparkfan claimed T4724: Migrate wikis off db4 to db5.
Fri, Sep 20, 17:49 · Amanda Catherine, Database, Operations

Wed, Sep 18

Southparkfan added a comment to T4504: Renew *.miraheze.org cert.

They've sent me a coupon code, but that code doesn't work. Asked for help.

Wed, Sep 18, 20:52 · SSL

Tue, Sep 17

Southparkfan added a comment to T4724: Migrate wikis off db4 to db5.

Candidates for moving:

root@db4:/srv/mariadb# grep -E '^[0-9\.]{1,3}G' /tmp/sizes.txt | sort -nr
25G     allthetropeswiki
21G     nonciclopediawiki
13G     nonsensopediawiki
9.8G    baobabarchiveswiki

These wikis occupy about 69G, about 18.3% of db4's space and 36.7% of db5's space.

Tue, Sep 17, 17:33 · Amanda Catherine, Database, Operations
Southparkfan triaged T4724: Migrate wikis off db4 to db5 as High priority.
Tue, Sep 17, 17:27 · Amanda Catherine, Database, Operations
Southparkfan added a comment to T4504: Renew *.miraheze.org cert.

GlobalSign is looking into it.

Tue, Sep 17, 17:16 · SSL

Sep 15 2019

Southparkfan added a comment to T4504: Renew *.miraheze.org cert.

Sent a reminder due to lack of a reply.

Sep 15 2019, 09:47 · SSL

Sep 9 2019

Southparkfan placed T4706: [Access Request] RhinosF1 for Mediawiki-Admins up for grabs.

As I mentioned in the staff channel recently, the willingness to learn and get experience is something I like. I think Miraheze benefits from a person like you on the MediaWiki team. Approved.

Sep 9 2019, 20:49 · Operations

Sep 8 2019

Southparkfan assigned T4706: [Access Request] RhinosF1 for Mediawiki-Admins to NDKilla.

This is waiting for your response.

Sep 8 2019, 20:42 · Operations
Southparkfan added a comment to T4706: [Access Request] RhinosF1 for Mediawiki-Admins.

These questions are to assess your technical capabilities. Some may be specific to MediaWiki administration, others may be used to determine if you would be a potential fit for Operations in the future. It is permitted to use search engines for your answers, however, bluntly copying commands without knowing what their parameters/arguments do is not good practice.
How do we enable encryption for HTTP traffic?

You can force it via .htcaccess

You cannot enable TLS via .htaccess, nor do we use Apache, try again please.

I've tried looking into it but haven't found much yet

See nginx.conf and mediawiki.conf.

For some reason php-fpm or nginx crashed or stopped. While backend servers are automatically depooled in order to keep the site running, loss of a backend means less capacity for serving traffic. How would you try to find out why the process crashed?

You could probably check a log or see if RamNode shows anything but I wouldn't know where exactly to look and don't believe mw-admins have RN access.

Please elaborate more, I am looking for in-depth answers. Which logs?

I wouldn't be certain

In the case I explained the server itself is still running, it's only a crash of certain processes. Using journalctl, dmesg and looking in /var/log/nginx/error.log or the MediaWiki logs (/var/log/mediawiki) you could get more information.

Sep 8 2019, 19:16 · Operations
Southparkfan added a comment to T4706: [Access Request] RhinosF1 for Mediawiki-Admins.

These questions are to assess your technical capabilities. Some may be specific to MediaWiki administration, others may be used to determine if you would be a potential fit for Operations in the future. It is permitted to use search engines for your answers, however, bluntly copying commands without knowing what their parameters/arguments do is not good practice.

cd srv/Mediawiki/w/maintenance
sudo -u www-data php deleteArchivedFiles.php --wiki dbname --delete --force
nice -5 sudo -u www-data php deleteArchivedFiles.php --wiki dbname --delete --force

  • I want to permanently delete all archived files for a wiki, however, the maintenance script puts a very high load on the MediaWiki server. Linux offers a way (for any command you execute) to reduce processing priority. What is the full command you would run?

Yup, nice is the command I was looking for. Though, your solution only words for negative values, so try using sudo nice instead of nice sudo (also improves readability!).

Sep 8 2019, 18:24 · Operations
Southparkfan added a comment to T4706: [Access Request] RhinosF1 for Mediawiki-Admins.

These questions are to assess your technical capabilities. Some may be specific to MediaWiki administration, others may be used to determine if you would be a potential fit for Operations in the future. It is permitted to use search engines for your answers, however, bluntly copying commands without knowing what their parameters/arguments do is not good practice.

Sep 8 2019, 16:47 · Operations

Aug 31 2019

Southparkfan raised the priority of T4504: Renew *.miraheze.org cert from Low to High.

Working on this.

Aug 31 2019, 15:48 · SSL

Aug 8 2019

Southparkfan added a comment to T4610: Extension for User Name requested.

Before installing one question, is this acceptable for privacy reasons? Asking due to it providing "{{CURRENTUSERREALNAME}}" and I'm not 100% sure if real name is public by default.

Aug 8 2019, 16:20 · Extensions, Configuration

Aug 7 2019

Southparkfan added a comment to T4554: Extension:StopForumSpam.

The extension itself is safe, however I do not like the idea of our IPs being blacklisted because someone used reported non-spambots to the StopForumSpam site. I want to know what the other sysadmins think.

Aug 7 2019, 22:15 · Operations, Extensions, Configuration
Southparkfan removed a project from T4610: Extension for User Name requested: Extension-Review.
Aug 7 2019, 22:10 · Extensions, Configuration
Southparkfan moved T4610: Extension for User Name requested from Blocked by security review to In Progress on the Configuration board.
Aug 7 2019, 22:10 · Extensions, Configuration
Southparkfan moved T4610: Extension for User Name requested from Pending security review to Reviewed on the Extensions board.
Aug 7 2019, 22:10 · Extensions, Configuration
Southparkfan added a comment to T4610: Extension for User Name requested.

UserMagic: seems obsolete due to the other two extensions and does cache user IPs, so declined.

Aug 7 2019, 22:09 · Extensions, Configuration
Southparkfan added a comment to T4610: Extension for User Name requested.

MyVariables: also disabling parser cache when needed, approved

Aug 7 2019, 22:09 · Extensions, Configuration
Southparkfan added a comment to T4610: Extension for User Name requested.

UserFunctions: caching the IP addresses of users in Varnish is not a good idea, but the parser cache seems to be disabled so security wise this is fine.

Aug 7 2019, 22:07 · Extensions, Configuration

Aug 1 2019

Southparkfan added a comment to T4172: Shrink db4's swap partition and reclaim space in root partition.

@John mind reviewing/commenting on this?

Aug 1 2019, 17:58 · Database, Operations

Jul 31 2019

Southparkfan added a comment to T4017: Reconfigure TLS settings inside MariaDB.

We're definitely using OpenSSL for MariaDB 10.2.24, great. First step would be creating a Miraheze CA with easy-rsa.

Jul 31 2019, 23:31 · Goal-2019-Jul-Dec, Operations

Jul 13 2019

Southparkfan closed T4532: Upgrade elasticsearch1 to 4gb SVZS as Resolved.
Jul 13 2019, 10:00 · Operations

Jul 3 2019

Southparkfan changed the visibility for T4196: stunnel not verifying backend certificates?.
Jul 3 2019, 23:26 · Security
Southparkfan closed T4196: stunnel not verifying backend certificates? as Declined.

Non-existent issue.

Jul 3 2019, 18:31 · Security

Jul 2 2019

Southparkfan added a comment to T4191: Redesign compression of content inside NGINX and Varnish.

Related: T4302

Jul 2 2019, 22:49 · Varnish, Operations

Jun 28 2019

Southparkfan added a comment to T4476: Renew miraheze.org and orain.org domain names.

Try again please.

Jun 28 2019, 14:26

Jun 25 2019

Southparkfan updated subscribers of T4476: Renew miraheze.org and orain.org domain names.

Ack.

Jun 25 2019, 11:38

Jun 18 2019

Southparkfan created T4476: Renew miraheze.org and orain.org domain names.
Jun 18 2019, 00:17

Jun 13 2019

Southparkfan added a comment to T4235: Enable PageDisqus on cloudytheology.miraheze.org.

@AmandaCath hi! It is a *potential* security issue, I'm actually lacking the tools I need to verify it's present or absent. If the former, the extension would likely pass review after the fix has been applied.

Jun 13 2019, 23:46 · Extensions
Southparkfan added a comment to T4235: Enable PageDisqus on cloudytheology.miraheze.org.

Blocked by T4468 (private task).

Jun 13 2019, 22:32 · Extensions
Southparkfan created T4468: Verify if PageDisqus has reflective XSS.
Jun 13 2019, 22:31 · Security, Extension-Review
Southparkfan added a comment to T4441: Extension:Multimap on OGF Community Sandbox.

Review process: the PHP and JavaScript resources must be checked.

Jun 13 2019, 22:14 · Extensions, Extension-Review, Configuration
Southparkfan moved T4388: Extension:WikiHiero from Pending security review to Reviewed on the Extensions board.
Jun 13 2019, 22:13 · Extensions
Southparkfan removed a project from T4388: Extension:WikiHiero: Extension-Review.
Jun 13 2019, 22:13 · Extensions
Southparkfan added a comment to T4388: Extension:WikiHiero.

This extension is used on WMF projects, no review needed.

Jun 13 2019, 22:13 · Extensions

Jun 12 2019

Southparkfan added a comment to T4461: Alternative Countries Wiki - "Lua error: Internal error: The interpreter has terminated with signal "24"..

Looks like a cpu limit violation (set in mediawiki config).

Jun 12 2019, 21:04 · MediaWiki, Import

Jun 2 2019

Southparkfan moved T4438: Upgrade elasticsearch to version 6 from Backlog to Operations on the Goal-2019-Jul-Dec board.
Jun 2 2019, 23:13 · Goal-2019-Jul-Dec, Elasticsearch, MediaWiki
Southparkfan moved T4260: Migrate all wikis to elasticsearch from Backlog to MediaWiki on the Goal-2019-Jul-Dec board.
Jun 2 2019, 23:13 · Goal-2019-Jul-Dec, Operations, Elasticsearch, MediaWiki
Southparkfan created T4438: Upgrade elasticsearch to version 6.
Jun 2 2019, 23:13 · Goal-2019-Jul-Dec, Elasticsearch, MediaWiki
Southparkfan added a project to T4260: Migrate all wikis to elasticsearch: Goal-2019-Jul-Dec.
Jun 2 2019, 23:10 · Goal-2019-Jul-Dec, Operations, Elasticsearch, MediaWiki
Southparkfan set the image for Goal-2019-Jul-Dec to F947646: fa-flag-checkered-green.png.
Jun 2 2019, 23:07
Southparkfan created Goal-2019-Jul-Dec.
Jun 2 2019, 23:07
Southparkfan added a comment to T4260: Migrate all wikis to elasticsearch.

Saturday the Site went down again due to a mysql failure caused by insufficient disk space. This should be done sooner.

Jun 2 2019, 22:52 · Goal-2019-Jul-Dec, Operations, Elasticsearch, MediaWiki

May 27 2019

Southparkfan updated subscribers of T4172: Shrink db4's swap partition and reclaim space in root partition.

@John mind reviewing/commenting on this?

May 27 2019, 00:14 · Database, Operations
Southparkfan added a comment to T4346: Enable TUN/TAP on servers.

@Paladox for lizardfs[123].miraheze.org: what is the impact of one node being offline? Does it only prevent MediaWiki from retrieving 1/3 of our static content or will LizardFS crash completely?

May 27 2019, 00:11 · Goal-2019-Jan-Jun, Operations

May 23 2019

Southparkfan created T4410: Absenting user in users module does not remove account from system.
May 23 2019, 23:43 · Operations, Puppet
Southparkfan removed a member for Security: MacFan4000.
May 23 2019, 22:45

May 10 2019

Southparkfan closed T4356: Mar9122 Wiki isn't working... as Resolved.

Fixed.

May 10 2019, 21:53 · Amanda Catherine, MediaWiki
Southparkfan claimed T4356: Mar9122 Wiki isn't working....

We're taking a look.

May 10 2019, 21:43 · Amanda Catherine, MediaWiki
GitHub <noreply@github.com> committed rPUPCb9fc549dc2cc: Add ns1/puppet1 to vpncloud configuration, for real (authored by Southparkfan).
Add ns1/puppet1 to vpncloud configuration, for real
May 10 2019, 21:35
GitHub <noreply@github.com> committed rPUPC37bd9550d473: Firewall rules for vpncloud puppet1/ns1 (authored by Southparkfan).
Firewall rules for vpncloud puppet1/ns1
May 10 2019, 21:32
GitHub <noreply@github.com> committed rPUPC3da8935b9883: Add vpncloud role on ns1/puppet1 (authored by Southparkfan).
Add vpncloud role on ns1/puppet1
May 10 2019, 21:30
GitHub <noreply@github.com> committed rPUPCbfb3c18a0a49: Assign vpncloud ip for puppet1 (authored by Southparkfan).
Assign vpncloud ip for puppet1
May 10 2019, 21:30
GitHub <noreply@github.com> committed rPUPC5b01f7a9030e: Assign vpncloud ip for ns1 (authored by Southparkfan).
Assign vpncloud ip for ns1
May 10 2019, 21:30

May 4 2019

Southparkfan added a comment to T4127: Install and puppetize VPNCloud.

So, after some hassle with a broken tun/tap on elasticsearch1 we have the following servers running vpncloud now:

cp310.0.1.4
db410.0.1.3
elasticsearch110.0.1.1
test110.0.1.2
May 4 2019, 23:30 · Goal-2019-Jan-Jun, Operations
Southparkfan triaged T4346: Enable TUN/TAP on servers as Normal priority.
May 4 2019, 23:29 · Goal-2019-Jan-Jun, Operations
GitHub <noreply@github.com> committed rPUPC8734e2ae24f6: fix port numbers (authored by Southparkfan).
fix port numbers
May 4 2019, 23:12
GitHub <noreply@github.com> committed rPUPCada597fddbbd: Add comments to miraheze-internal.net file (authored by Southparkfan).
Add comments to miraheze-internal.net file
May 4 2019, 23:04
GitHub <noreply@github.com> committed rPUPC4b7a6c945613: Add firewall rule for vpncloud db4 (authored by Southparkfan).
Add firewall rule for vpncloud db4
May 4 2019, 22:55
GitHub <noreply@github.com> committed R9:67b4d03a0643: Remove site notice (authored by Southparkfan).
Remove site notice
May 4 2019, 22:53
GitHub <noreply@github.com> committed rPUPC593cdf78b524: Add db4 to vpncloud peers (authored by Southparkfan).
Add db4 to vpncloud peers
May 4 2019, 22:51
GitHub <noreply@github.com> committed rPUPCa79e1c835c9c: Enable vpncloud on db4 (authored by Southparkfan).
Enable vpncloud on db4
May 4 2019, 22:50
GitHub <noreply@github.com> committed R9:1efb25148f25: Maintenance window for Elasticsearch (authored by Southparkfan).
Maintenance window for Elasticsearch
May 4 2019, 22:22
GitHub <noreply@github.com> committed R9:1f1f8310da93: Remove sitenotice (authored by Southparkfan).
Remove sitenotice
May 4 2019, 21:57
GitHub <noreply@github.com> committed R9:318fd670de47: Update Sitenotice.php (authored by Southparkfan).
Update Sitenotice.php
May 4 2019, 21:44
GitHub <noreply@github.com> committed R9:5574567d5f5e: Restrict sitenotice to wikis using ES (authored by Southparkfan).
Restrict sitenotice to wikis using ES
May 4 2019, 21:43
GitHub <noreply@github.com> committed R9:2c06a26ca76e: Sitenotice for ES server maintenance (authored by Southparkfan).
Sitenotice for ES server maintenance
May 4 2019, 21:41
GitHub <noreply@github.com> committed rPUPC56c381f51b94: Change default for vpncloud::server_ip (authored by Southparkfan).
Change default for vpncloud::server_ip
May 4 2019, 21:32
GitHub <noreply@github.com> committed rPUPC85b95aceec1f: Fix vpncloud module (authored by Southparkfan).
Fix vpncloud module
May 4 2019, 21:25
GitHub <noreply@github.com> committed rPUPC1925eba3e06e: cp3: assign vpncloud ip (authored by Southparkfan).
cp3: assign vpncloud ip
May 4 2019, 21:20
GitHub <noreply@github.com> committed rPUPC54ae3497eaa0: Load vpncloud role on cp3/elasticsearch1/test1 (authored by Southparkfan).
Load vpncloud role on cp3/elasticsearch1/test1
May 4 2019, 21:20