RT3 Access Denied DB Error on Install

Hi,

I’m working on installing Request Tracker 3.8.1 in order to test it out
for our department, however I am running into an error that I’ve been
unable to find a solution to.

I have tried the wiki, etc with no success.

I have a fresh Debian Etch install. I’ve ran make fixdeps and have all
of the perl modules installed and make testdeps reports complete success.

However, on make initialize-database after setting up my custom
configuration in RT_SiteConfig.pm, I receive the following error:

root@debtest:~/rt-3.8.1# make initialize-database
/usr/bin/perl sbin/rt-setup-database --action init --dba root
–prompt-for-dba-password
In order to create or update your RT database, this script needs to
connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no
database
password, just press return.

Password:
Working with:
Type: mysql
Host: localhost
Name: rt3
User: rt_user
DBA: root
Now creating a mysql database rt3 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs
Granting access to rt_user@‘localhost’ on rt3.
Done.
DBI connect(‘dbname=rt3;host=localhost;port=3306’,‘rt_user’,…) failed:
Access denied for user ‘rt_user’@‘localhost’ (using password: YES) at
/usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106
Connect Failed Access denied for user ‘rt_user’@‘localhost’ (using
password: YES)
at /home/kmcdermo/rt-3.8.1/sbin/…/lib/RT.pm line 204
make: *** [initialize-database] Error 255

Below are the database settings I have setup (with passwords heavily altered) in my RT_SiteConfig.pm. I have other settings custom-configured as well:

#db type
Set( $DatabaseType, ‘mysql’);

#DB Connection stuff
Set( $DatabaseHost, ‘localhost’);
Set( $DatabaseRTHost, ‘localhost’);
Set( $DatabasePort, ‘3306’);
Set( $DatabaseUser, ‘rt_user’);
Set( $DatabasePassword, ‘rt_password’);
Set( $DatabaseName, ‘rt3’);

Does anyone have any insite into something that I could try to get this up and working? Looks like a good system and am anxious to give it a try.

Keith McDermott
Desktop Support Specialist - PCN
Physics Department, Purdue University

Web: Science IT - College of Science - Purdue University
E-mail: kmcdermo@purdue.edu
Phone: (765)496-2202
Address:525 Northwestern Avenue
West Lafayette, IN 47907

Check out our new documentation at:
http://www.physics.purdue.edu/PCN/doc/wiki