Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: Problem with Ldap import from AD

Problem with Ldap import from AD 11 Monate 1 Woche her #100062

  • Donsson
  • Donssons Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 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
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Problem with Ldap import from AD 11 Monate 1 Woche her #100083

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6276
  • Dank erhalten: 801
  • Karma: 240
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
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Folgende Benutzer bedankten sich: Donsson

Problem with Ldap import from AD 11 Monate 1 Woche her #100085

  • Donsson
  • Donssons Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 2
  • Karma: 0
Thanks

That guided me to right direction.
I got it work with utf-8 encoding and changing protocol to ldapv3
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Problem with Ldap import from AD 11 Monate 6 Tage her #100132

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6276
  • Dank erhalten: 801
  • Karma: 240
Maybe we can update a little the LDAP.file.

But i think by dfault is this settings ?
No ?
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.267 Sekunden
Donation Image