Page MenuHomeMiraheze
Paste Active Pastes
  • DROP DATABASE 2gtvitrewiki;
    DROP DATABASE 2k20wiki;
    DROP DATABASE 42svwiki;
    DROP DATABASE 4b3twiki;
    DROP DATABASE 4dprintingwiki;
    ...
    • Mon, Nov 30, 20:40
    • 698 Lines
  • jobrunner1 metawiki: [d5aaceb1553e6954e85705c9] [no req] UnexpectedValueException from line 1228 of /srv/mediawiki/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php: Got connection to 'bybelstudieinfowiki', but expected '23b23twiki'
    #0 /srv/mediawiki/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(930): Wikimedia\Rdbms\LoadBalancer->getForeignConnection(integer, string, integer)
    #1 /srv/mediawiki/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(901): Wikimedia\Rdbms\LoadBalancer->getServerConnection(integer, string, integer)
    #2 /srv/mediawiki/w/extensions/CreateWiki/includes/WikiManager.php(54): Wikimedia\Rdbms\LoadBalancer->getConnection(integer, array, string)
    #3 /srv/mediawiki/w/extensions/CreateWiki/includes/CreateWiki/CreateWikiJob.php(9): WikiManager->__construct(string)
    ...
    • Sat, Nov 21, 23:40
    • 12 Lines
  • MariaDB [test2wiki]> select * from ipblocks where ipb_id = 9;
    +--------+-------------+----------+--------------+---------------+----------------+----------+---------------+--------------------+----------------------+------------+-----------------+---------------+-------------+-----------------+--------------------+---------------------+--------------+
    | ipb_id | ipb_address | ipb_user | ipb_by_actor | ipb_reason_id | ipb_timestamp | ipb_auto | ipb_anon_only | ipb_create_account | ipb_enable_autoblock | ipb_expiry | ipb_range_start | ipb_range_end | ipb_deleted | ipb_block_email | ipb_allow_usertalk | ipb_parent_block_id | ipb_sitewide |
    +--------+-------------+----------+--------------+---------------+----------------+----------+---------------+--------------------+----------------------+------------+-----------------+---------------+-------------+-----------------+--------------------+---------------------+--------------+
    | 9 | Miraheze 2 | 80 | 29775 | 5010 | 20200624223840 | 0 | 0 | 1 | 1 | infinity | | | 1 | 1 | 0 | NULL | 1 |
    ...
    • Sat, Nov 14, 16:33
    • 7 Lines
  • ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQDdBJtIRO4d5xw8jrqelIeTO4zRQHsliPDdLZdp9j56yhu5U39Nl0K5w5Cgt7jBwDc9xGNR4b/132MjlOfhOAI0K2lK+JUAxYMO/fH1LYoTnBIU49fl0E0RW5TH7zAaiZXy6LpdTDdfZoK22c8qvgR2WzRKxJzt9FivtyE9TBrtV2MDsYg9Yro1NwqOHeAWtIIV+P9q8Va8fO1c7fq9lgPxCxy6fFJLvLdjEHiis7BRdNl2yFn1d+tiWbHKdeJcR4gHt9jP+nQxvxl/XWxNt7TeKUnl77qjDRgH9nVXFkkfZYB4ZTPRv+UNIxx0nVkyuXlIKdlqxAD9rZ/E+NHElMYJKKBUguwtGawcoy8nDelE39ILfes9iWkA+n+vbmTnmGxBTUN3gD73UxjfdrOTUQztVWt0ddJgE1xmp5mUzh3HUnoR7w0tWScnFxUInkBv1Ht08AEXM2ngxd6LCFs2Lu08blzS3wNX8+o10X7SZ2lv7WUuRo+Yt5YYobi1EYG8GKVY5qdNHZDjrz1a93pJpwE37AmuzKFX6J2WsvxRMEtTorKbmEvMRgfuhwaqoPLgXvbYWATNFmauNOaSnFGN6YQW+N9sA4xky/eRK7uqctBOCneubt1EDA1GAYIJb4M6+aciUT+us9kzwZoHEwuCnE4CMnC6Bf1V+Rtqyb+Ps36K5w== universal.omega000@gmail.com
    • Fri, Nov 13, 23:06
    • 1 Line
  • 2020-11-08 02:55:11 jobrunner1 vsfanwiki: [1d489537f80c622c1fee1f03] [no req] Exception from line 566 of /srv/mediawiki/w/includes/libs/http/MultiHttpClient.php: Request has no 'url' field set.
    #0 /srv/mediawiki/w/includes/libs/http/MultiHttpClient.php(178): MultiHttpClient->normalizeRequests(array)
    #1 /srv/mediawiki/w/includes/deferred/CdnCacheUpdate.php(326): MultiHttpClient->runMulti(array)
    #2 /srv/mediawiki/w/includes/deferred/CdnCacheUpdate.php(147): CdnCacheUpdate::naivePurge(array)
    #3 /srv/mediawiki/w/includes/deferred/CdnCacheUpdate.php(84): CdnCacheUpdate::purge(array)
    ...
    • Sun, Nov 8, 19:09
    • 16 Lines
  • strace: Process 21007 attached
    accept(9, 0x7ffd4cc3da00, [112]) = ? ERESTARTSYS (To be restarted if SA_RESTART is set)
    --- SIGQUIT {si_signo=SIGQUIT, si_code=SI_USER, si_pid=21001, si_uid=0} ---
    close(9) = 0
    socket(AF_UNIX, SOCK_STREAM, 0) = 4
    ...
    • Oct 28 2020, 14:28
    • 123 Lines
  • strace: Process 21007 attached
    accept(9, 0x7ffd4cc3da00, [112]) = ? ERESTARTSYS (To be restarted if SA_RESTART is set)
    --- SIGQUIT {si_signo=SIGQUIT, si_code=SI_USER, si_pid=21001, si_uid=0} ---
    close(9) = 0
    socket(AF_UNIX, SOCK_STREAM, 0) = 4
    ...
    • Oct 28 2020, 14:27
    • 123 Lines
  • 2020-10-28 00:28:42 mw7 pluspiwiki: [399c5eeec4ab97f4b3f091aa] /w/index.php?title=%d0%a1%d0%bb%d1%83%d0%b6%d0%b5%d0%b1%d0%bd%d0%b0%d1%8f:%d0%92%d1%85%d0%be%d0%b4&returnto=zadacha+kuznecov+integraly+12-23 LogicException from line 409 of /srv/mediawiki/w/includes/cache/MessageCache.php: Process cache for 'ru' should be set by now.
    #0 /srv/mediawiki/w/includes/cache/MessageCache.php(1091): MessageCache->load(string)
    #1 /srv/mediawiki/w/includes/cache/MessageCache.php(1017): MessageCache->getMsgFromNamespace(string, string)
    #2 /srv/mediawiki/w/includes/cache/MessageCache.php(988): MessageCache->getMessageForLang(Language, string, boolean, array)
    #3 /srv/mediawiki/w/includes/cache/MessageCache.php(930): MessageCache->getMessageFromFallbackChain(Language, string, boolean)
    ...
    • Oct 28 2020, 00:31
    • 18 Lines
  • <?php
    require_once '/srv/mediawiki/w/maintenance/Maintenance.php';
    class runSchema extends Maintenance {
    ...
    • Oct 13 2020, 22:24
    • 43 Lines
  • DROP DATABASE 2boffy2tpswiki;
    DROP DATABASE 6b9twikiwiki;
    DROP DATABASE abominationfanbasesandhatebaseswiki;
    DROP DATABASE al132wiki;
    DROP DATABASE alfredsiwiki;
    ...
    • Sep 25 2020, 05:26
    • 241 Lines
  • Translations:Category:I18n/Cat/Doc/1/de
    Translations:I18nTest/Doc/1/de
    Translations:I18nTest/Doc/1/en
    Translations:Move test/1/en
    Translations:Move test/1/nl
    ...
    • Sep 19 2020, 05:03
    • 106 Lines
  • DROP DATABASE 2b2thackswiki;
    DROP DATABASE 2gearwiki;
    DROP DATABASE 2ggwiki;
    DROP DATABASE 3b9twiki;
    DROP DATABASE 3ndriuzwiki;
    ...
    • Aug 21 2020, 13:27
    • 1,158 Lines
  • Template:Public Wi-Fi block/doc
    Template:Uw-csblock/doc
    Template:Gs/topics/single notice
    Template:Tinc
    Template:Humor
    ...
    • Aug 20 2020, 22:53
    • 488 Lines
  • Module:Reply to
    Module:Asbox
    Module:High-use
    Template:Module other
    Template:Module rating
    ...
    • Aug 20 2020, 22:01
    • 54 Lines
  • Template:Public Wi-Fi block/doc
    Template:Uw-csblock/doc
    Template:Gs/topics/single notice
    Template:Tinc
    Template:Humor
    ...
    • Aug 20 2020, 22:00
    • 540 Lines
  • root@mw5:/var/log# mtr --report ns1.miraheze.org
    Start: 2020-07-25T13:56:36+0000
    HOST: mw5 Loss% Snt Last Avg Best Wrst StDev
    1.|-- 2001:41d0:800:10ff:ff:ff: 0.0% 10 1.2 1.3 0.9 2.0 0.4
    2.|-- vl15.lon1-eri1-sdagg4b-a7 0.0% 10 0.3 0.3 0.2 0.5 0.1
    ...
    • Jul 25 2020, 13:58
    • 20 Lines
  • 9b6twiki
    a320wiki
    abrigadawiki
    aeiawiki
    aibowiki
    ...
    • Jul 20 2020, 19:09
    • 180 Lines
  • refreshLinksDynamic
    refreshLinksPrioritized
    htmlCacheUpdate
    recentChangesUpdate
    activityUpdateJob
    ...
    • Jul 20 2020, 15:00
    • 13 Lines
  • jobrunner1.miraheze.org:
    mw7.miraheze.org:
    htmlCacheUpdate
    recentChangesUpdate
    refreshLinksDynamic
    ...
    • Jul 20 2020, 14:44
    • 8,075 Lines
  • root@puppet2:/home/paladox# salt-ssh -E "(mw.*|jobrunner.*)" cmd.run "cat /var/log/mediawiki/debug*/exception.log | grep categoryMembershipChange | awk '{print \$4}'"
    mw7.miraheze.org:
    csydeswiki:
    thefinalrumblewiki:
    csydeswiki:
    ...
    • Jul 20 2020, 13:56
    • 112 Lines
  • #!/bin/bash
    while read line; do
    mysql -e "use mhglobal; update cw_wikis set wiki_dbcluster = 'c2' where wiki_dbname = '${line}';"
    done < /home/paladox/db9-migration-closed-July11-2020/wikis_batch_1
    • Jul 14 2020, 23:15
    • 4 Lines
  • root@puppet2:/etc/puppetlabs/puppet/environments/production# ls -lah
    total 8.0K
    drwxrwxr-x 2 root root 4.0K Feb 9 03:44 .
    drwxrwxr-x 3 root root 4.0K Feb 9 03:44 ..
    lrwxrwxrwx 1 root root 32 Feb 9 02:25 manifests -> /etc/puppetlabs/puppet/manifests
    ...
    • Jul 14 2020, 21:44
    • 7 Lines
  • root@puppet2:/etc/puppetlabs/puppet# ls -lah
    total 112K
    drwxr-xr-x 13 root root 4.0K Jun 4 13:59 .
    drwxr-xr-x 7 root root 4.0K Apr 11 17:38 ..
    -rw-r--r-- 1 root root 5.4K Feb 9 02:13 auth.conf
    ...
    • Jul 14 2020, 21:44
    • 24 Lines
  • var_> var_dump($wgAutopromote);
    array(6) {
    ["autoconfirmed"]=>
    array(3) {
    [0]=>
    ...
    • Jul 11 2020, 20:54
    • 51 Lines
  • Traceback (most recent call last):
    File "/srv/mediawiki/w/extensions/MirahezeMagic/py/generateSitemapIndex.py", line 57, in <module>
    xmlfile.write('\n\t<sitemap>{0}{1}\n\t</sitemap>'.format(str(loc), str(lastmod)))
    OSError: [Errno 9] Bad file descriptor
    ...
    • Jul 10 2020, 14:16
    • 15 Lines
  • # Pastebin zAvbOxq0
    # $OpenBSD: sshd_config,v 1.103 2018/04/09 20:41:22 tj Exp $
    # This is the sshd server system-wide configuration file. See
    # sshd_config(5) for more information.
    ...
    • Jun 29 2020, 23:09
    • 122 Lines
  • MariaDB [mhglobal]> select * from globaluser where gu_name = 'zalgo';
    Empty set (0.001 sec)
    MariaDB [mhglobal]> select * from localuser where lu_name = 'zalgo';
    Empty set (0.001 sec)
    ...
    • Jun 19 2020, 17:58
    • 14 Lines
    • Plain Text
  • DELETE FROM catalog_resources WHERE certname_id = (SELECT id FROM certnames where certname = 'dbt1.miraheze.org');
    DELETE FROM catalog_resources WHERE title LIKE '%dbt1.miraheze.org%';
    DELETE FROM resource_params WHERE value LIKE '%dbt1.miraheze.org%';
    DELETE FROM factsets WHERE certname LIKE '%dbt1.miraheze.org%';
    • Jun 11 2020, 18:48
    • 4 Lines
  • protected function pickFromDatabase() {
    global $wgRandomImageStrict;
    $dbr = wfGetDB( DB_REPLICA );
    ...
    • May 24 2020, 20:50
    • 31 Lines
  • DROP DATABASE 2035wikiwiki;
    DROP DATABASE 2035wikiwiki;
    DROP DATABASE abayedavwiki;
    DROP DATABASE aberrantencyclopediawiki;
    DROP DATABASE abysmalrobotmasterswiki;
    ...
    • May 10 2020, 18:51
    • 37 Lines
  • > var_dump($wgAddGroups);
    array(2) {
    ["bureaucrat"]=>
    array(8) {
    [0]=>
    ...
    • May 5 2020, 20:36
    • 37 Lines
  • 2020-05-05 16:24:32 test2 atrociousyoutuberswiki: [c9eb069fc9c54491f4bcee2f] /wiki/Special:RecentChanges Flow\Exception\InvalidDataException from line 57 of /srv/mediawiki/w/extensions/Flow/includes/Model/UserTuple.php: User has both id and ip
    #0 /srv/mediawiki/w/extensions/Flow/includes/Model/UserTuple.php(86): Flow\Model\UserTuple->__construct(string, integer, string)
    #1 /srv/mediawiki/w/extensions/Flow/includes/Model/AbstractRevision.php(172): Flow\Model\UserTuple::newFromArray(array, string)
    #2 /srv/mediawiki/w/extensions/Flow/includes/Model/PostRevision.php(123): Flow\Model\AbstractRevision::fromStorageRow(array, Flow\Model\PostRevision)
    #3 /srv/mediawiki/w/extensions/Flow/includes/Data/Mapper/CachingObjectMapper.php(89): Flow\Model\PostRevision::fromStorageRow(array, NULL)
    ...
    • May 5 2020, 16:27
    • 35 Lines
  • $dbw->delete(
    'logging',
    [
    'log_action' => 'rename',
    'log_title' => $oldName,
    ...
    • May 2 2020, 17:59
    • 8 Lines
  • <?php
    /**
    * This program is free software; you can redistribute it and/or modify
    * it under the terms of the GNU General Public License as published by
    ...
    • May 1 2020, 14:41
    • 319 Lines
  • > $test = [ 'flow_revision' => [ 'fields' => [ 'test1' => '' ] ], 'flow_revision' => [ 'fields' => [ 'test2' => '' ] ] ];
    > print_r($test);
    Array
    (
    ...
    • May 1 2020, 14:23
    • 15 Lines
  • $extensionUpdates = [
    'flow_revision' = [
    'fields' => [
    'rev_mod_user_ip' => '',
    ],
    ...
    • May 1 2020, 13:21
    • 18 Lines
  • $extensionUpdates['flow_revision'] = [
    'table' => 'flow_revision',
    'fields' => [
    'rev_mod_user_ip' => '',
    ...
    • May 1 2020, 13:17
    • 19 Lines
  • SELECT Comment_Username,Comment_IP,Comment_Text,Comment_Date,Comment_Date AS timestamp,CommentID,Comment_Parent_ID,vote1.Comment_Vote_Score AS current_vote,SUM(vote2.Comment_Vote_Score) AS comment_score, stats_total_points FROM `Comments`, `user_stats` LEFT JOIN `Comments_Vote` `vote1` ON ((vote1.Comment_Vote_ID = CommentID)) LEFT JOIN `Comments_Vote` `vote2` ON ((vote2.Comment_Vote_ID = CommentID)) LEFT JOIN `Comments` `Comments` ON ((Comment_actor = stats_actor)) WHERE Comment_Page_ID = '22891' GROUP BY CommentID
    • Apr 30 2020, 16:55
    • 1 Line
  • GlobalBlocking/sql/globalblocks.sql:12:)
    GlobalBlocking/sql/global_block_whitelist.sql:8:)
    GlobalBlocking/sql/global_block_whitelist.sql:10:CREATE
    Flow/flow.sql:17:)
    Flow/flow.sql:27:)
    ...
    • Apr 29 2020, 18:51
    • 268 Lines
  • $this->recacheJson();
    foreach ( (array)$this->tables as $table => $selector ) {
    $this->cwdb->update(
    $table,
    ...
    • Apr 18 2020, 16:20
    • 13 Lines
  • <?php
    require_once __DIR__ . '/../../../maintenance/Maintenance.php';
    class hackScript extends Maintenance {
    ...
    • Apr 17 2020, 01:02
    • 47 Lines
  • Apr 15 20:01:36 jobrunner1 jobrunner[31595]: nice -15 php /srv/mediawiki/w/maintenance/runJobs.php --wiki='nihongowiki' --type='LocalGlobalUserPageCacheUpdateJob' --maxtime='60' --memory-limit='192M' --result=json STDERR:
    Apr 15 20:01:36 jobrunner1 jobrunner[31595]: #011PHP Warning: count(): Parameter must be an array or an object that implements Countable in /srv/mediawiki/w/extensions/CreateWiki/includes/WikiInitialise.php on line 57
    Apr 15 20:01:36 jobrunner1 jobrunner[31595]: Warning: count(): Parameter must be an array or an object that implements Countable in /srv/mediawiki/w/extensions/CreateWiki/includes/WikiInitialise.php on line 57
    Apr 15 20:01:36 jobrunner1 jobrunner[31595]: PHP Notice: Undefined index: domains in /srv/mediawiki/w/extensions/CreateWiki/includes/WikiInitialise.php on line 67
    Apr 15 20:01:36 jobrunner1 jobrunner[31595]: Notice: Undefined index: domains in /srv/mediawiki/w/extensions/CreateWiki/includes/WikiInitialise.php on line 67
    ...
    • Apr 15 2020, 20:11
    • 19 Lines
  • root@mw4:/srv/mediawiki/w/maintenance# sudo -u www-data php eval.php --wiki=awfulmovieswiki
    > var_dump($wgNamespaceAliases);
    array(3) {
    [""]=>
    int(275)
    ...
    • Apr 15 2020, 18:34
    • 10 Lines
  • "namespacealiases": [
    {
    "id": 6,
    "*": "Image"
    },
    ...
    • Apr 15 2020, 18:30
    • 14 Lines
  • [08-Apr-2020 17:36:09] [pool www] pid 1021
    script_filename = /srv/mediawiki/w/index.php
    [0x00007efecb01ff10] curl_exec() /srv/mediawiki/w/vendor/guzzlehttp/guzzle/src/Handler/CurlHandler.php:40
    [0x00007efecb01fe70] __invoke() /srv/mediawiki/w/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php:28
    [0x00007efecb01fdc0] GuzzleHttp\Handler\{closure}() /srv/mediawiki/w/vendor/guzzlehttp/guzzle/src/Handler/Proxy.php:51
    ...
    • Apr 8 2020, 17:49
    • 22 Lines
  • > var_dump($wgContentHandlers);
    array(9) {
    ["JsonSchema"]=>
    string(24) "JsonSchemaContentHandler"
    ["Scribunto"]=>
    ...
    • Apr 7 2020, 02:09
    • 21 Lines
  • [06-Apr-2020 00:10:22 UTC] wgRelatedArticlesFooterWhitelistedSkins
    2020-04-06 00:10:22 test2 test2wiki: [510a5ab26fd4e519adfd961c] /wiki/Special:ManageWiki/settings ErrorException from line 232 of /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php: PHP Warning: error_log() expects parameter 1 to be string, array given
    #0 [internal function]: MWExceptionHandler::handleError(integer, string, string, integer, array)
    #1 /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php(232): error_log(array, integer)
    #2 /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php(21): ManageWikiFormFactoryBuilder::buildDescriptorSettings(string, boolean, RequestContext, RemoteWiki)
    ...
    • Apr 6 2020, 00:24
    • 17 Lines
  • [06-Apr-2020 00:10:22 UTC] wgAbuseFilterActions
    2020-04-06 00:10:22 test2 test2wiki: [510a5ab26fd4e519adfd961c] /wiki/Special:ManageWiki/settings ErrorException from line 232 of /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php: PHP Warning: error_log() expects parameter 1 to be string, array given
    #0 [internal function]: MWExceptionHandler::handleError(integer, string, string, integer, array)
    #1 /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php(232): error_log(array, integer)
    #2 /srv/mediawiki/w/extensions/ManageWiki/includes/formFactory/ManageWikiFormFactoryBuilder.php(21): ManageWikiFormFactoryBuilder::buildDescriptorSettings(string, boolean, RequestContext, RemoteWiki)
    ...
    • Apr 6 2020, 00:22
    • 388 Lines
  • DROP DATABASE 2a2pwiki;
    DROP DATABASE 2b2tmcpewiki;
    DROP DATABASE 5rmmwiki;
    DROP DATABASE 7b7twiki;
    DROP DATABASE abootwikiwiki;
    ...
    • Apr 5 2020, 13:04
    • 1,072 Lines
  • {
    "timestamp": 0,
    "database": "metawiki",
    "created": "20150802185000",
    "dbcluster": "c1",
    ...
    • Mar 30 2020, 18:28
    • 8,651 Lines
    • JSON
  • File: databases.json
    ----
    {
    "timestamp": "20200329000000",
    "databases": [
    ...
    • Mar 29 2020, 19:59
    • 97 Lines
  • DELETE FROM catalog_resources WHERE certname_id = (SELECT id FROM certnames where certname = 'ns1.miraheze.org');
    DELETE FROM catalog_resources WHERE title LIKE '%ns1.miraheze.org%';
    DELETE FROM resource_params WHERE value LIKE '%ns1.miraheze.org%';
    DELETE FROM factsets WHERE certname LIKE '%ns1.miraheze.org%';
    • Mar 29 2020, 16:42
    • 4 Lines
  • 131parkhurstwiki
    200xwiki
    220biblewiki
    2boffy2tpswiki
    2builders2toolswiki
    ...
    • Mar 28 2020, 16:46
    • 1,818 Lines
  • <?php
    /**
    * This program is free software; you can redistribute it and/or modify
    * it under the terms of the GNU General Public License as published by
    * the Free Software Foundation; either version 2 of the License, or
    ...
    • Mar 28 2020, 16:40
    • 67 Lines
  • This is ApacheBench, Version 2.3 <$Revision: 1843412 $>
    Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
    Licensed to The Apache Software Foundation, http://www.apache.org/
    Benchmarking test2.miraheze.org (be patient)
    ...
    • Mar 24 2020, 02:22
    • 57 Lines
  • This is ApacheBench, Version 2.3 <$Revision: 1843412 $>
    Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
    Licensed to The Apache Software Foundation, http://www.apache.org/
    Benchmarking test2.miraheze.org (be patient)
    ...
    • Mar 24 2020, 02:21
    • 56 Lines
  • {{Server
    | name = xxx
    | location =
    | host = xxx.miraheze.org
    | usage =
    ...
    • Mar 19 2020, 21:23
    • 16 Lines
  • root@db4:/home/paladox# sed -n '501,1001p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_2
    root@db4:/home/paladox# sed -n '1002,1502p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_2
    root@db4:/home/paladox# sed -n '1503,2003p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_4
    root@db4:/home/paladox# sed -n '1002,1502p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_3
    root@db4:/home/paladox# sed -n '2004,2504p' /home/paladox/all_wikis > /home/paladox/all_wikis_selection_5
    ...
    • Mar 8 2020, 13:13
    • 9 Lines
  • My plan for the migrations will consist of setting the wiki into read only mode, backing up the db (by copying it to the new db host), restoring the db from the import on the new db server, switching the wiki to use the new db server and making the wiki use the new cache proxy.
    The below is a guide on the steps i will take to migrate wikis to the new infrastructure (note that not all steps have to be followed, but should be evauluated depending on size).
    1. Set the wiki into read only, you can do this by setting wgReadOnly in LocalSettings to 'Wiki being migrated to the new infrastructure'.
    ...
    • Feb 19 2020, 02:43
    • 10 Lines
  • root@db7:/home/paladox# fio --ioengine=libaio --size=1024m --filename=$HOME/tempfile --direct=1 --loops=5 --name=test --bs=1024m --rw=write --zero_buffers=1
    test: (g=0): rw=write, bs=(R) 1024MiB-1024MiB, (W) 1024MiB-1024MiB, (T) 1024MiB-1024MiB, ioengine=libaio, iodepth=1
    fio-3.12
    Starting 1 process
    test: Laying out IO file (1 file / 1024MiB)
    ...
    • Feb 17 2020, 21:43
    • 30 Lines
  • root@db7:/home/paladox# sudo stress-ng --cpu 4 --io 4 --vm 1 --vm-bytes 1G --timeout 60s --metrics-brief
    stress-ng: info: [32330] dispatching hogs: 4 cpu, 4 io, 1 vm
    stress-ng: info: [32330] successful run completed in 60.18s (1 min, 0.18 secs)
    stress-ng: info: [32330] stressor bogo ops real time usr time sys time bogo ops/s bogo ops/s
    stress-ng: info: [32330] (secs) (secs) (secs) (real time) (usr+sys time)
    ...
    • Feb 17 2020, 21:21
    • 8 Lines
  • root@misc2:/home/paladox# ping mw2.miraheze.org
    PING mw2.miraheze.org(2a00:d880:5:799::2 (2a00:d880:5:799::2)) 56 data bytes
    64 bytes from 2a00:d880:5:799::2 (2a00:d880:5:799::2): icmp_seq=1 ttl=62 time=1.40 ms
    64 bytes from 2a00:d880:5:799::2 (2a00:d880:5:799::2): icmp_seq=2 ttl=62 time=0.518 ms
    64 bytes from 2a00:d880:5:799::2 (2a00:d880:5:799::2): icmp_seq=3 ttl=62 time=7.51 ms
    ...
    • Feb 17 2020, 17:06
    • 24 Lines
    • Plain Text
  • # This file describes the network interfaces available on your system
    # and how to activate them. For more information, see interfaces(5).
    source /etc/network/interfaces.d/*
    ...
    • Feb 11 2020, 23:54
    • 18 Lines
  • 100.00% 249.777 1 - main()
    94.72% 236.597 1 - MediaWiki::run
    94.57% 236.215 1 - MediaWiki::main
    56.24% 140.481 1 - MediaWiki::{closure}
    56.24% 140.478 1 - OutputPage::output
    ...
    • Feb 11 2020, 17:50
    • 297 Lines
  • 100.00% 702.744 1 - main()
    97.81% 687.324 1 - MediaWiki::run
    96.71% 679.596 1 - MediaWiki::main
    87.38% 614.072 1 - MediaWiki::performRequest
    87.19% 612.692 1 - MediaWiki::performAction
    ...
    • Feb 11 2020, 17:45
    • 436 Lines
  • root@db6:/home/paladox# df -h
    Filesystem Size Used Avail Use% Mounted on
    udev 12G 0 12G 0% /dev
    tmpfs 2.3G 25M 2.3G 2% /run
    /dev/sda1 637G 2.9G 602G 1% /
    ...
    • Feb 10 2020, 14:08
    • 10 Lines
  • /usr/bin/ssh -v -e none -T -o BatchMode=yes cloud2.miraheze.org /usr/sbin/qm vncproxy 104
    OpenSSH_7.9p1 Debian-10+deb10u2, OpenSSL 1.1.1d 10 Sep 2019
    debug1: Reading configuration data /root/.ssh/config
    debug1: Reading configuration data /etc/ssh/ssh_config
    debug1: /etc/ssh/ssh_config line 19: Applying options for *
    ...
    • Feb 9 2020, 23:33
    • 30 Lines
  • Creating a cluster:
    1. Run the following `ssh -L 8006:127.0.0.1:8006 <user>@<cloud_host>.miraheze.org`
    2. Go to https://localhost:8006
    3. Enter login details, click on “Datacenter” then “Cluster”.
    ...
    • Feb 9 2020, 20:47
    • 15 Lines
  • Creating a cluster:
    1. Run the following `ssh -L 8006:127.0.0.1:8006 <user>@<cloud_host>.miraheze.org`
    2. Go to https://localhost:8006
    3. Enter login details, click on “Datacenter” then “Cluster”.
    ...
    • Feb 8 2020, 20:23
    • 15 Lines
  • IPV6 setup:
    1. Go to https://ca.ovh.com/manager/#/configuration/ip?tab=ip
    2. Select the host you want to configure the ipv6 address for, from the dropdown.
    3. You should see a ipv6 looking address in the list
    4. Click on it to expand the list
    ...
    • Feb 7 2020, 18:03
    • 131 Lines
    • Plain Text
  • iface vmbr0 inet6 static
    address 2001:41d0:800:1056::2
    netmask 64
    post-up /sbin/ip -f inet6 route add 2001:41D0:800:10FF:FF:FF:FF:FF dev vmbr0
    post-up /sbin/ip -f inet6 route add default via 2001:41D0:800:10FF:FF:FF:FF:FF
    ...
    • Feb 7 2020, 17:18
    • 7 Lines
  • # This file describes the network interfaces available on your system
    # and how to activate them. For more information, see interfaces(5).
    # The loopback network interface
    auto lo
    ...
    • Feb 7 2020, 16:12
    • 38 Lines
  • allow-hotplug eth0
    iface eth0 inet dhcp
    iface eth0 inet6 manual
    pre-up sleep 5
    up dhclient -6 -nw -v eth0
    ...
    • Feb 3 2020, 23:48
    • 18 Lines
  • allow-hotplug eth0
    #iface eth0 inet dhcp
    iface eth0 inet manual
    iface eth0 inet6 manual
    pre-up sleep 5
    ...
    • Feb 3 2020, 23:45
    • 17 Lines
  • cloud1:
    cp6
    db6
    gluster1
    jobrunner1
    ...
    • Feb 3 2020, 15:42
    • 20 Lines
    • Plain Text
  • 2020-01-31 20:00:56 test1.miraheze.org test1wiki: [287c1c1dd09621846fdd3f68] /wiki/Special:Random Wikimedia\Rdbms\DBQueryError from line 1603 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
    Query: SELECT page_title,page_namespace FROM `page` LEFT JOIN `page_props` `disambig_props` ON ((page_id = disambig_props.pp_page) AND disambig_props.pp_propname = 'disambiguation') LEFT JOIN `page_props` ON ((page_id = pp_page) AND pp_propname = 'softredirect') WHERE page_namespace IN ('4','0','250','252') AND page_is_redirect = '0' AND (page_random >= 0.540213465924) AND disambig_props.pp_page IS NULL AND pp_page IS NULL ORDER BY page_random LIMIT 1
    Function: RandomPage::selectRandomPageFromDB
    Error: 1052 Column 'pp_page' in where clause is ambiguous (mediawiki-internal-db-master.miraheze.org)
    • Jan 31 2020, 20:07
    • 4 Lines
  • /wiki/Special:Random Wikimedia\Rdbms\DBQueryError from line 1603 of /srv/mediawiki/w/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
    Query: SELECT page_title,page_namespace FROM `page` LEFT JOIN `page_props` ON ((page_id = pp_page) AND pp_propname = 'softredirect') LEFT JOIN `page_props` ON ((page_id = pp_page) AND pp_propname = 'softredirect') WHERE page_namespace IN ('4','0','250','252') AND page_is_redirect = '0' AND (page_random >= 0.275534197787) AND pp_page IS NULL ORDER BY page_random LIMIT 1
    Function: RandomPage::selectRandomPageFromDB
    Error: 1066 Not unique table/alias: 'page_props' (mediawiki-internal-db-master.miraheze.org)
    • Jan 31 2020, 19:38
    • 4 Lines
  • varnish> backend.list
    200
    Backend name Admin Probe Last change
    boot.misc2 probe healthy Thu, 30 Jan 2020 20:49:05 GMT
    boot.lizardfs6 probe 5/5 good Thu, 30 Jan 2020 21:02:19 GMT
    ...
    • Jan 30 2020, 23:03
    • 14 Lines
  • varnish> backend.list
    200
    Backend name Admin Probe Last updated
    boot.misc2 probe Healthy (no probe) Sun, 19 Jan 2020 20:48:23 GMT
    boot.lizardfs6 probe Healthy 5/5 Thu, 30 Jan 2020 21:02:21 GMT
    ...
    • Jan 30 2020, 23:02
    • 13 Lines
  • LIZARDFS6:
    root@lizardfs6:/home/paladox# dd if=/dev/zero of=/tmp/test1.img bs=1G count=1 oflag=dsync
    1+0 records in
    1+0 records out
    ...
    • Jan 27 2020, 22:39
    • 34 Lines
  • root@misc2:/home/paladox# ping6 2a00:d880:6:786::2
    PING 2a00:d880:6:786::2(2a00:d880:6:786::2) 56 data bytes
    64 bytes from 2a00:d880:6:786::2: icmp_seq=1 ttl=62 time=0.538 ms
    64 bytes from 2a00:d880:6:786::2: icmp_seq=2 ttl=62 time=0.674 ms
    64 bytes from 2a00:d880:6:786::2: icmp_seq=3 ttl=62 time=0.647 ms
    ...
    • Jan 22 2020, 13:49
    • 17 Lines
  • Categoría:Personas de Aguascalientes
    Categoría:Personas de Alemania
    Categoría:Personas de Andorra
    Categoría:Personas de Angola
    Categoría:Personas de Anguila
    ...
    • Jan 19 2020, 21:09
    • 166 Lines
  • Categoría:Fallecidos en 1700
    Categoría:Fallecidos en 1701
    Categoría:Fallecidos en 1702
    Categoría:Fallecidos en 1703
    Categoría:Fallecidos en 1704
    ...
    • Jan 19 2020, 17:24
    • 614 Lines
  • DROP DATABASE abortopediawiki;
    DROP DATABASE adhdwiki;
    DROP DATABASE adsnota10wiki;
    DROP DATABASE agroecowiki;
    DROP DATABASE airportexpresslinewiki;
    ...
    • Jan 11 2020, 14:58
    • 35 Lines
  • Redis page load times (10 times, under meta):
    Using hard refresh + empty cache and then another reload (also under chrome)
    * 300ms (PHP5 at test1.miraheze.org)
    * 343ms (PHP5 at test1.miraheze.org)
    ...
    • Jan 11 2020, 00:18
    • 27 Lines
  • if ( $wiki == 'default' ) {
    // If wiki is default, we mean it but we can't use RM this way
    $remoteWiki = RemoteWiki::newFromName( $wgCreateWikiGlobalWiki );
    } else {
    ...
    • Jan 3 2020, 21:17
    • 11 Lines
  • Step 1:
    For the first step this is quite important, you need to remove `127.0.1.1` from /etc/hosts.
    You also then need to add <main_ip> cloud[num].miraheze.org cloud[num].
    ...
    • Dec 26 2019, 20:02
    • 87 Lines
  • /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.pg.sql
    /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.sql
    /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.sqlite.sql
    /srv/mediawiki/w/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.pg.sql
    /srv/mediawiki/w/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sql
    ...
    • Dec 21 2019, 16:23
    • 436 Lines
  • /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.pg.sql
    /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.sql
    /srv/mediawiki/w/extensions/AbuseFilter/abusefilter.tables.sqlite.sql
    /srv/mediawiki/w/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.pg.sql
    /srv/mediawiki/w/extensions/AbuseFilter/db_patches/patch-abuse_filter_history.sql
    ...
    • Dec 21 2019, 16:19
    • 451 Lines
  • MediaWiki update:
    During upgrade window:
    /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblist/all.dblist /srv/mediawiki/w/maintenance/sql.php /srv/mediawiki/w/maintenance/archives/patch-rename-mysql-user_newtalk-indexes.sql
    ...
    • Dec 21 2019, 15:58
    • 40 Lines
  • [22-Nov-2019 18:18:13 UTC] {"code":0,"reason":"","headers":{"server":"nginx\/1.16.1","date":"Fri, 22 Nov 2019 18:18:13 GMT","content-type":"text\/html; charset=utf-8; profile=\"https:\/\/www.mediawiki.org\/wiki\/Specs\/HTML\/2.0.0\"","content-length":"25495","x-powered-by":"Express","access-control-allow-origin":"*","cache-control":"private,no-cache,s-maxage=0","content-revision-id":"89991","content-language":"en","vary":"Accept, Accept-Encoding","etag":"W\/\"6397-Uu3bqrLulNLVITCjLJwnfpwc7hc\"","strict-transport-security":"max-age=15768000; includeSubDomains; preload"},"body":"<!DOCTYPE html>\n<html prefix=\"dc: http:\/\/purl.org\/dc\/terms\/ mw: http:\/\/mediawiki.org\/rdf\/\" about=\"https:\/\/meta.miraheze.org\/wiki\/Special:Redirect\/revision\/89991\"><head prefix=\"mwr: https:\/\/meta.miraheze.org\/wiki\/Special:Redirect\/\"><meta charset=\"utf-8\"\/><meta property=\"mw:pageNamespace\" content=\"0\"\/><meta property=\"mw:pageId\" content=\"28\"\/><link rel=\"dc:replaces\" resource=\"mwr...
    • Nov 22 2019, 20:46
    • 1 Line
  • root@lizardfs6:/mnt/mediawiki-static-new# fio --randrepeat=1 --ioengine=libaio --direct=1 --gtod_reduce=1 --name=test --filename=random_read_write.fio --bs=4k --iodepth=64 --size=100M --readwrite=randrw --rwmixread=75
    test: (g=0): rw=randrw, bs=(R) 4096B-4096B, (W) 4096B-4096B, (T) 4096B-4096B, ioengine=libaio, iodepth=64
    fio-3.12
    Starting 1 process
    test: Laying out IO file (1 file / 100MiB)
    ...
    • Nov 13 2019, 00:18
    • 23 Lines
  • root@lizardfs6:/mnt/mediawiki-static# fio --randrepeat=1 --ioengine=libaio --direct=1 --gtod_reduce=1 --name=test --filename=random_read_write.fio --bs=4k --iodepth=64 --size=100M --readwrite=randrw --rwmixread=75
    test: (g=0): rw=randrw, bs=(R) 4096B-4096B, (W) 4096B-4096B, (T) 4096B-4096B, ioengine=libaio, iodepth=64
    fio-3.12
    Starting 1 process
    test: Laying out IO file (1 file / 100MiB)
    ...
    • Nov 13 2019, 00:11
    • 23 Lines
  • DROP DATABASE 99pdwikiwiki;
    DROP DATABASE addicteddadswiki;
    DROP DATABASE administrationatxingxiwiki;
    DROP DATABASE aegiswiki;
    DROP DATABASE aetronomiconwiki;
    ...
    • Nov 11 2019, 08:25
    • 113 Lines
  • 100.00% 369.829 1 - main()
    90.12% 333.274 1 - MediaWiki::run
    89.91% 332.497 1 - MediaWiki::main
    55.88% 206.646 1 - MediaWiki::{closure}
    55.88% 206.642 1 - OutputPage::output
    ...
    • Oct 29 2019, 22:00
    • 103 Lines
  • [29-Sep-2019 22:36:01] [pool www] pid 12288
    script_filename = /srv/mediawiki/w/index.php
    [0x00007fc3ca61e330] is_file() /srv/mediawiki/w/includes/libs/filebackend/FSFileBackend.php:563
    [0x00007fc3ca61e270] doGetFileStat() /srv/mediawiki/w/includes/libs/filebackend/FileBackendStore.php:662
    [0x00007fc3ca61e1a0] getFileStat() /srv/mediawiki/w/includes/libs/filebackend/FileBackendStore.php:604
    ...
    • Sep 29 2019, 22:47
    • 22 Lines
  • Template:Infobox_project
    Template:Collapsed_infobox_section_end
    Template:Collapsed_infobox_section_begin
    Template:Infobox3cols
    Template:Infobox_exoskeleton
    ...
    • Sep 20 2019, 22:07
    • 1,999 Lines
  • Module:Anchor
    Module:Arguments
    Module:Arguments/doc
    Module:Authority control
    Module:Authority control/doc
    ...
    • Sep 18 2019, 22:34
    • 117 Lines
  • DROP DATABASE agoldenbraidwiki;
    DROP DATABASE animatedfemalemusclewiki;
    DROP DATABASE anotheredentwwiki;
    DROP DATABASE bikepedbuspdxwiki;
    DROP DATABASE blobcatwiki;
    ...
    • Sep 18 2019, 21:03
    • 47 Lines
  • addicteddadswiki
    agoldenbraidwiki
    aimuviwiki
    alcideswiki
    amkt20wiki
    ...
    • Sep 18 2019, 20:39
    • 140 Lines