RTx::EmailCompletion - LDAP setup error and RDBMS not disabling

RT Users
1

Hi all,

Thanks to Kevin for pointing out the EmailCompletion extension. I had a user
ask me if I could do this and I hadn’t had time to look for it, rt-users
list saved me that time!

I installed it and got it running, works great with default setup.

I’m attempting the LDAP setup and want it NOT to search RT’s list(got a
bunch of junk emails I don’t want anyone to ever use).

Here is my config settings…

Set($EmailCompletionLdapServer, ‘XX.XX.XX.XX’);
Set($EmailCompletionLdapBase, ‘dc=mydomain,dc=local’);
Set($EmailCompletionLdapUser, ‘svc_rt’);
#Set($EmailCompletionLdapUser, ‘cn=service
rt,ou=Users,dc=mydomain,dc=local’);
Set($EmailCompletionLdapPass, ‘**************’);
Set($EmailCompletionLdapFilter, ‘(objectClass=person)’);
Set($EmailCompletionLdapAttrSearch, [qw/mail cn/]);
Set($EmailCompletionLdapAttrShow, “mail”);
Set($EmailCompletionLdapMinLength, 4);
Set($EmailCompletionRdmbsDisable, 1);
I have 2 issues I’m seeing now

  1. the EmailCompletionRdmbsDisable doesn’t seem to effect the lookup on RT’s
    database. In the debug logs I see this

[Tue May 24 19:30:01 2011] [debug]: SELECT DISTINCT main.* FROM Users main
JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) WHERE
(main.EmailAddress LIKE ‘%lori%’) AND (Principals_1.PrincipalType = ‘User’)
ORDER BY main.Name ASC
(/opt/rt3/local/plugins/RTx-EmailCompletion/lib/RTx/EmailCompletion.pm:23)

It’s still searching RT’s database. Now this could be linked to if the LDAP
is successful or not… but I would think the LDAP search would show up at
least?

  1. My LDAP bind fails with the setup above. I get a bind error(below)

[Tue May 24 19:30:01 2011] [crit]: Unable to bind to XX.XX.XX.XX:
LDAP_INVALID_CREDENTIALS
(/opt/rt3/local/plugins/RTx-EmailCompletion/lib/RTx/EmailCompletion/Ldap.pm:24)

I put in distinguishedName, as that’s what ExternalAuth uses as well. I ran
another test now nothing shows up in the error log… so I guess it’s
binding… but it still doesn’t show any results from my LDAP in the popup
list, only the ones from RT’s database.

I also ensured there wasn’t a limit on size of the popup and searched for
something that only has 1 result from both RT and LDAP databases.

Any thoughts?

Mike Johnson
Datatel Programmer/Analyst
Northern Ontario School of Medicine
955 Oliver Road
Thunder Bay, ON P7B 5E1
Phone: (807) 766-7331
Email: mike.johnson@nosm.ca

2

Might $EmailCompletionRdbmsDisable be the variable you want here?From: Mike Johnson <mike.johnson@nosm.camailto:mike.johnson@nosm.ca>
Date: Tue, 24 May 2011 16:34:54 -0400
To: <rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com>
Subject: [rt-users] RTx::EmailCompletion - LDAP setup error and RDBMS not disabling

Set($EmailCompletionRdmbsDisable, 1);
I have 2 issues I’m seeing now

  1. the EmailCompletionRdmbsDisable doesn’t seem to effect the lookup on RT’s database. In the debug logs I see this

[Tue May 24 19:30:01 2011] [debug]: SELECT DISTINCT main.* FROM Users main JOIN Principals Principals_1 ON ( Principals_1.id = main.idhttp://main.id/ ) WHERE (main.EmailAddress LIKE ‘%lori%’) AND (Principals_1.PrincipalType = ‘User’) ORDER BY main.Name ASC (/opt/rt3/local/plugins/RTx-EmailCompletion/lib/RTx/EmailCompletion.pm:23)

It’s still searching RT’s database. Now this could be linked to if the LDAP is successful or not… but I would think the LDAP search would show up at least?

3

Typos get me again!! I swear I’m dyslexic…

Anyway, I’ve changed that and I’m still getting the debug line that it’s
selecting users from the RT database.

Set($EmailCompletionLdapServer, ‘XX.XX.XX.XX’);
Set($EmailCompletionLdapBase, ‘dc=mydomain,dc=local’);
Set($EmailCompletionLdapUser, ‘distinguishedName of user’);
Set($EmailCompletionLdapPass, ‘pass’);
Set($EmailCompletionLdapFilter, ‘(objectClass=person)’);
Set($EmailCompletionLdapAttrSearch, [qw/mail cn/]);
Set($EmailCompletionLdapAttrShow, “mail”);
Set($EmailCompletionLdapMinLength, 4);
Set($EmailCompletionRdbmsDisable, 1);

As you can see, I’ve simplified my settings a fair bit more to try and get
it to work…

Still no LDAP values returned(not sure if the extension puts a debug line in
showing the bind/search in the logs but that isn’t there either), and the RT
database is still being used.

I restarted httpd after I made the changes, also tried using a completely
new browser(in case there was client side caching going on)… is there a
cache that needs cleaning on the server?

Thanks!
Mike.On Tue, May 24, 2011 at 10:11 PM, Roedel, Mark MarkRoedel@letu.edu wrote:

Might $EmailCompletionRdbmsDisable be the variable you want here?

From: Mike Johnson <mike.johnson@nosm.camailto:mike.johnson@nosm.ca>
Date: Tue, 24 May 2011 16:34:54 -0400
To: <rt-users@lists.bestpractical.com<mailto:
rt-users@lists.bestpractical.com>>
Subject: [rt-users] RTx::EmailCompletion - LDAP setup error and RDBMS not
disabling

Set($EmailCompletionRdmbsDisable, 1);
I have 2 issues I’m seeing now

  1. the EmailCompletionRdmbsDisable doesn’t seem to effect the lookup on
    RT’s database. In the debug logs I see this

[Tue May 24 19:30:01 2011] [debug]: SELECT DISTINCT main.* FROM Users main
JOIN Principals Principals_1 ON ( Principals_1.id = main.id<
http://main.id/> ) WHERE (main.EmailAddress LIKE ‘%lori%’) AND
(Principals_1.PrincipalType = ‘User’) ORDER BY main.Name ASC
(/opt/rt3/local/plugins/RTx-EmailCompletion/lib/RTx/EmailCompletion.pm:23)

It’s still searching RT’s database. Now this could be linked to if the LDAP
is successful or not… but I would think the LDAP search would show up at
least?

Mike Johnson
Datatel Programmer/Analyst
Northern Ontario School of Medicine
955 Oliver Road
Thunder Bay, ON P7B 5E1
Phone: (807) 766-7331
Email: mike.johnson@nosm.ca