Необходимо подключить view в удаленном Oracle как customer database backend. Для этого необходимое все установил
Код: Выделить всё
[root@otrs logs]# echo $ORACLE_HOME
/usr/lib/oracle/11.2/client64
[root@otrs logs]# echo $LD_LIBRARY_PATH
/usr/lib/oracle/11.2/client64/lib
[root@otrs logs]# su otrs -s /bin/bash -c "perl /opt/otrs/bin/otrs.CheckModules.pl"
o Apache::DBI......................ok (v1.12)
o Apache2::Reload..................ok (v0.13)
o Archive::Tar.....................ok (v1.92)
o Archive::Zip.....................ok (v1.30)
o Crypt::Eksblowfish::Bcrypt.......ok (v0.009)
o Crypt::SSLeay....................ok (v0.64)
o Date::Format.....................ok (v2.24)
o DateTime.........................ok (v1.04)
o DBI..............................ok (v1.627)
o DBD::mysql.......................ok (v4.023)
o DBD::ODBC........................Not installed! (optional - Required to connect to a MS-SQL database.)
o DBD::Oracle......................ok (v1.76)
o DBD::Pg..........................ok (v2.19.3)
o Digest::SHA......................ok (v5.85)
o Encode::HanExtra.................ok (v0.23)
o IO::Socket::SSL..................ok (v1.94)
o JSON::XS.........................ok (v3.01)
o List::Util::XS...................ok (v1.27)
o LWP::UserAgent...................ok (v6.26)
o Mail::IMAPClient.................ok (v3.37)
o IO::Socket::SSL................ok (v1.94)
o Authen::SASL...................ok (v2.15)
o Authen::NTLM...................ok (v1.09)
o ModPerl::Util....................ok (v2.000010)
o Net::DNS.........................ok (v0.72)
o Net::LDAP........................ok (v0.56)
o Template.........................ok (v2.24)
o Template::Stash::XS..............ok (undef)
o Text::CSV_XS.....................ok (v1.00)
o Time::HiRes......................ok (v1.9725)
o XML::LibXML......................ok (v2.0018)
o XML::LibXSLT.....................ok (v1.80)
o XML::Parser......................ok (v2.41)
o YAML::XS.........................ok (v0.54)
Код: Выделить всё
$ENV{ORACLE_HOME} = '/usr/lib/oracle/11.2/client64';
$ENV{LD_LIBRARY_PATH} = '/usr/lib/oracle/11.2/client/lib';
$ENV{NLS_LANG} = 'AMERICAN_AMERICA.AL32UTF8';
# $ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
# CustomerUser (customer database backend and settings)
$Self->{CustomerUser5} = {
Name => 'ora_client',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
DSN => 'DBI:Oracle://x.x.x.x:1521/base',
User => 'yyyy',
Password => 'zzzz',
Table => 'VIEW_OTRS',
CaseSensitive => 0,
},
# customer unique id
CustomerKey => 'N_SUBJECT_ID',
# customer #
CustomerID => 'N_SUBJECT_ID',
CustomerValid => 'N_SUBJ_STATE_ID',
CustomerUserListFields => ['VC_BASE_SUBJECT_NAME','VC_SUBJ_NAME'],
CustomerUserSearchFields => ['VC_BASE_SUBJECT_NAME', 'VC_SUBJ_NAME'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['VC_TAGS'],
CustomerUserNameFields => ['VC_BASE_SUBJECT_NAME'],
CustomerUserEmailUniqCheck => 0,
ReadOnly => 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
[ 'UserTitle', 'Title', 'N_SUBJECT_ID', 1, 0, 'int', '', 0 ],
[ 'UserLogin', 'Username', 'VC_BASE_SUBJECT_NAME', 1, 1, 'varchar', '', 0 ],
[ 'UserPassword', 'Password', 'VC_SUBJ_NAME', 0, 0, 'varchar', '', 0 ],
[ 'UserEmail', 'Email', 'VC_TAGS', 1, 0, 'varchar', '', 0 ],
[ 'ValidID', 'Valid', 'N_SUBJ_STATE_ID', 0, 1, 'int', '', 0 ],
],
# default selections
Selections => {
UserTitle => {
'Mr.' => 'Mr.',
'Mrs.' => 'Mrs.',
},
},
};
Код: Выделить всё
<Directory "/opt/otrs/bin/cgi-bin/">
AllowOverride None
Options +ExecCGI -Includes
# Добавил вот эти 2 строки
PerlSetEnv LD_LIBRARY_PATH /usr/lib/oracle/11.2/client64/lib
PerlSetEnv ORACLE_HOME /usr/lib/oracle/11.2/client64
<IfModule mod_version.c>
<IfVersion < 2.4>
Order allow,deny
Allow from all
</IfVersion>
<IfVersion >= 2.4>
Require all granted
</IfVersion>
</IfModule>
<IfModule !mod_version.c>
Order allow,deny
Allow from all
</IfModule>
<IfModule mod_filter.c>
<IfModule mod_deflate.c>
AddOutputFilterByType DEFLATE text/html text/javascript application/javascript text/css text/xml application/json text/json
</IfModule>
</IfModule>
</Directory>
Код: Выделить всё
[Thu Jan 31 10:53:20.973342 2019] [:error] [pid 3722] install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC
(@INC contains:
/opt/otrs/Custom /opt/otrs/Kernel/cpan-lib /opt/otrs/ /usr/local/lib64/perl5
/usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .
/etc/httpd) at (eval 158) line 3.\nPerhaps the DBD::Oracle perl module hasn't been fully installed,
\nor perhaps the capitalisation of 'Oracle' isn't right.\nAvailable drivers: DBM, ExampleP, File,
Gofer, Pg, Proxy, SQLite, Sponge, mysql.\n at /opt/otrs//Kernel/System/DB.pm line 204.\n