Tried reloading everything including Apache and MySQL? Has helped me on similar occasions. Otherwise the OTRS system log file (Mine is in /tmp/otrs.log) or apache error log may give more clues.
KR, Frans > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > Mark Hepler > Sent: dinsdag 3 maart 2009 18:20 > To: [email protected] > Subject: [otrs] Database connection problem. > > I must be rather dense here, but I can't seem to work out what I did to > cause the initial problem or how to get it fixed. > > New install of OTRS2 on Debian Lenny with mysql Database > > I made a simple change in the Config.pm to fix the link sent in the > auto response email. I added the following line to config.pm and > restarted the otrs2 service > > +++ > > $Self->{'FQDN'} = 'helpdesk.wrgservices.com'; > > +++ > > I then got a connection error that otrs was unable to connect to the > database. > > ++++ > > Message: Access denied for user 'otrs'@'localhost' (using password: NO) > > ++++ > > I've searched through the mailing list archives and tried several > options to resolve the connection issue, but nothing seems to be > working > for me. Would someone be able to tell me what I am missing ? > > This is one change I tried.. which seemed to have had no effect. > > # $Self->{DatabasePw} = $dbpass; > $Self->{DatabasePw} = 'otrs'; > > > It is still telling me that otrs is trying to connect to the database > with no password.. > > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ++++++++++++++ > > mysql> SET PASSWORD FOR 'otrs'@'localhost' = PASSWORD('otrs'); > Query OK, 0 rows affected (0.00 sec) > > > mysql> GRANT ALL PRIVILEGES ON otrs2.* TO 'otrs'@'localhost' IDENTIFIED > BY 'otrs'; > Query OK, 0 rows affected (0.00 sec) > > > > mysql> SHOW GRANTS FOR 'otrs'@'localhost'; > +---------------------------------------------------------------------- > ---------------------------------------+ > | Grants for o...@localhost > | > +---------------------------------------------------------------------- > ---------------------------------------+ > | GRANT USAGE ON *.* TO 'otrs'@'localhost' IDENTIFIED BY PASSWORD > '*DC3E1F4ED8E475AF5F198D1F66D8F73B3B4133B3' | > | GRANT ALL PRIVILEGES ON `otrs2`.* TO 'otrs'@'localhost' > | > +---------------------------------------------------------------------- > ---------------------------------------+ > 2 rows in set (0.00 sec) > > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ++++++++++++++++++++++++++++++++=== > > > helpdesk:/etc/otrs/Kernel# cat Config.pm > # -- > # Kernel/Config.pm - Config file for OTRS kernel > # Copyright (C) 2001-2006 OTRS GmbH, http://otrs.org/ > # -- > # $Id: Config.pm.dist,v 1.18 2006/09/07 16:15:41 mh Exp $ > # -- > # This software comes with ABSOLUTELY NO WARRANTY. For details, see > # the enclosed file COPYING for license information (GPL). If you > # did not receive this file, see http://www.gnu.org/licenses/gpl.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; > > BEGIN { > if (-f '/etc/otrs/database.pm') { > require '/etc/otrs/database.pm'; > if ($dbtype eq 'pgsql') { > $dbport ||= '5432'; > our $dsn = "DBI:Pg:dbname"; > } > else { > $dbport ||= '3306'; > our $dsn = "DBI:mysql:database"; > } > } > } > > sub Load { > my $Self = shift; > # ---------------------------------------------------- # > # ---------------------------------------------------- # > # # > # Start of your own config options!!! # > # # > # ---------------------------------------------------- # > # ---------------------------------------------------- # > > # ---------------------------------------------------- # > # database settings # > # ---------------------------------------------------- # > # DatabaseHost > # (The database host.) > $Self->{DatabaseHost} = $dbserver || 'localhost'; > # Database > # (The database name.) > $Self->{Database} = $dbname || 'otrs'; > # DatabaseUser > # (The database user.) > $Self->{DatabaseUser} = $dbuser || 'otrs'; > # DatabasePw > # (The password of database user. You also can use > bin/CryptPassword.pl > # for crypted passwords.) > # $Self->{DatabasePw} = $dbpass; > $Self->{DatabasePw} = 'otrs'; > > # DatabaseDSN > # (The database DSN for MySQL ==> more: "man DBD::mysql") > $Self->{DatabaseDSN} = > "$dsn=$Self->{Database};host=$Self->{DatabaseHost};port=$dbport;"; > > # (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} = '/usr/share/otrs'; > > # ---------------------------------------------------- # > # insert your own config settings "here" # > # config settings taken from Kernel/Config/Defaults.pm # > # ---------------------------------------------------- # > # $Self->{SessionUseCookie} = 0; > # $Self->{CheckMXRecord} = 0; > $Self->{'FQDN'} = 'helpdesk.wrgservices.com'; > # ---------------------------------------------------- # > # switch off the web based installer for the Debian package > $Self->{SecureMode} = 1; > > # ---------------------------------------------------- # > # data inserted by installer # > # ---------------------------------------------------- # > # $DIBI$ > > # ---------------------------------------------------- # > # ---------------------------------------------------- # > # # > # End of your own config options!!! # > # # > # ---------------------------------------------------- # > # ---------------------------------------------------- # > } > > # ---------------------------------------------------- # > # 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; > > > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > > ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Tue Mar 3 10:58:11 > 2009 > > Message: Access denied for user 'otrs'@'localhost' (using password: NO) > > Traceback (14366): > Module: Kernel::System::DB::new (v1.75.2.1) Line: 180 > Module: Kernel::System::Web::InterfaceAgent::Run (v1.23) Line: 144 > Module: > ModPerl::ROOT::ModPerl::Registry::usr_share_otrs_bin_cgi_2dbin_index_2e > pl::handler > (v) Line: 47 > Module: (eval) (v1.81) Line: 204 > Module: ModPerl::RegistryCooker::run (v1.81) Line: 204 > Module: ModPerl::RegistryCooker::default_handler (v1.81) Line: 170 > Module: ModPerl::Registry::handler (v1.99) Line: 31 > > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > +++++++++++++++++++ > > > > Any assistance would be greatly appreciated. > > > > -- > Mark Hepler > > [email protected] > > pgp keyserver: pgp.mit.edu > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! > http://www.otrs.com/en/support/enterprise-subscription/ --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
