Tech:Server admin log/2018

2017-05-29

 * 15:32 Southparkfan: stopped/started dovecot and removed user account 'john' on misc1

2017-05-28

 * 19:07 Reception123: > UPDATE revision SET rev_user = '10' WHERE rev_user_text = 'IJzeren Jan'; on isvwiki
 * 18:39 Reception123: SET rev_user = '22' WHERE rev_user_text = 'Siska'; on bpwiki
 * 18:39 Reception123: SET rev_user = '8' WHERE rev_user_text = 'Rachmat04'; on bpwiki

2017-05-27

 * 17:25 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php updateSpecialPages.php --wiki bpwiki

2017-05-26

 * 06:37 Reception|away: ran rebuildall.php --wiki bpwiki (tried to fix contribs issue)

2017-05-24

 * 17:16 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 17:15 Reception123: DELETED FROM cw_wikis ruvowikiwiki sambodiawiki sample1113wiki sbbehzadiwiki scatranslatorswiki scbcwiki sdeuropewiki (DP)
 * 17:08 Reception123: DELETE FROM cw_wikis rainfallwiki rcprobusitwiki readingclubwiki reizowiki reriawiki resetwiki revisionhistorymodelwiki rhythmwiki robloxscripterswiki rudinwiki (DP)
 * 17:00 Reception123: DELETED FROM cw_wikis omwiki openconstitutionwiki passtestwiki pavelwiki pittawiki planeteswiki popupwiki professionaldevelopmentwiki rafambienterowiki (DP)
 * 16:16 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 16:15 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'wikirailwiki';
 * 16:15 Reception123: DELETEROM cw_wikis WHERE wiki_dbname = 'libertywiki';
 * 16:13 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'metaautonomywiki';
 * 14:31 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php updateArticleCount.php --wiki isvwiki --update
 * 14:20 Reception123: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki armsinstitutewiki --full > /home/reception/armsinstitute.xml
 * 14:18 Reception123: updated local email from "madciclistawiki" to match "metawiki" for Jlgallego

2017-05-21

 * 18:44 John: dropping databases deleted previously
 * 18:36 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki on mw1
 * 18:33 Reception123: > reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki wikicanadawiki --full > /home/reception/wikicanada.xml
 * 18:17 Reception123: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki isvwiki /home/reception/isvorainorg_w-20150809-history.xml/isvorainorg_w-20150809-history.xml
 * 16:14 Reception123: reception@mw1:~$ sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 16:12 Reception123: DELETE FROM cw_wikis WHERE wiki_dbname = 'rtwiki'; (requested by revi)
 * 16:12 Reception123: DELETE FROM cw_wikis WHERE wiki_dbname = 'wikicanadawiki'; (LTA)
 * 05:51 Reception123: sudo -u www-data php importImages.php --wiki nenawikiwiki --search-recursively /home/reception/nenawiki1 on mw2

2017-05-20

 * 19:28 revi: extend length of Amanda ban to indefinite, just logging
 * 19:00 Reception123: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki nenawikiwiki /home/reception/NENAWiki-20170520182214.xml
 * 10:46 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 10:38 Reception123: forked Reception123/CustomHeader
 * 08:16 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 08:15 Reception123: DELETED FROM cw_wikis medaidwiki menkoiwiki momnyangwiki msswiki musictabswiki myclubwiki nadot2017wiki neuromodulationwiki newcrewwiki nighthawkwiki occultwikiwikawiki olliewiki (DP)
 * 08:07 Reception123: DELETED FROM cw_wikis hostelworldisdangerouswiki ilockedwiki inmomentappwikiwiki inmomentwiki interhistorypediawiki internalmedicinewiki israelianswerswiki jestermaxddwiki joeygeenwiki kutlaswiki lbhealthwiki locograndewiki lsferreirawiki medaidwiki (DP)
 * 07:55 Reception123: DELTED FROM cw_wikis flowfusionwiki fundacjapileckiegowiki genspediawiki geschichtinemwiki ghgwiki glafoxwiki globalrcruwiki globalwiki gvorsterwiki hattiesburgpbiswiki hausprojektwiki hertapewiki hfhofficewiki (DP)
 * 05:32 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php updateArticleCount.php --wiki ayrshirewiki --update
 * 05:29 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 05:28 Reception123: DELETE FROM cw_wikis WHERE wiki_dbname = 'lymernilwiki';

2017-05-17

 * 16:37 Reception|away: reception@mw1:~$ sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 16:36 Reception|away: > DELETE FROM cw_wikis WHERE wiki_dbname = 'arasuithielwiki';
 * 04:36 revi: revi@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki bchwiki --full > /home/revi/bchwiki20170517.xml

2017-05-14

 * 16:50 Reception123: reception@mw1:/srv/mediawiki/w/extensions/MirahezeMagic/maintenance$ sudo -u www-data php manageInactiveWikis.php --wiki metawiki --warn --close
 * 16:45 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 06:12 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-05-13

 * 19:46 John: cleared all storeconfigs for "bacula1" node
 * 18:25 John: continuous problems with bacula software wise after recent job restructuring, reinstalling bacula1
 * 18:13 Reception123: deleted random espiral.org.csr from /mnt/mediawiki-static
 * 17:16 Reception123: sudo -u www-data php dumpBackup.php --wiki ayrshirewiki --full > /home/reception/ayrshirewiki13052017.xml on mw1
 * 17:10 Reception123: deleted mediawiki-extensions-NewSignupPage repo as unneeded
 * 10:16 John: rebooted mw2
 * 08:31 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 07:44 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-05-10

 * 19:03 imbophil: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on MW1 and MW2
 * 13:39 Reception|away: sudo -u www-data php dumpBackup.php --wiki scruffywiki --full > /home/reception/scruffywiki10052017.xml on mw1

2017-05-08

 * 19:15 imbophil: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on MW1 and MW2
 * 14:19 Reception123: > UPDATE page SET page_content_model = "wikitext" WHERE page_content_model = "flow-board"; on wikicanadawiki
 * 08:14 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 06:35 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-05-07

 * 14:17 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-05-06

 * 18:57 John: upgrade phabricator
 * 18:00 revi: revi@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki testwiki --full > /home/revi/testwiki20170506.xml
 * 17:55 revi: revi@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki librewiki --full > /home/revi/librewiki20170506.xml
 * 17:50 revi: revi@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki maiasongcontestwiki --full > /home/revi/maiasongcontestwiki20170506.xml
 * 17:47 revi: revi@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki jayuwikiwiki --full > /home/revi/jayuwiki20170506.xml
 * 17:39 Reception123: nice 10 for below
 * 17:39 Reception123: sudo -u www-data php dumpBackup.php --wiki allthetropeswiki --full > /home/reception/allthetropes20170506.xml on mw2
 * 17:35 revi: revi@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki metawiki --full > /home/revi/metawiki20170506.xml
 * 17:26 revi: sudo -u www-data php dumpBackup.php --wiki reviwiki --full > /home/revi/reviwiki20170507.xml (nobody might care but I executed it)
 * 10:17 John: manually ran failed GlobalRename job
 * 06:36 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-05-03

 * 17:16 John: deleted ganglia and acme bacula pools
 * 16:07 revi: Disabled phabricator account Amanda, temporary: 2 months.
 * 16:00 John: made some security tasks public in line with reasonable disclosure (1 misc, 1 intended design and 1 resolved security task)
 * 15:51 John: changed view policy for T1747

2017-05-01

 * 14:00 John: upgrading phab
 * 13:24 John: create bot_passwords on centralauth
 * 13:17 John: created echo_unread_wikis table on metawiki
 * 11:07 Reception123: temporarily added google HTML verification to /srv/mediawiki
 * 11:03 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php deleteBatch.php --wiki bigforestwiki /home/reception/nuke.txt
 * 10:27 Reception123: reception@mw1:~$ sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 10:25 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname ='guarothwiki';
 * 09:08 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'dtswiki';

2017-04-28

 * 18:55 Reception123: sudo -u www-data php dumpBackup.php --wiki scruffywiki --full > /home/reception/scruffywiki28042017.xml

2017-04-23

 * 17:59 John: deleted Miraheze Widgets GitHub repo
 * 08:40 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 07:48 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 05:38 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-04-22

 * 10:23 Reception123: reception@mw1:/srv/mediawiki/w/extensions/MirahezeMagic/maintenance$ sudo -u www-data php manageInactiveWikis.php --wiki metawiki --warn --close

2017-04-20

 * 17:33 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php deleteBatch.php -u Reception123 --wiki testwiki home/reception/delete.txt (and more deletions to come)

2017-04-19

 * 10:56 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'bereawiki';

2017-04-18

 * 20:53 John: removed PrivateSettings.php from private repo
 * 16:14 John: moved uptime robot from sysadmin email account to operations + added staff as alert contact
 * 15:44 John: ./bin/files integrity --compute --all + phab upgrade
 * 06:27 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 06:03 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-04-17

 * 14:18 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki delete1wiki on mw* (testing extension)
 * 09:08 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki (remaining undefined magic word)
 * 08:36 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki metawiki on mw*

2017-04-16

 * 16:41 John: changed task edit policy
 * 06:05 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-04-15

 * 11:36 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-04-14

 * 20:28 PuppyKun: rebooting cp2 "Failed to get D-Bus connection: No such file or directory"
 * 13:56 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*
 * 04:45 Reception|away: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki calexitwiki --full > /home/reception/calexitwiki14042017.xml
 * 00:29 PuppyKun: ndkilla@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php deleteBatch.php --wiki scruffywiki --r="https://phabricator.miraheze.org/T1660" /home/ndkilla/scruffydelete

2017-04-11

 * 22:53 John: deleted binlogs

2017-04-10

 * 17:48 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 17:46 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'deltaquadtestwiki'; (LTA)
 * 17:46 Reception123: DELETED FROM cw_wikis delete[*-6]wiki

2017-04-09

 * 17:41 PuppyKun: MariaDB [phabricator_calendar]> update calendar_event set editPolicy="users" where id=21; and canceled the event
 * 17:35 PuppyKun: stripped phabricator MFA from NDKilla
 * 14:51 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php deleteBatch.php --wiki bigforestwiki /home/reception/nuke.txt
 * 14:40 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'scruffy2wiki';
 * 09:29 Southparkfan: restarted phd

2017-04-07

 * 16:53 John: forced umount on mw1
 * 16:35 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki modularwiki --full > /home/reception/modularwiki07042017.xml
 * 16:34 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki scruffywiki --full > /home/reception/scruffywiki07042017.xml

2017-04-05

 * 14:05 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 14:01 Reception123: DELETED FROM cw_wikis breakthegamewiki cisowiki comedyspaceshowwiki compendiumwiki dakadwiki datadefswiki deguwiki ep4wiki exerionwiki ezdmfwiki fabiowiki facebookhostwiki (DP)
 * 13:53 Reception123: reception@mw1:/srv/mediawiki/w/extensions/MirahezeMagic/maintenance$ sudo -u www-data php manageInactiveWikis.php --wiki metawiki --warn --close
 * 13:47 Reception123: DELETED FROM cw_wikis 3kwiki abilityandmeaningwiki aegyptiacawiki afswiki agrartechnikwiki agrocitewiki antitimerwiki aucelewiki aurcusonlinewiki authentiqwiki berlinwiki blackwaterregionallibrarywiki bleaguewiki borilowiki (DP)

2017-04-04

 * 14:27 PuppyKun: ndkilla@misc1:~$ sudo service icingabot restart && sudo service adminbot restart
 * 05:28 Reception|away: removed spam from cw_wikis+declined reqs

2017-04-03

 * 20:07 John: finally closed a task by using the database because edit policy was way too restrictive
 * 16:32 Reception|away: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki modularwiki /home/reception/localhost_muff-20130102-history.xml
 * 16:21 Reception|away: removed spam from cw_requests
 * 16:10 Reception|away: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php importImages.php --wiki modularwiki --search-recursively /home/reception/images

2017-04-02

 * 19:03 Southparkfan: restarted php5-fpm process on mw1 and mw2

2017-03-31

 * 16:52 John: upgraded phabricator
 * 16:28 John: dropped modularwiki
 * 16:07 John: reclaimed more space on db2

2017-03-28

 * 21:02 PuppyKun: ndkilla@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php updateArticleCount.php --wiki bgowiki --update
 * 15:34 PuppyKun: ndkilla@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php deleteBatch.php --wiki bgowiki --r="deleteBatch.php: Mass deletion of pages in Category:Pages_flagged_for_deletion" --u="NDKilla" /home/ndkilla/pages-to-delete2.txt"
 * 15:24 PuppyKun: ndkilla@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php deleteBatch.php --wiki bgowiki --r="deleteBatch.php: Mass deletion of pages in Category:Pages_flagged_for_deletion" --u="NDKilla" /home/ndkilla/pages-to-delete.txt"
 * 05:29 Reception|away: removed spam from cw_requests

2017-03-27

 * 16:36 Reception|away: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki bereawiki /home/reception/BereaWiki-20170318210125.xml

2017-03-26

 * 19:28 Southparkfan: purged several binlogs on db2
 * 08:39 Reception123: removed spam from cw_requests

2017-03-25

 * 20:14 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php rebuildrecentchanges.php --wiki modularwiki
 * 20:08 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki modularwiki /home/reception/localhost_muff-20130102-history.xml
 * 15:26 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php deleteBatch.php --wiki modularwiki /home/reception/deleted.txt
 * 10:19 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw* (run again)
 * 10:03 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki metawiki on mw* (was not rebuild after CW LC changes)
 * 08:59 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-03-24

 * 19:41 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php rebuildall.php --wiki metawiki ( not updating for a few days)
 * 19:36 Reception123: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php importImages.php --wiki modularwiki --search-recursively /home/reception/muffwigglerimages
 * 19:33 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 19:32 Reception123: DELETE FROM cw_wikis quamplexitywiki qwwiki refugeepathwayswiki sandeepucreatewiki secondcirclewiki sibcolombiawiki steellegionswikiwiki storyofaryonwiki technoteswiki ujimawiki vmbrawiki wikibharalwiki wikichineserockwiki wikinalyticswiki yadanbiadwiki (DP)
 * 19:21 Reception123: DELETED FROM cw_wikis itsmwikiitwikiwiki jaunepluswiki jjffjjwiki liftwiki liquidcablewiki lludrigawiki manyethriwiki masterwiki mpatwiki munankerdurshcilwiki notlandswiki offensivewiki plantwiki pnatcwiki ppluswiki (DP)
 * 19:11 Reception123: ... fairytailwiki falkewiki gastronomicapediawiki gbnavaparawiki geekkidswiki ggukvolunteerswiki girardfxwiki guitartopconstructionwiki i3wikiwiki interwikiwiki (DP)
 * 19:11 Reception123: DELETED FROM cw_wikis dddandtwikiwiki demokraciawiki diepiowiki dpauldwiki dsdocswiki dswiki ezybfowiki
 * 18:57 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'leagueswiki'; (LTA)
 * 18:57 Reception123: DELETED FROM cw_wikis academywiki adrianwiki alphadekelwiki anitrapavkawiki apexwiki augustinianumwiki b3wwiki brocktoncatholicwiki brunurbwiki cbmediawiki creativeartswiki ctrlaltdelpovertywiki cubeonwiki (DP)
 * 17:43 Reception123: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki modularwiki /home/reception/wikimuffwigglercom-20121222-history.xml
 * 06:10 Reception|away: removed cw_requests spam

2017-03-23

 * 20:24 John: importing bp.org images (again)
 * 19:46 John: restart jobrunner
 * 18:22 John: running "CREATE INDEX ar_usertext_timestamp ON archive (ar_user_text,ar_timestamp);" on all wikis
 * 16:09 PuppyKun: ndkilla@misc2:~$ sudo service redis-server restart (non-0 exit code)

2017-03-22

 * 21:31 PuppyKun: ndkilla@misc1:~$ sudo service icingabot restart
 * 19:50 Reception|away: removed spam from cw_requests
 * 19:06 John: moved uncommitted code to /home/southparkfan/ from /srv/mediawiki/w

2017-03-21

 * 17:34 Reception|away: > DELETE FROM cw_wikis WHERE wiki_dbname = 'wiki'; (created in error; pointless)

2017-03-18

 * 16:12 Reception123: deleted spam wiki requests
 * 15:14 Reception123: removed spam from cw_requests as it spammed RequestQueue
 * 15:11 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 15:10 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'wikihubwiki'; and wikisciencewiki (LTA)
 * 11:59 Reception123: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki

2017-03-17

 * 17:35 Reception|away: reception@mw2:/srv/mediawiki/w/extensions/MirahezeMagic/maintenance$ sudo -u www-data php manageInactiveWikis.php --wiki metawiki --warn --close
 * 16:55 Southparkfan: restarted ganglia-monitor on parsoid1

2017-03-16

 * 21:21 John: rolling restart of ganglia-monitor on servers

2017-03-14

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

2017-03-12

 * 18:49 John: creating pr_index table on all wikis
 * 17:59 John: importing images to bpwiki

2017-03-10

 * 17:20 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki meeusenwiki --full > /home/reception/meeusenwiki100302017.xml
 * 17:13 Southparkfan: hard reboot cp2, puppet fails, unresponsive to /usr/sbin/service and reboot commands

2017-03-07

 * 17:58 John: phabricator updated

2017-03-06

 * 18:04 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 18:01 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'wikiyangtzewiki'; (LTA)
 * 18:00 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'americanopediawiki'; (LTA)
 * 17:59 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'internalwiki'; (IRC request)

2017-03-05

 * 16:29 Southparkfan: deleted sagan4wiki
 * 16:01 Southparkfan: performing database maintenance on sagan4wiki
 * 11:59 Reception123: rebuilt recentchanges on Meta (testing something)

2017-03-04

 * 20:08 Reception123: removed spam from cw_requests (requests queue is flooded)
 * 16:25 Southparkfan: deleted southparkfan{2..5}wiki
 * 16:25 imbophil: sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on MW1 and MW2
 * 16:19 Southparkfan: rebuilt RC on metawiki

2017-03-03

 * 18:31 John: umount /mnt/mediawiki-static on mw1
 * 18:19 John: rebooting mw1, mount issues
 * 15:39 Southparkfan: dropped southparkfan{2..9}wiki
 * 15:30 Southparkfan: rebuilding recentchanges on metawiki
 * 14:38 Southparkfan: restarted phd
 * 13:46 Reception123: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php dumpBackup.php --wiki anothertimeline2120wiki --full > /home/reception/anothertimeline2120.xml & reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki particracywikiwiki /home/reception/anothertimeline2120wiki.xml
 * 13:32 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php rebuildall.php --wiki bigforestwiki and jayuwiki

2017-03-02

 * 23:53 PuppyKun: ndkilla@misc1$ service ircrcbot restart

2017-03-01

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

2017-02-25

 * 15:08 Reception123: removed spam from cw_requests

2017-02-24

 * 20:30 Southparkfan: upgraded piwik to 2.17.1, ran archive script
 * 20:08 Southparkfan: restarted ganglia daemon on db2
 * 18:35 John: stripped 2FA from phabricator account for John
 * 17:43 Reception123: sudo -u www-data php rebuildall.php --wiki lothuialethwiki and arasuithielwiki on mw1
 * 17:33 Reception123: DELETE FROM cw_wikis WHERE wiki_dbname = 'zgradetenniswiki'; (requested)
 * 17:02 Reception|away: sudo -u www-data php dumpBackup.php --wiki zgradetenniswiki --full > /home/reception/zgradetennis.xml on mw1

2017-02-23

 * 20:08 John: dropping databases in deleted.dblist
 * 19:57 Reception|away: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 19:56 Reception|away: DELETE FROM cw_wikis WHERE wiki_dbname = 'freedomopennesswiki'; (DP, making db space)
 * 17:50 John: phabricator upgraded
 * 17:49 John: upgrading phabricator

2017-02-22

 * 19:25 John: attached all unattached global accounts
 * 07:25 Reception|away: removed spam from cw_requests

2017-02-21

 * 19:32 Reception|away: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 19:31 Reception|away: DELETE FROM cw_wikis (mainwiki nemesiswiki theinternetemowiki)
 * 16:34 PuppyKun: restarted jobrunner on mw1

2017-02-20

 * 23:46 John: moved metawiki back to db2 - CreateWiki limitations
 * 20:34 John: rebooting mw2
 * 18:23 John: setting centralauth and loginwiki databases to read only
 * 17:31 John: restarted jobrunner
 * 17:02 Reception123: DELETED FROM cw_wikis (elementswiki, picturepediawiki, mountainpediawiki) (ban evasion; community imposed)
 * 15:34 John: php attachAccount.php --wiki loginwiki --userlist /home/johnflewis/list [attaching JBridgwood to global account]
 * 07:20 Reception|away: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php updateArticleCount.php --wiki tharranarothwiki --update (didn't work the first time)

2017-02-19

 * 15:00 Reception|away: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php updateArticleCount.php --wiki tharranarothwiki

2017-02-18

 * 21:28 John: killing icinga-bot, icinga changes coming up
 * 08:19 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 08:18 Reception123: DELETED FROM cw_wikis civicvwiki dadisawikiwiki edwardravenwoodwiki gamestartwiki gibswiki ideatwiki lastpodcastwiki micropediawiki portalwiki psikiwiki realmswiki recherchesdocumentaireswiki retrowikiwiki securitieswiki senadowiki singstarwikiwiki tanodswiki testdocumentationwiki witsacademywiki worldnewswiki (DP)
 * 07:54 Reception123: /srv/mediawiki/w/maintenance$ sudo -u www-data php rebuildLocalisationCache.php --wiki extloadwiki on mw*

2017-02-17

 * 17:55 John: parsoid updated
 * 17:22 John: upgrading parsoid involving breaking changes

2017-02-15

 * 16:54 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 16:52 Reception123: DELETED FROM cw_wikis walthamstowlabourwiki wikielectronicawiki wikihuertawiki wikingswiki wikiniscemiwiki wikiturawiki writinggallerywiki wsudmswiki ytwiki (DP)
 * 16:44 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 16:42 Reception123: DELETE FROM cw_wikis topchoicewiki trtitreprovisoirewiki tsaristwiki turkcesozlukwiki tyrolmountainswiki ultracomboswiki unibloxwiki urho3dwiki valentinawikiwiki vandwellingwiki velhocoiotewiki villanoswiki votcwiki voyagewiki vozquadwiki vrgowiki (DP)
 * 16:25 Reception123: sudo -u www-data php /srv/mediawiki/w/extensions/MirahezeMagic/maintenance/removeDeletedWikis.php --wiki metawiki
 * 16:21 Reception123: DELETED FROM cw_wikis taylorwiki tdkwwikiwiki testelitewiki testforspoonwiki thedangeloteamwiki thefuturewiki thepeoplegeekwiki thestarwarsarchiveswiki theworldofvailnoffwiki titreprovisoirewiki todosobreukwiki
 * 15:47 Reception123: > DELETE FROM cw_wikis WHERE wiki_dbname = 'atheiwiki' and ircaffiliateswiki ;

2017-02-14

 * 17:12 John: converted misc* to puppet agent
 * 17:08 John: converted mw* to puppet agent
 * 16:56 John: converted db* to puppet agent
 * 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