RE: [otrs] Charset problem at Agent LDAP synchronization
Hi, I had an issue with character sets being converted incorrectly. My issue was when data passed through mod_perl to and from the database. What I did to fix it is take the NLS_LANG environment variable and also make it a perl environment variable. The code I added was in the httpd.conf file for apache and it looked like the code below: PerlSetEnv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1 PerlPassEnv NLS_LANG Just replace the character set that you are using in your database and with LDAP. It may work but it may not. I am not using LDAP at all but I am using Oracle 10g. Let me know if it works out for you. Dan King Software Developer Canadian Resident Matching Service 613.237.0075 ext. 241 (Toll free) 877.CARMS.42 171 Nepean Street, Suite 300 Ottawa, ON, CAN K2P 0B4 www.carms.ca ------------------------------------------------------------------------------------ This e-mail message, including any attachments, is for the sole use of the intended recipients and may contain confidential and or privileged information. If you are not the intended recipient or this information has been forwarded in error, please contact the sender by reply e-mail and destroy copies of the original message. Ce message (incluant toute pièce jointe) s'adresse uniquement au(x) destinataire(s) prévu(s) ou à une personne autorisée à le recevoir en son (leur) nom. Il pourrait contenir des renseignements confidentiels ou protégés. Si vous l'avez reçu par erreur, nous vous prions d'en informer l'auteur dans les meilleurs délais, de ne pas divulguer son contenu et de le supprimer de votre système. Merci. -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sándor Fehér Sent: August 29, 2007 5:01 PM To: otrs@otrs.org Subject: [otrs] Charset problem at Agent LDAP synchronization Hi, There is a small but annoying problem in 2.2.2 Here is my scenario: The otrs box uses utf8 as default charset. It connects to an oracle 10g database uses EE8MSWIN1250 charset. My problem is that the Agent users' data got converted in bad format. The customers data get synchronized perfectly. My LDAP container uses utf8 also. In Config.pm at Customers section I use these options: SourceCharset => 'utf8',# DestCharset => 'iso-8859-2', But what about the Agent section ? How can I influence the conversion similar like above ? And at the end the bad news : I have a test system with 2.2.1 and it works fine with the same settings. Regards. Sandor _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
Dan King írta: Hi, Well. I thougth so if I made a mistake. There are a small difference between my 2.2.1 and 2.2.2 installation. After I set up the following ENV variable at the beginning of my /etc/init.d/apache2 my problem has gone. ENV="env -i LANG=C PATH=/bin:/usr/bin:/usr/local/bin LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client NLS_LANG=HUNGARIAN_HUNGARY.EE8MSWIN1250 ORACLE_SID=xe" That's all. Regards., Sandor
Hi,
I had an issue with character sets being converted incorrectly. My issue was when data passed through mod_perl to and from the database. What I did to fix it is take the NLS_LANG environment variable and also make it a perl environment variable. The code I added was in the httpd.conf file for apache and it looked like the code below:
PerlSetEnv NLS_LANG AMERICAN_AMERICA.WE8ISO8859P1 PerlPassEnv NLS_LANG
Just replace the character set that you are using in your database and with LDAP. It may work but it may not. I am not using LDAP at all but I am using Oracle 10g. Let me know if it works out for you.
Dan King Software Developer Canadian Resident Matching Service 613.237.0075 ext. 241 (Toll free) 877.CARMS.42 171 Nepean Street, Suite 300 Ottawa, ON, CAN K2P 0B4 www.carms.ca
------------------------------------------------------------------------------------
This e-mail message, including any attachments, is for the sole use of the intended recipients and may contain confidential and or privileged information. If you are not the intended recipient or this information has been forwarded in error, please contact the sender by reply e-mail and destroy copies of the original message. Ce message (incluant toute pièce jointe) s'adresse uniquement au(x) destinataire(s) prévu(s) ou à une personne autorisée à le recevoir en son (leur) nom. Il pourrait contenir des renseignements confidentiels ou protégés. Si vous l'avez reçu par erreur, nous vous prions d'en informer l'auteur dans les meilleurs délais, de ne pas divulguer son contenu et de le supprimer de votre système. Merci.
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Sándor Fehér Sent: August 29, 2007 5:01 PM To: otrs@otrs.org Subject: [otrs] Charset problem at Agent LDAP synchronization
Hi,
There is a small but annoying problem in 2.2.2 Here is my scenario: The otrs box uses utf8 as default charset. It connects to an oracle 10g database uses EE8MSWIN1250 charset. My problem is that the Agent users' data got converted in bad format. The customers data get synchronized perfectly. My LDAP container uses utf8 also. In Config.pm at Customers section I use these options:
SourceCharset => 'utf8',# DestCharset => 'iso-8859-2',
But what about the Agent section ? How can I influence the conversion similar like above ? And at the end the bad news : I have a test system with 2.2.1 and it works fine with the same settings.
Regards. Sandor
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? =http://www.otrs.com/
participants (2)
-
Dan King -
Sándor Fehér