Hallo Christian
Danke für die schnelle Antwort.
Meine Config.pm sieht folgendermaßen aus:
---cut---
#
CustomerUser
#
(customer user database backend and settings)
$Self->{CustomerUser} = {
Name => 'Database Backend',
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=web;host=10.20.0.35',
User => 'otrsclient',
Password => 'xxxxxxx',
Table => 'user',
},
# customer uniq id
CustomerKey => 'PID',
# customer #
CustomerID => 'LoginName',
#
CustomerValid => 'valid_id',
CustomerUserListFields => ['vorname', 'nachname',
'LoginName', 'kundennummer'],
#
CustomerUserListFields => ['LoginName', 'first_name', 'last_name',
'customer_id', 'email'],
CustomerUserSearchFields => ['LoginName', 'nachname', 'kundennummer'],
CustomerUserSearchPrefix => '*',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['LoginName'],
CustomerUserNameFields => ['anrede', 'vorname', 'nachname'],
CustomerUserEmailUniqCheck => 1,
#
AutoLoginCreation => 0,
#
AutoLoginCreationPrefix => 'auto',
#
AdminSetPreferences => 1,
#
ReadOnly => 1,
Map => [
# note: Login, Email and CustomerID needed!
# var, frontend, storage, shown, required, storage-type, http-link, readonly
[ 'UserSalutation', 'Salutation', 'anrede', 1, 0, 'var', '', 0 ],
[ 'UserFirstname', 'Firstname', 'vorname', 1, 1, 'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'nachname', 1, 1, 'var', '', 0 ],
[ 'UserLogin', 'Username', 'LoginName', 1, 1, 'var', '', 0 ],
[ 'UserPassword', 'Password', 'LoginPassword_crypted', 0, 1, 'var', '', 0 ],
[ 'UserEmail', 'Email', 'LoginName', 0, 1, 'var', '', 0 ],
#
[ 'UserEmail', 'Email', 'email', 1, 1, 'var',
'$Env{"CGIHandle"}?Action=AgentCompose&ResponseID=1&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}',
0 ],
[ 'UserCustomerID', 'CostomerID', 'kundennummer', 0, 1, 'var', '', 0 ],
#
[ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ],
#
[ 'UserComment', 'Comment', 'comments', 1, 0, 'var', '', 0 ],
#
[ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ],
#
[ 'Support_ID', 'Support_ID', 'Support_ID', 1, 1, 'var' ],
],
};
---cut---
Die entsprechende user table in der externen DB
sieht folgendermaßen aus:
---cut---
CREATE TABLE `user` (
`PID` int(11) NOT
NULL auto_increment,
`stamp` timestamp(14)
NOT NULL,
`LoginName`
varchar(200) NOT NULL default '',
`LoginPassword`
varchar(50) NOT NULL default '',
`LoginPassword_crypted` varchar(50) NOT NULL default '',
`firma` varchar(50)
default NULL,
`address1`
varchar(31) default NULL,
`address2`
varchar(31) default NULL,
`nachname`
varchar(50) default NULL,
`vorname` varchar(50)
default NULL,
`strasse` varchar(50)
default NULL,
`plz` varchar(7)
default NULL,
`ort` varchar(50) default NULL,
`telefon` varchar(15) default NULL,
`telefax` varchar(15) default NULL,
`kundennummer` varchar(15) default NULL,
`anrede` varchar(4) default NULL,
`titel`
varchar(20) default NULL,
`remarks`
varchar(255) default NULL,
`notify` varchar(50)
default NULL,
`infomail` tinyint(4)
default '0',
`flagnew` tinyint(4)
default '0',
`offline` date
default NULL,
PRIMARY KEY
(`PID`),
KEY `PID` (`PID`)
) TYPE=MyISAM AUTO_INCREMENT=38
;
---cut---
Wie gesagt, im Admin Bereich kann ich die DB suaber
auslesen und auch die Mappings stimmen.
Danke
Andre