18:24 mutante: running '/usr/lib/wikistats/update.php mw autofixit' which tries to magically fix stats URLs that are 301 and return a new location .. but it throws an error because then there are duplicate entries which the DB doesn't allow
23:08 mutante: - added user Aokoth as reader and member
2023-05-01
17:50 mutante: - running "/usr/lib/wikistats/update.php mw autofixit" which means "go trough mediawikis table, take all wikis that got a 301 last time they tried to talk to API, see where you get redirected to and if it looks like a valid api.php then use the new URL and update the database".
2021-12-14
23:12 mutante: - removing mysql root password to local mariabdb on wikistats-bullseye. data is meant to be public. getting ssh shell in the project is enough access control
2021-12-10
16:57 mutante: added api.wikimedia.org and thankyou.wikipedia.org to table of "wikimedia special wikis"
16:35 mutante: shutting down deprecated buster instance "wikistats-wild-tiger". replaced by "wikistats-bullseye" on.. you guessed it.. bullseye. @user jem your scripts have been copied from your home dir to /usr/local/bin/wikistats/
2021-10-22
22:36 mutante: - deleted simplelamp temp test instance
22:36 mutante: - creating new instance wikistats-bullseye for testing upgrade to next release
19:18 mutante: - created new instance dancing-goat with buster as backup and to replace stretch
19:17 mutante: - deleted old instances T128642 and T21008
2019-04-18
19:05 bd808: deleting some project- and prefix-wide puppet config to try to get puppet running again on VMs (re-logged for andrewbogott)
2019-02-08
22:52 mutante: - creating throw away instance to test if T128642 is still true or not
22:50 mutante: - shutting down and deleted instance T210008 once made for testing krypton upgrade but broken somehow
2018-12-14
18:39 mutante: - ran deploy-wikistats deploy, copied .xml files, migrationg to new region should be all done now
18:25 mutante: - replaced wikistats-kraken (eqiad) with wikistats-greyhound (eqiad-r), new stretch image, copied mysql data over, deleted and recreated web proxy
14:24 andrewbogott: migrating project to eqiad1-r
2018-11-20
22:02 mutante: deleted instance wikistats-cowgirl (jessie), replaced after > 3 years
2018-11-16
01:58 mutante: - added new projects: punjabi.wikimedia, yue.wiktionary, li.wikinews and shn.wikpedia
01:19 mutante: - shut down instance cowgirl (jessie), replaced by kraken (stretch)
00:28 mutante: deleting instance tacotuesday2 - not used
2018-11-15
04:16 mutante: switched backend of web proxy to wikistats-kraken (stretch upgrade), migrated db dump from jessie instance cowgirl, deleted extra webproxy
2018-11-14
17:04 mutante: - mysql server currently down, replacing mysql with mariadb and puppetizing, maintenance mode until later today
2018-01-09
00:10 mutante: instance -kraken, upgrade php7 and mariadb packages
2017-10-17
18:53 paladox: wikistats-cowgirl upgrading linux-meta-4.9 as last package to upgrade.
00:01 mutante: - added kbp.wikipedia and pt.wikimedia
2017-05-19
22:07 mutante: fixed puppet issues, puppetized db pass and grants to bootstrap instances, apt-get upgrading wikistats-petcow (jessie), testing stretch with separate instance -octopus ..
2017-05-18
19:17 mutante: - deployed code change that removes ALL mysql_ function remants (they have been removed in PHP7/stretch). now using PDO to connect to db.
2017-05-15
22:15 mutante: launching new instance wikistats-octopus with experimental stretch image
2017-04-26
03:27 mutante: added new Wikipedia "dty" - Doteli (T160947)
2016-08-15
02:17 mutante: deleted 'nostalgia' from wikipedias table per request (it's in the 'specials' table already)
01:52 mutante: major cleanup of backend data. deleted and fixed hundreds (redirects, duplicates, broken wikis, convert to API, ..)
2016-07-12
21:42 mutante: deleted wikistats-southpark instance to free resources
21:40 chasemp: nova start wikistats-southpark.wikistats.eqiad.wmflabs
18:33 mutante: shutting down instance wikistats-southpark, lastlog said not used since February
2015-07-15
02:56 mutante: - apt-get upgrade
2015-07-14
23:48 mutante: added more missing projects, pnb.wikt, ca.wm, cn.wm ..
23:47 mutante: built and installed packaged 2.10
23:02 mutante: add missing Persian Wikivoyage (fa)
September 18
23:11 mutante: - package install problem due to bug 70981
August 20
23:52 mutante: - so that now we have puppet status OK again (missing puppetized db setup)
23:50 mutante: - deleted old proxy, created new one, switched backend over to wikistats-petcow instance
August 19
21:14 mutante: - puppet broken, Apache setup, DB setup, DPKG, attempting to revive on fresh instance wikistats-petcow
12:36 mutante: - metapedias (error 302) - sk.metapedia, et.metapedia, fix stats URLs (yea, use /m/ instead of /w/ now :P)
12:20 mutante: - editthis (error 991) - delete 'bridge' (readapi denied), delete 'kanji' (No db present), delete 'kickipedia' (no reply), delete 'lost20' (no reply)
December 8
19:36 mutante_: fix fetching of extended info, add new API fields si_langconversion,si_linktrail,si_linkprefix,si_titleconversion. run update on wikis without names to give them one from si_sitename
19:30 mutante_: (mw) 10 more converted from Special page to API using different ways to guess the api.php URL. deleted a couple broken ones
17:51 mutante: (mw) ran conversion script attempting to find ancient wikis that meanwhile may have api.php. 10 wikis succesfully converted (out of 190)
17:07 mutante: (mw) id 143 switch to API, battlestarwiki.org wikis, fixed es,fr,zh,deleted duplicates de,en..
16:49 mutante: - referata wikis, deleted 28 closed wikis that became 404
December 7
21:05 mutante: - various fixes with some broken updates in wiktionary and mediawiki table, remaining ones with error code "991" means the remote site has database issues, even if it looks like it works in browser, the script gets internal_api_error_DBConnectionError or similar
21:03 mutante: (wx) - chapter wikis - removed because they all don't use mediawiki anymore (sigh!?) - wikimedia.fr, wikimedia.ch, wikimedia.org.ve, wikimedia.org.il, wikimedia.org.ar ..(less and less chapters actually use mw)
21:02 mutante: (wx) - chapter wikis - fixed URLs due to site redesigns: wikimedia.de, wikimedia.org.ph, pa.us.wm -> pa-us.wm
September 11
00:19 mutante: switching from public IP to YuviProxy
September 4
19:43 mutante: - fixed stats updates for a couple hundred external mediawikis, by adding a trim() :p for some reason some API results have whitespace
July 30
02:24 mutante: added missing el.wikivoyage, fixed wikivoyage timestamps/updates, running wiki-site update, add 1.22wmf12 to good versions
March 27
23:49 mutante: - add new 'he' and 'uk' wikivoyages