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