search

Chefkeks / osTicket-Addons

osTicket Addons
7 stars 3 forks source link

AD Sync "Umlaut" mutated vowel #6

Open freshW opened 7 years ago

freshW commented 7 years ago

I'm again testing your osTicket LDAP User Information Addon v0.4 in my ost 1.9.12 - it works well but i got one problem.

How can I change It so that some special german/french chars are written correct to the DB? So like äöué ? On the webpage of the plugin and in the logfile the chars are correct but in the DB they are wrong :(

I also use the ldap "Authentication and Lookup" and the "HTTP Passthru Authentication", there I have no problem with äöué

Do you have any Idea.

Chefkeks commented 7 years ago

Hi there,

I was never aware of the limitation with German Umlauts. Since I'm German too, working in a German Company, I first thought "this can't be an issue" when I read your report. But then I checked our accounts and found out that because of such issues all users in our whole AD are entered with the alternative writing method, so "ae" instead of "ä" and so on.

I'll have a look tomorrow and try what happens when I add a users with ä, ö, etc.

Cheers, Michael

Chefkeks commented 7 years ago

Ok, just tried with 2 installation: 1.9.14 and 1.10, bot with my LDAP User Info Addon v.0.4 and it correctly wrote everything to the database. I used Fününününü as the test string.

Maybe it's related to the PHP version or the MySQL database collation?! We here use a linux machine with apache 2.4.6, PHP 5.6.9, MySQL 5.6.12 and both databases have utf8_general_ci collation. I know that there are newer versions of apache, php, etc out there, but you know never touch a running system ;)

I really hope that helps you, since I'm not a developer nor a code debugger - instead I'm just a system administrator with limited coding skills, but at least they're good enough for things like the LDAP User Info Addon. I'm sure someone with real coding skills would definitely do a better job on this in half the time or less and develop an (un)official addon for osTicket to sync LDAP/AD and osTicket accounts, but since that doesn't seem to happen, I'm happy for me and for everyone else for whom the LDAP User Info Addon is working!

So sorry I'm not able to really help you with the issue :( Michael

freshW commented 7 years ago

Oh I see, i will test again this week and give you feedback, maybe I have a config mistake in test enviroment.

Thanks for your help.

freshW commented 7 years ago

I testet it again, our datase has utf8_general_ci. We use: osTicket-Version v1.9.12 Server-Software Apache/2.4.10 (Debian) MySQL-Version 5.5.53 PHP-Version 5.6.27-0+deb8u1

Did you test it with the company field?

Chefkeks commented 7 years ago

Tested it only with one field, but I don't think it would make a difference since all fields are treated the same way during the process.