[imp] Autocomplete address problem.

ANANT S ATHAVALE asa at isac.gov.in
Fri Feb 6 10:24:20 UTC 2015


----- Message from "Servizi Informatici (admin)" <admin at dei.unipd.it>  
---------
     Date: Fri, 06 Feb 2015 11:08:28 +0100
     From: "Servizi Informatici (admin)" <admin at dei.unipd.it>
Subject: Re: [imp] Autocomplete address problem.
       To: imp at lists.horde.org


> On 02/06/2015 07:01 AM, ANANT S ATHAVALE wrote:
>>
>> ----- Message from ANANT S ATHAVALE <asa at isac.gov.in> ---------
>>  Date: Tue, 03 Feb 2015 11:54:33 +0530
>>  From: ANANT S ATHAVALE <asa at isac.gov.in>
>> Subject: [imp] Autocomplete address problem.
>>    To: imp at lists.horde.org
>>    Cc: turba at lists.horde.org
>>
>>
>>> Dear List,
>>>
>>> I have recently installed latest stable version of HGWE.
>>>
>>> Autocomplete is not working for one of the attribute which I have  
>>> mentioned in search under LDAP.
>>>
>>> for IMP, prefs.local.php, I have set
>>>
>>> $_prefs['search_sources']['hook'] = true;
>>> $_prefs['search_fields']['hook'] = true;
>>> $_prefs['add_source']['hook'] = true;
>>>
>>> enabled the hooks in imp/hooks.local.php
>>>
>>>
>>> for turba,
>>>
>>> turba/attributes.local.php (the file contains additional  
>>> attribute, which is refered in LDAP)
>>>
>>> <?php
>>> $attributes['staffno'] = array(
>>>   'label' => _("StaffNumber"),
>>>   'type' => 'text',
>>>   'required' => false,
>>>   'params' => array('regex' => '', 'size' => 32, 'maxlength' => 32)
>>> );
>>>
>>> $attributes['postalAddress'] = array(
>>>   'label' => _("Postal Address"),
>>>   'type' => 'text',
>>>   'required' => false,
>>> );
>>>
>>> $attributes['cn'] = array(
>>>   'label' => _("Complete Name"),
>>>   'type' => 'text',
>>>   'required' => false,
>>> );
>>>
>>>
>>> turba/backends.local.php
>>>
>>> <?php
>>> $cfgSources['localsql']['title'] = 'My Address Book';
>>> $cfgSources['localsql']['use_shares'] = false;
>>> $cfgSources['localldap']['disabled'] = false;
>>> $cfgSources['localldap']['title'] = 'LDAP Directory';
>>> $cfgSources['localldap']['params']['server'] = 'xxx.xx.x.xx';
>>> $cfgSources['localldap']['params']['root'] = 'dc=xxxx,dc=xxx';
>>> $cfgSources['localldap']['params']['bind_dn'] = 'cn=Manager,dc=xxx';
>>> $cfgSources['localldap']['params']['bind_password'] = 'xxxxxxxxxx';
>>> $cfgSources['localldap']['params']['limit'] = 20;
>>> $cfgSources['localldap']['params']['scope'] = 'sub';
>>> $cfgSources['localldap']['map'] = array(
>>>       '__key' => 'dn',
>>>       '__uid' => 'mailacceptinggeneralid',
>>>       'staffno' => 'staffnumber',
>>>       'postalAddress' => 'postalAddress',
>>>       'cn' => 'cn',
>>>       'name' => array('fields' => array('cn', 'postalAddress'),
>>>                       'format' => '%s %s',
>>>                       'parse' => array(
>>>                           array('fields' => array('cn'),
>>>                                 'format' => '%s' ),
>>>                           array('fields' => array('cn', 'postalAddress'),
>>>                                 'format' => '%s', '%s' ))),
>>>       'email' => 'mail',
>>>       'freebusyUrl' => 'uid'
>>>   );
>>> $cfgSources['localldap']['search'] = array('staffno','name','email');
>>> $cfgSources['localldap']['export'] =  false;
>>> $cfgSources['localldap']['browse'] =  false;
>>>
>>> turba/prefs.local.php
>>>
>>> <?php
>>> $prefGroups['addressbooks']['suppress'] = true;
>>> $prefGroups['sync']['suppress'] = true;
>>> $prefGroups['columns']['suppress'] = true;
>>> $_prefs['default_dir']['locked'] = true;
>>> $_prefs['default_dir']['value'] = 'localsql';
>>> $_prefs['columns']['locked'] = true;
>>> $_prefs['columns']['value']=  
>>> "localsql\temail\nlocalldap\temail\tstaffno\nfavourites\temail";
>>>
>>>
>>> With these settings, if I try to autocomplete on staff number, it  
>>> does not work.  While on name and email it works.  How to debug?
>>>
>>>
>>>
>>> -- 
>>>    सादर धन्यवाद/ Thanks & Regards
>>>         अनंत / Anant
>>> ------------------------------------------------------------------------------ Confidentiality Notice: This e-mail message, including any attachments, is  
>>> for
>>> the sole use of the intended recipient(s) and may contain confidential and
>>> privileged information. Any unauthorized review, use, disclosure or
>>> distribution is prohibited. If you are not the intended recipient, please
>>> contact the sender by reply e-mail and destroy all copies of the original
>>> message.
>>> ------------------------------------------------------------------------------ -- imp mailing  
>>> list
>>> Frequently Asked Questions: http://wiki.horde.org/FAQ
>>> To unsubscribe, mail: imp-unsubscribe at lists.horde.org
>>
>>
>> ----- End message from ANANT S ATHAVALE <asa at isac.gov.in> -----
>>
>> I did add the following lines in ContactAutoCompleter.php
>>
>> 54,57c54
>> <
>> <     Horde::debug($ob->fields, "/logs/horde-debug.log");
>> <     Horde::debug($ob->sources, "/logs/horde-debug.log");
>> <
>>
>> and please find attached horde-debug.log file.  I am also seeing in  
>> LDAP log that, it is being searched for the parameter.
>>
>> Feb  6 11:35:49 servername slapd[1267]: conn=128477575 op=1 SRCH  
>> base="dc=xxxx,dc=xxx" scope=2 deref=0  
>> filter="(|(staffnumber=*xx0xxxx*)(|(|(cn=*xx0xxxx*)(postalAddress=*xx0xxxx*)))(mail=*xx0xxxx*))
>>
>> Please suggest, what I should look at to resolve the issue.
>>
>>
>>
>>
> Hello
> did you try with 'ldapsearch' in a shell to do a similar search?
> Something like:
> ldapsearch -w managerpassword -D "cn=Manager,dc=xxx,dc= ...."  
> staffnumber=xx0xxxx
>
> Maybe "staffnumber" attribute isn't searchable (check your LDAP schema).
>
> Regards
>
>    Valerio
>
>
> -- 
> imp mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org


----- End message from "Servizi Informatici (admin)"  
<admin at dei.unipd.it> -----

It was and is working in Horde Groupware Webmail Edition 5.1.4.  I  
recently installed Horde Groupware Webmail Edition 5.2.4 and facing  
this issue.

As per the LDAP logs, it is returning one entry, but not getting  
displayed on screen (my understanding).

Feb  6 11:35:49 server slapd[1267]: conn=128477575 fd=23 ACCEPT from  
IP=xxx.xx.x.xx:43843 (IP=0.0.0.0:389)
Feb  6 11:35:49 server slapd[1267]: conn=128477575 op=0 BIND  
dn="cn=xxxxxxx,dc=xxx" method=128
Feb  6 11:35:49 server slapd[1267]: conn=128477575 op=0 BIND  
dn="cn=xxxxxxx,dc=xxx" mech=SIMPLE ssf=0
Feb  6 11:35:49 server slapd[1267]: conn=128477575 op=0 RESULT tag=97  
err=0 text=
Feb  6 11:35:49 server slapd[1267]: conn=128477575 op=1 SRCH  
base="dc=xxxx,dc=xxx" scope=2 deref=0  
filter="(|(staffnumber=*xx0xxxx*)(|(|(cn=*xx0xxxx*)(postalAddress=*xx0xxxx*)))(mail=*xx0xxxx*))"
Feb  6 11:35:49 server slapd[1267]: conn=128477575 op=1 SRCH attr=dn  
cn postalAddress mail sn
Feb  6 11:35:49 server slapd[1267]: conn=128477575 op=1 SEARCH RESULT  
tag=101 err=0 nentries=1 text=
Feb  6 11:35:49 server slapd[1267]: conn=128477575 op=2 UNBIND
Feb  6 11:35:49 server slapd[1267]: conn=128477575 fd=23 closed



-- 
      सादर धन्यवाद/ Thanks & Regards
           अनंत / Anant
------------------------------------------------------------------------------
Confidentiality Notice: This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
------------------------------------------------------------------------------



More information about the imp mailing list