[13:49:51] tgr_, is there some way to get a list of oauth consumers from an API or some labs replica DB query? [17:56:37] I think it's no on both accounts [19:07:55] Krenair: no. Probably not too hard to whip up an API though. [19:08:08] or you can screen-scrape Special:OAuthListConsumers [19:08:40] I suppose there are very limited circumstances under which this would be useful information to someone who can't just query it out of the prod dbs [19:09:29] wonder if we should make a view into the table? [19:15:44] I'd imagine so [19:15:51] Obviously can't expose email addresses and stuff... [19:16:01] But the stuff that's already public on https://meta.wikimedia.org/wiki/Special:OAuthListConsumers ? [19:16:46] tgr: I think that's the monolog update into shape, without breaking the output [19:18:25] Krenair: I think you'd only need to expose 5 or 6 fields to get it matching [19:19:53] I'm interested in the URI [19:20:20] an API is probably not too useful in general, yeah [19:20:27] mainly because I'm wondering precisely how big a task https://phabricator.wikimedia.org/T244473 is [19:20:31] I guess if we look at https://meta.wikimedia.org/wiki/Special:OAuthListConsumers/view/e4adb20f601565de1099dc8fdd94899b [19:20:35] There's a few more fields [19:20:37] OTOH everything that has a special page should have an API [19:20:43] Krenair: I can also run an SQL query for you too if that's easiest [19:21:24] what's it for? [19:21:41] tools.wmflabs.org url changes [19:21:57] going to toolname.toolforget.net or whatever from tools.wmflabs.org/toolname [19:22:08] is there a lab replica DB for that? [19:22:09] I guess the question is "how many oauth consumers need updating?" [19:22:17] select oarc_callback_url from oauth_registered_consumer where oarc_callback_url like '%tools.wmflabs.org%; ? [19:22:42] I mean, is labswiki included in the labs replica DBs? [19:22:52] though I'm not sure about owner-only consumers that might get included [19:22:58] I'm not sure how that helps tgr? [19:23:02] They're on meta [19:23:05] https://github.com/wikimedia/puppet/blob/e0da161490eed41d9b446b825add7bb2747b9ce7/manifests/realm.pp#L209 [19:23:08] they are not [19:23:16] IIRC no? but that info might be hopelessly out of date [19:23:31] meta/global/whatever [19:23:48] don't mind me, I'm confused :) [19:23:53] heh [19:24:03] but not necessarily everything is on meta, that much is true [19:24:13] Krenair: You're missing a ' ;p [19:24:18] 335 rows [19:24:19] yep [19:24:19] wikitech has its own OAuth install [19:24:21] Would you like it pastebinning? [19:24:26] thanks [19:24:30] so has the steward wiki I think? [19:24:57] granted that's just one or two consumers each [19:25:28] | https://tools.wmflabs.org/ | [19:25:29] ffs [19:25:36] Though that row probably doesn't work well :P [19:25:40] 'wmgUseOAuth' => [ [19:25:40] 'default' => true, [19:25:40] 'private' => false, [19:25:40] 'fishbowl' => false, [19:25:40] 'foundationwiki' => true, // T170301 [19:25:41] T170301: Add OAuth Extension to Wikimedia Foundation Wiki - https://phabricator.wikimedia.org/T170301 [19:25:41] ], [19:25:59] Reedy, hmmm, does that generic tools one have oarc_callback_is_prefix ? [19:26:27] it's a 1, so yeah [19:26:30] if you want to filter out owner-only comsumers that's "and not oarc_owner_only" [19:27:00] lots of http:// hardcoded ones [19:27:04] but then owner-only consumers are unlikely to have a toolforge callback url anyway [19:27:21] https://phabricator.wikimedia.org/P10698 [19:28:27] so those three https://tools.wmflabs.org/ ones have the prefix flag and can presumably be used by anything running on tools? [19:31:13] theoretically, but it doesn't make sense to use a consumer with anything running on tools; maybe it's someone who maintains multiple tools and wanted them to have a common consumer [19:32:19] Added oarc_name [19:32:22] this change could pose a problem for that [19:33:17] ah [19:33:23] here we are [19:33:26] one of them is called Kaspar [19:33:33] take a look at https://meta.wikimedia.org/w/index.php?title=Special:OAuthListConsumers/view/97305aae1b2e4ba5db935c1c48f9bacd&name=Kaspar&publisher=&stage=-1 vs https://meta.wikimedia.org/w/index.php?title=Special:OAuthListConsumers/view/225f7802487d405a64849ccda7766785&name=Kaspar&publisher=&stage=-1 [19:35:27] oh, right, the query should be filtered to approved (and maybe proposed) status [19:36:13] that's 1 and 0