View Issue Details

IDProjectCategoryView StatusLast Update
0004811SOGoWeb Calendarpublic2022-05-18 00:24
Reporternicolaspothin@socitmail.com Assigned Tofrancis  
PrioritynormalSeverityfeatureReproducibilityalways
Status assignedResolutionopen 
PlatformLinuxOSDevianOS VersionStretch
Product Version4.0.8 
Summary0004811: disable usersearch completion with web calendar
Description

Hi ,

I have a debian server stretch with sogo 4.0.8 ; Multi domain ; authentication with SQL.

My problem is I do not find an option / configuration / tips to disable usersearch completion in share web calendar.

I tried with options
SOGoSearchMinimumWordLength=100
or
isAddressBook=NO

But nothing change in the usersearch when doing a share

Thanks to you for help

TagsNo tags attached.

Relationships

related to 0005514 new Hide user accounts from each other 

Activities

Christian Mack

Christian Mack

2019-09-16 09:43

developer   ~0013744

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

nicolaspothin@socitmail.com

nicolaspothin@socitmail.com

2019-09-16 10:43

reporter   ~0013745

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,

Christian Mack

Christian Mack

2019-09-16 12:37

developer   ~0013748

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

nicolaspothin@socitmail.com

nicolaspothin@socitmail.com

2019-09-16 17:22

reporter   ~0013749

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

Christian Mack

Christian Mack

2019-09-17 07:04

developer   ~0013750

Last edited: 2019-09-17 07:05

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.

nicolaspothin@socitmail.com

nicolaspothin@socitmail.com

2019-09-17 19:07

reporter   ~0013753

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

francis

francis

2019-09-18 18:51

administrator   ~0013757

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.

nicolaspothin@socitmail.com

nicolaspothin@socitmail.com

2019-09-19 10:38

reporter   ~0013759

Last edited: 2022-05-18 00:24

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 = &quot;mysql://mailadmin:xxxxxxx@localhost:3306/mail/virtual_users&quot;;
        canAuthenticate = YES;
        isAddressBook = NO;
        displayName = &quot;Display dev.socitmail.com&quot;;
        userPasswordAlgorithm = &quot;sha512-crypt&quot;;
        IMAPLoginFieldName = &quot;mail&quot;;
        LoginFieldNames = (&quot;c_uid&quot;);
        DomainFieldName = &quot;domain&quot;;
        }
      );
    };
  };

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

Related Changesets

sogo: master 3cddb54e

2019-09-18 14:02

francis


Details Diff
(js) Apply SOGoSearchMinimumWordLength everywhere

Fixes 0004811
Affected Issues
0004811
mod - UI/Templates/MailPartViewers/UIxMailPartICalViewer.wox Diff File
mod - UI/Templates/MailerUI/UIxMailEditor.wox Diff File
mod - UI/Templates/MailerUI/UIxMailUserDelegationEditor.wox Diff File
mod - UI/Templates/SchedulerUI/UIxAppointmentViewTemplate.wox Diff File
mod - UI/Templates/UIxAclEditor.wox Diff File

Issue History

Date Modified Username Field Change
2019-09-15 13:38 nicolaspothin@socitmail.com New Issue
2019-09-16 09:43 Christian Mack Note Added: 0013744
2019-09-16 10:43 nicolaspothin@socitmail.com Note Added: 0013745
2019-09-16 12:37 Christian Mack Note Added: 0013748
2019-09-16 17:22 nicolaspothin@socitmail.com Note Added: 0013749
2019-09-17 07:04 Christian Mack Note Added: 0013750
2019-09-17 07:05 Christian Mack Note Edited: 0013750
2019-09-17 19:07 nicolaspothin@socitmail.com Note Added: 0013753
2019-09-18 18:10 francis Changeset attached => sogo master 3cddb54e
2019-09-18 18:10 francis Assigned To => francis
2019-09-18 18:10 francis Resolution open => fixed
2019-09-18 18:48 francis Status new => assigned
2019-09-18 18:48 francis Resolution fixed => open
2019-09-18 18:51 francis Note Added: 0013757
2019-09-19 10:38 nicolaspothin@socitmail.com Note Added: 0013759
2022-05-09 13:06 Christian Mack Relationship added related to 0005514
2022-05-18 00:24 francis Note Edited: 0013759