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
