LDAP Email and login
Users must have "email" defined in LDAP (Active Directory), because the EmailAddress column in user table cannot be NULL.
could not execute batch command.[SQL: SQL not available] ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'EmailAddress', table 'HgLab.dbo.User'; column does not allow nulls. INSERT fails.
But this is not mandatory and there are some directories (LDAP) where users doesnt have email specified, therefore they cannot use HgLab.
A simple solution would be, if the user doesnt have email specified then add the UPN as email in the User table automatically (the userPrincipalName is user@domain). Also, the Email field should be editable in the user profile through UI, because maybe the user would like to use an external email like @gmail.com or @yahoo.com or change its current email whenever is specified in LDAP or not.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
Support Staff 1 Posted by Anton Gogolev on 16 Oct, 2013 07:40 AM
Alejandro,
Users not having an email address is something I have already stumbled upon and that's already fixed in an upcoming version (this and auto-generation of email addresses).
As for changing ones' email address, it's a nice idea but requires careful handling of various edge-cases. Plus, I'm thinking of supporting multiple emails per user (so that changesets will get linked properly), so this has to be factored in.
Nevertheless, thanks for the report!