Editing User:Jukeboksi/Blog/2019

Next year [[User:Jukeboksi/Log/2020]]

== TODO ==
* Write a [[w:crowdfunding]] pitch to attempt to raise funds to get a reasonable subset of the planned [[features]] implemented by a professional. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 13:13, 20 April 2019 (UTC)
* Install and configure [[mw:Extension:Translate]] and start updating articles to good state and translating them to Finnish for appeal to the Finnish crowd. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 13:11, 20 April 2019 (UTC)

----
== December ==

=== Friday 2019-12-27 ===
* Made, verified and distributed backups [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 20:24, 27 December 2019 (CET)

=== Thursday 2019-12-26 ===
* Upgraded the wiki family to 1.34 
* Made, verified and distributed backups in preparation for upgrades. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 16:14, 26 December 2019 (CET)

=== Monday 2019-12-16 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 22:20, 16 December 2019 (CET)

=== Thursday 2019-12-05 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 18:19, 5 December 2019 (CET)

=== Sunday 2019-12-01 ===
* Made, verified and distributed backups. Going to improve automation and move to a better system to do this. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 22:32, 1 December 2019 (CET)

== November ==

=== Sunday 2019-11-24 ===
* Made, verified and distributed backups. Migrated the wikis to a new Debian 10 server with stricter security and much faster system. Some things still need to be tuned and tested before the migration can be called complete. (tomorrow). [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 22:31, 24 November 2019 (CET)

=== Thursday 2019-11-14 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 18:56, 14 November 2019 (UTC)

----

== October ==

=== Saturday 2019-10-26 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 13:08, 26 October 2019 (UTC)

=== Saturday 2019-10-05 ===
* Today I've been translating the [[Open Food Facts]] apps and tomorrow I'm going to translate the [[w:Taxonomy (general)|taxonomies]] so that it can get more intelligent in Finnish. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 21:00, 5 October 2019 (UTC)

== September ==

=== Monday 2019-09-30 ===
* Made backups and a snapshot Upgraded BCM! wiki and Wikistudy to 1.33, tested that things work and made backups at ~ 16:00 EET.

=== Sunday 2019-09-29 ===
* Made, verified and distributed upgrades. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 11:33, 29 September 2019 (UTC)

=== Saturday 2019-09-28 ===
New try at the upgrading. I thought that the [[test wiki]]'s inconsistent state could be due to that the shared tables need to be disabled during the upgrade or there will be trouble. So I made a copy of the shared tables and uploaded them into the test wiki before running the upgrade and the test wiki got up just fine. Now that I have tested that [[mw:Extension:Wikibase]] works in the test wiki and editing and uploading work on both wikis I'm happy to say that the wiki family is happily at the newest [[Mediawiki]] version 1.33

=== Friday 2019-09-27 ===
In the morning wrote [https://phabricator.wikimedia.org/T234027 this ticket to the Wikimedia Phabricator ticketing system titled 'Unable to upgrade wiki family of 2 wikis from 1.32.0 to 1.33.0 due to DB structure being different than the upgrade.php expects'] and then various people helped and expert [[w:User:Anomie]] provided SQL to fix the issue of the ticket. Big thanks to Anomie for single-handedly putting the database of the [[test wiki]] into a consistent and upgradeable state.

Not all was well yet. Running the upgrades on the 2 wikis of the wiki family this [[development wiki]] was fine, but the [[test wiki]] ended up in an inconsistent state e.g. Main Page missing, revisions missing. 

=== Thursday 2019-09-26 ===
* Made backups and attempted the upgrade again. Did not work. Got help from #mediawiki. Making a Phabricator ticket was suggested by duesen @ #mediawiki. Thank you [[mw:User:Duesentrieb]] for all the help. 
 
=== Wednesday 2019-09-25 ===
* Problem with the upgrade. There are two wikis in this wiki family and the test wiki won't run the upgrade. Rolled back both upgrades and going to think about how to sort the situation. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 21:41, 25 September 2019 (UTC)

=== Monday 2019-09-23 ===
* Going to make backups, snapshot the server and upgrade the Mediawiki. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 07:38, 23 September 2019 (UTC)
:: Made the backups on Monday. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 08:54, 25 September 2019 (UTC)

=== Friday 2019-09-20 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 13:31, 20 September 2019 (UTC)

=== Wednesday 2019-09-11 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 19:34, 11 September 2019 (UTC)
----

== August ==

=== Friday 2019-08-30 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 20:22, 30 August 2019 (UTC)

=== Wednesday 2019-08-28 ===
* https://yuka.io/en/ is an app by YUKA SAS, a company funded by the premium payments of the premium tier of the freemium. Premium-tier includes nutritional calculations, which are at the core of [[OFF]]. Includes consumer reviews, otherwise quite like OFF. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 10:08, 28 August 2019 (UTC)

=== Sunday 2019-08-25 ===
* Today I've been translating [[Open Food Facts]] labels and categories to Finnish. Some dupes but not enough to cause concern. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 20:47, 25 August 2019 (UTC)

=== Saturday 2019-08-24 ===
* This looks interesting: https://toogoodtogo.co.uk [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 22:46, 23 August 2019 (UTC)

=== Friday 2019-08-23 ===
* This hackathon looks interesting and it will close in 8 hrs from now. Need to check up on what kind of innovative software against food loss they came up with: https://foodwastehackathon.tech/. This link was found through [[Open Food Facts]]'es [[w:Slack (software)|Slack]].

=== Thursday 2019-08-22 ===
* Scouting the Open Food Facts wiki I ran into this one: [http://www.bilans-ges.ademe.fr/en/accueil Resource centre for greenhouse gas accounting] and their (?) [https://data.ademe.fr/datasets/ademe-extrait-base-carbone-v14-0 Extrait de la Base Carbone], which seems to be a database for figuring out carbon emissions, including extraction and processing of the fuel before it is used. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 17:58, 22 August 2019 (UTC)
* Today I've been translating the [[Open Food Facts]] website at https://translate.openfoodfacts.org/ into Finnish. Last few days I have been experimenting with the app and the website and it seems to work quite well, though not everything is yet resolved. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 17:36, 22 August 2019 (UTC)

=== Tuesday 2019-08-20 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 14:26, 20 August 2019 (UTC)

=== Saturday 2019-08-17 ===
Saw a small piece on [[Open Food Facts]] on France24 a couple of days ago and started an article on it. It is a copyleft effort for "foods and beverages only"-policy and focus on health stuff. I have installed the Android app and it looks like a fun way to contribute as everything is under a [[copyleft]] license. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 13:06, 17 August 2019 (UTC)

=== Thursday 2019-08-15 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 12:59, 17 August 2019 (UTC)

=== Tuesday 2019-08-06 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 13:36, 6 August 2019 (UTC)

== July ==
=== Thursday 2019-07-18 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 16:46, 18 July 2019 (UTC)

=== Tuesday 2019-07-16 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 13:17, 16 July 2019 (UTC)

== June ==

=== Thursday 2019-06-20 ===

* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 14:46, 20 June 2019 (UTC)

=== Monday 2019-06-03 ===

* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 22:10, 3 June 2019 (UTC)

----

== May ==

=== Thursday 2019-05-30 ===
* Bought a new VPS from Hetzner Online AG into their Helsinki DC. The advantages of the new server are that there is substantially more RAM and the disk is  also bigger and it is blazing fast [[w:NVMe|NVMe]] and not HDD, like at the old hosting guys. Will migrate all Consumerium wikis and sites soon-ish. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 21:13, 29 May 2019 (UTC)

=== Monday 2019-05-27 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 15:01, 27 May 2019 (UTC)

=== Wednesday 2019-05-22 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 16:36, 22 May 2019 (UTC)

=== Saturday 2019-05-18 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 09:34, 18 May 2019 (UTC)

=== Friday 2019-05-03 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 14:15, 3 May 2019 (UTC)

== April ==

=== Tuesday 2019-04-23 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 19:53, 23 April 2019 (UTC)

=== Saturday 2019-04-20 ===
[[File:BCM-wiki-logo.png|thumb|right|300px|[https://wiki.ban-covert-modeling.org/wiki/ Ban Covert Modeling! wiki] logo by artist and uploader. I care.]]
* Extended registration of  the domain of [https://wiki.ban-covert-modeling.org/wiki/ Ban Covert Modeling! wiki] until Friday 2025-03-14 20:51:45 UTC and I'll pay it another 5 yrs more, be it needed. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 19:20, 20 April 2019 (UTC)

=== Saturday 2019-04-13 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 12:28, 13 April 2019 (UTC)

=== Sunday 2019-04-07 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 12:44, 7 April 2019 (UTC)

=== Wednesday 2019-04-03 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 20:57, 3 April 2019 (UTC)

== March ==

=== Thursday 2019-03-28 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 18:06, 28 March 2019 (UTC)

=== Tuesday 2019-03-26 ===
* [[Consumium free social]] media instances are now migrated from the old virtual server in Netherlands to a new virtual server in Germany. Cost of running them went substantially down and resources went up. The only negative thing about the new server is that the hosting company does not use renewable electricity, but the fact that the data center has ground water cooling mitigates this a bit as it saves a lot of electricity. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 21:33, 26 March 2019 (UTC)
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 21:30, 26 March 2019 (UTC)
=== Saturday 2019-03-23 ===
* If someone else is wondering about a few edits happening which '''show a difference of few bytes negative''' in the '''Recent Changes''', but when you click the '''diff it says that there is no difference''': I was naturally worried when I saw the first occurrence of this and asked around in #mediawiki and the explanation is that around [[Mediawiki]] version 1.10 the line termination characters were reformed and thus these weird edits can happen when someone edits an article in a way that replaces the old line termination character with the new, shorter, ones and then Recent Changes sees a difference in the size, but the diff does not look at '''<u>how</u> the lines are terminated''' and concludes that nothing has been changed. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 17:01, 23 March 2019 (UTC)
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 16:51, 23 March 2019 (UTC)

=== Sunday 2019-03-17 ===
* I'm soon going to set up ssh agent forwarding as [http://www.unixwiz.net/techtips/ssh-agent-forwarding.html explained very clearly here]. This allows for fully automated backupping procedures that can be run regularly by a cronjob on my local machine if I also set up [https://www.funtoo.org/Keychain keychain] while avoiding the perils of having non-passphrase-protected keys on any servers. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 20:16, 17 March 2019 (UTC)
* Added a favicon.ico for https://consumerium.org and https://kuluttajisto.consumerium.org and made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 17:03, 17 March 2019 (UTC)

=== Thursday 2019-03-14 ===
The [[test wiki]] now has a favicon.ico corresponding to the orange version of the logo used on the test wiki. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 14:59, 14 March 2019 (UTC)

=== Wednesday 2019-03-13 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 18:04, 13 March 2019 (UTC) 

=== Saturday 2019-03-02 ===
* Facebook did not originally grant a short handle for Consumerium.org, but today it offered the possibility to create one, so now the Facebook page can be found with an easy to remember URL https://www.facebook.com/ConsumeriumORG/ [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 14:23, 2 March 2019 (UTC)

== February ==
=== Wednesday 2019-02-27 ===
* Made, verified and distributed backups. Upgrading [[Consumium free social]] [[diaspora]]* today to 0.7.10.0 (on another server). [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 11:07, 27 February 2019 (UTC)

=== Sunday 2019-02-24 ===
* Rebooting the OS for new kernel. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 20:18, 24 February 2019 (UTC)
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 20:11, 24 February 2019 (UTC)

=== Thursday 2019-02-14 ===
* Upgraded this wiki and the [[Test wiki]] (the only 2 members of a [[mw:Manual:Wiki family|wiki family]]) to the latest stable Mediawiki ([[mw:Release notes/1.32|Release notes for 1.32]]). There was some trouble when upgrading the test wiki with 'php update.php --wiki=testwiki' exited with an error stating that the updater tried to update the wrong database (!), but after banging my head at the keyboard for a while I figured out this may be due to the test wiki sharing some tables from this development wiki and that indeed was the case. After I commented out the shared tables in LocalSettings.php the upgrade run just fine. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 21:21, 14 February 2019 (UTC)
* Upgraded [https://wiki.study/regarding/Main_Page my semi-private study wiki] to latest stable [[Mediawiki]] (1.32.0) and now proceeding to do the same for this development wiki. Downtime of maximum of few minutes expected. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 18:53, 14 February 2019 (UTC)
* Extensions of Wordpressen at https://consumerium.org and https://kuluttajisto.consumerium.org updated. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 13:05, 14 February 2019 (UTC)
* Apologies for the fact that the email sending system <s>is broken</s>. Probably due to that it uses encrypted connection to the SMTP-server with authentication and I (probably) changed the password and forgot to update it in LocalSettings.php. I will work to fix this issue today. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 12:44, 14 February 2019 (UTC)
:::: UPDATE: Email issue resolved and email is now working as expected. Once again sorry about that it was broken (by me). [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 12:50, 14 February 2019 (UTC)
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 12:41, 14 February 2019 (UTC)

=== Saturday 2019-02-02 ===
* Made, verified and distributed backups. [[User:Jukeboksi|Jukeboksi]] ([[User talk:Jukeboksi|talk]]) 09:44, 2 February 2019 (UTC)

Previous year [[User:Jukeboksi/Blog/2018]]