[00:12:55] bd808: I'm sorry. In the past three months DBAs had massively reduced capacity for various (expected and unexpected) reasons. Thankfully starting Jan 1st, we are back to full capacity (and even more as a new hire just joined). I'm saying this to say I haven't forgotten about it (there were so many fires to attend). It's in my list and I've been actually hoping to tackle it next week. I'm also super grateful to Reedy for picking up slack [00:12:56] in user requests. If anyone is feeling like helping, I'd really appreciate it. [00:16:19] What actually is left to do? [00:22:18] we need to get the list of linked SUL accounts (from their LDAP to SUL that's stored in idm) and connect the ones that are not connected in wikitech [00:22:18] Amir1: No need to apologize. As I said this is in my view a failing of the org by making you a hero implementor. I know all about signing up for more work than you end up being able to accomplish. [00:25:48] There is another list of SUL -> Developer mappings we can pull from Striker's database too. We want to get those into LDAP eventually, but Striker is another "best effort" project that has not gotten as much done as folks might like. [00:26:55] I think I know how to make a list from both sources. Then we'd need to feed that into some script that would rename the wikitech accounts and attach them to the SUL accounts. [00:28:06] yeah [00:28:33] is there a main script for renames? [00:28:36] *maint [00:28:47] let me check, there should be [00:29:02] there is renameUser.php [00:30:56] cool. weirdly it doesn't seem to have a page on mw.o, but the script looks like it would do the needful on the renaming side [00:31:12] and there is an attach script that Reedy has already been using [00:31:34] we should also run MigratePass1.php but also that code needs a little bit of clean up. If I'm reading it currently it loads all users everywhere from centralauth database in one giant query [00:35:21] hmmm... that's the script that assumes that local user X should be matched to SUL user X. I'm not exactly sure how I feel about that. [00:38:45] ah, yeah, before that, we need to run PopulateListOfUsersToRename and then UpdateUsersToRename [00:39:03] which renames the ones that haven't been attached to Username~labswiki [00:39:55] :nod: that seems broadly better [00:41:26] Amir1: how about we grab some time next week and script up a plan, get some folks to double check our ideas, and then hope to implement in the following week or two? [00:41:38] sure, sounds good to me [00:42:49] Would you mind being in charge of picking a day/time for us to get started? My calendar should be up to date. [00:43:20] You know better than I when you might have bandwidth and energy for a call :) [00:46:09] sent an invite, Mondays are a mess but the rest should be fine if you want to move it around [00:54:10] Amir1: awesome. Looking forward to helping make a plan. :) [00:54:18] \o/