"User questions and discussions about OTRS in German." otrs-de@otrs.org schrieb am 08.06.04 19:09:19:
On Tuesday, June 08, 2004 5:54 PM Bernhard Mainusch linuxteufel@web.de wrote:
[Tue Jun 8 17:49:26 2004] null: DBD::mysql::st execute failed: Unknown column 'sAMAccountName' in 'field list' at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 400.
Das bedeutet, dass in der DB-Quelle das Feld sAMAccountName angefordert wird. Die vorherigen Postings Deiner Config.pm geben das aber nicht her. Poste doch noch mal die CustomerUser-Quellen.
Gruß,
Robert Kehl
Da bin ich wieder.
Hier die paar Zeilen. Ich hoffe es bringt mich weiter.
$Self->{'AuthModule'} = 'Kernel::System::Auth::LDAP'; $Self->{'AuthModule::LDAP::Host'} = '172.16.2.1'; $Self->{'AuthModule::LDAP::BaseDN'} = 'dc=Franz,dc=local'; # $Self->{'AuthModule::LDAP::BaseDN'} = 'ou=Verwaltung,ou=Franz-Benutzer,dc=Franz,dc=local'; $Self->{'AuthModule::LDAP::UID'} = 'sAMAccountName'; $Self->{'AuthModule::LDAP::SearchUserDN'} = 'cn=Administrator,ou=Verwaltung,ou=Franz-Benutzer,dc=Franz,dc=local'; $Self->{'AuthModule::LDAP::SearchUserPw'} = 'password'; # $Self->{'AuthModule::LDAP::GroupDN'} = 'cn=Administrator,ou=Verwaltung,ou=Franz-Denutzer,dc=Franz,dc=local'; $Self->{'AuthModule::LDAP::AccessAttr'} = 'memberUid'; # $Self->{'AuthModule::LDAP::UserAttr'} = 'UID'; $Self->{'AuthModule::LDAP::UserAttr'} = 'DN';
$Self->{'Customer::AuthModule'} = 'Kernel::System::CustomerAuth::LDAP'; $Self->{'Customer::AuthModule::LDAP::Host'} = '172.16.2.1'; $Self->{'Customer::AuthModule::LDAP::BaseDN'} = 'dc=Franz,dc=local'; # $Self->{'Customer::AuthModule::LDAP::BaseDN'} = 'ou=Franz-Benutzer,dc=Franz,dc=local'; $Self->{'Customer::AuthModule::LDAP::UID'} = 'sAMAccountName';
# $Self->{'Customer::AuthModule::LDAP::GroupDN'} = 'cn=Administrator,ou=Verwaltung,ou=Franz-Benutzer,dc=Franz,dc=local'; # $Self->{'Customer::AuthModule::LDAP::AccessAttr'} = 'cn=Administrator,ou=Verwaltung,ou=Franz-Benutzer,dc=Franz,dc=local';
$Self->{'Customer::AuthModule::LDAP::SearchUserDN'} = 'cn=Administrator,ou=Verwaltung,ou=Franz-Benutzer,dc=Franz,dc=local'; $Self->{'Customer::AuthModule::LDAP::SearchUserPw'} = "password"; $Self->{'Customer::AuthModule::LDAP::UserAttr'} = 'DN'; $Self->{'Customer::AuthModule::LDAP::Params'} = { port => 389, version => 3, };
$Self->{UserSyncLDAPMap} = { # DB -> LDAP Firstname => 'givenName', Lastname => 'sn', Email => 'mail', };
# CustomerUser1 # (customer user database backend and settings) $Self->{CustomerUser1} = { Name => 'Datenbank', Module => 'Kernel::System::CustomerUser::DB', Params => { Table => 'customer_user', # to use an external database # DSN => 'DBI:odbc:yourdsn', # DSN => 'DBI:mysql:database=customerdb;host=customerdbhost', # User => '', Password => '', }, # customer uniq id CustomerKey => 'login', CustomerID => 'customer_id', CustomerValid => 'valid_id', CustomerUserListFields => ['first_name', 'last_name', 'email'], # CustomerUserListFields => ['login', 'first_name', 'last_name', 'customer_id', 'email'], CustomerUserSearchFields => ['login', 'last_name', 'customer_id'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 250, CustomerUserPostMasterSearchFields => ['email'], CustomerUserNameFields => ['salutation', 'first_name', 'last_name'], # ReadOnly => 1, Map => [ # note: Login, Email and CustomerID needed! # var, frontend, storage, shown, required, storage-type, http-link [ 'UserSalutation', 'Salutation', 'salutation', 1, 0, 'var' ], [ 'UserFirstname', 'Firstname', 'first_name', 1, 1, 'var' ], [ 'UserLastname', 'Lastname', 'last_name', 1, 1, 'var' ], [ 'UserLogin', 'Login', 'sAMAccountName', 1, 1, 'var' ], [ 'UserPassword', 'Password', 'pw', 0, 1, 'var' ], [ 'UserEmail', 'Email', 'email', 0, 1, 'var' ], [ 'UserCustomerID', 'CustomerID', 'customer_id', 0, 1, 'var' ], [ 'UserComment', 'Comment', 'comments', 1, 0, 'var' ], [ 'ValidID', 'Valid', 'valid_id', 0, 1, 'int' ], ], };
#customerUser #(Customer user ldap backend and settings) $Self->{CustomerUser} = { Name => 'LDAP Quelle Franz', Module => 'Kernel::System::CustomerUser::LDAP', Params => { # ldap host Host => '172.16.2.1', # ldap base dn BaseDN => 'dc=Franz,dc=local', # BaseDN => 'ou=Franz-Benutzer,dc=Franz,dc=local', # search scope (one|sub) SSCOPE => 'sub', # The following is valid but would only be necessary if the # anonymous user does NOT have permission to read from the LDAP tree UserDN => 'cn=Administrator,ou=Verwaltung,ou=Franz-Benutzer,dc=Franz,dc=local', UserPW => 'password', AlwaysFilter => '', SourceCharset => 'utf-8', DestCharset => 'iso-8859-1', }, # customer uniq id CustomerKey => 'sAMAccountName', # customer # CustomerID => 'mail', CustomerUserListFields => ['sAMAccountName', 'cn', 'mail'], CustomerUserSearchFields => ['sAMAccountName', 'cn', 'mail'], CustomerUserSearchPrefix => '', CustomerUserSearchSuffix => '*', CustomerUserSearchListLimit => 250, CustomerUserPostMasterSearchFields => ['mail'], CustomerUserNameFields => ['givenname', 'sn'], Map => [ # note: Login, Email and CustomerID needed! # var, frontend, storage, shown, required, storage-type # [ 'UserSalutation', 'Title', 'title', 1, 0, 'var' ], [ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var' ], [ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var' ], [ 'UserLogin', 'Login', 'sAMAccountName', 1, 1, 'var' ], [ 'UserEmail', 'Email', 'mail', 1, 1, 'var' ], [ 'UserCustomerID', 'CustomerID', 'mail', 0, 1, 'var' ], # [ 'UserPhone', 'Phone', 'telephonenumber', 1, 0, 'var' ], # [ 'UserAddress', 'Address', 'postaladdress', 1, 0, 'var' ], # [ 'UserComment', 'Comment', 'description', 1, 0, 'var' ], # [ 'Userorganisation', 'Organisation', 'ou', 1, 0, 'var' ] ], };
Gruß auch von mir! _______________________________________________________________________ Moechten Sie Ihre SMS noch ausdrucksstaerker und emotionaler gestalten? Fuegen Sie einfach ein Bild hinzu! http://freemail.web.de/?mc=021194