Tech:Server admin log/2018

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.