Karsten Heymann schrieb:
Bist Du sicher, dass Du die richtige DB.pm geändert hast? Es gibt im OTRS-Baum mehrere Dateien dieses Namens.
Unten nochmal der Diff mit den umgebenden Zeilen:
--- DB.pm~ 2007-07-26 16:13:33.000000000 +0200 +++ DB.pm 2007-08-15 10:36:17.000000000 +0200 @@ -68,6 +68,7 @@ if ($Self->{CustomerUserMap}->{Params}->{DSN}) { $Self->{DBObject} = Kernel::System::DB->new( LogObject => $Param{LogObject}, + MainObject => $Param{MainObject}, ConfigObject => $Param{ConfigObject}, DatabaseDSN => $Self->{CustomerUserMap}->{Params}->{DSN}, DatabaseUser => $Self->{CustomerUserMap}->{Params}->{User},
Ich hatte schon die richtige Datei, nur ist es in OTRS 2.2.1 ein paar Zeilen höher. ;-) Die Fehlermeldung ist jetzt weg, nur leider werden die Kunden irgendwie nicht richtig angezeigt. Es werden lediglich leere Zeilen angezeigt. Die Tabelle `account` hat folgende Struktur: --- snip --- id bigint(20) UNSIGNED customer_id bigint(20) UNSIGNED pass varchar(255) utf8_general_ci title varchar(255) utf8_general_ci firstname varchar(255) utf8_general_ci surname varchar(255) utf8_general_ci birthday date fon varchar(255) utf8_general_ci fax varchar(255) utf8_general_ci email varchar(255) utf8_general_ci language_id varchar(2) utf8_general_ci time_zone_id int(10) UNSIGNED state_id tinyint(3) UNSIGNED create_date datetime last_update timestamp --- snap --- In OTRS habe ich diese folgendermaßen eingebunden: --- snip --- $Self->{CustomerUser1} = { Name => 'Kunden', Module => 'Kernel::System::CustomerUser::DB', Params => { DSN => 'DBI:mysql:database=cdb;host=localhost', User => 'otrs', Password => 'lsjgf45nf44ef443rffde4', Table => 'account', }, # customer uniq id CustomerKey => 'id', # customer # CustomerID => 'id', CustomerValid => 'state_id', CustomerUserListFields => ['firstname', 'surname', 'email'], CustomerUserSearchFields => ['id', 'surname', 'id'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 250, CustomerUserPostMasterSearchFields => ['email'], CustomerUserNameFields => ['title','firstname','surname'], CustomerUserEmailUniqCheck => 1, # # show now own tickets in customer panel, CompanyTickets # CustomerUserExcludePrimaryCustomerID => 0, # # generate auto logins # AutoLoginCreation => 0, # AutoLoginCreationPrefix => 'auto', # admin can change customer preferences AdminSetPreferences => 0, # just a read only source ReadOnly => 1, Map => [ # note: Login, Email and CustomerID needed! # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly [ 'UserSalutation', 'Salutation', 'title', 1, 0, 'var', '', 1 ], [ 'UserFirstname', 'Firstname', 'firstname', 1, 1, 'var', '', 1 ], [ 'UserLastname', 'Lastname', 'surname', 1, 1, 'var', '', 1 ], [ 'UserLogin', 'Username', 'id', 1, 1, 'var', '', 1 ], [ 'UserPassword', 'Password', 'pass', 0, 1, 'var', '', 1 ], [ 'UserEmail', 'Email', 'email', 0, 1, 'var', '', 1 ], [ 'UserCustomerID', 'CustomerID', 'id', 0, 1, 'var', '', 1 ], [ 'UserComment', 'Comment', 'info', 1, 0, 'var', '', 1 ], [ 'ValidID', 'Valid', 'state_id', 0, 1, 'int', '', 1 ], ], # default selections Selections => { UserSalutation => { 'Mr.' => 'Herr', 'Mrs.' => 'Frau', }, }, }; --- snap --- Gibt es eine Möglichkeit zu debugen, was da schief läuft? Viele Grüße Bastian