Page MenuHomeMiraheze

RhinosF1 (Samuel)
Sysadmin

Projects (7)

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Saturday

  • Clear sailing ahead.

User Details

User Since
May 24 2019, 17:22 (69 w, 5 d)
Availability
Available
IRC Nickname
RhinosF1
GitHub User
RhinosF1
Miraheze User
RhinosF1 [ Global Accounts ]

FOSS developer and Miraheze Sysadmin.

See https://login.miraheze.org/wiki/User:RhinosF1

Recent Activity

Today

RhinosF1 added a comment to T6146: Varnish/Nginx? returning 429 due to DDoS/SQLi mitigations when rendering Math Images in some cases.

causing icinga to warn because nginx access logs were filled with 429s.

It was doing this with the old system anyway on occasion. I assume you mean more frequently. Are 429s something we can exclude from the check? Would that be better?

Thu, Sep 24, 09:03 · Site Reliability Engineering, Extensions, Universal Omega
RhinosF1 added a comment to T6146: Varnish/Nginx? returning 429 due to DDoS/SQLi mitigations when rendering Math Images in some cases.

It seems this problem will prolong indefinitely or should we expect a solution soon?

@Paladox and @Southparkfan are working to deal with this. The rate limiter will probably exist for the foreseeable future unless we are happy are resources can cope with traffic that was causing issues (DDoS/SQLis) but we are working to improve the solution so it doesn't affect legitimate traffic.

Thu, Sep 24, 09:02 · Site Reliability Engineering, Extensions, Universal Omega

Yesterday

RhinosF1 renamed T6211: Changing language in ManageWiki not impacting displayed i18n messages from request editing LocalSettings.php to display the wiki in Arabic to Changing language in ManageWiki not impacting displayed i18n messages.
Wed, Sep 23, 13:02 · ManageWiki, Configuration, Universal Omega
RhinosF1 reopened T6211: Changing language in ManageWiki not impacting displayed i18n messages as "Open".
Wed, Sep 23, 13:01 · ManageWiki, Configuration, Universal Omega
RhinosF1 updated subscribers of T6211: Changing language in ManageWiki not impacting displayed i18n messages.

I've looked at the documentation as we should be doing that when you change the option and I see:

In MediaWiki 1.8 or older, if you change this after installation, you should run the maintenance/rebuildmessages.php script to rebuild the user interface messages (MediaWiki namespace). Otherwise, you will not see the interface in the new language, or a mix of the old and new languages. Note that running that script will override any custom interface messages you may have created.

Wed, Sep 23, 13:01 · ManageWiki, Configuration, Universal Omega

Tue, Sep 22

RhinosF1 added a project to T6208: DBQueryError: Production Error.
Tue, Sep 22, 02:14 · Production Error, MediaWiki

Mon, Sep 21

RhinosF1 assigned T6204: Security Review LDAP Stack to Paladox.

Over to you to install, or should we just just close and handle the rest in the parent task

Mon, Sep 21, 18:21 · Universal Omega, Extensions
RhinosF1 added a subtask for T5580: Setup a wiki for LDAP: T6204: Security Review LDAP Stack.
Mon, Sep 21, 17:36 · Site Reliability Engineering
RhinosF1 added a parent task for T6204: Security Review LDAP Stack: T5580: Setup a wiki for LDAP.
Mon, Sep 21, 17:36 · Universal Omega, Extensions

Sun, Sep 20

RhinosF1 added a comment to T6137: Localisation of namespace - Event:.

Could you reply to the dev on the github issue?

Sun, Sep 20, 18:10 · Upstream, Extensions, Universal Omega
RhinosF1 edited projects for T6201: Add Skinny extension and few skines, added: Extensions; removed MediaWiki.
Sun, Sep 20, 16:48 · Universal Omega, Extensions
RhinosF1 updated subscribers of T4976: CSP whitelist request for www.desmos.com.
Sun, Sep 20, 12:38 · Universal Omega, Configuration
RhinosF1 renamed T4976: CSP whitelist request for www.desmos.com from Add iframe extension and config [CSP whitelist request for www.desmos.com] to CSP whitelist request for www.desmos.com.
Sun, Sep 20, 12:38 · Universal Omega, Configuration
RhinosF1 reopened T4976: CSP whitelist request for www.desmos.com, a subtask of T5092: Create a CSP whitelist policy, as Open.
Sun, Sep 20, 12:37 · Site Reliability Engineering
RhinosF1 reopened T4976: CSP whitelist request for www.desmos.com as "Open".

Per merged task

Sun, Sep 20, 12:37 · Universal Omega, Configuration
RhinosF1 merged T6200: Add "www.desmos.com" to Content Security Policy into T4976: CSP whitelist request for www.desmos.com.
Sun, Sep 20, 12:37 · Universal Omega, Configuration
RhinosF1 merged task T6200: Add "www.desmos.com" to Content Security Policy into T4976: CSP whitelist request for www.desmos.com.
Sun, Sep 20, 12:37

Sat, Sep 19

RhinosF1 added a comment to T5189: Google Search Console Team Coverage issues warnings.

Hmm, I'd need to ask whoever asked that rule to see if we can switch it.

Sat, Sep 19, 17:42 · Universal Omega, Configuration
RhinosF1 added a comment to T5189: Google Search Console Team Coverage issues warnings.

Yes we did that in mid July. I'm just not blacklisting the ~6000 entires manually it would take to resolve the error in search console. Google shouldn't be indexing them any more. They're old errors.

Sat, Sep 19, 17:22 · Universal Omega, Configuration
RhinosF1 updated subscribers of R9:b04893259161: block indexing of NS_SPECIAL (#3191).

Removing randomly subscribed people

Sat, Sep 19, 17:19
RhinosF1 merged T5189: Google Search Console Team Coverage issues warnings into T5978: Set $wgNamespaceRobotPolicies to noindex for NS_SPECIAL.
Sat, Sep 19, 17:17 · Universal Omega, Configuration
RhinosF1 merged task T5189: Google Search Console Team Coverage issues warnings into T5978: Set $wgNamespaceRobotPolicies to noindex for NS_SPECIAL.
Sat, Sep 19, 17:17 · Universal Omega, Configuration
RhinosF1 added a comment to T5189: Google Search Console Team Coverage issues warnings.

We blocked indexing of all special pages, this was fixed months back.

Sat, Sep 19, 17:13 · Universal Omega, Configuration
RhinosF1 added a comment to T6137: Localisation of namespace - Event:.

@Helper: please see the replies at https://github.com/edwardspec/mediawiki-extension-JsCalendar/issues/2

Sat, Sep 19, 09:34 · Upstream, Extensions, Universal Omega
RhinosF1 added a comment to T6137: Localisation of namespace - Event:.

The part about localising custom namespaces, it would have to have a change to ManageWiki.

Sat, Sep 19, 07:17 · Upstream, Extensions, Universal Omega
RhinosF1 edited projects for T6137: Localisation of namespace - Event:, added: Extensions, Upstream; removed MediaWiki.

If you would provide the JsCalendar extension to all new wiki, why not to translate the Event namespace, used by default in the extension, together with translation of extension by translatewiki.net ?

Sat, Sep 19, 07:15 · Upstream, Extensions, Universal Omega
RhinosF1 added a comment to T6196: Delete a wiki.

Actually, you're blocked on wiki so it'll be stewards@miraheze.org

Sat, Sep 19, 07:12 · MediaWiki

Fri, Sep 18

RhinosF1 renamed T6195: Allow upload_by_url from Special:Upload from Enable $wgAllowCopyUploads to Allow upload_by_url from Special:Upload.
Fri, Sep 18, 20:14 · MediaWiki, Universal Omega

Mon, Sep 7

RhinosF1 renamed T6146: Varnish/Nginx? returning 429 due to DDoS/SQLi mitigations when rendering Math Images in some cases from Varnish/Nginx? returning 429 when rendering Math Images in some cases to Varnish/Nginx? returning 429 due to DDoS/SQLi mitigations when rendering Math Images in some cases.
Mon, Sep 7, 17:13 · Site Reliability Engineering, Extensions, Universal Omega
RhinosF1 renamed T6146: Varnish/Nginx? returning 429 due to DDoS/SQLi mitigations when rendering Math Images in some cases from Extension:Math formulas return 429 errors to Varnish/Nginx? returning 429 when rendering Math Images in some cases.
Mon, Sep 7, 17:13 · Site Reliability Engineering, Extensions, Universal Omega
RhinosF1 moved T6146: Varnish/Nginx? returning 429 due to DDoS/SQLi mitigations when rendering Math Images in some cases from Deployed Extension Bugs to Backlog on the Extensions board.

@Southparkfan, @Paladox: Could this be the rate limiter kicking into play?

Mon, Sep 7, 17:12 · Site Reliability Engineering, Extensions, Universal Omega
RhinosF1 raised the priority of T6146: Varnish/Nginx? returning 429 due to DDoS/SQLi mitigations when rendering Math Images in some cases from Normal to High.

Moving to high, a lot of wikis use this.

Mon, Sep 7, 17:09 · Site Reliability Engineering, Extensions, Universal Omega

Sat, Sep 5

RhinosF1 changed the visibility for T6145: test new form config.
Sat, Sep 5, 06:24 · Trash
RhinosF1 updated the task description for T6145: test new form config.
Sat, Sep 5, 06:24 · Trash
RhinosF1 created T6145: test new form config.
Sat, Sep 5, 06:24 · Trash

Aug 24 2020

RhinosF1 committed R9:567ff4e63f77: managewiki: migrate wgFooterIcons (authored by RhinosF1).
managewiki: migrate wgFooterIcons
Aug 24 2020, 22:24

Aug 22 2020

RhinosF1 closed T6041: WikiBase custom configuration as Invalid.

Script should run within 2 weeks now. Sub tasks are open for the additional feature requests. Closing this as invalid as it's simply a tracking task for 3 seperate issues/requests

Aug 22 2020, 06:58 · MediaWiki
RhinosF1 added a project to T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org): Production Error.
Aug 22 2020, 06:57 · Production Error, Upstream, MediaWiki
RhinosF1 added a project to T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org): Upstream.
Aug 22 2020, 06:56 · Production Error, Upstream, MediaWiki
RhinosF1 closed T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org), a subtask of T6041: WikiBase custom configuration, as Resolved.
Aug 22 2020, 06:56 · MediaWiki
RhinosF1 closed T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org), a subtask of T6045: Maintain default wikimedia sites when running populateWikibaseSitesTables, as Resolved.
Aug 22 2020, 06:56 · MediaWiki
RhinosF1 closed T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org), a subtask of T6046: Allow custom additional sites to be added to sites table, as Resolved.
Aug 22 2020, 06:56 · MediaWiki
RhinosF1 closed T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org) as Resolved.

Patch is upstream to make this work for all wikis and disabled for wikis with longer db names than this supports.

Aug 22 2020, 06:56 · Production Error, Upstream, MediaWiki
RhinosF1 merged task T6020: The site link does not work on interucroniaswiki into T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org).
Aug 22 2020, 06:55 · Extensions
RhinosF1 merged T6020: The site link does not work on interucroniaswiki into T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org).
Aug 22 2020, 06:55 · Production Error, Upstream, MediaWiki
RhinosF1 added a comment to T5988: Review all custom domains with unusual rDNS entries.

Status?

I'm marked as busy (see staffwiki) but any on the list that still trigger icinga alerts can be removed.

Aug 22 2020, 06:28 · SSL
RhinosF1 added a comment to T6054: Switch to ConfirmEdit/HCaptcha on diamowiki.miraheze.org.

Status?

We have the keys. We just need to decide whether we are okay doing this.

Aug 22 2020, 06:27 · Universal Omega, Configuration, Extensions
RhinosF1 added a comment to T5942: Miraheze Phabricator not remembering login session.
In T5942#118775, @John wrote:

I'm still struggling to reproduce this regardless of how I login. My current session has been going for weeks now

Aug 22 2020, 00:57 · Phabricator

Aug 21 2020

RhinosF1 edited projects for T6078: Extend Expensive Parser Function Limit ($wgExpensiveParserFunctionLimit) , added: Configuration; removed MediaWiki.
Aug 21 2020, 18:53 · Configuration
RhinosF1 reopened T5856: Enable file types uploads as "Open".

Now available on upstream REL1_34 branch

Aug 21 2020, 18:53 · MediaWiki, Upstream

Aug 20 2020

RhinosF1 updated the task description for T6073: Resolve google detected 5xx errors.
Aug 20 2020, 21:28 · MediaWiki, Production Error, Site Reliability Engineering
RhinosF1 created T6073: Resolve google detected 5xx errors.
Aug 20 2020, 15:43 · MediaWiki, Production Error, Site Reliability Engineering
RhinosF1 added a comment to T4005: Execute external commands on MediaWiki servers inside sandboxes.

Noting for when the time comes to read over https://phabricator.wikimedia.org/T260281#6399181 and ensure we won't face the same issues

Aug 20 2020, 11:31 · Security, Goal-2020-Jul-Dec, Site Reliability Engineering, MediaWiki
RhinosF1 triaged T6070: Apply 2017! change to cargo table as Normal priority.
Aug 20 2020, 08:50 · Site Reliability Engineering, Database, Extensions
RhinosF1 added a comment to T5199: Cargo table problem.

No one has updated the database, gonna create a seperate task.

Aug 20 2020, 08:46 · Universal Omega, Extensions

Aug 19 2020

RhinosF1 updated subscribers of T6064: Request to be security reviewer.

Adding the current security reviewers for their thoughts and maybe you could invent a proficieny test.

Aug 19 2020, 21:24 · Site Reliability Engineering
RhinosF1 added a project to T6060: Enable Special:Log?type=spamblacklist on metawiki : Configuration.
Aug 19 2020, 13:52 · Configuration, Extensions
RhinosF1 renamed T6056: 18/19-08-2020 cp* failures from 18-08-2020 cp* failures to 18/19-08-2020 cp* failures.
Aug 19 2020, 07:36 · Amanda Catherine, Site Reliability Engineering
RhinosF1 reopened T6056: 18/19-08-2020 cp* failures as "Open".

Here the alerts go again

Aug 19 2020, 07:36 · Amanda Catherine, Site Reliability Engineering

Aug 18 2020

RhinosF1 closed T6057: Sudden performance loss in Google search result as Invalid.

I have added you to search console.
Also check, sites meta tags which is required for search console verification.

Aug 18 2020, 13:43 · Site Reliability Engineering
RhinosF1 added a comment to T6057: Sudden performance loss in Google search result.

Looking at how you've set it up, you'll have to add me (rhinosf1[at]gmail.com) to your search console property.

Aug 18 2020, 12:50 · Site Reliability Engineering
RhinosF1 claimed T6057: Sudden performance loss in Google search result.

We don't control how google rank your wiki. It's not reflected by *.miraheze.org but I'll look

Aug 18 2020, 12:46 · Site Reliability Engineering
RhinosF1 added a project to T6057: Sudden performance loss in Google search result: Site Reliability Engineering.
Aug 18 2020, 12:44 · Site Reliability Engineering
RhinosF1 placed T6057: Sudden performance loss in Google search result up for grabs.
Aug 18 2020, 12:42 · Site Reliability Engineering
RhinosF1 updated the task description for T6056: 18/19-08-2020 cp* failures.
Aug 18 2020, 08:58 · Amanda Catherine, Site Reliability Engineering
RhinosF1 triaged T6056: 18/19-08-2020 cp* failures as Unbreak Now! priority.
Aug 18 2020, 08:58 · Amanda Catherine, Site Reliability Engineering
RhinosF1 added a comment to T5199: Cargo table problem.

According to Yaron Koren, the database cargo_tables and cargo_pages are never created. To create them, stewards please help call update.php.

Aug 18 2020, 06:57 · Universal Omega, Extensions

Aug 16 2020

RhinosF1 added a comment to T6054: Switch to ConfirmEdit/HCaptcha on diamowiki.miraheze.org.

Seen, will check later.

Aug 16 2020, 10:05 · Universal Omega, Configuration, Extensions
RhinosF1 edited projects for T6054: Switch to ConfirmEdit/HCaptcha on diamowiki.miraheze.org, added: Extensions, Configuration; removed MediaWiki.
Aug 16 2020, 08:12 · Universal Omega, Configuration, Extensions
RhinosF1 renamed T6054: Switch to ConfirmEdit/HCaptcha on diamowiki.miraheze.org from Enable ConfirmEdit on diamowiki.miraheze.org to Switch to ConfirmEdit/HCaptcha on diamowiki.miraheze.org.
Aug 16 2020, 08:12 · Universal Omega, Configuration, Extensions
RhinosF1 added a comment to T6054: Switch to ConfirmEdit/HCaptcha on diamowiki.miraheze.org.

ConfirmEdit is enabled now, I don't think there's any reason to change the cache type.

Aug 16 2020, 07:30 · Universal Omega, Configuration, Extensions

Aug 15 2020

RhinosF1 added a reverting change for R9:18d564c9c840: add '.*scratch' to rw blacklist (#3116): R9:2dcf09935ad0: revert scratch addition to cw blacklist.
Aug 15 2020, 22:10
RhinosF1 committed R9:2dcf09935ad0: revert scratch addition to cw blacklist (authored by RhinosF1).
revert scratch addition to cw blacklist
Aug 15 2020, 22:10
RhinosF1 added a comment to T6048: WikiHiero Extension.

i still did not get the WikiHiero extension on my wiki.

Aug 15 2020, 14:20 · Universal Omega, Extensions
RhinosF1 added a comment to T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org).

@Paladox: could you run the alter on the tables now rather than waiting for upstream to merge?

Aug 15 2020, 12:30 · Production Error, Upstream, MediaWiki
RhinosF1 moved T6048: WikiHiero Extension from Review Needed to Reviewed Accepted on the Extensions board.

WMF installed, auto-approved

Aug 15 2020, 09:58 · Universal Omega, Extensions
RhinosF1 closed T6050: 新提交 as Invalid.

See https://meta.miraheze.org/wiki/FAQ#How_do_I_change_my_logo_or_favicon.3F

Aug 15 2020, 09:54 · Configuration
RhinosF1 added a comment to E122: SRE Duty.

No one known to be available and able. See email to sre@

Aug 15 2020, 09:03
RhinosF1 cancelled E122: SRE Duty.
Aug 15 2020, 09:03

Aug 14 2020

RhinosF1 changed the status of T6024: ScratchBlocks extension not parsing properly on some pages from Resolved to Invalid.
Aug 14 2020, 14:17 · Extensions
Hispano76 awarded T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org) a Like token.
Aug 14 2020, 13:41 · Production Error, Upstream, MediaWiki
RhinosF1 added a comment to T6041: WikiBase custom configuration.

I'll see what others say

Aug 14 2020, 11:07 · MediaWiki
RhinosF1 moved T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org) from Backlog to Bugs on the MediaWiki board.
Aug 14 2020, 09:56 · Production Error, Upstream, MediaWiki
RhinosF1 edited projects for T6041: WikiBase custom configuration, added: MediaWiki; removed Configuration.
Aug 14 2020, 09:55 · MediaWiki
RhinosF1 moved T6041: WikiBase custom configuration from Backlog to Maintenance Script Run on the MediaWiki board.
Aug 14 2020, 09:55 · MediaWiki
RhinosF1 added a parent task for T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org): T6046: Allow custom additional sites to be added to sites table.
Aug 14 2020, 09:54 · Production Error, Upstream, MediaWiki
RhinosF1 added a subtask for T6046: Allow custom additional sites to be added to sites table: T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org).
Aug 14 2020, 09:54 · MediaWiki
RhinosF1 added a parent task for T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org): T6045: Maintain default wikimedia sites when running populateWikibaseSitesTables.
Aug 14 2020, 09:54 · Production Error, Upstream, MediaWiki
RhinosF1 added a subtask for T6045: Maintain default wikimedia sites when running populateWikibaseSitesTables: T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org).
Aug 14 2020, 09:54 · MediaWiki
RhinosF1 triaged T6046: Allow custom additional sites to be added to sites table as Normal priority.
Aug 14 2020, 09:53 · MediaWiki
RhinosF1 triaged T6045: Maintain default wikimedia sites when running populateWikibaseSitesTables as Normal priority.
Aug 14 2020, 09:52 · MediaWiki
RhinosF1 added a comment to T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org).

@Paladox: could we add https://github.com/miraheze/MirahezeMagic/commit/472a8acfcbb9798c37c8df88200cf23354209326 back or alter the table?

Aug 14 2020, 09:35 · Production Error, Upstream, MediaWiki
RhinosF1 added a comment to T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org).

Well, this is very strange. I see the error is in field site_global_key which is defined as varbinary(32): while I cannot be sure of your naming convention, I assume you are identifying the wiki with an ID like datatrekwiki or datatrek so it should easily fit.

The insert it's failing on is for a wiki with a db name of 38 characters which is over 32. We seem to allow db names up to 64 charecters.

Aug 14 2020, 09:34 · Production Error, Upstream, MediaWiki
RhinosF1 added a comment to T6041: WikiBase custom configuration.

Try to use the importSites.php script, as explained here, with the following XML file:

<?xml version="1.0"?>
<sites xmlns="http://www.mediawiki.org/xml/sitelist-1.0/" version="1.0">
  <site type="mediawiki">
    <globalid>wikitrek</globalid>
    <group>wikitrek</group>
    <path type="page_path">https://wikitrek.org/index.php/$1</path>
    <path type="file_path">https://wiktrek.org/$1</path>
    <languagecode>it</languagecode>
  </site>
  <site type="mediawiki">
    <globalid>sto</globalid>
    <group>gamepedia</group>
    <path type="page_path">https://sto.gamepedia.com/$1</path>
    <path type="file_path">https://sto.gamepedia.com/$1</path>
    <languagecode>en</languagecode>
  </site>
</sites>

I believe the content is self-explanatory, anyway this file is adding two wikis respectively to wikitrek and gamepedia group. This would allow all users to link WikiBase entities to pages from those sites using SiteLink – of course provided that $wgWBRepoSettings['siteLinkGroups'] is properly configured accordingly.

This will just get overridden once the script works. We need to find a method to add other wikis to the script that populates it and get that working.

Aug 14 2020, 09:25 · MediaWiki
RhinosF1 added a comment to T6041: WikiBase custom configuration.

I can see about the standard wikimedia ones if we can modify the script we reuse. I'd just leave the info on other wikis you want added here and we can work on it.

Aug 14 2020, 09:15 · MediaWiki
RhinosF1 added a comment to T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org).

The easiest and more robust way to add sites to the sites table is using an XML file and importSites.php script as described here https://www.mediawiki.org/wiki/Manual:Sites_table#Adding_a_new_site .
I will provide a sample in T6041 for you to try.

That won't help, the script that we use to populate the sites table of wikis is failing because the column isn't big enough for the data it needs to hold. We're going to have that issue whatever way we try and import the table.

Aug 14 2020, 09:07 · Production Error, Upstream, MediaWiki
RhinosF1 updated subscribers of T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org).

@Paladox: You've dealt with similar issues before, would you mind proposing whatever change needs to be done and/or applying it to our tables?

Aug 14 2020, 08:52 · Production Error, Upstream, MediaWiki
RhinosF1 added a comment to T6041: WikiBase custom configuration.

And another question: are you only adding Miraheze wikis to sites table? Meaning you are discarding the configuration with the default groups like wikipedia, commons, wikidata and so on?

Only Miraheze Wikis, it should be running when you turn the extension on as well but I'll do a manual run for your wiki.

Aug 14 2020, 08:35 · MediaWiki
RhinosF1 triaged T6044: populateWikibaseSitesTable.php fails with Error: 1406 Data too long for column 'site_global_key' at row 1 (db11.miraheze.org) as Normal priority.
Aug 14 2020, 08:34 · Production Error, Upstream, MediaWiki
RhinosF1 added a comment to T6041: WikiBase custom configuration.

And another question: are you only adding Miraheze wikis to sites table? Meaning you are discarding the configuration with the default groups like wikipedia, commons, wikidata and so on?

Only Miraheze Wikis, it should be running when you turn the extension on as well but I'll do a manual run for your wiki.

Aug 14 2020, 08:28 · MediaWiki