Page MenuHomePhabricator

ValerioBoz-WMCH (Valerio Bozzolan)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Jan 26 2023, 5:40 PM (63 w, 4 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
ValerioBoz-WMCH [ Global Accounts ]

The account @ValerioBoz-WMCH is dedicated to technical sprints requested by Wikimedia CH (Switzerland).

See my Meta-wiki page for working details:

My personal volunteer account is this other one:

Image credit: "Polite Cat meme" in low resolution, fair use.

Recent Activity

Today

ValerioBoz-WMCH created T362605: NextCloud for WMCH.
Tue, Apr 16, 6:54 AM · WMCH-Infrastructure

Mon, Apr 1

ValerioBoz-WMCH set Due Date to Fri, Apr 5, 3:00 PM on T361460: Fix email notifications from the WMCH Zabbix monitoring server (to also receive alarms related to Wikimini.org outages).
Mon, Apr 1, 8:13 AM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH triaged T361460: Fix email notifications from the WMCH Zabbix monitoring server (to also receive alarms related to Wikimini.org outages) as High priority.
Mon, Apr 1, 8:10 AM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH created T361460: Fix email notifications from the WMCH Zabbix monitoring server (to also receive alarms related to Wikimini.org outages).
Mon, Apr 1, 8:09 AM · Wikimini.org, WMCH-Infrastructure

Sat, Mar 30

ValerioBoz-WMCH updated the task description for T278034: Install a monitoring system (Zabbix) in WMCH server members2.
Sat, Mar 30, 7:00 PM · WMCH-Infrastructure

Mon, Mar 25

ValerioBoz-WMCH added a comment to T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35.

Premise: now at least stock demo works (temporary domain)

Mon, Mar 25, 8:09 AM · Wikimini.org, WMCH-Infrastructure

Mon, Mar 18

ValerioBoz-WMCH added a comment to T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35.

Attempt number 4.

Mon, Mar 18, 8:03 AM · Wikimini.org, WMCH-Infrastructure

Sun, Mar 17

valerio.bozzolan awarded T357013: Set "main" branch in WMCH Infrastructure repository a Love token.
Sun, Mar 17, 5:18 PM · Phabricator

Mar 8 2024

ValerioBoz-WMCH added a comment to T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35.

First of all:

Mar 8 2024, 5:14 PM · Wikimini.org, WMCH-Infrastructure

Mar 4 2024

ValerioBoz-WMCH added a comment to T358721: Investigate performance issues in DicoAdo.org.

Unrelated note, the Apache HTTPd is under-loaded:

Mar 4 2024, 8:06 AM · DicoAdo.org, WMCH-Infrastructure
ValerioBoz-WMCH changed the point value for T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35 from 8 to 24.
Mar 4 2024, 8:00 AM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH claimed T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35.
Mar 4 2024, 8:00 AM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH added a comment to T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35.

I kind of restarted this upgrade from scratch last week. I will be a bit verbose soon.

Mar 4 2024, 7:18 AM · Wikimini.org, WMCH-Infrastructure

Feb 29 2024

ValerioBoz-WMCH added a comment to T358721: Investigate performance issues in DicoAdo.org.

Interestingly the memcached's protocol is super documented. Lovely!

Feb 29 2024, 3:48 PM · DicoAdo.org, WMCH-Infrastructure

Feb 28 2024

ValerioBoz-WMCH removed a watcher for DicoAdo.org: valerio.bozzolan.
Feb 28 2024, 8:13 PM
ValerioBoz-WMCH added a watcher for DicoAdo.org: ValerioBoz-WMCH.
Feb 28 2024, 8:13 PM
ValerioBoz-WMCH renamed T358721: Investigate performance issues in DicoAdo.org from Investigate performance issues in WMCH-DicoAdo to Investigate performance issues in DicoAdo.org.
Feb 28 2024, 8:13 PM · DicoAdo.org, WMCH-Infrastructure
ValerioBoz-WMCH added a watcher for WMCH-Infrastructure: ValerioBoz-WMCH.
Feb 28 2024, 8:12 PM
ValerioBoz-WMCH removed a watcher for WMCH-Infrastructure: valerio.bozzolan.
Feb 28 2024, 8:12 PM
ValerioBoz-WMCH created E1716: WMCH Tech Boost.
Feb 28 2024, 8:11 PM · WMCH-Infrastructure, events
ValerioBoz-WMCH triaged T358721: Investigate performance issues in DicoAdo.org as High priority.
Feb 28 2024, 8:10 PM · DicoAdo.org, WMCH-Infrastructure
ValerioBoz-WMCH created T358721: Investigate performance issues in DicoAdo.org.
Feb 28 2024, 8:10 PM · DicoAdo.org, WMCH-Infrastructure

Feb 26 2024

ValerioBoz-WMCH closed T331153: Wikimini extensions review as Resolved.

Let's declare this as concluded. We can still comment and update the description. The situation is clearer now.

Feb 26 2024, 8:22 AM · Internet-Archive, WMCH-Infrastructure, Wikimini.org
ValerioBoz-WMCH closed T331153: Wikimini extensions review, a subtask of T268880: Upgrade production Wikimini from MediaWiki 1.28.0 to at least 1.31 (current Debian GNU/Linux stable), as Resolved.
Feb 26 2024, 8:22 AM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH closed T331153: Wikimini extensions review, a subtask of T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35, as Resolved.
Feb 26 2024, 8:22 AM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH committed rWCIN675e035eb181: wikimini: activate demo virtualhosts (ar, en, es, fr, it, lab, stock, sv).
wikimini: activate demo virtualhosts (ar, en, es, fr, it, lab, stock, sv)
Feb 26 2024, 8:13 AM
ValerioBoz-WMCH committed rWCINbc3e5ce92eea: wikimini: deploy demo virtualhosts (ar, en, es, fr, it, lab, stock, sv).
wikimini: deploy demo virtualhosts (ar, en, es, fr, it, lab, stock, sv)
Feb 26 2024, 8:13 AM
ValerioBoz-WMCH committed rWCINee0d5ae23803: wikimini: drop legacy tests.
wikimini: drop legacy tests
Feb 26 2024, 8:12 AM
ValerioBoz-WMCH updated the task description for T331153: Wikimini extensions review.
Feb 26 2024, 8:05 AM · Internet-Archive, WMCH-Infrastructure, Wikimini.org
ValerioBoz-WMCH updated the task description for T357013: Set "main" branch in WMCH Infrastructure repository.
Feb 26 2024, 7:38 AM · Phabricator
ValerioBoz-WMCH claimed T277880: Deploy a testing Wikimini.
Feb 26 2024, 7:28 AM · WMCH-Infrastructure, Wikimini.org
ValerioBoz-WMCH added a comment to T277880: Deploy a testing Wikimini.

I've created this curtesy wildcard domain record to test things in Wikimini:

Feb 26 2024, 7:27 AM · WMCH-Infrastructure, Wikimini.org

Feb 25 2024

ValerioBoz-WMCH closed T277880: Deploy a testing Wikimini as Resolved.

Some progress here.

Feb 25 2024, 9:04 PM · WMCH-Infrastructure, Wikimini.org
ValerioBoz-WMCH closed T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G) as Resolved.

Our cute "spammer-obliviater" is starting to run dry without being able to identify more spam. And I'm not creative enough to put additional keywords. Anyway we gained +20 GB free disk space and that's enough \o/

Feb 25 2024, 9:04 PM · Wikimini.org
ValerioBoz-WMCH closed T277880: Deploy a testing Wikimini, a subtask of T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35, as Resolved.
Feb 25 2024, 9:04 PM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH closed T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G), a subtask of T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35, as Resolved.
Feb 25 2024, 9:04 PM · Wikimini.org, WMCH-Infrastructure

Feb 17 2024

ValerioBoz-WMCH closed T348426: Upgrade DicoAdo.org from 1.35.11 to 1.39.5 (LTS) as Resolved.

And, DicoAdo is online with 1.39.5 \o/

Feb 17 2024, 11:28 PM · WMCH-Infrastructure, DicoAdo.org
ValerioBoz-WMCH renamed T348426: Upgrade DicoAdo.org from 1.35.11 to 1.39.5 (LTS) from Upgrade DicoAdo.org from 1.35.11 to 1.39.5 to Upgrade DicoAdo.org from 1.35.11 to 1.39.5 (LTS).
Feb 17 2024, 11:27 PM · WMCH-Infrastructure, DicoAdo.org
ValerioBoz-WMCH committed rWCIN8920476e2082: Wikimini: make maintenance page super-easy to be activated.
Wikimini: make maintenance page super-easy to be activated
Feb 17 2024, 3:06 PM
ValerioBoz-WMCH committed rWCIN6fcf5e3a5e2f: minipedia: disable emails.
minipedia: disable emails
Feb 17 2024, 3:06 PM
ValerioBoz-WMCH committed rWCINbf46cd00d905: demo: refactor apache2 configs to be more KISS.
demo: refactor apache2 configs to be more KISS
Feb 17 2024, 3:06 PM
ValerioBoz-WMCH committed rWCIN264afb3b88be: wikimini: make wiki selector more robust.
wikimini: make wiki selector more robust
Feb 17 2024, 3:06 PM
ValerioBoz-WMCH closed T357848: Wikimini: make maintenance page more easy to be activated as Resolved.

BTW, Wikimini.org has the most beautiful maintenance page ever. Change my mind.

Feb 17 2024, 2:29 PM · Wikimini.org
ValerioBoz-WMCH created T357848: Wikimini: make maintenance page more easy to be activated.
Feb 17 2024, 2:24 PM · Wikimini.org

Feb 15 2024

ValerioBoz-WMCH closed T347684: Explore tool "What to do" in Toolforge as Resolved.

Indeed it queries PageAssessments so it depends by the current usage by every specific community.

Feb 15 2024, 9:48 AM · WMCH-Infrastructure

Feb 12 2024

ValerioBoz-WMCH updated the title for P56671 MediaWiki SPAMMER Obliviater from MediaWiki SPAMMER Killer to MediaWiki SPAMMER Obliviater.
Feb 12 2024, 8:00 AM · WMCH-Infrastructure
ValerioBoz-WMCH added a comment to T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).

Situation of 2024-02-12 (Monday) morning:

Feb 12 2024, 7:53 AM · Wikimini.org
ValerioBoz-WMCH edited P56671 MediaWiki SPAMMER Obliviater.
Feb 12 2024, 7:50 AM · WMCH-Infrastructure
ValerioBoz-WMCH edited P56671 MediaWiki SPAMMER Obliviater.
Feb 12 2024, 7:19 AM · WMCH-Infrastructure

Feb 11 2024

ValerioBoz-WMCH created P56671 MediaWiki SPAMMER Obliviater.
Feb 11 2024, 8:12 PM · WMCH-Infrastructure
ValerioBoz-WMCH renamed T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G) from Fix Wikimini beta "eswiki" edition: database too big (27G) to Fix Wikimini beta "eswiki" edition: database full of spam (27G).
Feb 11 2024, 8:08 PM · Wikimini.org
ValerioBoz-WMCH added a comment to T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).
$ sudo -u www-data HTTP_HOST=es.wikimini.org php ./deleteArchivedRevisions.php
Found 666888 revisions to delete.
Feb 11 2024, 8:07 PM · Wikimini.org
ValerioBoz-WMCH updated ValerioBoz-WMCH.
Feb 11 2024, 11:46 AM

Feb 10 2024

ValerioBoz-WMCH added a comment to T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).

Status update:

Feb 10 2024, 10:14 PM · Wikimini.org

Feb 9 2024

ValerioBoz-WMCH added a comment to F41829130: wiki spam killer output.png.
IMPORTANT: This is just here only for additional auditing. Probably not safe for work.
Feb 9 2024, 10:22 PM
ValerioBoz-WMCH moved T356964: Investigate High traffic on wmch-demo-01 server (hosting Wikimini) from Backlog to Done on the Wikimini.org board.
Feb 9 2024, 9:58 PM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH added a comment to T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).

BTW the "Wikimini spam killer" script was completed and it's running since minutes \o/

Feb 9 2024, 4:38 PM · Wikimini.org
ValerioBoz-WMCH updated the name of F41829130: wiki spam killer output.png from "image.png" to "wiki spam killer output.png".
Feb 9 2024, 4:38 PM
ValerioBoz-WMCH updated the name of F41829084: Wikimini spam killer.png from "image.png" to "Wikimini spam killer.png".
Feb 9 2024, 4:32 PM
ValerioBoz-WMCH added a comment to T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).

Note that there are false-positives after May 2016. Example

Feb 9 2024, 3:52 PM · Wikimini.org
ValerioBoz-WMCH raised the priority of T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G) from Low to High.

Thanks Lorangeo. I'm considering "May 2016" as a raw cut line and I'm proceeding in releasing a wipe script and use that, ASAP.

Feb 9 2024, 11:21 AM · Wikimini.org
ValerioBoz-WMCH added a comment to T348426: Upgrade DicoAdo.org from 1.35.11 to 1.39.5 (LTS).

If I have done everything correctly, the DicoAdo skin is now published on Wikimedia GitLab:

Feb 9 2024, 10:24 AM · WMCH-Infrastructure, DicoAdo.org
ValerioBoz-WMCH edited Description on DicoAdo.org.
Feb 9 2024, 10:22 AM
ValerioBoz-WMCH moved T356964: Investigate High traffic on wmch-demo-01 server (hosting Wikimini) from Working On to Recent Changes on the WMCH-Infrastructure board.
Feb 9 2024, 9:23 AM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH moved T348426: Upgrade DicoAdo.org from 1.35.11 to 1.39.5 (LTS) from Backlog to Working On on the WMCH-Infrastructure board.
Feb 9 2024, 9:23 AM · WMCH-Infrastructure, DicoAdo.org
ValerioBoz-WMCH lowered the priority of T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G) from High to Low.
IMPORTANT: I've explained the situation to Ilario and he is proposing to maybe just drop the experimental es version and eventually just restart from scratch with fresh initiatives. In this way we have less blocks.
Feb 9 2024, 9:22 AM · Wikimini.org
ValerioBoz-WMCH added a comment to T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).

Interestingly it's 2024 and it still does not exist an internal PHP official method call to block a specific user.

Feb 9 2024, 8:37 AM · Wikimini.org
ValerioBoz-WMCH added a comment to T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).

BTW the Nuke extension is not feasible since it works on recent changes, and it's not the case. Also other extensions would be lovely but they DO NOT work for MediaWiki 1.26. And we should really do not try to upgrade and only after cleanup.

Feb 9 2024, 8:12 AM · Wikimini.org

Feb 8 2024

ValerioBoz-WMCH committed rWCIN660dea852409: Wikimini: also put .cur icons under cache-control.
Wikimini: also put .cur icons under cache-control
Feb 8 2024, 7:15 PM
ValerioBoz-WMCH committed rWCIN80855af376d2: Wikimini: implement a bit of cache-control.
Wikimini: implement a bit of cache-control
Feb 8 2024, 7:15 PM
ValerioBoz-WMCH added a comment to T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).

I'm once again a bit surprised that there is not any maintenance script to delete pages from a list of page IDs, instead of having a complicated and not-reliable generation of namespace names from an SQL query.

Feb 8 2024, 4:06 PM · Wikimini.org
ValerioBoz-WMCH updated the name of F41815976: Phabricator Calendar strange Tags default.png from "image.png" to "Phabricator Calendar strange Tags default.png".
Feb 8 2024, 3:12 PM
ValerioBoz-WMCH created T357013: Set "main" branch in WMCH Infrastructure repository.
Feb 8 2024, 3:10 PM · Phabricator
ValerioBoz-WMCH set the point value for T356964: Investigate High traffic on wmch-demo-01 server (hosting Wikimini) to 2.5.
Feb 8 2024, 2:20 PM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH closed T356964: Investigate High traffic on wmch-demo-01 server (hosting Wikimini) as Resolved.

Some potential root problems:

Feb 8 2024, 1:44 PM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH added a comment to T356964: Investigate High traffic on wmch-demo-01 server (hosting Wikimini).

I've found suspicious requests to these binary file:

Feb 8 2024, 9:18 AM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH added a comment to E1707: WMCH Tech Boost.

New priority

Feb 8 2024, 7:52 AM · WMCH-Infrastructure, Wikimini.org, DicoAdo.org, events
ValerioBoz-WMCH added a comment to T356964: Investigate High traffic on wmch-demo-01 server (hosting Wikimini).

Before 2024-01-07, our Switzerland service provider reported a spike in the traffic on the server wmch-mores-demo-01 hosting Wikimini.org and another minor MediaWiki demo, specifically on ports 80 and 443. The unwanted traffic spike is coming mainly from Amazon AWS. Unclear if this is a denial of service or another thing. I can start looking at this in some minutes.

Feb 8 2024, 7:51 AM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH created T356964: Investigate High traffic on wmch-demo-01 server (hosting Wikimini).
Feb 8 2024, 7:48 AM · Wikimini.org, WMCH-Infrastructure

Feb 6 2024

ValerioBoz-WMCH added a project to E1708: WMCH Tech Boost: WMCH-Infrastructure.
Feb 6 2024, 3:07 PM · WMCH-Infrastructure, Wikimini.org, DicoAdo.org, events
ValerioBoz-WMCH updated the event description for E1707: WMCH Tech Boost.
Feb 6 2024, 3:06 PM · WMCH-Infrastructure, Wikimini.org, DicoAdo.org, events
ValerioBoz-WMCH created E1708: WMCH Tech Boost.
Feb 6 2024, 3:05 PM · WMCH-Infrastructure, Wikimini.org, DicoAdo.org, events
ValerioBoz-WMCH claimed T348426: Upgrade DicoAdo.org from 1.35.11 to 1.39.5 (LTS).
Feb 6 2024, 3:05 PM · WMCH-Infrastructure, DicoAdo.org
ValerioBoz-WMCH created E1707: WMCH Tech Boost.
Feb 6 2024, 3:03 PM · WMCH-Infrastructure, Wikimini.org, DicoAdo.org, events

Feb 1 2024

ValerioBoz-WMCH added a parent task for T335328: "Unexpected request" when trying to run maintenance script in Wikimini: T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).
Feb 1 2024, 9:38 PM · Wikimini.org
ValerioBoz-WMCH added a subtask for T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G): T335328: "Unexpected request" when trying to run maintenance script in Wikimini.
Feb 1 2024, 9:38 PM · Wikimini.org
ValerioBoz-WMCH set the point value for T335328: "Unexpected request" when trying to run maintenance script in Wikimini to 2.
Feb 1 2024, 6:08 PM · Wikimini.org
ValerioBoz-WMCH added a parent task for T335328: "Unexpected request" when trying to run maintenance script in Wikimini: T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35.
Feb 1 2024, 6:04 PM · Wikimini.org
ValerioBoz-WMCH added a subtask for T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35: T335328: "Unexpected request" when trying to run maintenance script in Wikimini.
Feb 1 2024, 6:04 PM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH closed T335328: "Unexpected request" when trying to run maintenance script in Wikimini as Resolved.

I'm very happy because I've found a SURPRISINGLY-KISS solution \o/

Feb 1 2024, 5:55 PM · Wikimini.org
ValerioBoz-WMCH added a parent task for T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G): T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35.
Feb 1 2024, 4:20 PM · Wikimini.org
ValerioBoz-WMCH added a subtask for T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35: T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).
Feb 1 2024, 4:20 PM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH claimed T308969: Fix Wikimini beta "eswiki" edition: database full of spam (27G).
Feb 1 2024, 4:20 PM · Wikimini.org

Jan 31 2024

ValerioBoz-WMCH raised the priority of T277880: Deploy a testing Wikimini from Medium to High.
Jan 31 2024, 8:18 PM · WMCH-Infrastructure, Wikimini.org
ValerioBoz-WMCH reopened T277880: Deploy a testing Wikimini, a subtask of T278033: Upgrade testing-Wikimini from MediaWiki 1.28.0 to 1.35, as Open.
Jan 31 2024, 8:18 PM · Wikimini.org, WMCH-Infrastructure
ValerioBoz-WMCH reopened T277880: Deploy a testing Wikimini as "Open".

This is not completed. The testing databases are not adopted by the test wiki.

Jan 31 2024, 8:18 PM · WMCH-Infrastructure, Wikimini.org
ValerioBoz-WMCH added a comment to T356312: Wikimini JavaScript error: can't redefine non-configurable property "__swiffy_override".

First, see:

Jan 31 2024, 8:12 PM · Wikimini.org
ValerioBoz-WMCH triaged T356317: Drop "addthis.com" dependency as High priority.
Jan 31 2024, 8:11 PM · Wikimini.org
ValerioBoz-WMCH moved T347239: Emails do not work anymore in Wikimini from Fixes to Done on the Wikimini.org board.
Jan 31 2024, 8:11 PM · WMCH-Infrastructure, Wikimini.org
ValerioBoz-WMCH added a comment to T277880: Deploy a testing Wikimini.

For the records the domain choosen for this was fr.test.wikimini.org and only works with a local DNS poison, associating that domain to the IPv4 89.207.237.59.

Jan 31 2024, 8:11 PM · WMCH-Infrastructure, Wikimini.org