Tech:Server admin log/2018

2016-07-16

 * 19:51 John: ensured all databases (651) have WikiForum database tables
 * 19:45 John: ensured all databases (652) have SocialProfile database tables
 * 19:15 John: ensured all databases (146) have PageTriage database tables
 * 19:10 John: ensured all databases (6) have Flow database tables
 * 19:08 John: ensured all databases (4) have Translate database tables
 * 19:04 John: ensured all databases (1) have BetaFeatures database tables
 * 19:03 John: ensured all databases (1) have Poll database tables
 * 19:02 John: ensured all databases (4) have TimedMediaHandler database tables
 * 18:59 John: ensured all databases (4) have TitleKey database tables

2016-07-15

 * 17:41 Southparkfan: increased HSTS for miraheze.org to 6 months
 * 11:58 PuppyKun: ran update.php twice on jbkwwiki (first run failed because of global_block_whitelist table or whatever that common thing is)

2016-07-14

 * 22:37 Southparkfan: installed security updates on mw1 & mw2
 * 19:42 Southparkfan: varnishadm 'ban req.http.Host == southparkfan.miraheze.org' @ cp1

2016-07-13

 * 10:09 Southparkfan: wiped everything in /tmp on misc1

2016-07-12

 * 22:55 Southparkfan: import finished & ran rebuildrecentchanges.php for wisdomsandboxwiki
 * 22:28 Southparkfan: running southparkfan@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki wisdomsandboxwiki /tmp/wisdomwiki.xml on mw1

2016-07-11

 * 20:28 Southparkfan: restarted jobrunner on mw1, it was stuck
 * 18:30 Southparkfan: ran ufw-fix on cp1
 * 05:26 John: remounted static on mw2
 * 05:26 John: started jobrunner on mw1
 * 05:24 John: remounted static on mw1
 * 05:21 John: rebooting mw1
 * 03:40 PuppyKun: 11:03:58 PM  RECOVERY - Host Cache Proxy 1 is UP: PING OK - Packet loss = 0%, RTA = 0.47 ms

2016-07-10

 * 22:55 John: disabled uploads globally
 * 22:24 John: rebooting cp1, NFS will have to manage after

2016-07-09

 * 22:54 John: ran manageInactiveWikis.php with --warn
 * 20:36 John: rebooting mw2, unresponsive
 * 14:13 PuppyKun: wisdomwikiwi> update page set page_namespace=1656 where page_namespace=1632;
 * 14:12 PuppyKun: wisdomwikiwi> update page set page_namespace=1654 where page_namespace=1630;

2016-07-08

 * 18:59 John: reloaded nginx on cp[12]
 * 13:42 PuppyKun: sudo php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2016-07-07

 * 17:20 Southparkfan: restarted jobrunner on mw1
 * 16:49 John: >UPDATE cw_wikis SET wiki_private = 1 WHERE wiki_dbname = "offensivesivewiki";
 * 16:00 PuppyKun: > update cw_wikis set wiki_language="en" where wiki_dbname="exerionwiki";

2016-07-06

 * 15:53 PuppyKun: puppet run on mw* after https://git.io/vKLXL
 * 12:28 PuppyKun: update cw_wikis set wiki_closed=0 where wiki_dbname="atplwiki";

2016-07-05

 * 14:29 John: ran update.php on new M[Ss]Calendar wikis

2016-07-04

 * 17:03 Southparkfan: all mwservers repooled, puppet re-enabled everywhere
 * 16:09 Southparkfan: disabled puppet on mwservers

2016-07-03

 * 22:02 labster: [allthetropeswiki]> drop table time_zone; drop table time_zone_leap_second; drop table time_zone_name; drop table time_zone_transition; drop table time_zone_transition_type;
 * 20:55 John: MariaDB [allthetropeswiki]> DROP TABLE event,general_log,procs_priv,proxies_priv,servers,tables_priv;
 * 20:48 John: MariaDB [allthetropeswiki]> DROP TABLE proc;
 * 14:37 John: update phabricator to stable
 * 08:56 John: rm /bacula/backups/STATIC-0004 /bacula/backups/STATIC-0008 on bacula1
 * 08:34 John: MariaDB [allthetropeswiki]> DROP TABLE host;
 * 08:34 John: MariaDB [allthetropeswiki]> DROP TABLE columns_priv, func, db;

2016-07-01

 * 19:43 John: delete wikis: jubeatwikithwiki, chavezwiki, putinwiki, ndtestwiki ,lupawiki
 * 18:11 PuppyKun: ran cleanupTitles.php --wiki testwiki to fix issues with TestWiki_talk:Request_permissions
 * 17:45 John: reopened madgendersciencewiki
 * 13:51 PuppyKun: finished manageInactive wikis, 104 wikis warned, 6 closed
 * 13:44 PuppyKun: forced puppet run on mw1 after "mediawiki/REL1_26 b86bf96", running manageInactiveWikis.php
 * 13:30 PuppyKun: sudo rm findInactiveWikis.php on mw1
 * 11:44 John: made seldirwiki public

2016-06-30

 * 12:31 Southparkfan: reopened wikiconstitucio.miraheze.org

2016-06-29

 * 15:03 PuppyKun: deleted lupawiki per founder request

2016-06-28

 * 18:37 Southparkfan: reopened ackbwiki
 * 06:34 Southparkfan: still not responding to reboot, opened ticket with VPS provider
 * 06:28 Southparkfan: bacula1 crashed, trying to reboot, server / control panel not responding to actions

2016-06-27

 * 13:22 Southparkfan: re-enabled puppet on misc2
 * 13:03 Southparkfan: disabled puppet on misc2

2016-06-26

 * 09:43 Southparkfan: issued varnishadm 'ban req.http.Host == wisdomwiki.org' on all cache proxies

2016-06-23

 * 12:10 Southparkfan: depooled mw1 @ cp2
 * 11:21 Southparkfan: taking down cp1 for maintenance

2016-06-21

 * 14:13 Southparkfan: MariaDB [metawiki]> update cw_wikis set wiki_closed=0 where wiki_dbname='ggdrwiki'; per request

2016-06-19

 * 03:49 PuppyKun: > delete from cw_wikis where wiki_dbname='ndtestwiki';

2016-06-18

 * 23:37 PuppyKun: > update cw_wikis set wiki_private=1 where wiki_dbname='biblicalwikiwiki';
 * 19:09 PuppyKun: sudo php runJobs.php --wiki metawiki
 * 19:09 PuppyKun: sudo php runJobs.php --wiki loginwiki
 * 18:59 PuppyKun: > update cw_wikis set wiki_closed=0 where wiki_dbname='biblicalwikiwiki';

2016-06-16

 * 18:24 Southparkfan: > update cw_wikis set wiki_language = 'fr' where wiki_dbname = 'evawiki';
 * 17:56 John: reopened biblicalwikiwiki

2016-06-15

 * 20:56 Southparkfan: renewed *.miraheze.org certificate. Apache and nginx on all cache proxies, appservers and misc. servers have been reloaded

2016-06-14

 * 02:33 PuppyKun: varnish purge https://downhillderelicts.miraheze.org on cp*
 * 02:32 PuppyKun: varnish> purge wiki.downhillderelicts.com on cp*

2016-06-13

 * 19:33 PuppyKun: varnish> ban req.http.Host == metatrek.miraheze.org on cp*
 * 18:53 John: php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/manageInactiveWikis.php --wiki metawiki --warn
 * 18:45 Southparkfan: varnish> ban req.http.Host == meta.trek.tk to fix custom domain

2016-06-11

 * 07:57 Southparkfan: ran FlowUpdateWorkflowPageId.php for All The Tropes (https://phabricator.wikimedia.org/T137594)

2016-06-10

 * 23:06 PuppyKun: merge mw-config #523 and run puppet on mw*
 * 22:43 PuppyKun: ensured git clone /srv/mediawiki/config on mw*
 * 22:14 PuppyKun: someone started log bot

2016-06-05

 * 18:52 Southparkfan: adminbot now runs as irc user
 * 16:23 John: removed HHVM references/files from private git

2016-06-03

 * 23:01 SPF|Cloud: test if Python ignores errors
 * 22:57 PuppyKun: Thank User:Southparkfan for working log not
 * 22:49 labster: channel spam
 * 22:49 SPF|Cloud: and another one
 * 22:49 SPF|Cloud: another test
 * 22:48 SPF|Cloud: test
 * 21:10 Southparkfan: MariaDB [allthetropeswiki]> update page set page_content_model = 'flow-board' where page_namespace = 3 and page_title not like '%/%' and page_content_model = 'wikitext'; to fix https://phabricator.miraheze.org/T340

2016-05-23

 * 17:27 JohnLewis: undeployed and removed HHVM from mw2 completely. It is no more.
 * 17:23 JohnLewis: undeployed and removed HHVM from mw1 completely.
 * 01:07 revi:, 502 everywhere.

2016-04-22

 * 22:24 Southparkfan: MariaDB [allthetropeswiki]> truncate ipblocks; to fix https://phabricator.miraheze.org/T229

2016-04-20

 * 17:12: NDKilla: > update cw_wikis set wiki_private=1 where wiki_dbname='evawiki'; per founder request

2016-04-12

 * 16:23: NDKilla closed lupawiki (cw_wikis wiki_closed=1) per founder request

2016-03-27

 * 19:48 Southparkfan: resetted password for user 'O'. Sent email to user with new password.
 * ~19:45 Southparkfan: ran deleteEmptyAccounts.php --wiki metawiki --fix --migrate --safe-migrate and checkLocalUser.php --delete on some wikis
 * 17:31 JohnLewis: deleted several wikis. See dormancy page history for a list. +internalwiki

2016-03-26

 * 20:13 JohnLewis: deleted bzduropediawiki

2016-03-25

 * 13:47 Southparkfan: php deleteEmptyAccounts.php --wiki metawiki --fix --safe-migrate --migrate

2016-03-15

 * 5:30 NDKilla: UPDATE cw_wikis SET wiki_closed=1 WHERE wiki_dbname="internalwiki"; (via mw1 maintenance/sql.php)

2016-03-12

 * 15:44 Southparkfan: /srv/mediawiki/w/extensions/CentralAuth/maintenance# php deleteEmptyAccounts.php --wiki metawiki --fix --safe-migrate to delete global acocunts without any attached users
 * 15:16 Southparkfan: foreachwikiindblist /srv/mediawiki/dblist/all.dblist maintenance/checkLocalUser.php --verbose 1 --delete > ~/tmp-ca.log at mw1 to fix annoying "Could not find user data for" MWExceptions

2016-03-11

 * 19:01 JohnLewis: UPDATE cw_wikis SET wiki_private = "0" WHERE wiki_dbname = "aevumkathwiki";

2016-03-08

 * 22:12 JohnLewis: deleted spiraltestwiki and allthetropestestwiki
 * 19:53 JohnLewis: DROP DATABASE (for following: poserdazfreebiestestwiki, gameswiki, wikiacawiki)
 * 19:47 JohnLewis: DELETE FROM cw_wikis WHERE wiki_dbname = "wikiacawiki";
 * 05:25 revi:, icinga crying for varnish backend problems

2016-03-07

 * 22:41 JohnLewis: root@ns3 relays: The system is going down for power-off at Mon 2016-03-07 22:41:14 UTC!
 * 22:40 JohnLewis: root@ns3:~# shutdown -P

2016-02-26

 * 17:56 JohnLewis: UPDATE cw_wikis SET wiki_private="1",wiki_sitename="LBS Global Energy Summit" WHERE wiki_dbname="lbsgeswiki";

2016-02-24

 * 19:19 JohnLewis: /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/maintenance/patchSql.php /srv/mediawiki/w/extensions/BetaFeatures/sql/create_counts.sql

2016-02-22

 * 22:16 JohnLewis: UPDATE cw_wikis SET wiki_language = "es" WHERE wiki_dbname = "ricwiki";
 * 20:45 JohnLewis: reboot servers for security updates relating to core system files.

2016-02-16

 * 16:28 Southparkfan: deleted thoughtonomywikiwiki dumps

2016-02-03

 * 15:50 JohnLewis: UPDATE cw_wikis SET wiki_closed=0,wiki_private=1 WHERE wiki_dbname='quantixwiki';

2016-01-20

 * 16:29 SPF|Cloud: ran checkLocalNames.php and checkLocalUser.php on spiralwiki with --delete option. (https://github.com/miraheze/mw-config/issues/264)

2016-01-18

 * 17:10 SPF|Cloud: deleted gameswiki database
 * 17:05 SPF|Cloud: deleted gameswiki database
 * 16:46 SPF|Cloud: deleted emptysetwiki database per NDKilla's request
 * 16:35 PuppyKun: restarted HHVM (process was "active (exited)" with fatal errors)

2016-01-16

 * 02:06 PuppyKun: ran SQL query "UPDATE cw_wikis SET wiki_closed=1 WHERE wiki_dbname='quantixwiki' OR wiki_dbname='catboxwiki' or wiki_dbname='emptysetwiki';" on mw1
 * 02:05 PuppyKun: Manually restarted HHVM on mw1 ~10 mins ago

2016-01-10

 * 17:17 PuppyKun: manually run puppet on mw1 and run namespaceDupes.php --wiki adnovumwiki --fix

2016-01-09

 * 01:46 PuppyKun: manually ran update.php on adnovumwiki. failed the first time due to global blocking table already existing (this usually doesn't cause it to fail?) running it again finished successfully in 0.7s

2016-01-07

 * 15:09 SPF|Cloud: ran removeDeletedWikis.php to delete poserdazfreebiestestwiki + removed it from cw_wikis

Information
All times are in UTC+0/GMT.

Archives: 2015.