I 've been searching the forum for info on updating external_id on discourse db. found this topic interesting: [image] Is it possible to change users SSO's external_id after a DB migration? Support First I had issues with the external_id field on SSO, because they were all initially strings of length 16, and later I stored 24chars strings, but it completely messed up, you could get logged under a different user, it seems it cropped the external_id length, but that was hard to debug. So I make sure to keep external_id with the same length, it’s not really practical, why not using a TEXT column type for it? And my question is also, can I update the external_id of existing users, after doin… Still I was interested in some insights regarding the implications of updating the external_id on the database. could I just issue an sql update and set the new correct external_id? can that bring any hidden problems? like if the user has a current open session or something else? I got the users created through sso using an external_id that’s the user’s account id on the external system. (I may need to model something else but it would be cool to be able to avoid changing the external system model at least for now) the problem for me is that the person may have more than one account on the external system and can merge those accounts into one so sometimes depending on how he merges a new external_id can come for the same user/email. I am using the require_activation option so as I 've read on the mentioned topic I can’t delete the record and wait for it to be recreated. thank you

[image] Nicolas Barrera: could I just issue an sql update and set the new correct external_id? Yes, you should be able to do that, but you should fix the real problem first [image] Nicolas Barrera: the problem for me is that the person may have more than one account on the external system and can merge those accounts into one so sometimes depending on how he merges a new external_id can come for the same user/email. for instance when accounts are being merged always make sure the lowest ID is assigned / used.

Yes.. during external account merges I am respecting the oldest account… but sometimes that’s not what I need. some accounts interact with the forum (type A, letsay) and some other accounts are not meant for that (type B). so if they first create a type B account… and later they create a type A account, they do sso with it on the forum and later they merge A & B and honor the oldest account which has a different external_id so yes… I need to come up with a solution for my external system thingy… but I think I will setup a daily cron that checks if any of this happened and fixup the external_ids for the moment. thank you!

In that case you could either a) synchronize all accounts to discourse using the SSO sync mechanism b) keep track of which accounts have been used to log in to Discourse or c) when you merge, do an external ID lookup to determine which account(s) have been used with Discourse

Is it ok to update external_id on discourse database?

Product Support SSO

RGJ (Richard - Communiteq) June 7, 2023, 10:09pm 2

Yes, you should be able to do that, but you should fix the real problem first

for instance when accounts are being merged always make sure the lowest ID is assigned / used.

Topic		Replies	Views
Is it possible to change users SSO's external_id after a DB migration? Product Support	3	1781	June 1, 2019
A way for admins to edit users' external IDs Feature	10	2956	February 25, 2019
SSO - Updating a user's External ID SSO	2	974	April 12, 2022
How can one update a user based on external_id? Product Support	2	1043	January 21, 2021
Modify identity provider external ID for a User SSO rest-api	1	663	January 22, 2024

Is it ok to update external_id on discourse database?

Related topics