Frustrated

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@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@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@localhost’ to database ‘rt2alpha’ at /usr/lib/perl
5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 77, line 1.
make: *** [createdb] Error 11
[root@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@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@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@localhost’ to database ‘rt2’ at /usr/lib/perl
5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 77, 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/

-----BEGIN PGP SIGNED MESSAGE-----

On 24-Mar-2003, pjackson@arterystudio.com wrote message “[rt-users] Frustrated”

DBD::mysql::db do failed: Access denied for user: ‘root@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@localhost’ to database ‘rt2alpha’ at
/usr/lib/perl
5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 77, line 1.
make: *** [createdb] Error 11
[root@fusion rt-2-0-13]#

are you sure that root is configured to have access in mysql?

in the the mysql database, select * from user where User = “root”;

Andy Harrison
Great Works Internet
System Operations
ajharrison@gwi.net
RSA 1024 pgp key: http://www.nachoz.com/andy.pub

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPn9KflPEkLgodAWVAQGjowQAoL5Ugco9qYi3lp1oWDQFYCbyOelPWaRr
54X51MJ1iMkEku/Y/hV56o0ISpPKORvXLgeCID7RYiojxPsUzSfK6brMeOuDmbcd
lWUJyxheYqoG6UxINUvvQDTvKVs8G7O9UvOJ3LTB0PLZhV9yG6s8FtrMSHTivC5d
glgLmF4nVmw=
=2Qza
-----END PGP SIGNATURE-----

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

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@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@localhost’ to database ‘rt2alpha’ at /usr/lib/perl
5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 77, line 1.
make: *** [createdb] Error 11
[root@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:



Dropping mysql database rt2alpha.
DBD::mysql::db do failed: Access denied for user: ‘root@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@localhost’ to database ‘rt2’ at /usr/lib/perl
5/site_perl/5.6.1/DBIx/DataSource/Driver.pm line 77, 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.

Phillip C. Jackson

Well, you say it’s fixed anyway, but in case this is useful: your errors
sound very similar to what I was facing last week: the DBD::mysql::db do failed
on line 77 etc. I emailed the list, but no-one had an answer.

After incredible frustration, I discovered that I needed to change the
permissions or ownership on the mysql files ie. chmod … /var/lib/mysql/*
(I spent days looking in the wrong place - perl modules; I have v. little
exp with DBs)

Good luck with version 3.

Glen Davison