Where in the database is the User ID Attribute (userid) received from the SSO

[Julio E. P. K.]

Hi:

When configuring the SSO, we got this:

User ID Attribute: Required. This value is used to associate the user’s edX account with the campus account. It is not displayed to users.

By default, uses userid, urn:oid:0.9.2342.19200300.100.1.1.

It works completely fine and we got login from SSO. However I can't find where in the database this userid is. Is it hashed?

Best regards,

Julio

[Xavier Antoviaque]

Hi Julio,

 

This is a value your IdP would be sending, and by default it would be looking at the variable name "userid", but you can chose a different name if your IdP sends it under another name at /admin/third_party_auth/samlproviderconfig/

 

It is stored in the social_auth_usersocialauth table, which stores the association between the local edX user and the IdP/username combination.

 

--

Xavier

@OpenCraft

--

You received this message because you are subscribed to the Google Groups "General Open edX discussion" group.

To view this discussion on the web visit https://groups.google.com/d/msgid/edx-code/08021222-d7e2-4d44-9a40-99afb529c82c%40googlegroups.com.

 

[Julio E. P. K.]

Thank you very much Xavier.

We are integrating legacy usual login with SSO login. I made tests and now I see it completely possible.

Best regards,

Julio