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/

Reply via email to