derzeit stehe ich irgendwie auf dem Schlauch.
(CentOS7, OTRS 4.0.4)
Ich habe in meiner Config.pm die ganz normalen Datenbank-Settings drin. Zusätzlich noch ein Backend aus dem Windows-AD für User und Agents.
Jetzt würde ich gerne ein zweites Kundenbackend anlegen mit Usern, die in einer externen MySQL-DB liegen.
Ich habe in meine Config.pm folgenden Code eingbaut:
Code: Select all
$Self->{CustomerUser5} = {
Name => 'Mitarbeiter ohne AD-Konto',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
# if you want to use an external database, add the
# required settings
DSN => 'DBI:odbc:yourdsn',
DSN => 'DBI:mysql:database=personal_noad;host=localhost',
User => 'personal_noad',
Password => '12345678',
Table => 'personal_noad',
},
# customer unique id
CustomerKey = 'login',
# customer #
CustomerID = 'customer_id',
CustomerValid = 'valid_id',
CustomerUserListFields => ['first_name', 'last_name', 'email'],
CustomerUserSearchFields => ['login', 'last_name', 'customer_id'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['title','first_name','last_name'],
CustomerUserEmailUniqCheck => 1,
# # show not own tickets in customer panel, CompanyTickets
# CustomerUserExcludePrimaryCustomerID => 0,
# # generate auto logins
# AutoLoginCreation => 0,
# AutoLoginCreationPrefix => 'auto',
# # admin can change customer preferences
# AdminSetPreferences => 1,
# # cache time to live in sec. - cache any database queries
# CacheTTL => 0,
# # just a read only source
# 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', 'Status', 1, 0, 'var', '', 0 ],
[ 'UserFirstname', 'Firstname', 'Vorname', 1, 1, 'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'Name', 1, 1, 'var', '', 0 ],
[ 'UserLogin', 'Username', 'Anzeigename', 1, 1, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'E_Mail', 1, 1, 'var', '', 0 ],
[ 'UserCustomerID', 'CustomerID', 'PNR', 0, 1, 'var', '', 0 ],
[ 'UserMobile', 'Mobile', 'Handynummer', 1, 0, 'var', '', 0 ],
],
};
Kann es sein, dass es daran liegt, dass die Mitarbeiter alle die selbe E-Mail-Adresse (dummy@localhost) haben?