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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sándor Fehér
Sent: August 29, 2007 5:01 PM
To: [email protected]
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/
_______________________________________________
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/
