[rt-users] Frustrated

[pjackson at arterystudio.com]

Alirght guys/gals - I need some guidance.  Below is my config ..

RedHat 7.3 (fresh system)
Request Tracker: v. 2-0-13
Apache (RPM install): Apache/1.3.27 (Unix)  (Red-Hat/Linux)
MYSQL: (RPM install): MySQL version 3.23.54
DBI: DBI-1.13
HTML-Mason: HTML-Mason-1.04
Libapreq: libapreq-1.1

All other dependencies installed through CPAN.

Ran 'make testdeps' and reported all 'INSTALLED'.  However, when I run 'make 
install' I get the following error message.

-----------
[root at fusion rt-2-0-13]# make install
mkdir -p //opt/rt2/bin
mkdir -p //opt/rt2/WebRT/data
mkdir -p //opt/rt2/WebRT/sessiondata
mkdir -p //opt/rt2/etc
mkdir -p //opt/rt2/lib
mkdir -p //opt/rt2/WebRT/html
mkdir -p //opt/rt2/local/WebRT/html
/usr/bin/perl   tools/initdb 'mysql' '/usr' 'localhost' '' 'root' 'rt2alpha' cre
ate
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2alpha.
DBD::mysql::db do failed: Access denied for user: 'root at localhost' to database '
rt2alpha' at /usr/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 77, <
STDIN> line 1.
Access denied for user: 'root at localhost' to database 'rt2alpha' at /usr/lib/perl
5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 77, <STDIN> line 1.
make: *** [createdb] Error 11
[root at fusion rt-2-0-13]#

-----------

I am, without question, uber-confused.  Spent the majority of my weekend with 
this to no avail.  Anybody have any insight?  I did read the comments in the 
lists archives, however, didn't quite find the answer.  Another interesting 
note - I did get the db to build once as 'rt2' however, it failed at the 'group 
name'.  After doing that, I cant drop the old rt2 db.  I get the following 
error:

-----------

[root at fusion rt-2-0-13]# make dropdb
/usr/bin/perl   tools/initdb 'mysql' '/usr' 'localhost' '' 'root' 'rt2' drop
Now dropping the RT2 database.
Enter the mysql password for root:
About to drop mysql database rt2alpha.
WARNING: This will erase all data in rt2.
If you have an existing RT 2.x installation, this will destroy all your data.
i
Proceed [y/N]:y

Dropping mysql database rt2alpha.
DBD::mysql::db do failed: Access denied for user: 'root at localhost' to database '
rt2' at /usr/lib/perl5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 77, <
STDIN> line 2.
Access denied for user: 'root at localhost' to database 'rt2' at /usr/lib/perl
5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 77, <STDIN> line 2.

-----------

...weird because I am using root permissions.  I also cannot drop this db 
through mySQL - something whacked with the perm's.

OK ... so, that's that.  If anyone is interested in making a couple bucks and 
doing the install, this would also be an option as I've wasted tons of time 
messing with this.

ANY HELP would be oh so great.

Regards,

Phillip C. Jackson
IT Director
The Artery Studio

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/