Tech:Server admin log/2018

2018-02-15

 * 18:01 Reception|away: moved to db3 and dropped on db2 nextlevelwikiwiki recentiawiki teriawiki zendariwiki
 * 17:40 Reception|away: moved supernamuwiki from db3 to (temporary) db4, dropped from db3

2018-02-14

 * 19:31 Reception|away: DELETED from CW_WIKIS and dropped ictjudikaturawiki (T2724)
 * 19:17 Reception|away: moved templatewiki and mc2wiki to db3 and dropped on db2

2018-02-12

 * 11:12 revi: https://phabricator.miraheze.org/H30 updated to automatically subscribe CoCC members

2018-02-11

 * 06:57 Reception123: purge binary logs before '2018-02-11 06:00:00'; on db2
 * 06:52 Reception123: sudo -u www-data foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/maintenance/sql.php /srv/mediawiki/w/extensions/QuizGame/sql/quizgame.sql
 * 06:48 Reception123: sudo -u www-data php mergeMessageFileList.php --output /srv/mediawiki/config/ExtensionMessageFiles.php --wiki test1wiki and rebuild LC on mw*

2018-02-10

 * 12:03 Reception123: DROPPED wikis below
 * 10:56 Reception123: DELETED FROM CW_WIKIS altenpflegewiki altwiki amningwiki amparodenaswiki annuwikiwiki anon4wiki antoinewiki apenlinjewiki apituwiki apparchitectwiki apslaxwiki aptotecwiki aquivawiki arabudlandwiki arbabilowiki archipediawiki argentinachicagowiki arguwikiwiki arkheonwiki armlaptopwiki askerwiki astawiki atkinswiki atplwiki audiowikiwiki autismadminswiki
 * 07:31 Reception123: sudo -u www-data php importDump.php --wiki podpediawiki /home/reception/roosterteeth_pages_current.xml on mw2

2018-02-08

 * 20:58 Southparkfan: mw1 repooled
 * 19:12 Southparkfan: mw1 emergency depool
 * 19:10 Reception123: purge binary logs before '2018-02-08 16:00:00'; on db2
 * 18:47 Southparkfan: on cp4: varnishlog -g raw -i Backend_health -a -w /var/log/varnish/varnish-backend.log -D
 * 16:37 Southparkfan: ran git submodule update --init in /srv/piwik

2018-02-06

 * 06:46 Reception123: moved liberartwiki to libreartwiki

2018-02-04

 * 13:27 Reception123: moved mistralcupwiki from db4 to db2 (created when metawiki was moved to db4; not declared in Database.php)
 * 09:40 Reception123: moved to db3 and dropped on db2 ctswiki fourleafficswiki karniarutheniawiki madciclistawiki nvcwiki songcontestswiki unionnorteamericanawiki valentinaprojectwiki
 * 05:55 Reception123: moved metawiki back to db2 (has to be on default or else there are CW errros)

2018-02-03

 * 23:53 Southparkfan: dropped worlduniversityandschoolwiki, tmewiki and vandalwiki, all wikis have been transferred to c3
 * 22:44 Southparkfan: moved metawiki to c3, dropped database on db2. backup is in /home/dbcopy for emergencies
 * 18:19 Reception123: upgraded phabricator

2018-02-02

 * 20:04 Reception123: purge binary logs before '2018-02-02 18:00:00'; on db2
 * 18:28 Southparkfan: MariaDB [metawiki]> update cw_wikis set wiki_dbcluster = 'c3' where wiki_dbname = 'testwiki';
 * 15:48 PuppyKun: destroyed db5 last night

2018-02-01

 * 22:03 PuppyKun: root@mw1:/srv/mediawiki/w/extensions/CentralAuth/maintenance# sudo -u www-data php fixStuckGlobalRename.php --wiki=maiasongcontestwiki --logwiki=metawiki "WEMO666" "Chriskk01b"
 * 21:55 PuppyKun: MariaDB [centralauth]> delete from renameuser_status where ru_wiki="lothuialethwiki"; (query ok, 1 row affected)
 * 21:44 PuppyKun: removeDeletedWikis for lothuialethwiki
 * 18:59 Southparkfan: cleaned puppet certificate info about db5
 * 18:48 PuppyKun: hard rebooting db5
 * 17:29 revi: update phabricator maniphest form 14 ( https://phabricator.miraheze.org/transactions/editengine/maniphest.task/view/14/ ) preamble
 * 02:12 PuppyKun: rebooted db5
 * 02:05 PuppyKun: rebooted db5
 * 02:00 PuppyKun: started hard reboot of db5.miraheze.org (unresponsive to ssh)
 * 01:48 PuppyKun: doing first puppet run on db5.cloud.online.net (??? that was the name that showed up when i did --wait-for-cert on db5.mh.o and the fingerprint matched)

2018-01-29

 * 10:27 revi: create #spam in Phabricator, for spammy tasks

2018-01-28

 * 18:59 Reception123: moved to db3 and dropped on db2 madgendersciencewiki ubrwikiwiki nonbinarywiki linenwiki beatstationwiki daesocialwiki uncyclopediawiki musicarchivewiki thegreatwarwiki christianmusictempwiki hellointernetwiki christianmusicwiki spritopiawiki magnaversewiki
 * 18:24 Reception123: disabled puppet on db3
 * 15:33 Reception123: revi added to @miraheze puppet-users team

2018-01-27

 * 20:36 Reception123: purge binary logs before '2018-01-27 15:00:00'; on db2

2018-01-25

 * 17:04 Reception|away: installed db4 and signed cert on puppet1

2018-01-24

 * 18:48 Reception|away: upgraded phabricator

2018-01-23

 * 06:45 Reception|away: purge binary logs before '2018-01-23 00:00:00';

2018-01-22

 * 20:26 Reception|away: sudo rm -rf /var/lib/puppet/reports on puppet1 (disk space running out)

2018-01-21

 * 10:50 Reception123: sudo -u www-data php mergeMessageFileList.php --output /srv/mediawiki/config/ExtensionMessageFiles.php --wiki test1wiki and rebuild LC on mw*
 * 08:31 Reception123: archived H2 (no longer used)

2018-01-20

 * 08:09 Reception123: sudo -u www-data php dumpBackup.php --wiki metawiki --full > /home/reception/metawiki.xml on mw3

2018-01-19

 * 18:22 Reception123: rebooted test1 (puppetmaster)
 * 17:43 Reception123: sudo -u www-data php importDump.php --wiki pwikiwiki /home/reception/arkcls-wiki-20180117.xml on mw1

2018-01-18

 * 17:54 Reception123: re-enabled puppet on db3
 * 17:54 Reception123: moved databases to db3 and dropped on db2 dariawikiwiki viagroupiawiki truecapitalistwiki emulationwiki cpiwiki ylscwiki hirapediawiki whentheycrywiki utamacrosswiki sumroletaericwiki
 * 17:30 Reception123: disabled puppet on db3

2018-01-16

 * 06:37 Reception123: renewed phab.miraheze.wiki on misc1

2018-01-09

 * 06:49 Reception123: upgraded Phabricator

2018-01-08

 * 06:02 Reception123: restarted Phabricator daemons

2018-01-07

 * 02:33 PuppyKun: rebooted mw2 to fix puppet hangs?

2018-01-06

 * 16:19 Reception123: reinstalling bacula1 (size change; backups not running)

2018-01-05

 * 01:34 PuppyKun: MariaDB [centralauth]> update globaluser set gu_hidden="suppressed" where gu_id in (9192,9193,9188,9190,13117,13118,13119,13140,12407,12405,12404,11327,12293,11296,11292,11280,11481,11716,11717,11196,11197,11198,11199,11201,11202,11203,11204,11205); Query OK, 28 rows affected (0.01 sec)

2018-01-04

 * 18:23 Reception123: sudo -u www-data php importImages.php --wiki dariawikiwiki --search-recursively /home/reception/images on mw1
 * 08:41 Reception123: re-reinstall test1 on debian 9

2018-01-03

 * 16:47 Reception123: reinstalling test1 on debian 9

2018-01-02

 * 15:13 Reception123: started jobrunner on mw2 (moved from test1)
 * 15:09 Reception123: restarted phabricator daemons
 * 08:24 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki test1wiki on mw*

2018-01-01

 * 23:26 PuppyKun: renewed publictestwiki.com
 * 15:05 Reception123: cleared /tmp of mw2 (full)
 * 09:08 Reception|away: sudo -u www-data php importDump.php --wiki dariawikiwiki /home/reception/DariaWikiDump_12.31.17.xml on mw2

Information
All times are in UTC+0/GMT.

Archives: 2015, 2016, 2017