SIMPLELDAP (Retrieve user details) Fails

[Reggie Garrison]

Hi All,

I have run into a stumbling block with RS and AD and was hoping someone here might be able to help.  When using SIMPLELDAP to import my users from AD, I am able to connect and bind but I cannot retrieve any user details.  I have pasted the debug log here:

1	2017-06-09 15:02:16 SQL: SELECT COUNT(*) value FROM (SELECT creation_date as date,ref, field8 as description,'resourcereview' as type FROM (select distinct r.hit_count score, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,r.annotation_count ,null group_access, null user_access ,r.field12 ,r.field8 ,r.field3 , r.hit_count total_hit_count from resource r where resource_type in ('1','2','3','4') and archive in (-1) and r.ref>0 group by r.ref order by r.ref desc limit 200000) resources UNION SELECT created as date,ref,username as description,'resourcerequest' as type FROM (SELECT u.username,u.fullname,r.*,(SELECT count(*) FROM collection_resource cr WHERE cr.collection=r.collection) c,u2.username assigned_to_username FROM request r LEFT OUTER JOIN user u ON r.user=u.ref LEFT OUTER JOIN user u2 ON r.assigned_to=u2.ref WHERE r.assigned_to IS null AND r.status=0 ORDER BY status,ref desc) requests UNION SELECT created as date,ref,concat(fullname,if(email<>'',concat('(',email,')'),'')) as description,'userrequest' as type FROM (SELECT u.ref,u.created,u.fullname,u.email,u.username from user u left outer join usergroup g on u.usergroup=g.ref where usergroup IN (2,1,4,9,15,11,14,10,12,13,7,8,5,6,3) and u.approved='0' order by u.created) users) allactions
2	2017-06-09 15:02:16 SQL: select * from usergroup order by (ref='2') desc,name
3	2017-06-09 15:02:16 $results_sql=select distinct r.hit_count score, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,r.annotation_count ,null group_access, null user_access ,r.field12 ,r.field8 ,r.field3 , r.hit_count total_hit_count from resource r where resource_type in ('1','2','3','4') and archive in (-1) and r.ref>0 group by r.ref order by r.ref desc limit 200000
4	2017-06-09 15:02:16 SQL: select ref from resource_type_field where keywords_index=1 and length(name)>0
5	2017-06-09 15:02:16 SQL: select ref as value from resource_type_field where keywords_index=1
6	2017-06-09 15:02:16 search= -1 restypes=1,2,3,4 archive=-1 daylimit= editable_only=true
7	2017-06-09 15:02:16 SQL: select * from resource_type order by order_by,ref
8	INNER JOIN `message` ON user_message.message=message.ref LEFT OUTER JOIN `user` ON message.owner=user.ref WHERE user_message.user='1' AND message.expires > NOW() AND user_message.seen='0' ORDER BY user_message.ref ASC
9	2017-06-09 15:02:16 SQL: SELECT user_message.ref, user.username AS owner, user_message.seen, message.created, message.expires, message.message, message.url FROM `user_message`
10	WHERE user = '1';
11	FROM user_preferences
12	`value`
13	SELECT parameter,
14	2017-06-09 15:02:16 SQL:
15	2017-06-09 15:02:16 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority
16	AND specific_to_group = '3';
17	AND (page = 'message' OR page = 'all' OR page = '' ) #pagefilter
18	WHERE language = 'en-US'
19	FROM site_text
20	`page` >>> I would appreciate any help at all resolving this. Thank You, Reggie

[Troy Yeager]

Were you ever able to get this figured out? I'm running into the same issue and the debug doesn't provide any help.

Here is my debug output for reference:

2018-01-23 17:59:47 LDAP - Attempting to bind to AD server as : [ID]@[DOMAIN]

2018-01-23 17:59:47 LDAP - Success binding to AD server as : [ID]@[DOMAIN]

2018-01-23 17:59:47 LDAP - Connecting to LDAP server: [SERVER] on port 636

2018-01-23 17:59:47 LDAP - Connected to LDAP server 

2018-01-23 17:59:47 LDAP - Attempting to bind to LDAP server as : [ID]@[DOMAIN]

2018-01-23 17:59:47 LDAP - preparing search DN: OU=Employees,OU=People,DC=corp,DC=[DOMAIN],DC=com

2018-01-23 17:59:47 LDAP - binding as [ID]@[DOMAIN]

2018-01-23 17:59:47 LDAP - searching OU=Employees,OU=People,DC=corp,DC=[DOMAIN],DC=com as [ID]@[DOMAIN]

2018-01-23 17:59:47 LDAP - performing search: filter=(&(objectClass=person)(CN=[ID]))

2018-01-23 17:59:47 LDAP - retrieving attributes: displayname,memberOf,mail,telephoneNumber

2018-01-23 17:59:47 LDAP - search returned value Resource id #80

2018-01-23 17:59:47 LDAP - found 0 entries

2018-01-23 17:59:47 LDAP - search returned no values

Thanks,

Troy

[Troy Yeager]

Nevermind... just figured it out... I change the "Login field" to be 'samAccountName' instead of CN and all was good.

Thanks,

Troy

[fish slippery]

Excuse me, where are your debug info located? And how did you set the BIND DN and password in this plugin?