[14:23:50] Is there any way to link to a file on disk ("Media:abc.mp3") as the target of an Image? If I use JUST [[Media:abc.mp3]], I get a link to the file on disk (not the MediaWiki render of the file). If I use [[File:image.jpg|link=Media:abc.mp3]], I get the image properly, but the link is to the MediaWiki render, not the file on disk. [14:25:57] ah! [14:26:05] I can use the {{filepath:}} magic word instead. [14:26:20] [[File:image.jpg|link={{filepath:abc.mp3}}]] works [14:27:25] alternatively, does TimedMediaHandler, in 2018, do mp3 playing? the README.md doesn't mention mp3s at all anymore, but the MW extension page does, and it's all uber confusing. [14:28:28] The extension can [14:38:41] * Morbus goes to install TMH [14:48:41] @Reedy thanks. Got TMH working with mp3s [15:29:06] andre__: thanks for fixing/creating those tasks, i'll stick to the template from now in [15:30:35] andre__: can you un-publish https://codein.withgoogle.com/dashboard/tasks/5265052258009088/ for now? the task has a dependency on another task [15:30:54] (technically you could work on one without the other, but you would have merge conflicts, so i wanted to delay one of them) [15:39:05] Is the iwlinks table still the right place to figure out interwiki links between articles? Or do I need to query Wikidata? [15:39:32] Wikidata [15:39:46] MatmaRex: Wait, we have a template? :D Nah, thanks for throwing your hat in! I'll unpublish, sure [15:40:06] Reedy: dang; thanks. [15:41:25] MatmaRex: I'm mostly adding some more context to tasks (like linking to the VE User Guide), that's all. The tasks are already in pretty good shape I'd say [15:42:10] (Also, I meant langlinks, but I'm assuming the response is the same.) [15:44:44] Oh, hang on [15:44:58] guillom: I think I got confused between interwiki and articles [15:45:23] you mean links between articles on the same wiki? [15:45:55] between different wikis is wikidata (for most projects) [15:45:56] Reedy: Basically I need to figure out if a page on enwiki has an equivalent page on another wiki, and all I have is the title of the page on enwiki. [15:46:10] ok, yes, that's wikidata then [15:47:24] Got it. [15:47:28] * guillom rolls up his sleeves. [15:47:39] * guillom puts on his thinking cap. [15:48:40] guillom: Can do it via the API [15:49:33] I have to add in other criteria too, so I'm thinking Quarry. [15:54:24] I'd say WDQS would probably work well for that (if you know sparql) [17:14:06] I don't. [17:14:43] Also, my printout of the DB schema is out-of-date and now I have to deal with MCR, it seems -_- [17:15:11] Whyyyyy. [17:26:21] Ok so instead of finding the content in text.old_text, I find the slots.slot_revision_id, then the content.content_id, but where do I actually find the content's text? [17:30:10] guillom: From the DBs? You don't. [17:30:26] guillom: It's in ExternalStore. You access it through MW. [17:31:07] Since ~2007 or whenever. [17:31:49] And this is why this work should be left to people who know what they're doing [17:32:33] :-) [17:33:01] James_F: So there's no way to access a revision's wikitext from Quarry? [17:33:16] I don't know. I don't use Quarry. [17:33:18] Sorry. [17:34:02] guillom: no, Quarry doesn't have access to page content [17:34:37] Deletion/suppression is handled at the application layer, so yeah, that'd be impossible to provide via Quarry. [17:34:39] legoktm: Thanks. Well I'll just send a "I can't help with that analysis, sorry - shrug emoji" then. [17:37:48] Page text doesn't get replicated into labs [17:38:02] (none of ExternalStore does) [17:45:35] guillom: if this is someone authorized to see this data, you would have to use api [17:46:23] for the nontext content you would have to use analytics-store.eqiad.wmnet instead of quarry if its redacted in quarry [17:46:43] Krenair: bawolff_: thanks. Yeah it's public data (not deleted) but this is going beyond the kind of one-off help I'm willing to provide. [17:51:46] alternatively just talk to the prod DBs, but I think they discourage that these days :) [17:52:20] Oh, gci started. Im totally not ready to add any tasks [17:52:22] used to sometimes just pick a random codfw slave DB and run stuff there [17:52:53] then I got some analytics/research access later on and used that instead [17:56:27] I don't think I even have access to the stats machine any more. [17:59:05] guillom, you don't appear to have any prod ssh access anymore, no: https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/377446/ [17:59:23] I'm completely ok with that :) [22:03:22] Continuing convo from #wikimedia-tech....... having issues with a private Mediawiki install. "Lua error: Cannot create process: proc_open(/dev/null): failed to open stream: Operation not permitted" errors [22:05:55] open_Basedir not set (permitted) Lua 5.1.5 installed // I have sudo and root access to server running the install