LDAP Email and login

Alejandro Tamayo Castillo's Avatar

Alejandro Tamayo Castillo

15 Oct, 2013 03:05 PM

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.

  1. Support Staff 1 Posted by Anton Gogolev on 16 Oct, 2013 07:40 AM

    Anton Gogolev's Avatar

    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!

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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

Recent Discussions

26 Nov, 2018 01:47 PM
16 Nov, 2018 07:51 PM
06 Nov, 2018 04:30 PM
24 Oct, 2018 07:57 AM
20 Jul, 2018 11:07 PM

 

05 Jul, 2018 10:53 AM
27 May, 2018 01:33 AM
14 May, 2018 03:38 PM
04 May, 2018 07:45 AM
28 Feb, 2018 07:08 AM
08 Feb, 2018 03:16 PM