Do you mean autocompletion across domains?
What have you set for SOGoDomainsVisibility?

Hi,

Yes it is about autocompletion, but not specifically accross domains.

( NB : In fact I use SOGoDomainsVisibility for visibility between domains on another server Sogo but I think it is not corresponding for my request)

In this case I would like to disable autocompletion ( for non personnal addressbook ) inside the same domain.
I would like each user is invisible from another one for autocompletion.

I hope my explain is clear...

Kind regards,

Then you have to disable the global addressbook altogether, which means setting
isAddressBook = NO;
in your SOGoUserSources for that domain.

So I retry to check with changing on 'isAddressBook' parameter.

When it is on 'YES' :

• autocompletion work when I fill receiver on new mail.
• autocompletion work when I fill user on share (emai or calendar).

When it is on 'NO' :

• autocompletion DO NOT work when I fill receiver on new mail. ---> that is OK
• autocompletion work when I fill user on share (emai or calendar). ---> No change ...

Is this comportment is normal ?
Or do you want all my configuration to check few paramters...?

Thanks

With 'isAddressBook' set to NO there should be no autocompletion.
Neither in emails, nor appointment invitations, nor priviledge settings on calendars or address books.

Only exception would be contacts in one of your address books, or ones shared to you.

Hi,

Here is my configuration /etc/sogo/sogo.conf part for domain :
[...]
domains = {
dev.socitmail.com = {
SOGoSearchMinimumWordLength = 5;
SOGoLanguage = French;
SOGoMailDomain = dev.socitmail.com;
SOGoUserSources = (
{
type = sql;
id = users_1;
viewURL = "mysql://mailadmin:xxxxxx@localhost:3306/mail/virtual_users";
canAuthenticate = YES;
isAddressBook=NO;
displayName = "Display dev.socitmail.com";
userPasswordAlgorithm = "sha512-crypt";
IMAPLoginFieldName = "mail";
LoginFieldNames = ("c_uid");
DomainFieldName = "domain";
}
);
};
};
[...]

With restart service sogo and/or reboot server, 'userSearch' work again .

'sogo.log' are :
Sep 17 20:44:31 sogod [845]: |SOGo| starting method 'GET' on uri '/SOGo/so/devadmin@dev.socitmail.com/usersSearch?search=@dev'
Sep 17 20:44:31 sogod [845]: |SOGo| traverse(acquire): devadmin@dev.socitmail.com => usersSearch
Sep 17 20:44:31 sogod [845]: |SOGo| do traverse name: 'devadmin@dev.socitmail.com'
Sep 17 20:44:31 sogod [845]: |SOGo| do traverse name: 'usersSearch'
Sep 17 20:44:31 sogod [845]: |SOGo| set clientObject: <0x55821bd372a0[SOGoUserFolder]: name=devadmin@dev.socitmail.com container=0x55821b6b9b10/(null)>
2019-09-17 20:44:31.831 sogod[845:845] <MySQL4Channel[0x0x55821b6faef0] connection=0x0x55821bb7e308> SQL: SELECT * FROM virtual_users WHERE (LOWER(c_cn) LIKE '%@dev%' OR LOWER(mail) LIKE '%@dev%') AND (domain = 'dev.socitmail.com');
2019-09-17 20:44:31.832 sogod[845:845] <MySQL4Channel[0x0x55821b6faef0] connection=0x0x55821bb7e308> query has results, entering fetch-mode.
Sep 17 20:44:31 sogod [845]: |SOGo| request took 0.005440 seconds to execute
Sep 17 20:44:31 sogod [845]: <0x0x55821bdeaee0[WOResponse]> Zipping of response disabled
Sep 17 20:44:31 sogod [845]: 192.168.10.21 "GET /SOGo/so/devadmin@dev.socitmail.com/usersSearch?search=@dev HTTP/1.1" 200 234/0 0.007 - - 0

If you have an idea to search on another way or if you see an error.

Thanks you

I fixed the behaviour of SOGoSearchMinimumWordLength so the parameter is respected in all auto-completion input field.

However, if you set it to a very large value, you won't be able to assign permissions to new users.

Hi Francis,

Ok I tested your fixed with that :

  domains = {
    dev.socitmail.com = {
      SOGoSearchMinimumWordLength = 100;
      SOGoLanguage = French;
      SOGoMailDomain = dev.socitmail.com;
      SOGoUserSources = (
        {
        type = sql;
        id = users_1;
        viewURL = "mysql://mailadmin:xxxxxxx@localhost:3306/mail/virtual_users";
        canAuthenticate = YES;
        isAddressBook = NO;
        displayName = "Display dev.socitmail.com";
        userPasswordAlgorithm = "sha512-crypt";
        IMAPLoginFieldName = "mail";
        LoginFieldNames = ("c_uid");
        DomainFieldName = "domain";
        }
      );
    };
  };

The parameter 'SOGoSearchMinimumWordLength' is working now everywhere for user !

Great Thanks :)

But the thing I would like finally is permit to user to add a share without to see all account of domain(s). Like if each user was "invisible" (if not shared made) on his mailbox.
So like this the GAL would be NOT visible.

The user would have a view on his personnal addressbook (and shared) and could fill manually a share with, "in the best world", auto completion only on his personnal addressbook, or if not possible with validation possible when name/email corresponding exactly... (in fact now I can not add a share without auto completion because I need select in a list when auto-completion find some things)

NB : I try to use 'isAddressBook=NO' without success.

Kind regards for your help and DEV