[02:24:31] dam, the password I was about to use is actually a known phrase D: [02:26:52] oh even better there's a password generator based on xkcd:936 [02:26:54] http://preshing.com/20110811/xkcd-password-generator/ [04:08:27] oh wow, that was the wrong room :D [07:55:16] hey - on Special:SpecialPages - you see unordered lists underneath headings ... but it's split into two columns [07:55:41] how can I recreate this on a normal page? without using something like tables - i've tried to use the same css classes as the specialpages page but unsucessfully [08:02:38] Is there a way to create a wiki that has a public IP address, but all articles are private and no user can circumvent that besides the admin? [08:02:57] ie, anyone who isn't a user that tries to visit the wiki just gets the login page [08:09:51] foul_owl: yes? [08:10:14] https://www.mediawiki.org/wiki/Manual:Preventing_access [09:05:41] Ahh ok I didn't see a section for "users" so I thought that was just for installing mediawiki or developing for it [09:08:21] I suppose my question should be clarified: is there a way for the admin to control if all pages default to public or private, not the sysadmin [09:09:14] As I have to turn this over to someone with no sysadmin experience [11:26:55] Hi, Could I fetch a specific property of page B while I'm on page A? [11:33:42] Oh it seems I can through the #ask [11:35:17] how do I get it to output in plain text, the result, instead of a whole table [12:34:36] Would you like to have a customized Twitter bot to tweet related Wikimedia stuffs, check this out: https://github.com/ch3nkula/Wiki-Twit-Bot, just sharing to members of the community I love ;) [12:41:53] lol [12:42:48] Platonides: :) [12:43:54] I guess your next step is to discover the time people set this on their cron [12:44:04] before owning their accounts :P [12:45:53] Platonides: :D [12:46:13] I won't dare that ;) [14:25:09] Friends, I'm having trouble making mediawiki connect to the database. Can you help? [14:26:19] !ask | markmedes2 [14:26:19] markmedes2: Please feel free to ask your question: if anybody who knows the answer is around, they will surely reply. Don't ask for help or for attention before actually asking your question, that's just a waste of time – both yours and everybody else's. :) [14:49:56] Hi, me again, yesterday I got help and actually found the culprit for our spam bot infestation -> We have GitHub Oauth enabled and spam bots create accounts on GitHub solely for the purpuose of login into our wiki and spamming. If I can somehow have a captcha before the oauth request this would be perfect, what would be the place to put in the code there? in the oauth or confirmedit plugin? [16:50:38] nm, I realized this extension needs refinement to hook into the AuthManager [17:05:33] how are passwords stored in the database? [17:05:40] i mistakenly updated a password and locked the user out [17:06:41] salted and hashed [17:07:23] what would the update query look like [17:07:36] bewbs: use https://www.mediawiki.org/wiki/Manual:ChangePassword.php to change a password [17:09:27] hmm [17:09:57] i can't really do that [17:10:08] my install is on windows iis [17:13:11] my condolences... [17:13:34] https://www.mediawiki.org/wiki/Manual_talk:Resetting_passwords [17:13:41] is this sql accurate? [17:13:51] it doesn't seem to work [17:15:17] bewbs: no it is not accurate [17:15:23] It was accurate about 15 years ago [17:16:01] https://www.mediawiki.org/wiki/Manual:User_table#user_password [17:16:07] err, that's the slightly newer one. accurate about 5 years ago [17:16:24] bewbs: it is entirely possible to run maintinance scripts on windows [17:16:33] how so? [17:16:46] :A: + MD5(password) ? [17:17:14] The backwards compatibility code will see the :A: + md5(password) and upconvert it, so it should work fine to manually set it like that [17:17:29] via the command line? [17:17:36] bewbs: If you have a php cli binary installed, you can run it from command prompt [17:17:46] Exact details depend on how you installed php [17:18:03] probably php isn't in your system path, so you probably have to do something like [17:18:19] C:\full\path\to\php.exe changePassword.php ... [17:18:54] it crashed my php [17:19:35] trying to run it [17:20:05] you hvae to make sure you're using the command line php.exe, not the cgi module php.exe [17:22:17] Sorry, I lied slightly. The SQL on that talk page will probably work (Assuming the current password is valid since its not changing the first two letters) since mediawiki is backwards compatibile with old versions [17:23:04] i navigated to C:\Program Files (x86)\PHP\v5.6 and ran php via the cli [17:23:42] That probably won't entirely work, because your current working directory has to be the maintinance directory of your mediawiki install for the script to work [17:23:54] Unless you set the MW_INSTALL_PATH environment variable correctly [17:24:07] also waht's the difference between user_password and user_newpassword [17:24:22] i specified the complete path of the script for changepassword.php [17:24:46] newpassword is for when someone gets sent a password reset email [17:25:18] The mediawiki script still needs the current working directory to be the maintiance directory. Specifying the full path of the maintinace script will not work [17:25:35] ah [17:27:14] still crashed php [17:27:35] can i edit a users password if i'm a site admin [17:28:17] if email works the user can reset the password himself [17:28:55] i'm not sure where to set the smtp settings [17:28:59] i didn't see it via setup [17:29:17] !wg SMTP [17:29:17] https://www.mediawiki.org/wiki/Manual:%24wgSMTP [17:29:43] thanks [17:29:51] gotta meeting, hopefully it'll work though [17:53:46] Hi, for ~ 2 hours we have been seeing increased latency and an increased number of connectionTimeout exceptions when calling the Query api with prop=extracts of en.wikipedia.org/w/api.php from the UK. Is this a known issue? [17:59:34] amzndev: I haven't heard anything. This is more a question for the #wikimedia-operations channel [18:01:26] Ok, thanks