[imp] Autocomplete address problem.

[Servizi Informatici (admin)]

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