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 ],
],
};
bei manchen kommt dass der user kein zugriff hat, obwohl der user in beiden DBs vorhanden ist. Kann es vllt sein, dass die tickets immer fest einem von beiden UserDBs zugeordnet wird? und wenn das Ticket bspw. Max Mustermann in der OTRS DB gehört kann ich es mit dem Max Mustermann aus der extl. SQL nicht abfragen?