[otrs] Database connection problem.

3 Mar 2009

      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 otrs@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_2epl::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

mhepler@wrgservices.com

pgp keyserver:  pgp.mit.edu