Tech:Server admin log/2019

2019-01-11

 * 05:36 paladox: [03:10:04] <+paladox>	!log repool mw3
 * 05:36 paladox: [02:50:04] <+paladox>	!log repool mw2
 * 05:36 paladox: [02:27:34] <+paladox>	!log repooling mw1 and depool mw2 and mw3
 * 05:35 paladox: [00:36:33] <+MacFan4000>	!log changing default branch for @miraheze/mediawiki to REL1_32
 * 05:35 paladox: [00:14:16] <+paladox>	!log upgrading all wiki's to 1.32
 * 05:35 paladox: [00:10:15] <+paladox>	!log upgrading metawiki to 1.32
 * 05:35 paladox: [00:06:41] <+paladox>	!log putting all wiki's into read only - pending upgrade to 1.32
 * 05:35 paladox: [23:29:43] <+paladox>	!log depool mw1
 * 00:06 paladox: putting all wiki's into read only - pending upgrade to 1.32

2019-01-10

 * 23:29 paladox: depool mw1
 * 18:39 paladox: Renaming svwiki to psl631testwiki per T3967

2019-01-09

 * 01:40 Southparkfan: dropped southparkfan[2-5]wiki wikis
 * 01:34 Southparkfan: executed once again
 * 01:19 Southparkfan: executed previous queries again
 * 01:16 Southparkfan: MariaDB [metawiki]> delete from echo_notification where notification_timestamp like '20190109%' and notification_user = 2;
 * 01:16 Southparkfan: MariaDB [metawiki]> delete from echo_event where event_type = 'wiki-creation';
 * 00:18 Southparkfan: testing changes in CreateWiki on mw1

2019-01-08

 * 01:50 MacFan4000: deleting iwwiki

2019-01-07

 * 23:46 paladox: sudo chmod -R 0770 /etc/puppetlabs/puppet/ssl-keys
 * 23:45 MacFan4000: (paladox) sudo chmod 0770 /etc/puppetlabs/puppet/ssl-keys on puppet1
 * 23:43 paladox: sudo chmod 0700 /etc/puppetlabs/puppet/ssl-keys on puppet1
 * 22:31 MacFan4000: macfan@mw1:/$ sudo -u www-data php /srv/mediawiki/w/maintenance/dumpBackup.php --wiki tesminadventureswiki --full --output gzip:/mnt/mediawiki-static/dumps/tesminadventureswiki.xml.gz
 * 12:29 MacFan4000: DELETE FROM mw_namespaces WHERE ns_dbname='xedwiki' AND ns_namespace_name='Greek_talk'; (per stewards noticeboard)
 * 12:29 MacFan4000: DELETE FROM mw_namespaces WHERE ns_dbname='xedwiki' AND ns_namespace_name='Greek'; (per stewards noticeboard)
 * 12:28 MacFan4000: DELETE FROM mw_namespaces WHERE ns_dbname='xedwiki' AND ns_namespace_name='English_talk'; (per stewards noticeboard)
 * 12:28 MacFan4000: DELETE FROM mw_namespaces WHERE ns_dbname='xedwiki' AND ns_namespace_name='English'; (per stewards noticeboard)

2019-01-06

 * 17:00 paladox: running lc on mw* and test1
 * 14:48 paladox: importing mw dump on bigcartoonwiki (on mw1)
 * 14:45 paladox: importing mw dump for nowchesswiki
 * 14:06 paladox: /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/maintenance/sql.php /srv/mediawiki/w/extensions/GlobalBlocking/globalblocking.sql on mw3
 * 04:09 paladox: repool mw1
 * 04:04 paladox: delete from mw_namespaces where ns_dbname = 'metawiki' and ns_namespace_name = 'TestHello_talk';
 * 04:04 paladox: delete from mw_namespaces where ns_dbname = 'metawiki' and ns_namespace_name = 'TestHello';
 * 00:55 paladox: running lc on mw*

2019-01-05

 * 17:10 paladox: depool mw1
 * 01:56 paladox: upgrading phabricator on misc4

2019-01-04

 * 20:44 Southparkfan: stop jobrunner on mw3
 * 20:32 Southparkfan: install iftop on mw[1-3]
 * 00:26 Southparkfan: ran update cw_requests set cw_user = 44876 where cw_id = 6919;

2019-01-03

 * 23:48 paladox: running update set commands on db4 to fix cw_user for requests that have the wrong id.
 * 23:36 paladox: update cw_requests set cw_user = 44922 where cw_dbname = 'giantesswiki'; on db4
 * 23:35 paladox: update cw_requests set cw_user = 44929 where cw_dbname = 'dawsontechboothwiki'; on db4
 * 23:28 paladox: ALTER TABLE cw_comments MODIFY cw_comment_user INT(10) NOT NULL; on db4
 * 23:27 paladox: ALTER TABLE cw_requests MODIFY cw_user INT(10) NOT NULL; on db4
 * 16:04 paladox: sudo -u www-data php scriptMira2.php --wiki=nonciclopediawiki on mw1
 * 15:49 paladox: sudo -u www-data /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist maint*/manageJobs.php --action=delete --type="LocalGlobalUserPageCacheUpdateJob" on mw1
 * 04:26 paladox: sudo -u www-data /usr/bin/nice -19 /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist maint*/manageJobs.php --action=delete --type="LocalGlobalUserPageCacheUpdateJob" on mw1
 * 03:46 paladox: creating MacFan4000 on icingaweb2
 * 03:40 paladox: creating Voidwalker on icingaweb2
 * 02:38 paladox: recreating namespace Guide and Guide_talk for wiki paliwikiwiki
 * 02:33 paladox: delete from mw_namespaces where ns_dbname = 'paliwikiwiki' and ns_namespace_id = 3001; on db4
 * 02:33 paladox: delete from mw_namespaces where ns_dbname = 'paliwikiwiki' and ns_namespace_id = 3000; on db4
 * 01:15 paladox: MatomoAnalytics::addSite( 'untrashwiki' ) on mw1

2019-01-02

 * 00:15 paladox: update mw_namespaces set ns_aliases = '["Image_talk"]' where ns_dbname = 'metawiki' and ns_namespace_name = 'File_talk'; on db4
 * 00:14 paladox: update mw_namespaces set ns_aliases = '["Image"]' where ns_dbname = 'metawiki' and ns_namespace_name = 'File'; on db4

2019-01-01

 * 21:17 paladox: repool mw1
 * 21:07 paladox: delete all namespaces cdb files on mw*
 * 18:00 Reception123: MariaDB [phabricator_herald]> UPDATE herald_rule SET isDisabled = '1' WHERE id = '10'; (inactive user)
 * 17:59 Reception123: MariaDB [phabricator_herald]> UPDATE herald_rule SET isDisabled = '1' WHERE id = '28'; (inactive user)
 * 16:23 MacFan4000: macfan@mw3:~$ sudo service jobrunner restart && sudo service jobchron restart
 * 16:21 MacFan4000: running jobs everywhere in a screen on mw1
 * 16:19 paladox: running scriptMira2.php on mw1 (it creates a local account on metawiki and loginwiki)
 * 15:05 paladox: run UPDATE globaluser SET gu_email = 'xxx' WHERE gu_name = 'Revenant Lord'; (where xxx is a email)
 * 15:01 paladox: depool mw1