ich weiss für einige ist es ein leidiges Thema,
ich aber laufe bald die Wand hoch
Es geht um die OTRS Anbindung an das Active Directory.
Ich möchte unsere AD User als Kunden
und die Admins als Supporter einbinden.
Nun habe ich folgendes Problem.
Sobald ich die rcotrs restart ausführe, folgt dieser Fehlerstring:
Shutting down OTRS
Disable /opt/otrs/bin/PostMaster.pl ... done.
no crontab for otrs
Shutting down cronjobs ... failed!
Starting OTRS
Checking Apache ... done.
Checking MySQL ... done.
Checking database connect... (DBI connect('database=otrs;host=localhost;','otrs',...) failed: Access denied for user 'otrs'@'localhost' (using password: YES) at /opt/otrs/Kernel/System/DB.pm line 197
ERROR: OTRS-CheckDB-10 Perl: 5.8.8 OS: linux Time: Fri Nov 30 00:56:58 2007
Message: Access denied for user 'otrs'@'localhost' (using password: YES)
Traceback (19444):
Module: Kernel::System::DB::new (v1.75) Line: 174
Module: /opt/otrs/bin/CheckDB.pl (v1.17) Line: 49
No database connect!)
----------------------------------------------------------------------------
Error: Maybe your database isn't configured yet?
----------------------------------------------------------------------------
Try the web installer to configure your database:
-->> http://vmsuse.tiptop.local/otrs/installer.pl <<--
----------------------------------------------------------------------------
or configure your database with README.database (DB - Setup Example)
----------------------------------------------------------------------------
failed
Mein Config.pm sieht wie folgt aus:
Code: Select all
# ---------------------------------------------------- #
#Ldap Authentifizierung gegen AD
package Kernel::Config;
sub Load {
$Self->{'AuthModule'} = 'Kernel::System::Auth::LDAP';
$Self->{'AuthModule::LDAP::Host'} = 'pmdc001.domain.local';
$Self->{'AuthModule::LDAP::BaseDN'} = 'DC=domain,DC=local';
$Self->{'AuthModule::LDAP::UID'} = 'sAMAccountName';
$Self->{'AuthModule::LDAP::SearchUserDN'} = 'cn=administrator, ou=Administrators and Operators, ou=Infrastructure Objects, dc=domain, dc=local';
$Self->{'AuthModule::LDAP::SearchUserPw'} = 'Kennwort';
# Kundenauthentifizierung
$Self->{'Customer::AuthModule'} = 'Kernel::System::CustomerAuth::LDAP';
$Self->{'Customer::AuthModule::LDAP::Host'} = 'pmdc001.domain.local';
$Self->{'Customer::AuthModule::LDAP::BaseDN'} = 'ou=users, ou=1001, ou=AHP Companies, dc=domain ,dc=local';
$Self->{'Customer::AuthModule::LDAP::UID'} = 'sAMAccountName';
#$Self->{'AuthModule::LDAP::SearchUserDN'} = 'cn=administrator, ou=Administrators and Operators, ou=Infrastructure Objects, dc=domain, dc=local';
#$Self->{'AuthModule::LDAP::SearchUserPw'} = 'Kennwort';
# Datenbank
# CustomerUser
# (customer user database backend and settings)
$Self->{CustomerUser} = {
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', 'login', 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 1
# (customer user ldap backend and settings)
$Self->{CustomerUser1} = {
Name => 'FIRMA-LDAP',
Module => 'Kernel::System::CustomerUser::LDAP',
Params => {
# ldap host
Host => 'pmdc001.domain.local',
# ldap base dn
BaseDN => 'ou=users, ou=1001, ou=AHP Companies, dc=domain ,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=Administrators and Operators, ou=Infrastructure Objects, dc=domain, dc=local',
UserPw => 'Kennwort',
AlwaysFilter => '',
SourceCharset => 'utf-8',
DestCharset => 'iso-8859-1',
},
# customer uniq id
CustomerKey => 'sAMAccountName',
# customer #
CustomerID => 'mail',
#mail muss am ende stehen
#CustomerUserListFields => ['cn','sAMAccountName', 'description', 'department'],
CustomerUserListFields => ['cn','sAMAccountName','description','mail'],
CustomerUserSearchFields => ['cn', 'sAMAccountName', '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' ],
],
};
}
# ---------------------------------------------------- #
# needed system stuff (don't edit this) #
# ---------------------------------------------------- #
use strict;
use vars qw(@ISA $VERSION);
use Kernel::Config::Defaults;
push (@ISA, 'Kernel::Config::Defaults');
$VERSION = '$Revision: 1.18 $';
$VERSION =~ s/^\$.*:\W(.*)\W.+?$/$1/;
# -----------------------------------------------------#
1;
Was mach ich falsch?
Vielen vielen Dank im Voraus