Details

Reviewers

Commits

rOPSbb5da5835c74: Add interwiki agora: and wolfplex:

Summary

Create a more restricted user for MediaWiki maintenance.
Privileges are limited to the affected tables.

Populate a support SQL script with the interwiki list.
The use of REPLACE allows to avoid to read tables first;
the script is safe to run each time it's modified.

Install MariaDB client on saas-mediawiki role,
so that script can be run from there.

References:

Test Plan

Create a link [[agora:Operations grimoire]] on Wolfplex wiki

Diff Detail

Repository

rOPS Nasqueron Operations

Lint

Lint Passed

Unit

No Test Coverage

Branch

interwiki-wolfplex-agora

Build Status

Buildable 5987
Build 6269: arc lint + arc unit

Event Timeline

dereckson created this revision.Sat, Oct 11, 16:11

dereckson held this revision as a draft.

Harbormaster completed remote builds in B5987: Diff 9662.Sat, Oct 11, 16:11

+ MariaDB client installation
+ MariaDB user
+ Vault privileges
+ Run support script

Harbormaster completed remote builds in B5988: Diff 9663.Sun, Oct 12, 10:05

dereckson edited the test plan for this revision. (Show Details)Sun, Oct 12, 10:05

dereckson retitled this revision from Populate extra interwiki to Add interwiki agora: and wolfplex:.

dereckson edited the summary of this revision. (Show Details)

dereckson mentioned this in T2140: Migrate Wolfplex wiki tables on a dedicated database.Sun, Oct 12, 10:30

Blocked by T2140 for Wolfplex, but we can still run it for Agora.

Rebased against D3737 split

Harbormaster completed remote builds in B5990: Diff 9666.Sun, Oct 12, 10:50

Seems iw_api needs to be populated or a blank string

roles/saas-mediawiki/mediawiki/files/interwiki/interwiki.sql.jinja
23	ERROR 1048 (23000) at line 19: Column 'iw_api' cannot be null

Per https://dev.mysql.com/doc/refman/5.7/en/user-names.html it's 32 in MySQL and undocumented in MariaDB similar section

Harbormaster completed remote builds in B5991: Diff 9667.Sun, Oct 12, 11:04

dereckson edited the summary of this revision. (Show Details)Sun, Oct 12, 11:49

iw_api is NOT NULL

Harbormaster completed remote builds in B5992: Diff 9668.Sun, Oct 12, 11:54

Works like a charm:

db-B-001

$ mysql nasqueron_wiki
root@localhost [nasqueron_wiki]> SELECT * FROM interwiki WHERE iw_prefix = 'wolfplex';
+-----------+----------------------------------+--------+------------+----------+----------+
| iw_prefix | iw_url                           | iw_api | iw_wikiid  | iw_local | iw_trans |
+-----------+----------------------------------+--------+------------+----------+----------+
| wolfplex  | https://www.wolfplex.org/wiki/$1 |        | wolfplexdb |        0 |        0 |
+-----------+----------------------------------+--------+------------+----------+----------+
1 row in set (0.000 sec)