I'm trying to add to OTRS 5 customer database located on a MS SQL Sever.
Should I install additional modules or ODBC Driver?
I checked modules by command: ./otrs.CheckModules.pl. Module DBD::ODBC is installed, is that enough?
Code: Select all
o Apache::DBI......................ok (v1.12)
o Apache2::Reload..................ok (v0.13)
o Archive::Tar.....................ok (v1.90)
o Archive::Zip.....................ok (v1.30)
o Crypt::Eksblowfish::Bcrypt.......ok (v0.009)
o Crypt::SSLeay....................ok (v0.58)
o Date::Format.....................ok (v2.24)
o DBI..............................ok (v1.630)
o DBD::mysql.......................ok (v4.025)
o DBD::ODBC........................ok (v1.45)
o DBD::Oracle......................Not installed! (optional - Required to connect to a Oracle database.)
o DBD::Pg..........................Not installed! Use: 'apt-get install -y libdbd-pg-perl' (optional - Required to connect to a PostgreSQL database.)
o Encode::HanExtra.................ok (v0.23)
o IO::Socket::SSL..................ok (v1.965)
o JSON::XS.........................ok (v2.34)
o List::Util::XS...................ok (v1.27)
o LWP::UserAgent...................ok (v6.13)
o Mail::IMAPClient.................ok (v3.35)
o IO::Socket::SSL................ok (v1.965)
o ModPerl::Util....................ok (v2.000008)
o Net::DNS.........................ok (v0.68)
o Net::LDAP........................ok (v0.58)
o Template.........................ok (v2.24)
o Template::Stash::XS..............ok (undef)
o Text::CSV_XS.....................ok (v1.02)
o Time::HiRes......................ok (v1.9725)
o Time::Piece......................ok (v1.20_01)
o XML::LibXML......................ok (v2.0108)
o XML::LibXSLT.....................ok (v1.84)
o XML::Parser......................ok (v2.41)
o YAML::XS.........................ok (v0.41)
How to configure parameters to connect with ODBC.
I got the following data to the database connection:
This is a separate instance of the database with a prepared view:
SRV-002\PROFT
Server name/hostname: SRV-002
IP 192.168.1.10
User: otrs
Pass: start****
Code: Select all
$Self->{CustomerUser} = {
Name => 'Database Backend',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
# if you want to use an external database, add the
# required settings
# DSN => 'DBI:odbc:yourdsn',
# Type => 'mssql', # only for ODBC connections
# DSN => 'DBI:mysql:database=customerdb;host=customerdbhost',
# User => '',
# Password => '',
Table => 'customer_user',
# ForeignDB => 0, # set this to 1 if your table does not have create_time, create_by, change_time and change_by fields
# CaseSensitive will control if the SQL statements need LOWER()
# function calls to work case insensitively. Setting this to
# 1 will improve performance dramatically on large databases.
CaseSensitive => 0,
},
I'm a beginner with otrs. I will be grateful for your help