[rt-users] Need Help

[Rob Walker]

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 at localhost' (Using password: YES) at tools/initdb line 144
> Access denied for user: 'rt_user at localhost' (Using password: YES) at 
> tools/initdb line 144, <STDIN> 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