Re: [rt-users] RTx::EmailCompletion - LDAP setup error and RDBMS not disabling
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 wrote: > Might $EmailCompletionRdbmsDisable be the variable you want here? > > > From: Mike Johnson mailto:mike.john...@nosm.ca>> > Date: Tue, 24 May 2011 16:34:54 -0400 > To: 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.john...@nosm.ca
Re: [rt-users] RTx::EmailCompletion - LDAP setup error and RDBMS not disabling
Might $EmailCompletionRdbmsDisable be the variable you want here? From: Mike Johnson mailto:mike.john...@nosm.ca>> Date: Tue, 24 May 2011 16:34:54 -0400 To: 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?
[rt-users] RTx::EmailCompletion - LDAP setup error and RDBMS not disabling
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? 2. 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.john...@nosm.ca