[Mahara-contributors] [Bug 547565] Re: Cannot log in or modify user when auth_remote_user has duplicate username entries
** Changed in: mahara Status: Fix Committed = Fix Released -- Cannot log in or modify user when auth_remote_user has duplicate username entries https://bugs.launchpad.net/bugs/547565 You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Status in Mahara ePortfolio: Fix Released Bug description: If there are duplicate entries in auth_remote_user for the same username login (and modifying the user record) fails. The code clearly expects the username to be unique and errors ensue. This bug was imported from eduforge.org, see: https://eduforge.org/tracker/index.php?func=detailaid=2183group_id=176atid=739 ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 547565] Re: Cannot log in or modify user when auth_remote_user has duplicate username entries
There is almost certainly something wrong with this stuff, but it confuses me. I *think* the authinstance column on the auth_remote_user table is probably redundant, and that we should rely on the authinstance column in the usr table at all times. Whenever a user gets created, we try to store the parent authinstance in the usr table *and* in auth_remote_usr if possible. The only complication is that a parent auth method can be added after the user gets created for the first time, so you end up with some users who have the parent method stored, and other users with the child method stored. As far as I can tell, the user's authinstance never gets updated during login in either table. The only time it changes is by the admin changing it deliberately on the admin 'edit account settings' page, and when the user gets removed from an institution that owns their authinstance. I guess the use case for sometimes storing the parent and sometimes the child is when some users might be able to log in to Mahara from multiple moodles in the same institution (parent authinstance is stored) and other users can only log in from one moodle (child auth stored). Will do some more digging and confirm that we can ignore the authinstance column of auth_remote_user. If we can then obviously it'll require rewriting a few queries. -- Cannot log in or modify user when auth_remote_user has duplicate username entries https://bugs.launchpad.net/bugs/547565 You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Status in Mahara ePortfolio: Triaged Bug description: If there are duplicate entries in auth_remote_user for the same username login (and modifying the user record) fails. The code clearly expects the username to be unique and errors ensue. This bug was imported from eduforge.org, see: https://eduforge.org/tracker/index.php?func=detailaid=2183group_id=176atid=739 ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 547565] Re: Cannot log in or modify user when auth_remote_user has duplicate username entries
Another thing to fix here is that the institution column on the host table is redundant. host is pointed at by a wwwroot in the auth_instance_config table (sadly we would have to split up that table to enforce this relationship with a fk constraint). Because every authinstance has an institution, we shouldn't have one on host. -- Cannot log in or modify user when auth_remote_user has duplicate username entries https://bugs.launchpad.net/bugs/547565 You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Status in Mahara ePortfolio: Triaged Bug description: If there are duplicate entries in auth_remote_user for the same username login (and modifying the user record) fails. The code clearly expects the username to be unique and errors ensue. This bug was imported from eduforge.org, see: https://eduforge.org/tracker/index.php?func=detailaid=2183group_id=176atid=739 ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 547565] Re: Cannot log in or modify user when auth_remote_user has duplicate username entries
I'm adding a change to delete all remote user records (not just those for the old authinstance) when the admin changes a user's authinstance. I can't find any other way for a user to get duplicate remote user records, so I'm closing this for now. Because so much of this stuff to do with institutions, authinstances remote hosts is not enforced at the db level, I'm going to leave the big cleanup for when I've got more time. ** Changed in: mahara Status: Triaged = Fix Committed -- Cannot log in or modify user when auth_remote_user has duplicate username entries https://bugs.launchpad.net/bugs/547565 You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Status in Mahara ePortfolio: Fix Committed Bug description: If there are duplicate entries in auth_remote_user for the same username login (and modifying the user record) fails. The code clearly expects the username to be unique and errors ensue. This bug was imported from eduforge.org, see: https://eduforge.org/tracker/index.php?func=detailaid=2183group_id=176atid=739 ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 547565] Re: Cannot log in or modify user when auth_remote_user has duplicate username entries
** Changed in: mahara Assignee: (unassigned) = Richard Mansfield (richard-mansfield) -- Cannot log in or modify user when auth_remote_user has duplicate username entries https://bugs.launchpad.net/bugs/547565 You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Status in Mahara ePortfolio: Triaged Bug description: If there are duplicate entries in auth_remote_user for the same username login (and modifying the user record) fails. The code clearly expects the username to be unique and errors ensue. This bug was imported from eduforge.org, see: https://eduforge.org/tracker/index.php?func=detailaid=2183group_id=176atid=739 ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 547565] Re: Cannot log in or modify user when auth_remote_user has duplicate username entries
** Changed in: mahara Status: New = Triaged -- Cannot log in or modify user when auth_remote_user has duplicate username entries https://bugs.launchpad.net/bugs/547565 You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Status in Mahara ePortfolio: Triaged Bug description: If there are duplicate entries in auth_remote_user for the same username login (and modifying the user record) fails. The code clearly expects the username to be unique and errors ensue. This bug was imported from eduforge.org, see: https://eduforge.org/tracker/index.php?func=detailaid=2183group_id=176atid=739 ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
[Mahara-contributors] [Bug 547565] Re: Cannot log in or modify user when auth_remote_user has duplicate username entries
** Changed in: mahara Status: Confirmed = New ** Changed in: mahara Importance: Low = Medium ** Changed in: mahara Milestone: None = 1.3.0 -- Cannot log in or modify user when auth_remote_user has duplicate username entries https://bugs.launchpad.net/bugs/547565 You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Status in Mahara ePortfolio: New Bug description: If there are duplicate entries in auth_remote_user for the same username login (and modifying the user record) fails. The code clearly expects the username to be unique and errors ensue. This bug was imported from eduforge.org, see: https://eduforge.org/tracker/index.php?func=detailaid=2183group_id=176atid=739 ___ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp