[rt-users] RT3 Access Denied DB Error on Install

[Keith A McDermott]

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 at 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:    http://www.physics.purdue.edu/pcn
E-mail: kmcdermo at 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