0004222: MySQL based setup does not allow select-able e-mail From addresses - SOGo | BTS

ID	Project	Category	View Status	Date Submitted	Last Update

0004222	SOGo	Web Mail	public	2017-07-07 02:34	2017-08-02 14:57

Reporter	davrom	Assigned To	francis
Priority	high	Severity	minor	Reproducibility	always
Status	closed	Resolution	no change required
Platform	Dell/Asus	OS	CentOS	OS Version	6
Product Version	3.2.0

Summary	0004222: MySQL based setup does not allow select-able e-mail From addresses
Description	This will be an overlap with some cited already here on-line - but to date cannot find the correct syntax or possibility to allow a user to select from a list of From addresses when composing an e-mail. Requirement is for: david@domain1.com, david@domain2.com, admin@domain1.com to be able to be selected from the one single SOGo/Linux user that is the termination point for these addresses (ie, there is only one physical user 'david' on the system but uses these three addresses). There are two Linux servers, one using the older SOGo 2 and the later SOGo 3 and this feature has never been possible - they are not using LDAP.
Steps To Reproduce	Click on From in composition screen and you only have one choice of sender. Have been trawling the original logs since 2015 on this one waiting for a clear and hopefully simple solution.
Additional Information	SOGoMailCustomFrom = YES; SOGoMailCustomFromEnabled = YES; are set in /etc/sogo/sogo.conf but there appears to be no actual ability to get this to work without some stipulation on-line to implement multiple domains under LDAP which is not feasible at this point. Have tried MailFieldNames as well but this prevents logins. Is there a simple way to alias the from addresses either at the main .conf level or user level?
Tags	No tags attached.

davrom 2017-07-07 02:45 reporter	sogo.conf (3,897 bytes)

Christian Mack 2017-07-07 08:50 developer ~0012058	How did you store those email addresses in your mysql?

davrom 2017-07-12 03:55 reporter ~0012090	Thanks for the reply Christian. Just via a shell script I wrote that front ends the relevant variables, which in turn does: use sogo; INSERT INTO sogo_users VALUES ('$THISUSER', '$THISUSER', MD5('$THISPASSWORD'), '$FULLNAME', '$EMAILADDR'); use mysql;

Christian Mack 2017-07-12 07:27 developer ~0012092	You should add at least one additional email field in your sogo_users table, and then set MailFieldNames in your SOGoUserSources in sogo.conf according to those fields. See https://sogo.nu/files/docs/SOGoInstallationGuide.html#_authentication_using_sql

Date Modified	Username	Field	Change
2017-07-07 02:34	davrom	New Issue
2017-07-07 02:45	davrom	File Added: sogo.conf
2017-07-07 08:50	Christian Mack	Note Added: 0012058
2017-07-11 13:53	ludovic	Severity	major => minor
2017-07-12 03:55	davrom	Note Added: 0012090
2017-07-12 07:27	Christian Mack	Note Added: 0012092
2017-08-02 14:57	francis	Status	new => closed
2017-08-02 14:57	francis	Assigned To	=> francis
2017-08-02 14:57	francis	Resolution	open => no change required