[02:13:36] hi, how can I insert __NOTOC__ in scribuntu? [02:15:20] ? [02:15:55] ? I want my lua script to insert __NOTOC__ [04:27:40] Hello all, can someone with a recent backup of wikipedia let me know how large their categorylinks table is? I've been importing it for a few days now and its at 63GB... wondering when i can actually use it! [04:45:03] x1f577, which wikipedia? [04:45:35] Krenair: enwiki [04:45:54] Krenair: thank you [04:45:55] krenair@tools-bastion-03:/public/dumps/public/enwiki/20161101$ ls -lh *categorylinks* [04:45:56] -rw-rw-r-- 1 abcdefg icinga 2.0G Nov 2 09:14 enwiki-20161101-categorylinks.sql.gz [04:46:25] Krenair: ah, I'm talking about the fully populated table, i have the files [04:46:43] Krenair: currently importing the 15GB expanded file and it's already at 63GB [04:47:01] the directory containing the mysql data, that is [04:47:43] (this file is like 3GB uncompressed) [04:47:44] hm [04:49:04] Krenair: really?! mine was 15GB uncompressed... [04:50:19] obviously I'm not going to run this stuff against the real production enwiki master, but [04:50:26] labs replica shows it as 22GB [04:50:45] based on select round(((data_length + index_length) / 1024 / 1024 / 1024), 4) as `Size in GB` from information_schema.tables where table_schema = 'enwiki' and table_name = 'categorylinks'; [04:51:05] 22.2853 [04:51:50] based on http://stackoverflow.com/a/9620273/1306662 [04:52:43] Krenair: that's odd considering mine has been expanding for the past two days... [04:53:35] thanks though, maybe i downloaded the wrong file [04:54:56] x1f577: what is the filename that you downloaded? [04:57:09] p858snake|L2: enwiki-latest-categorylinks.sql.gz [04:59:19] Krenair: i does your query accound for the indices? [04:59:50] not sure [05:00:22] Krenair: probably that index_length bit [05:00:33] yeah, I think so too [05:00:49] https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html [05:00:52] Index_length [05:00:53] For MyISAM, Index_length is the length of the index file, in bytes. [05:01:26] ah, but it's not MyISAM [05:01:31] it's InnoDB [05:01:42] "For InnoDB, Index_length is the approximate amount of memory allocated for non-clustered indexes, in bytes. Specifically, it is the sum of non-clustered index sizes, in pages, multiplied by the InnoDB page size." [05:48:50] Is there any way to use short URLs with simple redirect rules or no server config change? I'm using Caddy to serve MediaWiki and am not sure how to create short URLs using Caddy. https://caddyserver.com/docs/redir [05:49:43] so I'm having some issues after an upgrade from Ubuntu 14.04 to 16.04 (mediawiki was gone!). I've installed the latest stable and will settle for manually updating from now on. [05:49:45] http://www.powershelladmin.com/wiki/Main_Page [05:49:52] I'm having some issues with formatting and stuff. [05:50:05] there were some errors I couldn't read in time before they scrolled away during upgrade [05:50:16] but I've done a bunch of stuff and this is where I'm at now [05:50:26] I'm trying to get the MobileFrontend.php working now ... [05:50:35] but it doesn't show the menu and stuff? [05:50:41] CSS missing? [05:50:54] * . https://caddyserver.com/docs/rewrite [05:51:14] is that a bot? [05:51:52] no, mt-dev was speaking before you [05:52:33] mt-dev, you should probably ask caddy rather than us [05:53:13] mt-dev: I'd get an apache config from http://shorturls.redwerks.org/, then ask the caddy community how to re-create that. [05:54:07] if you find a good solution, maybe email the authors of that site so they can add it in. [05:55:46] if I remove the wfLoadSkin( 'MonoBook' ); # line, mediawiki says I have four skins [05:55:52] from LocalSettings.php [05:55:57] and provides some info [05:56:01] (very nice, btw) [05:56:44] vaya, ubuntu no longer has mediawiki in repos, you mean? [05:56:55] yeah, see earlier link for my site [05:56:57] it's live [05:57:04] I'm doing the upgrade live, facing the net [05:57:16] it's got readable content now after 4-5 hours of work [05:57:41] (On an unrelated note, I don't like the mobilefrontend approach. Instead of making a new user-friendly skin, it'd've made sense to edit the existing skins and make them more mobile-friendly.) [05:58:15] That's fine. For me it's just a question of providing a better experience for mobile users. Right now I'll do whatever it takes. [05:58:33] right - hang on [06:00:02] and for desktop users, at this point ... [06:00:09] I want the logo and stuff on the side :\ [06:00:17] it's at the bottom now, I think CSS isn't being read [06:00:49] yeah, the styling is gone; do you have access to the webserver config and logs? [06:00:57] I am root [06:01:16] so I would start by checking the webserver logs to see why it doesn't succeed at loading the styling [06:01:36] right, maybe I just need to cp -r another folder ... [06:01:55] I did it with images/, extensions/ ... uh maybe something more [06:01:58] else* [06:02:07] I think your styling gives a 404 at this moment [06:02:31] sounds logical [06:03:25] it's loaded through http://www.powershelladmin.com/w/index.php which isn't found [06:03:46] oh, man, errors galore in here [06:03:48] I click 'log in' and it takes me to w/index.php which is also not found [06:04:02] ugh that /w/, I tried to get rid of it. [06:04:14] it used to be /wiki/ so I tried to make it /wiki/ in the new one. [06:04:27] to keep my precious links [06:04:31] you can get rid of it when users are viewing web pages, but not when they are logging in or editing or retrieving css [06:04:40] getting rid of it entirely breaks things [06:04:42] this site actually has over 40,000 views per month [06:05:24] as a first step, I would downgrade mediawiki back to what it was, or put a 'sorry, the website is under maintaiance unexpectedly, please sit tight' on the homepage [06:05:32] PHP Warning: include(/usr/share/mediawiki-extensions/base/ExtensionFunctions.php): failed to open stream: No such file or directory in /etc/mediawiki-extensions/extensions.php on line 4 [06:05:51] as a second step, I would do a proper upgrade [06:05:55] It's ok. Traffic is so low during weekends. I'll take my chances for now with the new (lack of) layout. [06:06:01] I have no easy way back either .. [06:06:10] because a proper upgrade doesn't need you copying files by hand [06:06:26] the distro upgrade messed with it [06:06:31] https://www.mediawiki.org/wiki/Manual:Upgrading does mention a full backup as a first step, so [06:06:53] I have XML and SQL backup, but this upgrade happened through apt. [06:07:02] And the upgrade removed instead of upgrading. [06:07:05] so you need to have a copy of your database, localsettings.php, images, and extensions [06:07:07] But kept images/, etc. [06:07:16] I made a manual copy of LocalSettings.php before. [06:07:19] ok [06:07:36] so the next thing you do is you put your copies aside and install a new empty vanilla wiki [06:08:02] well, you unpack it. you don't actually install it [06:08:05] I already have a tar.gz [06:08:17] so I can install it with a slightly different folder name [06:08:26] parallel with the currently running one [06:08:34] what directory is the wiki in right now? [06:08:49] /var/www/vhosts/powershelladmin.com/wiki/wiki [06:08:50] the one I face when I open your site [06:08:51] ok [06:09:07] before the upgrade, it was the same directory name, yes? [06:09:30] it, um, used to be a symlink with the name "w" [06:09:43] I changed it for some (maybe stupid) reason [06:09:46] so it was /var/www/vhosts/powershelladmin.com/wiki/w/ ? [06:09:50] I can just rename that, though [06:09:57] but, damn, I changed it in config files [06:10:01] it's ok [06:10:06] don't change it yet [06:10:06] to get it as /wiki/ online [06:10:21] can you pastebin 'ls /var/www/vhosts/powershelladmin.com/wiki/wiki' and your webserver config? [06:14:54] https://pastebin.ubuntu.com/23504618/ [06:16:29] ok [06:21:13] vaya, the system package 'mediawiki' is back in 16.10 if you want to do that [06:22:25] need LTS .. [06:22:47] ok [06:23:07] what errors do you get in your webserver log? [06:23:41] PHP Warning: include(): Failed opening '/usr/share/mediawiki-extensions/base/ExtensionFunctions.php' for inclusion (include_path='/var/www/vhosts/powershelladmin.com/wiki/wiki:/var/www/vhosts/powershelladmin.com/wiki/wiki/includes:/var/www ...... [06:23:53] that folder doesn't exist [06:24:33] and your localsettings.php? [06:25:08] that's got some passwords and stuff, I'll search for that path in there [06:25:22] I would comment out the two redirectmatch lines in apache config and restart apache. just to see whether that helps [06:25:38] "/usr/share" not found in LocalSettings.ophp [06:25:49] https://pastebin.ubuntu.com/23504618/ lines 49 and 50 may be breaking things [06:25:53] I can try, I've been wondering about those [06:26:08] but something is referencing this folder/file [06:26:20] I need to search recursively to find it with grep or something. [06:26:29] no, just comment them out and restart apache [06:26:37] ok [06:26:40] after you do that, open your webserver log and look for errors. that warning you pasted is intriguing, but harmless [06:27:37] assuming a wiki can run without extensions, that is - the issues we're facing right now are basic wiki functionality [06:29:52] looks like the same layout and same errors [06:30:06] I need to get those ExtensionFunctions.php [06:30:38] updatedb; locate ... # nothing [06:34:25] um, you commented them out and restarted apache, yes? [06:34:40] ja [06:39:49] ok. I will install mediawiki on a debian and get back to you; it's VERY hard to find an example apache config on mw.org for some reason [06:43:16] it's almost 8 AM, so I'm running out of time [06:43:31] I was prepared to go to bed with a dead site, so I'm at least happy there's readable content [06:51:33] vaya, you still can find error messages from your webserver. you didn't show any [06:57:47] That ExtensionFunctions.php it can't find is the only error I can see. [07:13:01] https://www.mediawiki.org/wiki/Extension:ExtensionFunctions.php [07:13:33] no other errors in the web log [07:26:06] if I try to include MobileFrontend I get a 500 [07:26:15] I think it's getting too late for me for this now [07:29:24] yes [07:29:29] and please do not do two things at the same time [07:29:46] I would grep for ' ExtensionFunctions.php' in the webserver config dir and in the wiki dir recursively [07:29:51] without the space [07:30:42] root@li371-49:/var/www/vhosts/powershelladmin.com/wiki/wiki# grep -ri 'ExtensionFunctions.php' * [07:30:42] root@li371-49:/var/www/vhosts/powershelladmin.com/wiki/wiki# [07:30:44] :-| [07:30:50] on to the next [07:31:11] well, just grep for it in '/' if you wish [07:31:54] found one in /etc [07:31:55] # grep -ri 'ExtensionFunctions.php' /etc/* [07:32:12] ./etc/mediawiki-extensions/extensions.php:include( '/usr/share/mediawiki-extensions/base/ExtensionFunctions.php' ) ; [07:32:42] the next step is to find out what is calling the mediawiki-extensions [07:32:53] look for that using grep [07:33:34] I'm sorry, this channel is usually more helpful than this - you can post to mediawiki-l or something to get help, or just ask here when the right people are awake (95% of people here have a running mediawiki somewhere and have a working apache config, and I happen to be among the 5% who don't) [07:36:52] the file is just missing, I think [07:36:58] "provides base functionality" [07:37:10] funny it isn't in the tar.gz with mediawiki? [07:40:33] you need to find where 'mediawiki-extensions' is mentioned on your filesystem [07:40:43] grep -ri mediawiki-extensions / [07:45:38] what I need is ExtensionFunctions.php [07:45:42] it's in /etc [07:45:46] I think that's the reference [07:46:01] extensions.php references it [07:46:11] but it's not in the file system [07:46:30] it's deprecated [07:46:36] hm [07:49:14] I'll just leave this as it is for now, I need to sleep [07:49:28] 9 AM coming up, ridiculous, I was ready for bed at 2 AM ... [07:58:58] tried this, didn't work for wiki/wiki as will investigate more after a nap [08:10:39] # debian specific include: [08:10:39] #if (is_file("/etc/mediawiki-extensions/extensions.php")) { [08:10:39] # include( "/etc/mediawiki-extensions/extensions.php" ); [08:10:40] #} [08:10:48] tried just commenting it out (as you can see), same result [08:10:58] now napping 4 rl [08:14:48] tried wiki/wiki/includes for the link about Load.php too, no go [08:39:10] vaya: I would recommend just dumping your current setup, and just using the mediawiki package from scratch (which is a import of legoktm's debian package I believe) and starting again [08:39:32] because the plain package should be working fine, unless the ubuntu team have broken it [08:40:29] although there does seem to be a number of open bugs on the ubuntu side https://launchpad.net/ubuntu/+source/mediawiki/+bugs [08:59:43] I'm trying to install vagrant. Does ./setup.sh need root? [08:59:51] mediawiki-vagrant, even. [09:04:15] from ./setup.sh and following instructions, I get http://dpaste.com/1Y6KP2S.txt ERROR: Could not find a valid gem 'vagrant-share' (= 1.1.6) in any repository [09:04:50] Vagrant 1.8.7 [13:56:39] "Reception" reminds me of sth [14:36:27] Asterixf2: ist [14:36:42] ja [21:50:03] Hey there. I deleted a user (which didn't do anything yet) from the database and would like register a user with the same name, but mediawiki won't let me. Any ideas? [21:51:22] Apparently he's still somewhere in the DB [21:51:44] Is there some maintenance script to completely remove him? [21:52:52] TheConen: can you check what is the error message in the logs when trying to recreate? [21:53:00] !debuglog | TheConen [21:53:00] There is no such key, you probably want to try: !errors, !sqllog, [21:53:06] !errors | TheConen [21:53:06] TheConen: To see PHP errors, add this to the very top of LocalSettings.php: error_reporting(E_ALL); ini_set("display_errors", 1); Fatal PHP errors usually go to Apache's error log - also check the error_log setting in php.ini (or use phpinfo). For more details in wiki error reports, set $wgShowExceptionDetails = true; $wgShowSQLErrors = true; For full debug output, set $wgDebugLogFile to some path you like. [21:53:18] cache [21:55:45] I'm using IIS on windows server 2012r2 [21:58:03] saber: "Very top" means before the it seems i cannot create any new users [22:07:35] TheConen: I'd go for $wgDebugLogFile first, the question is also what MediaWiki is saying when it refuses to create one. Also do check php error log. [22:08:09] did that, but for some reason it doesn't seem to create the log file [22:08:15] $wgDebugLogFile = "E:\tttWiki\log.txt"; [22:08:50] Create an empty file [22:09:11] check if the folder has permissions for IIS to write on it [22:09:36] also, what's the error message do you get? [22:10:25] Es gab ein Problem bei der Übertragung deiner Benutzerdaten. Diese Aktion wurde daher sicherheitshalber abgebrochen, um eine falsche Zuordnung deiner Änderungen zu einem anderen Benutzer zu verhindern. Bitte gehe zurück zur vorherigen Seite, lade sie erneut und versuche, den Vorgang erneut auszuführen. [22:10:28] it's german.... [22:11:35] IIS has full write permissions [22:12:20] session problems... [22:13:12] TheConen: see details of https://www.mediawiki.org/wiki/Manual:$wgSessionCacheType [22:13:27] nah, there are no session problems [22:13:34] I cannot created any new user manually [22:14:55] I deleted a user from the db table "user" (because I couldn't find any other way to delete a user) and it seems to have fucked something up [22:18:51] is there some maintenance script that fixes the user table? [22:20:57] Not arbitarily fixes it, no [23:37:34] how do i write a markup code to show the total number of pages in a category? [23:38:41] {{PAGESINCAT:catname}} [23:43:12] thanks, Reedy :) after some fiddling around, I found |pages and |subcats for it gives more details too. Good thing. :)