[10:09:43] Hi, so if I run `select * from page where page_id=158802283 limit 1;` I would get a single entry of `Pounding_Mortar_and_Pestle.jpg` and its details. Since this is a file, it should exist on file table. If I run `select * from file where file_name='Pounding_Mortar_and_Pestle.jpg'` I get no results. Is ther any reason? [10:10:28] it is against commonswiki_p [12:01:54] Looking at https://www.mediawiki.org/wiki/Manual:File_table @Ladsgroup introduced this table recently. My guess is that it hasn't been populated yet for older uploads (re @nokibsarkar: Hi, so if I run select * from page where page_id=158802283 limit 1; I would get a single entry of Pounding_Mortar_and_Pestle.jpg...) [12:03:04] Yeah. We haven't started the script on commons yet since text table migration is still running there. In the meantime use image table please [12:03:53] Do you have a phab for that? I'll add it to the manual (re @Ladsgroup: Yeah. We haven't started the script on commons yet since text table migration is still running there. In the meantime use image ...) [12:05:07] https://phabricator.wikimedia.org/T385167 maybe? [12:14:19] Yup (re @MaartenDammers: https://phabricator.wikimedia.org/T385167 maybe?) [12:14:31] That's the ticket. Thanks [12:34:59] A user signed up on 2014 but in `user` table `registration`=NULL. Why? weren't registration date collected back then? [12:41:56] how do you know they signed up in 2014? [12:45:20] Oh, sorry my bad. First edit was 7 dec 2004. [12:47:09] Any way, I cannot create a tunnel to commonswiki_p from a digitalocean droplet using `ssh -N nokibsarkar@dev.toolforge.org -L 3307:commonswiki.analytics.db.svc.wikimedia.cloud:3306` . It shows `nokibsarkar@dev.toolforge.org: Permission denied (publickey,hostbased).` But i can create a tunnel on localhost using the same command without any issue [12:57:42] yeah, 2004 sounds early enough that those weren't recorded [12:58:06] for the ssh issue, use -v to check that the correct key is being used [12:59:56] Ok. Thanks. I got it [13:00:32] how can I keep this session open indefinitely in the background? [14:30:28] Is it possible to run OCI-compatible images (not built from Buildpack. I have not figured out how to convert a Containerfile to buildpack) on Toolforge? [14:32:19] @xtexxxx no sorry. Not as of today anyway. [14:33:08] the current toolforge build process is usually smart, you usually only need lang-specific files to trigger the correct build [14:33:21] you may not need to convert anything [15:19:06] arturo: but it fails when there is a complex build process. For example, first build HTML with some npm steps and then build a Go/Rust binary which includes outputs from the first step. [15:39:01] o/ Whats the process of getting an app added for idp.wmcloud.org ? [15:41:47] addshore: what are you trying to do? [15:42:02] I'm not exactly sure what "app" means here [15:42:15] I was trying to get a cli authing with idp for api access, but I just landed on https://wikitech.wikimedia.org/wiki/Help:Toolforge/API#Authentication and realize that I might be getting ahead of myself [15:42:20] so will likely put a pin in this for now [15:43:25] ok [15:44:23] I think there could be ways to use tokens, but I'm not sure on the latest developments [15:44:35] they are related to the push-to-deploy works [15:47:26] * addshore reads https://phabricator.wikimedia.org/T194332 [15:55:34] i think T332478 is the closest task to what you're looking for, featuring some anchient ideas of mine [15:55:35] T332478: Decouple Toolforge API gateway authentication from Kubernetes certificates - https://phabricator.wikimedia.org/T332478 [16:02:33] oooh, that looks like a good title [16:03:04] I only just discovered today (according to the docs) that I might be able to use the public API directly once i have fetched the k8s certs rather than also doing that through a tunnel :D [16:05:47] *subscribes to that ticket* [16:18:14] huh, is the api already publicly available? [16:20:01] oh right [16:22:02] addshore: i'm afraid we have a tls-terminating reverse proxy on the way which means you can't pass certificates to the api from the outside [16:22:36] Gotcha, I'll keep the ssh tunnel in place then for outside usage for now :D [16:25:48] at first copying k8s certificates to the outside felt scary before i remembered those aren't valid for a year anymore :P [18:29:59] taavi: I was actually going to ask how long they do last (I guess I could check actually maybe)? but I certainly noticed they dont last forever