Problem with Ldap import from AD

More
3 years 7 months ago #100062 by Donsson
Donsson created the topic: Problem with Ldap import from AD
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

Please Log in to join the conversation.

More
3 years 7 months ago #100083 by DenisChenu
DenisChenu replied the topic: Problem with Ldap import from AD
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

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: Donsson

Please Log in to join the conversation.

More
3 years 7 months ago #100085 by Donsson
Donsson replied the topic: Problem with Ldap import from AD
Thanks

That guided me to right direction.
I got it work with utf-8 encoding and changing protocol to ldapv3

Please Log in to join the conversation.

More
3 years 7 months ago #100132 by DenisChenu
DenisChenu replied the topic: Problem with Ldap import from AD
Maybe we can update a little the LDAP.file.

But i think by dfault is this settings ?
No ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now