Hallo Boris, hast du es wie hier gemacht? http://doc.otrs.org/3.1/de/html/auth-backends.html Wenn du weiter runter scrollst wird ein bespiel gemacht wie man die Tabelle z.b. um die Spalte Raumnummer anpasst. Evtl. findest du einen kleinen Fehler bei dir wenn du dir das vergleichst.
Ansonsten würde ich noch die skripte otrs/bin/otrs.LoaderCache.pl -o delete mal ausführen und otrs.DeleteCache ... Bei mir gingen manche Sachen nicht wenn ich noch den alten CSS Cache hatte. Otrs.RebuildConfig.pl wäre auch ne Möglichkeit... ( diese würde ich aber als letztes probieren ). Gruß Alex Von: otrs-de-boun...@otrs.org [mailto:otrs-de-boun...@otrs.org] Im Auftrag von Boris Wagener Gesendet: Donnerstag, 26. April 2012 10:22 An: User questions and discussions about OTRS.org in German Betreff: [otrs-de] Kundendaten aus lokaler DB/ zusätzliche Felder Hi, ich habe in meiner customer_user Tabelle zusätzliche Felder hinzugefügt. Die werden mit sync_ldap2db befüllt. Das klappt auch soweit. Die Kunden Authentifizieren sich gegen LDAP aber die Daten wollen wir aus der lokalen DB holen. So sieht die Config.pm aus: #-------------------------------------------------------------------------------------------- # firma # #-------------------------------------------------------------------------------------------- #-------------------------------------------------------------------------------------------- # Agenten Authentifizeirung # #-------------------------------------------------------------------------------------------- $Self->{'AuthModule1'} = 'Kernel::System::Auth::LDAP'; $Self->{'AuthModule::LDAP::Host1'} = 'dc.firma.local'; $Self->{'AuthModule::LDAP::BaseDN1'} = 'dc=firma,dc=local'; $Self->{'AuthModule::LDAP::UID1'} = 'sAMAccountName'; $Self->{'AuthModule::LDAP::SearchUserDN1'} = 'otrsldap@firma.local'; $Self->{'AuthModule::LDAP::SearchUserPw1'} = 'Passwort123'; #-------------------------------------------------------------------------------------------- # Kunden Authentifizeirung # #-------------------------------------------------------------------------------------------- $Self->{'Customer::AuthModule1'} = 'Kernel::System::CustomerAuth::LDAP'; $Self->{'Customer::AuthModule::LDAP::Host1'} = 'dc.firma.local'; $Self->{'Customer::AuthModule::LDAP::BaseDN1'} = 'DC=firma, DC=local'; $Self->{'Customer::AuthModule::LDAP::UID1'} = 'sAMAccountName'; $Self->{'Customer::AuthModule::LDAP::SearchUserDN1'} = 'otrsldap@firma.local'; $Self->{'Customer::AuthModule::LDAP::SearchUserPw1'} = 'Passwort123'; #-------------------------------------------------------------------------------------------- # Kundendaten # #-------------------------------------------------------------------------------------------- #-------------------------------------------------------------------------------------------- # CustomerUser (customer database backend and settings) $Self->{CustomerUser1} = { Name => 'Database Datasource', 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=customerdb;host=customerdbhost', # User => '', # Password => '', Table => 'customer_user', # if your frontend is unicode and the charset of your # customer database server is iso-8859-1, use these options. # SourceCharset => 'iso-8859-1', # DestCharset => 'utf-8', # CaseSensitive will control if the SQL statements need LOWER() # function calls to work case insensitively. Setting this to # 1 will improve performance dramatically on large databases. CaseSensitive => 0, }, # customer unique id CustomerKey => 'login', # customer # CustomerID => 'customer_id', CustomerValid => 'valid_id', CustomerUserListFields => ['first_name', 'last_name', 'email'], CustomerUserSearchFields => ['login', 'last_name', 'customer_id'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 500, CustomerUserPostMasterSearchFields => ['email'], CustomerUserNameFields => ['title','first_name','last_name'], CustomerUserEmailUniqCheck => 1, # # show not own tickets in customer panel, CompanyTickets # CustomerUserExcludePrimaryCustomerID => 0, # # generate auto logins # AutoLoginCreation => 0, # AutoLoginCreationPrefix => '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: Login, Email and CustomerID needed! # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly, http-link-target [ 'UserTitle', 'Title', 'title', 1, 0, 'var', '', 0 ], [ 'UserFirstname', 'Firstname', 'first_name', 1, 1, 'var', '', 0 ], [ 'UserLastname', 'Lastname', 'last_name', 1, 1, 'var', '', 0 ], [ 'UserLogin', 'Username', 'login', 1, 1, 'var', '', 0 ], [ 'UserPassword', 'Password', 'pw', 0, 0, 'var', '', 0 ], [ 'UserEmail', 'Email', 'email', 1, 1, 'var', '', 0 ], [ 'Firma', 'firma', 'company', 1, 0, 'var', '', 0], [ 'Abteilung', 'abteilung', 'department', 1, 0, 'var', '', 0 ], [ 'Vorgesetzter', 'vorgesetzter','manager', 1, 0, 'var', '', 0 ], [ 'Buero', 'buero', 'physicalDeliveryOfficeName', 1, 0, 'var', '', 0 ], # [ 'UserEmail', 'Email', 'email', 1, 1, 'var', '$Env{"CGIHandle"}?Action=AgentTicketCompose&ResponseID=1&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}', 0 ], [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var', '', 0 ], # [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ], [ 'UserPhone', 'Phone', 'phone', 1, 0, 'var', '', 0 ], [ 'UserFax', 'Fax', 'fax', 1, 0, 'var', '', 0 ], [ 'UserMobile', 'Mobile', 'mobile', 1, 0, 'var', '', 0 ], [ 'UserStreet', 'Street', 'street', 1, 0, 'var', '', 0 ], [ 'UserZip', 'Zip', 'zip', 1, 0, 'var', '', 0 ], [ 'UserCity', 'City', 'city', 1, 0, 'var', '', 0 ], [ 'UserCountry', 'Country', 'country', 1, 0, 'var', '', 0 ], [ 'UserComment', 'Comment', 'comments', 1, 0, 'var', '', 0 ], [ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int', '', 0 ], ], }; #-------------------------------------------------------------------------------------------- # firma Ende # #-------------------------------------------------------------------------------------------- Authetifizierung geht. Aber die Daten (die zusätzlichen Felder) werden beim Kunden nicht angezeigt. Kann mir jemand sagen woran das liegt? Boris Besuchen Sie unsere Website: www.sidion.de Rechtliche Angaben: USt-Id: DE 147755321 . Unternehmenssitz: Nöllenstraße 42 . 70195 Stuttgart . Inhaber . Geschäftsführer: René Sutorius
--------------------------------------------------------------------- OTRS mailing list: otrs-de - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs-de To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs-de
