ich benötige dringend eure Hilfe,
Ich versuche gerade ein zweites Backend anzubinden, mein System ist OTRS 3.0.0 mysql zweites Backend ist MSSQL.
ODBC ist eingerichtet und getestet.
meine Config.pm ist angepasst
Code: Select all
$Self->{"Database::Type"} = "mssql";
$Self->{CustomerUser} = {
Name => 'vpn',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
DSN => 'DBI:ODBC:CENTRON,
User => 'bbo',
Password => '1',
Table => 'vpn',
},
customer uniq id
CustomerKey => 'UserID',
CustomerID => 'Account_Id',
CustomerValid => 'valid_id',
CustomerUserListFields => ['first_name', 'last_name', 'email'],
CustomerUserSearchFields => ['login', 'last_name', 'customer_id'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['salutation','first_name','last_name'],
CustomerUserEmailUniqCheck => 1,
ReadOnly => 1,
Map => [
[ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var', '', 0 ],
[ 'UserFirstname', 'Firstname', 'First_Name', 1, 1, 'var', '', 0 ],
[ 'UserLastname','Lastname','Last_Name', 1, 1, 'var', '', 0 ],
[ 'UserLogin','Username','UserID',1, 1, 'var', '', 0 ],
[ 'UserPassword','Password','Password',0, 0, 'var', '', 0 ],
[ 'UserEmail','Email','EMail',1, 1, 'var', '', 0 ],
[ 'UserCustomerID', 'CustomerID', 'AccountID', 0, 1, 'var', '', 0 ],
],
Selections => {
UserSalutation => {
'Mr.' => 'Mr.',
'Mrs.' => 'Mrs.',
},
},
};Unknown database type! Set option Database::Type in Kernel/Config.pm to (mysql|postgresql|oracle|db2|mssql).
hat einer Idee wodran es liegen kann.