Hello all,
we set up SOGo 2.0.7 with multiple domains and a MySQL backend (Postfix
admin database) and everything works fine, many thanks for this very
good work.
There is a small problem I can not solve: On the login page, if I check
"remember me" SOGo add the domain to the login name. Instead of
[email protected] sogo stores [email protected]@domain1.com.
All advice are welcome
Thanks
François
{
NSGlobalDomain = {
};
sogod = {
NGUseUTF8AsURLEncoding = YES;
OCSFolderInfoURL =
"mysql://postfixadm:*****@127.0.0.1:3306/postfix/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://postfixadm:*****@127.0.0.1:3306/postfix/sogo_sessions_folder";
SOGoACLsSendEMailNotifications = YES;
SOGoAppointmentSendEMailNotifications = YES;
SOGoCalendarDefaultRoles = (
PublicViewer,
ConfidentialDAndTViewer
);
SOGoDomainsVisibility = (
(
"domain2.com",
"domain1.com",
)
);
SOGoDraftsFolderName = Drafts;
SOGoEnableDomainBasedUID = YES;
SOGoFirstDayOfWeek = 1;
SOGoFoldersSendEMailNotifications = YES;
SOGoIMAPServer = "127.0.0.1";
SOGoLanguage = French;
SOGoLoginModule = Calendar;
SOGoMailMessageCheck = "every_5_minutes";
SOGoMailingMechanism = smtp;
SOGoMemcachedHost = "127.0.0.1";
SOGoPasswordChangeEnabled = YES;
SOGoProfileURL =
"mysql://postfixadm:*****@127.0.0.1:3306/postfix/sogo_user_profile";
SOGoSMTPServer = "127.0.0.1";
SOGoSentFolderName = Sent;
SOGoSieveScriptsEnabled = YES;
SOGoSieveServer = "sieve://127.0.0.1:4190";
SOGoSuperUsernames = (
"[email protected]"
);
SOGoTimeZone = "Europe/Paris";
SOGoTrashFolderName = Trash;
SOGoVacationEnabled = YES;
domains = {
"domain1.com" = {
SOGoDraftsFolderName = Drafts;
SOGoMailDomain = "domain1.com";
SOGoUserSources = (
{
DomainFieldName = domain;
IMAPLoginFieldName = mail;
LoginFieldNames = (
"c_name"
);
canAuthenticate = YES;
displayName = "Utilisateurs domain1.com";
id = users2;
isAddressBook = YES;
type = sql;
userPasswordAlgorithm = "md5-crypt";
viewURL =
"mysql://postfixadm:*****@127.0.0.1:3306/postfix/sogo_users_domain1_com";
}
);
};
"domain2.com" = {
SOGoDraftsFolderName = Drafts;
SOGoMailDomain = "domain2.com";
SOGoUserSources = (
{
DomainFieldName = domain;
IMAPLoginFieldName = mail;
LoginFieldNames = (
"c_name"
);
canAuthenticate = YES;
displayName = "Utilisateurs domain2.com";
id = users1;
isAddressBook = YES;
type = sql;
userPasswordAlgorithm = "md5-crypt";
viewURL =
"mysql://postfixadm:*****@127.0.0.1:3306/postfix/sogo_users_domain2_com";
}
);
};
};
};
}
viewURL is a MySQL view on the mailbox table :
c_uid francois
c_name [email protected]
c_password $1$******/
c_cn Francois Grange
mail [email protected]
domain domain1.com
c_domain domain1.com
--
[email protected]
https://inverse.ca/sogo/lists
