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 tbale 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
_______________________________________________
OTRS Mailingliste: otrs-de - Webpage: http://otrs.org/
Archiv: http://lists.otrs.org/pipermail/otrs-de/
Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/
Support oder Consulting fuer Ihr OTRS System?
=> http://www.otrs.de/
