
As requested. [root@customers Kernel]# cat Config.pm # -- # Kernel/Config.pm - Config file for OTRS kernel # Copyright (C) 2001-2009 OTRS AG, http://otrs.org/ # -- # $Id: Config.pm.dist,v 1.21 2009/02/16 12:01:43 tr Exp $ # -- # This software comes with ABSOLUTELY NO WARRANTY. For details, see # the enclosed file COPYING for license information (AGPL). If you # did not receive this file, see http://www.gnu.org/licenses/agpl.txt. # -- # Note: # # -->> OTRS does have a lot of config settings. For more settings # (Notifications, Ticket::ViewAccelerator, Ticket::NumberGenerator, # LDAP, PostMaster, Session, Preferences, ...) see # Kernel/Config/Defaults.pm and copy your wanted lines into "this" # config file. This file will not be changed on update! # # -- package Kernel::Config; sub Load { my $Self = shift; # ---------------------------------------------------- # # ---------------------------------------------------- # # # # Start of your own config options!!! # # # # ---------------------------------------------------- # # ---------------------------------------------------- # # ---------------------------------------------------- # # database settings # # ---------------------------------------------------- # # DatabaseHost # (The database host.) $Self->{'DatabaseHost'} = 'localhost'; # Database # (The database name.) $Self->{'Database'} = 'otrs'; # DatabaseUser # (The database user.) $Self->{'DatabaseUser'} = 'otrs'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{'DatabasePw'} = 'SOMEPASSWORD'; # DatabaseDSN # (The database DSN for MySQL ==> more: "man DBD::mysql") $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; # (The database DSN for PostgreSQL ==> more: "man DBD::Pg") # if you want to use a local socket connection # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; # if you want to use a tcpip connection # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};"; # ---------------------------------------------------- # # fs root directory # ---------------------------------------------------- # $Self->{Home} = '/opt/otrs'; # ---------------------------------------------------- # # insert your own config settings "here" # # config settings taken from Kernel/Config/Defaults.pm # # ---------------------------------------------------- # # $Self->{SessionUseCookie} = 0; # $Self->{'CheckMXRecord'} = 1; # $Self->{'AuthModule'} = 'Kernel::System::Auth::LDAP'; # $Self->{'AuthModule::LDAP::Host'} = 'fileserver01.technogymusa.com'; # $Self->{'AuthModule::LDAP::BaseDN'} = 'DC=technogymusa,DC=com'; # $Self->{'AuthModule::LDAP::UID'} = 'sAMAccountName'; # $Self->{'AuthModule::LDAP::SearchUserDN'} = 'CN=Linux Users,CN=Users,DC=technogymusa,DC=com'; # $Self->{'AuthModule::LDAP::SearchUserPw'} = 'SOMEPASSWORD'; ## Admin Auth $Self->{'AuthModule'} = 'Kernel::System::Auth::LDAP'; $Self->{'AuthModule::LDAP::Host'} = 'fileserver01.technogymusa.com'; $Self->{'AuthModule::LDAP::BaseDN'} = 'DC=technogymusa,DC=com'; $Self->{'AuthModule::LDAP::UID'} = 'sAMAccountName'; $Self->{'AuthModule::LDAP::SearchUserDN'} = 'CN=Linux Users,CN=Users,DC=technogymusa,DC=com'; $Self->{'AuthModule::LDAP::SearchUserPw'} = 'SOMEPASSWORD'; ## User Auth $Self->{'Customer::AuthModule'} = 'Kernel::System::CustomerAuth::LDAP'; $Self->{'Customer::AuthModule::LDAP::Host'} = 'fileserver01.technogymusa.com'; $Self->{'Customer::AuthModule::LDAP::BaseDN'} = 'DC=technogymusa,DC=com'; $Self->{'Customer::AuthModule::LDAP::UID'} = 'sAMAccountName'; $Self->{'Customer::AuthModule::LDAP::SearchUserDN'} = 'CN=Linux Users,CN=Users,DC=technogymusa,DC=com'; $Self->{'Customer::AuthModule::LDAP::SearchUserPw'} = 'SOMEPASSWORD'; $Self->{CustomerUser} = { Module => 'Kernel::System::CustomerUser::LDAP', Params => { Host => 'fileserver01.technogymusa.com', BaseDN => 'DC=technogymusa,DC=com', SSCOPE => 'sub', UserDN => 'CN=Linux Users,CN=Users,DC=technogymusa,DC=com', UserPw => 'SOMEPASSWORD', }, CustomerKey => 'sAMAccountName', CustomerID => '[customer_id]', CustomerUserListFields => ['sAMAccountName', 'cn', 'mail'], CustomerUserSearchFields => ['sAMAccountName', 'cn', 'mail'], 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' ], ], }; # agent data sync against ldap $Self->{'AuthSyncModule'} = 'Kernel::System::Auth::Sync::LDAP'; $Self->{'AuthSyncModule::LDAP::Host'} = 'ldap://fileserver01.technogymusa.com/'; $Self->{'AuthSyncModule::LDAP::BaseDN'} = 'DC=technogymusa,DC=com'; $Self->{'AuthSyncModule::LDAP::UID'} = 'sAMAccountName'; $Self->{'AuthSyncModule::LDAP::SearchUserDN'} = 'CN=Linux Users,CN=Users,DC=technogymusa,DC=com'; $Self->{'AuthSyncModule::LDAP::SearchUserPw'} = 'SOMEPASSWORD'; $Self->{'AuthSyncModule::LDAP::UserSyncMap'} = { # DB -> LDAP UserFirstname => 'givenName', UserLastname => 'sn', UserEmail => 'mail', }; $Self->{'AuthSyncModule::LDAP::UserSyncInitialGroups'} = [ 'users', ]; # ---------------------------------------------------- # # ---------------------------------------------------- # # data inserted by installer # # ---------------------------------------------------- # # $DIBI$ $Self->{'SystemID'} = 11; $Self->{'SecureMode'} = 1; $Self->{'Organization'} = 'Technogym USA'; $Self->{'LogModule::LogFile'} = '/tmp/otrs.log'; $Self->{'LogModule'} = 'Kernel::System::Log::SysLog'; $Self->{'FQDN'} = 'customers.technogymusa.com'; $Self->{'DefaultLanguage'} = 'en'; $Self->{'AdminEmail'} = 'it@technogymusa.com'; $Self->{'DefaultCharset'} = 'utf-8'; # ---------------------------------------------------- # # ---------------------------------------------------- # # # # End of your own config options!!! # # # # ---------------------------------------------------- # # ---------------------------------------------------- # } # ---------------------------------------------------- # # needed system stuff (don't edit this) # # ---------------------------------------------------- # use strict; use warnings; use vars qw(@ISA $VERSION); use Kernel::Config::Defaults; push (@ISA, 'Kernel::Config::Defaults'); use vars qw(@ISA $VERSION); $VERSION = qw($Revision: 1.21 $)[1]; # -----------------------------------------------------# 1; From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Nils Leideck - ITSM Sent: Friday, January 29, 2010 2:15 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] customer database and LDAP Hi, On 29.01.2010, at 22:39, Chris Johnson wrote: Checking database connect... Can't modify constant item in scalar assignment at /opt/otrs/Kernel/Config.pm line 142, near "'login'," BEGIN not safe after errors--compilation aborted at /opt/otrs/Kernel/Config.pm line 234. Compilation failed in require at /opt/otrs/bin/CheckDB.pl line 38. BEGIN failed--compilation aborted at /opt/otrs/bin/CheckDB.pl line 38. could you post your Config.pm ? Nils Leideck -- Nils Leideck Senior Consultant nils.leideck@leidex.netmailto:nils.leideck@leidex.net nils.leideck@otrs.com http://webint.cryptonode.de / a Fractal project CU @ CeBIT 2010 in Hannover, Germanyhttp://www.cebit.de and get to know more about OTRS at booth no. C37 in hall 2 from March 2-6, 2010!