Tech:Server admin log

From Meta
Jump to navigation Jump to search

2020-01-18[edit | edit source]

  • 17:09 paladox: that script is adding "urlshortener-create-url" to * for all wikis
  • 17:08 paladox: root@mw1:/home/paladox# ./foreachwikiindblist /srv/mediawiki/dblist/all.dblist
  • 16:58 paladox: delete from mw_permissions where perm_dbname = '131parkhurstwiki' and perm_group = "all.dblist";
  • 15:44 paladox: delete from mw_permissions where perm_dbname = '131parkhurstwiki' and perm_group = "\\*" LIMIT 1;
  • 15:44 paladox: delete from mw_permissions where perm_dbname = '00sretrolivingwiki' and perm_group = "\\*" LIMIT 1;
  • 15:44 paladox: delete from mw_permissions where perm_dbname = '131parkhurstwiki' and perm_group = "\\*" LIMIT 1;
  • 15:44 paladox: delete from mw_permissions where perm_dbname = '131parkhurstwiki' and perm_group = "\\*" LIMIT 1;
  • 15:44 paladox: delete from mw_permissions where perm_dbname = '00sretrolivingwiki' and perm_group = "\\*" LIMIT 1;
  • 15:43 paladox: delete from mw_permissions where perm_dbname = '00sretrolivingwiki' and perm_group = "\*" LIMIT 1;
  • 15:43 paladox: delete from mw_permissions where perm_dbname = '00sretrolivingwiki' and perm_group = '\*' LIMIT 1;
  • 15:43 paladox: delete from mw_permissions where perm_dbname = '00sretrolivingwiki' and perm_group = '+' LIMIT 1;
  • 15:43 paladox: delete from mw_permissions where perm_dbname = '00sretrolivingwiki' and perm_group = '+' LIMIT 1;
  • 15:43 paladox: delete from mw_permissions where perm_dbname = '1920swiki' and perm_group = '+' LIMIT 1;
  • 15:43 paladox: delete from mw_permissions where perm_dbname = '1920swiki' and perm_group = '"*"' LIMIT 1;
  • 15:43 paladox: delete from mw_permissions where perm_dbname = '131parkhurstwiki' and perm_group = '"*"' LIMIT 1;
  • 15:43 paladox: delete from mw_permissions where perm_dbname = '131parkhurstwiki' and perm_group = '\*' LIMIT 1;
  • 15:43 paladox: delete from mw_permissions where perm_dbname = '00sretrolivingwiki' and perm_group = '\*' LIMIT 1;
  • 15:42 paladox: delete from mw_permissions where perm_dbname = '00sretrolivingwiki' and perm_group = '"*"' LIMIT 1;
  • 14:16 Reception123: manually remove custom domain from teessidehackspacewiki

2020-01-17[edit | edit source]

  • 19:10 Reception123: sudo -u www-data php /srv/mediawiki/w/maintenance/importDump.php --wiki=thefinalrumblewiki /home/reception/thefinalrumble_pages_full.xml
  • 02:11 paladox: rm -rf /srv/mediawiki/w/cache/manage*/** on mw* and lizardfs6
  • 01:48 paladox: restoring mw_permissions from a newish backup (after running "delete from mw_permissions where perm_group = "\*";" which seemed to updated 4,000 results)
  • 01:43 paladox: update mw_permissions set perm_permissions = '["autocreateaccount","createaccount","edit","createpage","createtalk", "writeapi","viewmywatchlist","editmywatchlist","viewmyprivateinfo", "editmyprivateinfo","editmyoptions","abusefilter-log","abusefilter-log-detail", "abusefilter-view","autocreateaccount","centralauth-merge", "oathauth-enable","urlshortener-create-url"]' where perm_group = '*' and perm_dbname = 'default';
  • 00:12 paladox: apt-get upgrade - misc2

2020-01-16[edit | edit source]

  • 23:53 paladox: /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/extensions/ManageWiki/maintenance/modifyGroupPermission.php --addperms="urlshortener-create-url,urlshortener-manage-url" sysop
  • 23:47 paladox: update mw_permissions set perm_permissions = '["editsitecss","upload_by_url","editsitejson","editsitejs","skipcaptcha","block","createaccount","delete","deletedhistory","deletedtext","undelete","editinterface","editusercss","edituserjson","edituserjs","import","importupload","move","move-subpages","move-rootuserpages","move-categorypages","patrol","autopatrol","protect","editprotected","rollback","upload","reupload","reupload-shared","unwatchedpages","autoconfirmed","editsemiprotected","ipblock-exempt","blockemail","markbotedits","apihighlimits","browsearchive","noratelimit","movefile","unblockself","suppressredirect","mergehistory","managechangetags","deletechangetags","abusefilter-modify","abusefilter-modify-restricted","abusefilter-revert","deletelogentry","deleterevision","abusefilter-log-detail","override-antispoof","globalblock-whitelist","massmessage","nuke","tboverride","titleblacklistlog", "delete-dump","generate-dump","view-dump","urlshortener-create-url","urlshortener-manage-url"]' where perm_group = 'sysop' and perm_dbname = 'default';
  • 02:34 paladox: reboot misc4
  • 02:15 paladox: downgraded puppetdb on puppet1 - broke ssl connection to postgresql
  • 01:48 paladox: root@db4:/home/paladox# sudo service postgresql restart
  • 01:44 paladox: on puppet1
  • 01:44 paladox: apt-get upgrade puppet-agent puppetdb puppetdb-termini puppetserver salt-common salt-minion
  • 01:43 paladox: upgrade puppet-agent on cp4

2020-01-15[edit | edit source]

  • 08:26 Reception123: sudo -u www-data php fixStuckGlobalRename.php --wiki=receptionflamewarswiki AnimalLovingGuy "ScrewSociety" --logwiki=metawiki

2020-01-14[edit | edit source]

  • 23:10 paladox: reinstall cp2 as debian buster
  • 23:09 paladox: restart php7.3-fpm on mw2 for config change
  • 23:09 paladox: turn TUN off on cp2
  • 23:06 paladox: restart php7.3-fpm on mw3 for config change
  • 22:59 paladox: rebuild lc on mw* and lizardfs6
  • 17:39 paladox: apt-get upgrade - lizardfs6
  • 01:43 paladox: sudo -u www-data php update.php --wiki=sagan4wiki --quick --force - mw1
  • 01:21 paladox: MariaDB [sagan4wiki]> ALTER TABLE /*_*/cargo_tables ADD field_helper_tables text NOT NULL;

2020-01-13[edit | edit source]

  • 15:32 paladox: MariaDB [mhglobal]> UPDATE cw_wikis SET wiki_settings = REPLACE(wiki_settings, '"wgServer":"https:\/\/wintermoor.net "', null ) WHERE wiki_dbname = 'wintermoorwiki';

2020-01-12[edit | edit source]

  • 23:29 paladox: removed redis from all mediawiki servers
  • 15:25 paladox: repooled lizardfs6
  • 15:15 paladox: temporarily depool lizardfs6
  • 08:32 Reception123: reception@mw1:/srv/mediawiki/w/maintenance$ sudo -u www-data php purgeList.php --all --purge --wiki twinkletestwiki + rebuildall.php
  • 08:06 Reception123: ran rebuildall on twinkletestwiki

2020-01-11[edit | edit source]

  • 23:35 paladox: [23:30:52] <+paladox> !log switched TUN off on misc2
  • 23:34 paladox: apt-get upgrade on misc2
  • 22:52 paladox: upgrade nodejs on misc3
  • 22:48 paladox: resizing misc3 - https://clientarea.ramnode.com/index.php?rp=/announcements/431/More-SSD-for-Standard-KVM.html
  • 17:04 paladox: apt-get upgrade - bacula1
  • 16:58 paladox: root@bacula1:/bacula/backup# rm DB*
  • 16:57 Reception123: sudo -u www-data php /srv/mediawiki/w/maintenance/rebuildLocalisationCache.php --wiki loginwiki on mw* and lizardfs6
  • 14:59 Reception123: DELETED and DROPPED dbs https://phabricator.miraheze.org/P247
  • 14:52 Reception123: reception@mw1:~$ sudo -u www-data php /srv/mediawiki/w/extensions/CreateWiki/maintenance/deleteWikis.php --wiki loginwiki --delete Reception123
  • 11:12 Reception123: reception@mw1:/srv/mediawiki/w/extensions/CentralAuth/maintenance$ sudo -u www-data php fixStuckGlobalRename.php --wiki=receptionflamewarswiki GasMask0217 "KP619" --logwiki=metawiki
  • 10:29 Reception123: run fixStuckGlobalRename.php on all wikis for username above
  • 10:18 Reception123: sudo -u www-data php fixStuckGlobalRename.php --wiki=aawikiwiki PaperClip "FireBarrier101" --logwiki=metawiki
  • 04:25 paladox: repool lizardfs6
  • 04:18 paladox: depool lizardfs6
  • 04:18 paladox: repool mw3
  • 04:12 paladox: depool mw3
  • 04:12 paladox: repool mw2
  • 04:08 paladox: depool mw2
  • 04:07 paladox: repool mw1
  • 04:04 paladox: depool mw1

2020-01-09[edit | edit source]

  • 22:07 paladox: sudo -u www-data php /srv/mediawiki/w/maintenance/importDump.php --wiki=inforevivalwiki --report=1 Wiki-20200109132453.xml
  • 21:20 paladox: rebuild lc on mw* and lizardfs6
  • 19:34 paladox: ALTER TABLE /*$wgDBprefix*/matomo ADD INDEX matomo_wiki (matomo_wiki); - db4
  • 19:17 paladox: MariaDB [mhglobal]> ALTER TABLE /*$wgDBprefix*/cw_wikis ADD INDEX wiki_dbname (wiki_dbname); -db4
  • 18:59 paladox: MariaDB [mhglobal]> ALTER TABLE /*$wgDBprefix*/mw_namespaces ADD INDEX ns_dbname (ns_dbname); -db4
  • 18:59 paladox: MariaDB [mhglobal]> ALTER TABLE /*$wgDBprefix*/mw_permissions ADD INDEX perm_dbname (perm_dbname); - db4
  • 00:57 paladox: restart php7.3-fpm on mw2

2020-01-08[edit | edit source]

  • 21:37 paladox: restart mysql on db4
  • 21:33 paladox: restart mysql on db5
  • 19:56 paladox: restart php7.3-fpm on lizardfs6 and mw*
  • 17:16 paladox: SET GLOBAL thread_cache_size = 100; - (db4|db5)
  • 16:52 paladox: MariaDB [(none)]> SET GLOBAL thread_cache_size = 80;
  • 16:33 paladox: MariaDB [(none)]> SET GLOBAL thread_pool_stall_limit = 10;
  • 16:14 paladox: MariaDB [(none)]> SET GLOBAL slow_query_log = 'OFF';
  • 16:10 paladox: MariaDB [(none)]> SET GLOBAL long_query_time = 10;
  • 16:04 paladox: MariaDB [(none)]> SET GLOBAL long_query_time = 15;
  • 16:04 paladox: MariaDB [(none)]> SET GLOBAL slow_query_log = 'ON';
  • 15:30 paladox: restart php7.3-fpm on mw* and lizardfs6
  • 15:21 Reception123: purge binary logs BEFORE '2020-01-08 08:00'

2020-01-07[edit | edit source]

  • 17:16 paladox: root@mw1:/srv/mediawiki/w/extensions/CentralAuth/maintenance# sudo -u www-data php fixStuckGlobalRename.php --wiki=receptionflamewarswiki --logwiki=metawiki ErtasVideos Hendicted

2020-01-06[edit | edit source]

  • 20:22 Reception123: reception@mw2:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki testwiki /home/reception/Wikipedia-20200106202002.xml

2020-01-05[edit | edit source]

  • 19:47 paladox: rebuild lc on mw* and lizardfs6
  • 00:25 paladox: ./bin/auth strip --user Paladox --all-types (misc4)

2020-01-04[edit | edit source]

  • 10:13 Reception123: reception@mw3:/srv/mediawiki/w/maintenance$ sudo -u www-data php importDump.php --wiki loginwiki /home/reception/TestWiki-20200104100040.xml

2020-01-02[edit | edit source]

  • 18:48 paladox: depool, repool and restart php7.3-fpm on mw3
  • 18:44 paladox: depool, repool and restart php7.3-fpm on mw2
  • 18:43 paladox: restart php7.3-fpm on mw1
  • 18:31 paladox: root@mw1:/home/paladox# sudo -u www-data php /srv/mediawiki/w/maintenance/importDump.php --wiki=radioscanningtwwiki --report=1 X.xml
  • 03:10 paladox: rm -rf /srv/mediawiki/w/cache/managewiki/** on mw* and lizardfs6
  • 03:01 paladox: root@test1:/srv/mediawiki/w/extensions/StopForumSpam/maintenance# sudo -u www-data php updateBlacklist.php --wiki=sdiywiki
  • 02:44 paladox: upgrade phabricator on misc4
  • 02:42 paladox: MariaDB [(none)]> drop database uncyclopediakrwiki;
  • 02:30 paladox: root@mw1:/home/paladox# sudo -u www-data php /srv/mediawiki/w/extensions/CreateWiki/maintenance/renameWiki.php --wiki=loginwiki --rename uncyclopediakrwiki truthwiki paladox

2020-01-01[edit | edit source]

  • 17:49 paladox: root@misc1:/home/paladox# deluser labster
  • 15:53 Reception123: sudo -u www-data php fixStuckGlobalRename.php --wiki=200xwiki PaperClip "FireBarrier101" --logwiki=metawiki
  • 14:24 Reception123: MariaDB [phabricator_herald]> UPDATE herald_rule SET isDisabled = '1' WHERE id = '21'; (empty)
  • 04:36 paladox: root@mw1:/srv/mediawiki/w# /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/maintenance/sql.php /srv/mediawiki/w/extensions/QuizGame/sql/patches/patch-add-default-choice_answer_count.sql
  • 00:37 paladox: restart varnish cp2,cp4