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 'u...@domain.com.br' I'm
redirected do a URL with my email address as
'u...@domain.com.br@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
dan...@domain2.com.br it will check domain.com.br's MySQL first.
I'm logging in as u...@domain.com 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 |
+---------------------------+----------+------------------------------------+---------------------------+---------------------------+
| dan...@domain.com.br | daniel | (erased) | dan...@domain.com.br
| dan...@domain.com.br |
| regis...@domain.com.br | registro | (erased) | regis...@domain.com.br
| regis...@domain.com.br |
| ven...@domain.com.br | vendas | (erased) | ven...@domain.com.br
| ven...@domain.com.br |
| cont...@domain.com.br | contato | (erased) | cont...@domain.com.br
| cont...@domain.com.br |
| ad...@domain.com.br | admin | (erased) | ad...@domain.com.br
| ad...@domain.com.br |
+---------------------------+----------+------------------------------------+---------------------------+---------------------------+
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:s...@mysql0-1.domain.int: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:s...@mysql0-1.domain.int:3306/auth/sogo_domain2combr";
}
);
};
}'
Thank you very much.
Best,
Daniel Colchete
--
users@sogo.nu
https://inverse.ca/sogo/lists
