Tech:Server admin log/2018

2017-02-14

 * 16:52 John: converted cp* to puppet agent -- we really need to upgrade cp2
 * 16:50 John: converted bacula1 to puppet agent
 * 16:00 John: converted ns1.miraheze.org to a puppet agent
 * 12:45 John: changed viewPolicy on two tickets via mysql

2017-02-13

 * 21:08 labster: restarted jobqueue
 * 19:34 John: rebooting mw2, unresponsive

2017-02-12

 * 17:23 John: restarted IRCRC bot about 4 days of its being down

2017-02-11

 * 20:15 Reception123: /srv/mediawiki/w/maintenance$ sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 19:38 Reception123: removed threats/harassment from 4 wiki requests (sql.php)
 * 11:25 Reception123: /srv/mediawiki/w/maintenance$ sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 11:05 Reception123: reception@mw1:/srv/mediawiki/w/extensions/MirahezeMagic/maintenance$ sudo -u www-data php manageInactiveWikis.php --wiki metawiki --warn --close

2017-02-10

 * 19:08 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php deleteBatch.php /home/reception/testpage.txt --wiki claneuphoriawiki --r Not_responsive_._ Error. --u Reception123
 * 14:27 Reception123: moved bigforestwikipediawiki files to bigforeswiki (mediawiki-static)
 * 09:21 Reception123: ran same again after restore fail
 * 09:20 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php deleteBatch.php /home/reception/testpage.txt --wiki claneuphoriawiki --r Not responsive. Gives error. --u Reception123

2017-02-09

 * 20:01 imbophil: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw1 and mw2

2017-02-08

 * 16:09 John: renamed bigforestwikipediawiki -> bigforestwiki

2017-02-07

 * 11:03 revi: at mw1.
 * 11:03 revi: sudo -u www-data php /srv/mediawiki/w/maintenance/importDump.php --wiki unjeongwiki /home/revi/unjungwiki_dump_20161016.xml

2017-02-05

 * 20:26 imbophil: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on MW1 and MW2

2017-02-04

 * 09:17 Reception123: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php /srv/mediawiki/w/maintenance/importImages.php --wiki bigforestwikipediawiki --search-recursively /home/reception/images

2017-02-03

 * 19:08 John: phabricator upgraded - new favourites menu
 * 19:05 John: upgrading phabricator
 * 17:45 Reception123: sudo -u www-data php importDump.php --wiki bigforestwikipediawiki /home/reception/dump1.xml on mw2

2017-02-02

 * 17:36 John: cleared /srv/mediawiki/{w|config} on mw1 for refresh - long puppet runs caused by inconsistencies in git

2017-01-31

 * 15:06 John: restarted MySQL on db3 to have new tmp directory change take place
 * 14:55 John: cleared /tmp/ on db3

2017-01-28

 * 10:05 Reception|away: sudo -u www-data php importDump.php --wiki bigforestwikipediawiki /home/reception/dump.xml on mw2

2017-01-27

 * 19:34 John: dropped help_{topic,relation,keyword,category} on allthetropeswiki
 * 19:30 John: dropped plugin, ndb_binlog_index and slow_log on allthetropeswiki

2017-01-23

 * 12:08 Southparkfan: restarted ganglia daemon on all servers (excluding misc2/db3)

2017-01-22

 * 21:03 John: dropped attwiki and phabricator databases on db2
 * 19:11 John: killing apache on misc1, easiest way to stop phab being writable

2017-01-21

 * 14:22 Reception123: reception@mw1:/mnt/mediawiki-static/dumps/2016$ sudo -u www-data rm -rf maiasongcontestwiki.tgz
 * 14:21 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf bgowiki-2016-07-26-full.xml
 * 14:17 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf sterbalssundrystudieswiki24082016.zip
 * 14:17 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf lexique.xml
 * 14:16 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf poserdazfreebiesorainorg_w-20150808-history.xml
 * 14:16 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf permanentfuturelabwiki.xml
 * 14:16 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf izanagiwiki-2016-03-15.xml.gz
 * 14:16 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf izanagiwiki-20160216-full.xml
 * 14:15 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf softwarecrisiswiki-2016-05-03.xml
 * 14:15 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf szkwiki.xml.gz
 * 14:15 Reception123: reception@mw1:/mnt/mediawiki-static/dumps$ sudo -u www-data rm -rf bgowiki-2016-05-03.xml

2017-01-18

 * 17:41 John: disabled innodb_adaptive_hash_index

2017-01-13

 * 17:54 John: updated phabricator
 * 17:37 imbophil: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on MW1 and MW2

2017-01-11

 * 15:06 John: rm#'d /tmp on db2

2017-01-10

 * 20:35 John: DELETE FROM user_email WHERE id = "347";
 * 20:28 John: DELETE FROM user_externalaccount WHERE id = "368";

2017-01-07

 * 05:50 PuppyKun: MariaDB [trexwiki]> delete from user_groups where ug_user=30; query ok, 1 row affected. Remove `Ceo` from `IT Office` a non-existent user and a globally locked account

2017-01-06

 * 23:59 labster: restarted jobrunner
 * 13:39 Southparkfan: rebooting cp2, unresponsive to NRPE, sshd unresponsive, serial console not available due to lack of memory

2017-01-04

 * 19:56 imbophil: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on Mw1 and Mw2

2017-01-02

 * 21:59 John: running SQL on all wikis
 * 21:09 John: fully deleted 19 wikis
 * 21:00 John: deleting wikicanadawiki

2017-01-01

 * 19:16 John: installed php5-apcu on misc1 for phabricator
 * 19:08 John: phabricator upgraded
 * 19:07 John: phabricator upgrades coming
 * 15:01 Reception123: srv/mediawiki/w/maintenance sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

Information
All times are in UTC+0/GMT.

Archives: 2015, 2016