gibt es hier jemenden, der bereits einen MSSQL erfolgreich als (zusätzliches) Kunden-Backend einsetzt?
Ich kämpfe schon einige Zeit damit, allerdings bis jetzt erfolglos.
Sobald ich die (u.a.) Config in die Config.pm einfüge, geht gar nicht mehr...
Config: OTRS 3.3 auf Debian, Native SQL Client, ODBC Verbindung
Code: Select all
# CustomerUser2 (customer database backend and settings)
$Self->{CustomerUser2} = {
Name => 'crmdb',
Module => 'Kernel::System::CustomerUser2::DB',
Params => {
DSN => 'DBI:ODBC:driver=SQL Server Native Client 11.0;server=192.168.200.34;database=crmdb;uid=otrs;pwd=pwd;,
User => 'otrs',
Password => 'pwd',
Table => 'dbo.ADRESSEN',
SourceCharset => 'iso-8859-1',
DestCharset => 'utf-8',
CaseSensitive => 0,
},
CustomerKey => 'ADRESSEN_KEY',
CustomerID => 'ADRESSEN_KEY',
CustomerUserListFields => ['ADRESSEN_NAM1'],
CustomerUserSearchFields => ['ADRESSEN_KEY', 'ADRESSEN_NAM1'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit =>500,
CustomerUserPostMasterSearchFields => ['ADRESSEN_KEY'],
CustomerUserNameFields => ['ADRESSEN_NAM1'],
CustomerUserEmailUniqCheck => 0,
AutoLoginCreation => 1,
AdminSetPreferences => 1,
CacheTTL => 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
[ 'UserLogin', 'Username', 'ADRESSEN_NAM1', 1, 1, 'var', '', 0 ],
[ 'UserPassword', 'Password', 'ADRESSEN_KEY', 1, 0, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'ADRESSEN_EMAIL', 2, 0, 'var', '',0],
[ 'UserCustomerID', 'CustomerID', 'ADRESSEN_KEY', 1, 1, 'var', '', 0 ],
],
# default selections
Selections => {
UserSalutation => {
'1' => 'Herr',
'2' => 'Frau',
},
},
};
