[rt-users] Schema problem with RT
rfh at vialtus.com
Wed Dec 9 10:57:16 EST 2009
Name should also be unique , else how would 'someuser' login with their
As far as I know if a user created via email , then the Name will be the
email address which should also be unique across the internet.
Kenneth Marshall wrote:
> Dear RT developers,
> I have been investigating a problem with the automatic account
> creation process. I have been getting "could not load user"
> errors when internal users where trying to test from their
> external E-mail accounts to verify functionality. The upshot
> of my investigation is that the schemas all define a unique
> index on Name in the Users table. This is doomed to fail for
> most people who are sending from their Gmail/Hotmail/AOL
> accounts instead of their internal E-mail addresses.
> I was under the impression that the unique identifier for
> RT users was the EmailAddress and not the Name. In that
> case, the unique index should be on EmailAddress, instead
> of Name or alternatively the unique index should be on a
> composite key such as Name+EmailAddress.
> Would there be a problem with making that schema change
> and which is the preferred direction.
> Ken Marshall
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
More information about the rt-users