Need Help

Trying to install RT. I get an error on the rt_user password every time I
install on matter what i set the passowrd to or if the user dose not exsist
before the install. Here is the output from the install

what I am doing wrong.

TIA

make testdeps
/usr/bin/perl ./tools/testdeps -warn mysql
Checking for DBI 1.18 …found
Checking for DBIx::DataSource 0.02 …found
Checking for DBIx::SearchBuilder 0.48 …found
Checking for HTML::Entities…found
Checking for MLDBM…found
Checking for Net::Domain…found
Checking for Net::SMTP…found
Checking for Params::Validate 0.02 …found
Checking for HTML::Mason 1.02 …found
Checking for CGI::Cookie 1.20 …found
Checking for Apache::Cookie…found
Checking for Apache::Session 1.53 …found
Checking for Date::Parse…found
Checking for Date::Format…found
Checking for MIME::Entity 5.108 …found
Checking for Mail::Mailer 1.20 …found
Checking for Getopt::Long 2.24 …found
Checking for Tie::IxHash…found
Checking for Text::Wrapper…found
Checking for Text::Template…found
Checking for File::Spec 0.8 …found
Checking for Errno…found
Checking for FreezeThaw…found
Checking for File::Temp…found
Checking for Log::Dispatch 1.6 …found
Checking for DBD::mysql 2.0416 …found
root@incidents:/usr/src/rt-2-0-11# make install
mkdir -p //incidents/db/rt/bin
mkdir -p //incidents/db/rt/WebRT/data
mkdir -p //incidents/db/rt/WebRT/sessiondata
mkdir -p //incidents/db/rt/etc
mkdir -p //incidents/db/rt/lib
mkdir -p //incidents/db/rt/WebRT/html
mkdir -p //incidents/db/rt/local/WebRT/html
/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘root’ ‘rt2’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
cp etc/acl.mysql ‘//incidents/db/rt/etc/acl.mysql’
/usr/bin/perl -p -i -e " s’!!DB_TYPE!!‘“mysql”‘g;
s’!!DB_HOST!!’“localhost”‘g;
s’!!DB_RT_PASS!!‘“rt_pass”‘g;
s’!!DB_RT_HOST!!’“localhost”‘g;
s’!!DB_RT_USER!!‘“rt_user”‘g;
s’!!DB_DATABASE!!’“rt2”'g;"
//incidents/db/rt/etc/acl.mysql
bin/initacls.mysql ‘/incidents/db/mysql’ ‘localhost’ ‘’ ‘root’ ‘’ ‘rt2’
‘//incidents/db/rt/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user for RT
Enter password:
Enter the mysql administrator’s database password to nondestructively reload
the database
Enter password:
/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBI->connect(dbname=rt2;host=localhost) failed: Access denied for user:
‘rt_user@localhost’ (Using password: YES) at tools/initdb line 144
Access denied for user: ‘rt_user@localhost’ (Using password: YES) at
tools/initdb line 144, line 1.
make: *** [initdb.rtuser] Error 255
Chief Security Engineer | Daniel Fairchild danielf@supportteam.net
Unix is like a wigwam – no Gates, no Windows, and an Apache inside.

Trying to install RT. I get an error on the rt_user password every time I
install on matter what i set the passowrd to or if the user dose not exsist
before the install. Here is the output from the install

what I am doing wrong.

/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘root’ ‘rt2’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
cp etc/acl.mysql ‘//incidents/db/rt/etc/acl.mysql’
/usr/bin/perl -p -i -e " s’!!DB_TYPE!!‘“mysql”‘g;
s’!!DB_HOST!!’“localhost”‘g;
s’!!DB_RT_PASS!!‘“rt_pass”‘g;
s’!!DB_RT_HOST!!’“localhost”‘g;
s’!!DB_RT_USER!!‘“rt_user”‘g;
s’!!DB_DATABASE!!’“rt2”'g;"
//incidents/db/rt/etc/acl.mysql
bin/initacls.mysql ‘/incidents/db/mysql’ ‘localhost’ ‘’ ‘root’ ‘’ ‘rt2’
‘//incidents/db/rt/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user for
RT
Enter password:
Enter the mysql administrator’s database password to nondestructively reload
the database
Enter password:
/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBI->connect(dbname=rt2;host=localhost) failed: Access denied for user:
‘rt_user@localhost’ (Using password: YES) at tools/initdb line 144
Access denied for user: ‘rt_user@localhost’ (Using password: YES) at
tools/initdb line 144, line 1.
make: *** [initdb.rtuser] Error 255

Looks like you either told the interactive make program the wrong mysql
password for your rt_user or you don’t have rt_user in your mysql users table
with the same password as you supplied to the make program.

Using the same username (rt_user), and the same password, can you do mysql
commands against the rt2 database?

rob

Trying to install RT. I get an error on the rt_user password every time I
install on matter what i set the passowrd to or if the user dose not
exsist before the install. Here is the output from the install

what I am doing wrong.

/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘root’ ‘rt2’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
cp etc/acl.mysql ‘//incidents/db/rt/etc/acl.mysql’
/usr/bin/perl -p -i -e " s’!!DB_TYPE!!‘“mysql”‘g;
s’!!DB_HOST!!’“localhost”‘g;
s’!!DB_RT_PASS!!‘“rt_pass”‘g;
s’!!DB_RT_HOST!!’“localhost”‘g;
s’!!DB_RT_USER!!‘“rt_user”‘g;
s’!!DB_DATABASE!!’“rt2”'g;"
//incidents/db/rt/etc/acl.mysql
bin/initacls.mysql ‘/incidents/db/mysql’ ‘localhost’ ‘’ ‘root’ ‘’ ‘rt2’
‘//incidents/db/rt/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user
for

RT

Enter password:
Enter the mysql administrator’s database password to nondestructively
reload the database
Enter password:
/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBI->connect(dbname=rt2;host=localhost) failed: Access denied for user:
‘rt_user@localhost’ (Using password: YES) at tools/initdb line 144
Access denied for user: ‘rt_user@localhost’ (Using password: YES) at
tools/initdb line 144, line 1.
make: *** [initdb.rtuser] Error 255

Looks like you either told the interactive make program the wrong mysql
password for your rt_user or you don’t have rt_user in your mysql users
table with the same password as you supplied to the make program.

Using the same username (rt_user), and the same password, can you do mysql
commands against the rt2 database?

rob

Yeah after it did not work with the first install i added a rt_user user and
gave him a pass I was able to login to the mysql db so I tried again got the
same thing. then just for kicks i tried ti login in to the blank rt2 db and i
got in with the rt_user I serup thats why I am so stummped here I looked
through the archives and seen a similar post and did waht they suggested
which was to delete the first two lines in etc/acl.mysql and still the same
error.

I am using the latest rt 2.0.11 and mysql 3.23.48.

Chief Security Engineer | Daniel Fairchild danielf@supportteam.net
Unix is like a wigwam – no Gates, no Windows, and an Apache inside.

I figured it out I missed the password variable in the Makefile :slight_smile:

oops.

thanksOn Friday 15 February 2002 10:33 am, Rob Walker wrote:

On Friday 15 February 2002 08:23, Daniel F. Chief Security Engineer - wrote:

Trying to install RT. I get an error on the rt_user password every time I
install on matter what i set the passowrd to or if the user dose not
exsist before the install. Here is the output from the install

what I am doing wrong.

/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘root’ ‘rt2’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
cp etc/acl.mysql ‘//incidents/db/rt/etc/acl.mysql’
/usr/bin/perl -p -i -e " s’!!DB_TYPE!!‘“mysql”‘g;
s’!!DB_HOST!!’“localhost”‘g;
s’!!DB_RT_PASS!!‘“rt_pass”‘g;
s’!!DB_RT_HOST!!’“localhost”‘g;
s’!!DB_RT_USER!!‘“rt_user”‘g;
s’!!DB_DATABASE!!’“rt2”'g;"
//incidents/db/rt/etc/acl.mysql
bin/initacls.mysql ‘/incidents/db/mysql’ ‘localhost’ ‘’ ‘root’ ‘’ ‘rt2’
‘//incidents/db/rt/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user
for

RT

Enter password:
Enter the mysql administrator’s database password to nondestructively
reload the database
Enter password:
/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBI->connect(dbname=rt2;host=localhost) failed: Access denied for user:
‘rt_user@localhost’ (Using password: YES) at tools/initdb line 144
Access denied for user: ‘rt_user@localhost’ (Using password: YES) at
tools/initdb line 144, line 1.
make: *** [initdb.rtuser] Error 255

Looks like you either told the interactive make program the wrong mysql
password for your rt_user or you don’t have rt_user in your mysql users
table with the same password as you supplied to the make program.

Using the same username (rt_user), and the same password, can you do mysql
commands against the rt2 database?

rob


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Chief Security Engineer | Daniel Fairchild danielf@supportteam.net
Unix is like a wigwam – no Gates, no Windows, and an Apache inside.

Trying to install RT. I get an error on the rt_user password every time I
install on matter what i set the passowrd to or if the user dose not exsist
before the install. Here is the output from the install

what I am doing wrong.

TIA

make testdeps
/usr/bin/perl ./tools/testdeps -warn mysql
Checking for DBI 1.18 …found
Checking for DBIx::DataSource 0.02 …found
Checking for DBIx::SearchBuilder 0.48 …found
Checking for HTML::Entities…found
Checking for MLDBM…found
Checking for Net::Domain…found
Checking for Net::SMTP…found
Checking for Params::Validate 0.02 …found
Checking for HTML::Mason 1.02 …found
Checking for CGI::Cookie 1.20 …found
Checking for Apache::Cookie…found
Checking for Apache::Session 1.53 …found
Checking for Date::Parse…found
Checking for Date::Format…found
Checking for MIME::Entity 5.108 …found
Checking for Mail::Mailer 1.20 …found
Checking for Getopt::Long 2.24 …found
Checking for Tie::IxHash…found
Checking for Text::Wrapper…found
Checking for Text::Template…found
Checking for File::Spec 0.8 …found
Checking for Errno…found
Checking for FreezeThaw…found
Checking for File::Temp…found
Checking for Log::Dispatch 1.6 …found
Checking for DBD::mysql 2.0416 …found
root@incidents:/usr/src/rt-2-0-11# make install
mkdir -p //incidents/db/rt/bin
mkdir -p //incidents/db/rt/WebRT/data
mkdir -p //incidents/db/rt/WebRT/sessiondata
mkdir -p //incidents/db/rt/etc
mkdir -p //incidents/db/rt/lib
mkdir -p //incidents/db/rt/WebRT/html
mkdir -p //incidents/db/rt/local/WebRT/html
/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘root’ ‘rt2’ create
Now creating a database for RT.
Enter the mysql password for root:
Creating mysql database rt2.
cp etc/acl.mysql ‘//incidents/db/rt/etc/acl.mysql’
/usr/bin/perl -p -i -e " s’!!DB_TYPE!!‘“mysql”‘g;
s’!!DB_HOST!!’“localhost”‘g;
s’!!DB_RT_PASS!!‘“rt_pass”‘g;
s’!!DB_RT_HOST!!’“localhost”‘g;
s’!!DB_RT_USER!!‘“rt_user”‘g;
s’!!DB_DATABASE!!’“rt2”'g;"
//incidents/db/rt/etc/acl.mysql
bin/initacls.mysql ‘/incidents/db/mysql’ ‘localhost’ ‘’ ‘root’ ‘’ ‘rt2’
‘//incidents/db/rt/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user for RT
Enter password:
Enter the mysql administrator’s database password to nondestructively reload
the database
Enter password:
/usr/bin/perl tools/initdb ‘mysql’ ‘/incidents/db/mysql’ ‘localhost’ ‘’
‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBI->connect(dbname=rt2;host=localhost) failed: Access denied for user:
‘rt_user@localhost’ (Using password: YES) at tools/initdb line 144
Access denied for user: ‘rt_user@localhost’ (Using password: YES) at
tools/initdb line 144, line 1.
make: *** [initdb.rtuser] Error 255
Chief Security Engineer | Daniel Fairchild danielf@supportteam.net
Unix is like a wigwam – no Gates, no Windows, and an Apache inside.

                    s'!!DB_RT_PASS!!'"rt_pass"'g;\
                    s'!!DB_RT_USER!!'"rt_user"'g;\
                    s'!!DB_DATABASE!!'"rt2"'g;"

Enter the mysql password for rt_user:
DBI->connect(dbname=rt2;host=localhost) failed: Access denied for user:
‘rt_user@localhost’ (Using password: YES) at tools/initdb line 144

You’ve left the default password in the Makefile, ergo, the RT
installation has created a MySQL ‘user’ (very loose term there) with a
username of ‘rt_user’ and a password of ‘rt_pass’. When prompted, this is
the password you should be typing in, not that of any rt UNIX username
that you may have.

Regards,

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B                      Operations