
Hi all. I solved this problem, maybe it will help other peoples who will be faced with same situation. In Config.pm I inserted the following line: $ENV{ORACLE_HOME} = '/usr/local/oracle8-client/'; $ENV{LD_LIBRARY_PATH} = "/usr/local/oracle8-client/lib"; $ENV{NLS_LANG} = "RUSSIAN_CIS.UTF8"; ^^^^^^^^^^^^^^^^^^^^^^^^^^^ After that OTRS began to display Russian-speaking names of clients in a normal kind. All is great :-) I'm happy :-) Gazizov Andrey пишет:
Hi all.
I trying to integrate OTRS (2.4.1) with Oracle but it's not working for me :-) maybe someone faced with similar problem and could it solve. If it so it will be great if you can help me or simple share experience how you overcome this difficulty. Part of Config.pm follows the text. Notice that in my oracle DB I use other fields and therefore I change config in accordings with it. When I try to find customer via customer ID nothing happens :-) In OTRS log all looks fine and I don't found any errors in it.
$ENV{ORACLE_HOME} = '/usr/local/oracle8-client/'; $ENV{LD_LIBRARY_PATH} = "/usr/local/oracle8-client/lib"; # CustomerUser # (customer user database backend and settings) $Self->{CustomerUser} = { Name => 'Datenbank Quelle', Module => 'Kernel::System::CustomerUser::DB', Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:Oracle:sid=SID;host=A.B.C.D;port=1521;', User => '****', Password => '*****', Table => 'TABLE', }, # customer uniq id CustomerKey => 'a.customer_id', # customer # CustomerID => 'a.customer_id', CustomerUserListFields => ['a.fio_full_cli', 'a.email', 'a.phone'], CustomerUserSearchFields => ['a.customer_id'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 250, CustomerUserPostMasterSearchFields => ['a.email'], CustomerUserEmailUniqCheck => 1, Map => [ # note: Login, Email and CustomerID needed! # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly, http-link-target [ 'UserFirstname', 'Firstname', 'a.fio_full_cli', 1, 1, 'var', '', 0 ], [ 'UserLastname', 'Lastname', 'a.inter_name_cli', 1, 1, 'var', '', 0 ], [ 'UserEmail', 'Email', 'a.mail', 1, 1, 'var', '', 0 ], [ 'UserCustomerID', 'CustomerID', 'a.customer_id', 0, 1, 'var', '', 0 ], ],
};
-- Best regards, Andrey Gazizov ReTN