Trying to use RTFM

I am not sure if this is the correct list. I have RT 3.4.5 installed and
RTFM-2.2.0RC2 installed. When I try to run make initdb I get this
error:

make initdb
/usr/bin/perl -Ilib -I/opt/rt3/lib /opt/rt3/sbin/rt-setup-database
–action schema --datadir etc --datafile etc/initialdata --dba rt_user
DBI connect(‘dbname=rt3;host=localhost’,‘rt_user’,…) failed: Access
denied for user ‘rt_user’@‘localhost’ (using password: NO) at
/opt/rt3/sbin/rt-setup-database line 170
Failed to connect to dbi:mysql:;host=localhost as rt_user: Access
denied for user ‘rt_user’@‘localhost’ (using password: NO) at
/opt/rt3/sbin/rt-setup-database line 170.
…returned with error: 65280
make: *** [initdb] Error 255

Do I have to setup any Enviroemnnt variables? Ihave RTUSER and user set
to my mysql user.

TIA

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia

“Remember! That light at the end of the tunnel
Just might be the headlight of an oncoming train!”

Make sure that you set the user and password in MySql using this command:
grant all on rtdb.* to rtuser@localhost identified by ‘wibble’;
and make sure that your RT_SiteConfig.pm file matches the MySql

Set($DatabaseUser , ‘rtuser’);
Set($DatabasePassword , ‘wibble’);
Set($DatabaseName , ‘rtdb’);

Dan-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of John Boris
Sent: June 9, 2006 12:18 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Trying to use RTFM

I am not sure if this is the correct list. I have RT 3.4.5 installed and
RTFM-2.2.0RC2 installed. When I try to run make initdb I get this
error:

make initdb
/usr/bin/perl -Ilib -I/opt/rt3/lib /opt/rt3/sbin/rt-setup-database
–action schema --datadir etc --datafile etc/initialdata --dba rt_user
DBI connect(‘dbname=rt3;host=localhost’,‘rt_user’,…) failed: Access
denied for user ‘rt_user’@‘localhost’ (using password: NO) at
/opt/rt3/sbin/rt-setup-database line 170
Failed to connect to dbi:mysql:;host=localhost as rt_user: Access
denied for user ‘rt_user’@‘localhost’ (using password: NO) at
/opt/rt3/sbin/rt-setup-database line 170.
…returned with error: 65280
make: *** [initdb] Error 255

Do I have to setup any Enviroemnnt variables? Ihave RTUSER and user set
to my mysql user.

TIA

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia

“Remember! That light at the end of the tunnel
Just might be the headlight of an oncoming train!”

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical:
http://bestpractical.com/about/jobs.html

DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or any
action or omission taken by you in reliance on it, is prohibited and may be
unlawful. Please immediately contact the sender if you have received this
message in error. Thank you.

Thanks. I manually edited the lines that were complaining based on a
reply I just received and that worked. I thought I had it configured as
you write here but I guess I had something misconfigured. It is working
now. Thanks for the replies.

“Lamers, Dan” dlamers@elcan.com 06/09/06 2:00 PM >>>
Make sure that you set the user and password in MySql using this
command:
grant all on rtdb.* to rtuser@localhost identified by ‘wibble’;
and make sure that your RT_SiteConfig.pm file matches the MySql

Set($DatabaseUser , ‘rtuser’);
Set($DatabasePassword , ‘wibble’);
Set($DatabaseName , ‘rtdb’);

Dan-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On Behalf Of John
Boris
Sent: June 9, 2006 12:18 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Trying to use RTFM

I am not sure if this is the correct list. I have RT 3.4.5 installed
and
RTFM-2.2.0RC2 installed. When I try to run make initdb I get this
error:

make initdb
/usr/bin/perl -Ilib -I/opt/rt3/lib /opt/rt3/sbin/rt-setup-database
–action schema --datadir etc --datafile etc/initialdata --dba rt_user
DBI connect(‘dbname=rt3;host=localhost’,‘rt_user’,…) failed: Access
denied for user ‘rt_user’@‘localhost’ (using password: NO) at
/opt/rt3/sbin/rt-setup-database line 170
Failed to connect to dbi:mysql:;host=localhost as rt_user: Access
denied for user ‘rt_user’@‘localhost’ (using password: NO) at
/opt/rt3/sbin/rt-setup-database line 170.
…returned with error: 65280
make: *** [initdb] Error 255

Do I have to setup any Enviroemnnt variables? Ihave RTUSER and user
set
to my mysql user.

TIA

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia

“Remember! That light at the end of the tunnel
Just might be the headlight of an oncoming train!”

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical:

DISCLAIMER: The information in this message is confidential and may be
legally privileged. It is intended solely for the addressee. Access to
this
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or
any
action or omission taken by you in reliance on it, is prohibited and
may be
unlawful. Please immediately contact the sender if you have received
this
message in error. Thank you.