Re: [imp] Autocomplete address problem.

Fri, 06 Feb 2015 02:30:52 -0800
----- Message from "Servizi Informatici (admin)" <[email protected]> --------- 
    Date: Fri, 06 Feb 2015 11:08:28 +0100
    From: "Servizi Informatici (admin)" <[email protected]>
Subject: Re: [imp] Autocomplete address problem.
      To: [email protected]



On 02/06/2015 07:01 AM, ANANT S ATHAVALE wrote:


----- Message from ANANT S ATHAVALE <[email protected]> ---------
 Date: Tue, 03 Feb 2015 11:54:33 +0530
 From: ANANT S ATHAVALE <[email protected]>
Subject: [imp] Autocomplete address problem.
   To: [email protected]
   Cc: [email protected]



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: [email protected]



----- End message from ANANT S ATHAVALE <[email protected]> -----

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: [email protected]
----- End message from "Servizi Informatici (admin)" <[email protected]> -----
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.
------------------------------------------------------------------------------

--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [email protected]

Reply via email to