I did that, however, I'm getting this now: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. ________________________________ Apache/2.2.3 (CentOS) Server at customers.technogymusa.com Port 80 And I get the same thing when I try to do the web based installer.pl update: http://customers/otrs/installer.pl And when I restart OTRS, I get this: [root@customers Kernel]# /etc/init.d/otrs restart Shutting down OTRS Disable /opt/otrs/bin/PostMaster.pl ... done. Shutting down cronjobs ... no crontab for otrs failed! Starting OTRS.. Checking httpd ... done. Checking MySQL ... done. 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. Error! May your database isn't configured yet? Try the web installer to configure your database: -->> http://customers.technogymusa.com/otrs/installer.pl <<-- or configure your database with README.database (DB - Setup Example) So, I take a look at README.database, and it would seem that the DB is set up, as it's storing tickets and everything: I've been using this system with an LDAP customers auth, however, I would have figured that the tables for the customer db would have been created, but possibly not? How do I go and do just those? Chris Chris Johnson IT Manager Technogym USA 830 4th Ave South, Suite 300 | Seattle, WA 98134 Toll Free: (800) 804-0952 x 332 | Phone: (206) 623-1488 x 332 Mobile: (206) 245-6648 | Fax: (206) 623-1898 Email: cjohnson@technogymusa.com | www.technogymusa.comhttp://www.technogymusa.com/ [cid:imageba2982.jpg@a336994a.7edc49f5] Please visit our website for information on our Wellness Solutions at http://www.technogymusa.comhttp://www.technogymusa.com/ Disclaimer: This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Nils Leideck - ITSM Sent: Thursday, January 28, 2010 1:26 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] customer database and LDAP Hi, On 28.01.2010, at 22:09, Chris Johnson wrote: I'm using OTRS 2.4.5 and I'm trying to figure out if I can configure both LDAP lookups and have the OTRS built in customer database be searched for customer information in tickets. I found a document stating that it could be done in 2.3, and here's the URL: http://doc.otrs.org/2.3/en/html/x1638.html however, I don't see mention of it in the 2.4.5 documentation. Is this valid on both? exactly the same !!! Just use $Self->{CustomerUser2} 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!

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!