Good day everyone!
I'm trying to setup a multi-domain config here using SQL as auth source.
Since I have a SQL database I can create views in whatever format/schema
necessary, so this isn't a problem.
The problem I have is that when I log in as '[email protected]' I'm
redirected do a URL with my email address as
'[email protected]@domain.com.br'. One implication here is my CardDAV
and CalDAV config URLs. From what I understand, SOGo should read the
@domain.com.br, access only the right domain record and that is it, it
shouldn't need to append my domain again.
Another problem is that it is trying to authenticate my user with all
the domains, one domain at a time, as if it didn't care about the
'@domain.com.br' at all, about the SOGoMailDomain at all. With about 100
domains this is pretty inefficient. When I try to authenticate as
[email protected] it will check domain.com.br's MySQL first.
I'm logging in as [email protected] at the web interface.
Right now my tables have:
mysql> select * from sogo_domaincombr limit 5;
+---------------------------+----------+------------------------------------+---------------------------+---------------------------+
| c_uid | c_name |
c_password | c_cn |
mail |
+---------------------------+----------+------------------------------------+---------------------------+---------------------------+
| [email protected] | daniel | (erased) | [email protected]
| [email protected] |
| [email protected] | registro | (erased) | [email protected]
| [email protected] |
| [email protected] | vendas | (erased) | [email protected]
| [email protected] |
| [email protected] | contato | (erased) | [email protected]
| [email protected] |
| [email protected] | admin | (erased) | [email protected]
| [email protected] |
+---------------------------+----------+------------------------------------+---------------------------+---------------------------+
My GNUStep have:
sogod SOGoEnableDomainBasedUID YES
sogod SOGoForceIMAPLoginWithEmail YES
sogod domains '{
domain.com.br = {
SOGoIMAPServer = mail.domain.com.br;
SOGoMailDomain = domain.com.br;
SOGoSMTPServer = mail.domain.com.br;
SOGoUserSources = (
{
canAuthenticate = YES;
id = domain.com.br;
isAddressBook = NO;
type = sql;
userPasswordAlgorithm = crypt;
viewURL =
"mysql://sogo:[email protected]:3306/auth/sogo_domaincombr";
}
);
};
domain2.com.br = {
SOGoIMAPServer = mail.domain2.com.br;
SOGoMailDomain = domain2.com.br;
SOGoSMTPServer = mail.domain2.com.br;
SOGoUserSources = (
{
canAuthenticate = YES;
id = domain2.com.br;
isAddressBook = NO;
type = sql;
userPasswordAlgorithm = crypt;
viewURL =
"mysql://sogo:[email protected]:3306/auth/sogo_domain2combr";
}
);
};
}'
Thank you very much.
Best,
Daniel Colchete
--
[email protected]
https://inverse.ca/sogo/lists
