CiviCRM Community Forums (archive)

hi. i followed instructions on http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+LDAP+Integration and integrated LDAP with CiviCRM on our Ubuntu server (i posted a comment with differences in installation on ubuntu on above wiki page). but LDAP works kind of funny so i have a question:

when i run the query %abba% in civicrm i'm getting 6 records 3 of them with emails in primary location. than in thunderbird in address-book i search for 'abba' string. and i get 0 entries. i can see in the log-file that there are queries asked to mysql database like this one:

SELECT DISTINCT ldap_entries.id,civildap_individual.id,'inetOrgPerson' AS objectClass,ldap_entries.dn AS dn FROM ldap_entries,civildap_individual,civildap_contactemail WHERE civildap_individual.id=ldap_entries.keyval AND ldap_entries.oc_map_id=? AND 9=9 AND civildap_individual.contact_id=civildap_contactemail.contact_id AND ((civildap_contactemail.email LIKE '%abba%') OR (display_name LIKE '%abba%') OR (given_name LIKE '%abba%') OR (last_name LIKE '%abba%'))

i have try other strings, same thing, example: 'mah' in database 41 records at least 18 with email and in thunderbird address-book just 2 items. i do not understand this. is there anyway to make it show the same records?

regards, Wojtek

What is the version of civicrm you're using ? Some sql queries on openldap might need to be modified with the 2. version.

i am using modified 1.8 version.

As for the debug, what's the result when you run ldap in debug mode (you can prevent it to run in the background, that's easier to debug).

which exactly result i should post? there are many many lines for single query in the logfile. i attach part of log file. i still did not solve this mastery :-)

regards, Wojtek