[00:11:05] <john2gb>	 do i bother this channel about math extension being slow
[00:38:30] <ori>	 john2gb: no, you file a bug on phabricator.wikimedia.org
[00:53:55] <cornell_>	 Good evening all
[00:56:17] <cornell_>	 I've set up mediawiki on a local PC.  And I seem to've not setup, or don't remember, admin credentials.  Do I need them?  How can I recover, reset them.  I've tried password resets, but apparently emails aren't going out from that PC.
[00:58:05] <Reedy>	 use the maintenance script
[01:02:52] <cornell_>	 That's a script on the PC?  Via bash?
[01:03:17] <ori>	 https://www.mediawiki.org/wiki/Manual:Resetting_passwords
[01:06:41] <cornell_>	 Thank you Reedy, ori.  I can find my users via phpmyadmin.  Presumably, using the Use the changePassword.php will allow me to set passwords.
[01:08:52] <ori>	 yes
[01:15:45] <cornell_>	 Thank you much, ori.
[01:19:37] <cornell_>	 on the PC in question, I've installed Mint distro, and mediawiki.  Do I need to setup an email server to get mediawiki to send out emails?
[01:20:55] <cornell_>	 Or provide values for remote server?
[01:31:16] <grknight>	 cornell_: you should have to either point the instance to an SMTP relay https://www.mediawiki.org/wiki/Manual:$wgSMTP  or set up a local relay MTA (even something simple like nullmailer or ssmtp)
[01:40:11] <cornell_>	 Ah, thank you grknight... now I have to dig out where those variables are set ;-)
[01:56:39] <Reedy>	 !localsettings
[01:56:40] <wm-bot>	 All configuration is done in LocalSettings.php (near the end of the file). Editing other files means modifying the software. Default settings are not in LocalSettings.php, you can look in DefaultSettings.php. See <http://www.mediawiki.org/wiki/Manual:Configuring_MediaWiki>, <http://www.mediawiki.org/wiki/Manual:LocalSettings.php>, <http://www.mediawiki.org/wiki/Manual:Config_script>, and <http://noc.wikimedia.org/conf>
[01:58:57] <cornell_>	 Thank you all, reedy, ori, grknight.  And even wm-bot ;-)  Good night all, we'll see tomorrow how it all worked out.  TTFN
[01:58:57] <wm-bot>	 Hey cornell_, you are welcome!
[08:35:23] <Reventlov>	 Hi. I'm still trying to debug why I get this kind of error on a 1.35 mediawiki installation: "Erreur d’accès au serveur Parsoid/RESTBase (HTTP 400)". My setup involves nginx as a front reverse proxy, and apache as the real webserver used by mediawiki. I can see requests being made with this kind of message:
[08:35:42] <Reventlov>	 "The "Promise-Non-Write-API-Action" HTTP header was sent but the request was to an API write module."
[08:35:56] <Reventlov>	 (by tcpdumping on every http request made on the wiki)
[11:04:26] <arcy>	 Hi after some advice as searching google has proved futile.. are there any good ways to pull sql data through to a wikipage, where the data is not related to wiki and stored in external mysql databases? 
[11:06:14] <Vulpix>	 arcy: You may try this extension: https://www.mediawiki.org/wiki/Extension:External_Data##get_db_data_-_retrieve_data_from_a_database
[11:08:11] <arcy>	 I have tried that, and when i upgraded my server and the extension, it's throwing errors, which is why I was seeking an alternative solution :) as I cannot see where the problem lies, and it's getting frustrating. 
[15:06:50] <sdesalcala>	 Hi, I was wondering what are the uses of the SQL replica of Wikidata in wikidatawiki.analytics.db.svc.wikimedia.cloud (see https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database)? Why would someone use SQL over SPARQL to make queries? Wouldn't it be less optimized?
[15:07:40] <Reedy>	 Possibly
[15:07:52] <Reedy>	 But we provide replicas of all other databases
[15:08:00] <Reedy>	 So it will be useful for some use cases
[15:08:56] <sdesalcala>	 May I ask what type of use cases? I'm investigating about substitutes for when a query is too demanding and SPARQL has a timeout error, I would love to hear any info
[15:09:40] <Reedy>	 Well, you have the full raw dataset there. You can potentially do anything you want with it
[15:09:59] <Reedy>	 Including taking smaller dumps of tables to do work with in other tools
[15:10:10] <Reedy>	 so you might not be doing the whole query with SQL, but extracting some of it
[15:11:56] <sdesalcala>	 That certainly sounds useful. The current implementation of SPARQL for wikidata doesn't use SQL at any point, right?
[15:13:36] <Reedy>	 I don't believe so; but don't quote me on that :)
[15:15:22] <sdesalcala>	 Thanks. Is there some info on the SQL replica of Wikidata? I'm trying to navigate it but there's a trillion columns so I don't know what is what.
[15:15:54] <Reedy>	 Depends what you're looking for
[15:16:11] <Reedy>	 In most cases, it is basically the mediawiki schema + any and all tables added by Wikibase itself and any other extensions
[15:19:07] <sdesalcala>	 Oh I didn't know that there was a Wikibase schema: https://www.mediawiki.org/w/index.php?title=Manual:Database_layout/diagram&action=render Thanks. Where can I find the Wikidata-specific tables?
[15:19:25] <sdesalcala>	 is it wikidatawiki_p?
[15:21:09] <Reedy>	 that would be the repo specific tables, yeah
[15:21:33] <Reedy>	 there is the wbc_entity_usage table on client wikis too