[Timebox: 1h] Improve mediawiki docker environment
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	dang
	Fri, Jan 16, 3:17 PM

Description

There are a few problems working with the mediawiki docker environment:

~~No idea how to get login details of admin user~~ there is no record/doc mentioning it.
- PR: https://github.com/wbstack/mediawiki/pull/523
DB replication is live but often fails to CREATE USER and stuck, Second_Behind_Master stays at NULL
- PR: https://github.com/wbstack/mediawiki/pull/521
Mismatch between the configured base URL http://site1.localhost and the published port 8001
- PR: https://github.com/wbstack/mediawiki/pull/519
Captcha is required for creating account/logging in but doesn't work on docker env
- PR: https://github.com/wbstack/mediawiki/pull/520
Docker compose version is obsolete and causes warning
- PR: https://github.com/wbstack/mediawiki/pull/522

Event Timeline

dang created this task.Fri, Jan 16, 3:17 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFri, Jan 16, 3:17 PM

dang updated the task description. (Show Details)Fri, Jan 16, 3:20 PM

dang updated the task description. (Show Details)

Ollie.Shotton_WMDE renamed this task from Improve mediawiki docker environment to [Timebox: 4h] Improve mediawiki docker environment.Tue, Jan 20, 3:22 PM

Ollie.Shotton_WMDE moved this task from Engineering backlog to Kanban Board on the Wikibase Cloud board.

Ollie.Shotton_WMDE edited projects, added Wikibase Cloud (Kanban Board); removed Wikibase Cloud.

dang updated the task description. (Show Details)Wed, Jan 21, 10:01 AM

dang claimed this task.Wed, Jan 21, 1:36 PM

dang moved this task from To do to Doing on the Wikibase Cloud (Kanban Board) board.

dang updated the task description. (Show Details)Wed, Jan 21, 1:44 PM

dati18 opened https://github.com/wbstack/mediawiki/pull/517

Set ratio of DB_REPLICA load to 1

dang updated the task description. (Show Details)Wed, Jan 21, 2:56 PM

dang renamed this task from [Timebox: 4h] Improve mediawiki docker environment to [Timebox: 1.5h] Improve mediawiki docker environment.Wed, Jan 21, 4:09 PM

dati18 opened https://github.com/wbstack/mediawiki/pull/518

Add a service to create admin and PlatformReservedUser

dang renamed this task from [Timebox: 1.5h] Improve mediawiki docker environment to [Timebox: 1.h] Improve mediawiki docker environment.Thu, Jan 22, 12:27 AM

dang updated the task description. (Show Details)

dati18 opened https://github.com/wbstack/mediawiki/pull/519

Fix generated URLs to include :8001 in docker compose dev env

dang updated the task description. (Show Details)Thu, Jan 22, 12:42 AM

dati18 opened https://github.com/wbstack/mediawiki/pull/520

Disable Captcha for docker compose environment

dang updated the task description. (Show Details)Thu, Jan 22, 1:02 AM

dang renamed this task from [Timebox: 1.h] Improve mediawiki docker environment to [Timebox: 0.5h] Improve mediawiki docker environment.Thu, Jan 22, 1:14 AM

dang updated the task description. (Show Details)

dang updated the task description. (Show Details)Thu, Jan 22, 9:11 AM

dang updated the task description. (Show Details)

dang renamed this task from [Timebox: 0.5h] Improve mediawiki docker environment to [Timebox: 0h] Improve mediawiki docker environment.Thu, Jan 22, 10:41 AM

dang updated the task description. (Show Details)

No idea how to get login details of admin user, there is no record/doc mentioning it. -> since we can disable Captcha and all users in docker compose env has sysop and bureaucrat rights, I think it's unnecessary to create admin user when starting docker compose
DB replication seems to be failing; when a replica is configured: login doesn’t work -> replica is live but stuck on SQL thread due to a failed CREATE USER

Slave_IO_Running: Yes
Slave_SQL_Running: No
Last_SQL_Errno: 1396
Last_SQL_Error: Operation CREATE USER failed for repl@% (query: CREATE USER repl@%)
Seconds_Behind_Master: NULL

dang removed dang as the assignee of this task.Thu, Jan 22, 10:47 AM

dang moved this task from Doing to Ready for Peer Review on the Wikibase Cloud (Kanban Board) board.

dang moved this task from Ready for Peer Review to Doing on the Wikibase Cloud (Kanban Board) board.Thu, Jan 22, 1:28 PM

dang renamed this task from [Timebox: 0h] Improve mediawiki docker environment to [Timebox: 4h] Improve mediawiki docker environment.Thu, Jan 22, 1:31 PM

dang claimed this task.

dang updated the task description. (Show Details)

dati18 opened https://github.com/wbstack/mediawiki/pull/521

Make replication user creation duplicate-safe

I tried to "beef up" replication thinking it would make REPLICA being able to handle more traffic, but it didn't yield any results and REPLICA is still stuck at CREATE USER, making REPLICA unstable and not healthy.

Real cause: CREATE USER 'repl'@'%' binlog event it fails with 1396, meaning repl user exists, REPLICA tries to execute the same CREATE USER and fails. It doesn't happen on freshly created volume but restarting existing environment can trigger the statement again and it is obviously replicated. Sometimes replica state changes: either the volume was reset (no more repl user) or it started from a point after CREATE USER event so replica won't replay it and no 1396.

I tried to simply use CREATE USER IF NOT EXISTS to make replica "duplicate-safe"

dang renamed this task from [Timebox: 4h] Improve mediawiki docker environment to [Timebox: 1.5h] Improve mediawiki docker environment.Thu, Jan 22, 4:25 PM

dang removed dang as the assignee of this task.

dang updated the task description. (Show Details)

dang moved this task from Doing to Ready for Peer Review on the Wikibase Cloud (Kanban Board) board.

dati18 closed https://github.com/wbstack/mediawiki/pull/520

Disable Captcha for docker compose environment

dang updated the task description. (Show Details)Fri, Jan 23, 9:54 AM

Tarrow claimed this task.Fri, Jan 23, 4:33 PM

Tarrow moved this task from Ready for Peer Review to In Review on the Wikibase Cloud (Kanban Board) board.

tarrow opened https://github.com/wbstack/mediawiki/pull/522

Remove version from docker-compose.yml

dati18 closed https://github.com/wbstack/mediawiki/pull/521

Make replication user creation duplicate-safe

Tarrow updated the task description. (Show Details)Fri, Jan 23, 4:46 PM

Tarrow updated the task description. (Show Details)

tarrow opened https://github.com/wbstack/mediawiki/pull/523

docs: add information about docker compose environment

Tarrow renamed this task from [Timebox: 1.5h] Improve mediawiki docker environment to [Timebox: 1h] Improve mediawiki docker environment.Fri, Jan 23, 5:00 PM

Tarrow reassigned this task from Tarrow to dang.

Tarrow updated the task description. (Show Details)

Tarrow moved this task from In Review to To do on the Wikibase Cloud (Kanban Board) board.

Tarrow subscribed.

tarrow closed https://github.com/wbstack/mediawiki/pull/523

docs: add information about docker compose environment

dang updated the task description. (Show Details)Mon, Jan 26, 9:01 AM

tarrow closed https://github.com/wbstack/mediawiki/pull/522

Remove version from docker-compose.yml

dang updated the task description. (Show Details)Mon, Jan 26, 9:42 AM

dang removed dang as the assignee of this task.Mon, Jan 26, 11:38 AM

dang moved this task from To do to Ready for Peer Review on the Wikibase Cloud (Kanban Board) board.