Ich habe nun die Config so eingestellt, dass nur die externe DB genutzt wird.
Aber dennoch sind nicht alle Tickets da - ganz im Gegenteil.
Im OTRS Kundenportal sehe ich meine eigenen (2) und unter Firmentickets (600+) alle Ticket der Benutzer über die verlinkten Kundennummer.
Über die Webabfrage sehe nur meine zwei Tickets welche einem anderen User gehören unter der gleichen Kundennummer.
Frage am Rand - schaut sich das OTRS Kundenportal irgendwie die Domain in der Mailadresse an?
#########################
#########################
# CustomerUser (customer database backend and settings)
$Self->{CustomerUser} = {
Name => 'extDB',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
DSN => 'DBI:mysql:database=xxx;host=xxx',
User => 'xxx',
Password => 'xxx',
Table => 'com_users_view',
SourceCharset => 'iso-8859-1',
DestCharset => 'utf-8',
CaseSensitive => 0,
ForeignDB => 1, # <-- THIS IS IMPORTANT WHEN YOU USE EXTERNAL DB WITHOUT create_$
},
#customer unique id
CustomerKey => 'uemail',
# customer #
CustomerID => 'partner_number',
CustomerValid => 'valid_id',
CustomerUserListFields => ['ufirstname', 'ulastname', 'uemail'],
CustomerUserSearchFields => ['ufirstname', 'ulastname', 'partner_number', 'uemail'],
CustomerUserSearchPrefix => '*',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['uemail'],
CustomerUserNameFields => ['ufirstname','ulastname'],
CustomerUserEmailUniqCheck => 1,
# # show not own tickets in customer panel, CompanyTickets
CustomerUserExcludePrimaryCustomerID => 0,
# # generate auto uemails
# AutouemailCreation => 0,
# AutouemailCreationPrefix => '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: uemail, uemail and CustomerID needed!
# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link$
# [ 'create_time', 'Created', 'activation_date', 2, 0, 'var', '', 0],
[ 'UserTitle', 'Title', 'ugender', 1, 0, 'var', '', 0 ],
[ 'UserFirstname', 'Firstname', 'ufirstname', 1, 1, 'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'ulastname', 1, 1, 'var', '', 0 ],
[ 'UserLogin', 'Username', 'uemail', 1, 1, 'var', '', 0 ],
[ 'UserPassword', 'Password', 'upass', 0, 0, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'uemail', 1, 1, 'var', '', 0 ],
# [ 'Useruemail', 'uemail', 'uemail', 1, 1, 'var', '$Env{"CGIHandle"}?$
[ 'UserCustomerID', 'CustomerID', 'partner_number', 0, 1, 'var', '', 0 ],
# [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],
# [ 'UserPhone', 'Phone', 'uphone', 1, 0, 'var', '', 0 ],
# [ 'UserFax', 'Fax', 'fax', 1, 0, 'var', '', 0 ],
# [ 'UserMobile', 'Mobile', 'mobile', 1, 0, 'var', '', 0 ],
# [ 'UserStreet', 'Street', 'ucompany_street', 1, 0, 'var', '', 0 ],
# [ 'UserZip', 'Zip', 'ucompany_zip', 1, 0, 'var', '', 0 ],
# [ 'UserCity', 'City', 'ucompany_city', 1, 0, 'var', '', 0 ],
# [ 'UserCountry', 'Country', 'user_cntr', 1, 0, 'var', '', 0 ],
# [ 'UserComment', 'Comment', 'comments', 1, 0, 'var', '', 0 ],
[ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ],
],
# default selections
Selections => {
UserTitle => {
'male' => 'Mr.',
'female' => 'Mrs.',
},
},
};
########### (customer user database backend and settings)
$Self->{CustomerCompany} = {
Name => 'Kunden',
Module => 'Kernel::System::CustomerCompany::DB',
Params => {
# if you want to use an external database, add the
# required settings
DSN => 'DBI:mysql:database=xxx;host=xxx',
User => 'xxx',
Password => 'xxx',
Table => 'com_users_company',
SourceCharset => 'iso-8859-1',
DestCharset => 'utf-8',
CaseSensitive => 0,
ForeignDB => 1,
},
###### company unique id
CustomerCompanyKey => 'partner_number',
CustomerCompanyValid => 'CustValid',
CustomerCompanyListFields => [ 'partner_number', 'cname' ],
CustomerCompanySearchFields => ['partner_number', 'cname'],
CustomerCompanySearchPrefix => '*',
CustomerCompanySearchSuffix => '*',
CustomerCompanySearchListLimit => 250,
CacheTTL => 0, # 60 * 60 * 24, # use 0 to turn off cache
#ReadOnly => 1,
Map => [
# var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly
[ 'CustomerID', 'CustomerID', 'partner_number', 0, 1, 'var', '', 0 ],
[ 'CustomerCompanyName', 'Company', 'cname', 1, 1, 'var', '', 0 ],
# [ 'CustomerCompanyStreet', 'Street', 'ucompany_street', 1, 0, 'var', '', 0 ],
# [ 'CustomerCompanyZIP', 'Zip', 'ucompany_zip', 1, 0, 'var', '', 0 ],
# [ 'CustomerCompanyCity', 'City', 'ucompany_city', 1, 0, 'var', '', 0 ],
# [ 'CustomerCompanyCountry', 'Country', 'country', 1, 0, 'var', '', 0 ],
# [ 'CustomerCompanyURL', 'URL', 'url', 1, 0, 'var', '$Data{"CustomerCompanyURL"}', 0 ],
# [ 'CustomerCompanyComment', 'Comment', 'comments', 1, 0, 'var', '', 0 ],
# [ 'ValidID', 'Valid', 'CustValid', 0, 1, 'int', '', 0 ],
],
};