Welcome, Guest
Username: Password: Remember me

TOPIC: Problem with Ldap import from AD

Problem with Ldap import from AD 6 months 3 weeks ago #100062

  • Donsson
  • Donsson's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
I'm trying to get participants from active directory.
LimeSurvey binds to it ok and is working basicly correctly.

Problem is that when the group from whitch I try to import participant contains users whos name
contains umlauts (ä,ö, etc), the import crasches with error:

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xE4\xE4' for column 'lastname' at row 1


If I select a group that has users without umlauts it works as it should.

Is there any workaround since changing users names is not an option?

Used version of Limesurvey 2.00+ (130923) stable
The administrator has disabled public write access.

Problem with Ldap import from AD 6 months 3 weeks ago #100083

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5854
  • Thank you received: 716
  • Karma: 222
Hi,

Looking at application/config/LDAP.php, there are this information:
// Define the encoding used by the LDAP directory
// You may omit this parameter (let it commented out)
// as the default value, 'utf-8', should work for most installations.
// However, Active Directory in West Europe may use 'cp850'.
// $LDAP_server[$serverId]['encoding'] = 'utf-8';

Maybe you can try in your server config:
// Define the encoding used by the Ldap directory
// You may omit this parameter (let it commented out)
// as the default value, 'utf-8', should work for most installations.
// However, Active Directory in West Europe may use 'cp850'.
$ldap_server[$serverId]['encoding'] = 'cp850';

OR another encoding ...

Denis
The administrator has disabled public write access.
The following user(s) said Thank You: Donsson

Problem with Ldap import from AD 6 months 3 weeks ago #100085

  • Donsson
  • Donsson's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Thanks

That guided me to right direction.
I got it work with utf-8 encoding and changing protocol to ldapv3
The administrator has disabled public write access.

Problem with Ldap import from AD 6 months 3 weeks ago #100132

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5854
  • Thank you received: 716
  • Karma: 222
Maybe we can update a little the LDAP.file.

But i think by dfault is this settings ?
No ?
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.211 seconds
Donation Image