Can't install

All,

I’m trying to install RT and make install keeps erroring out. make dropdb works fine, however.

Here is the output, with the “passwords” starred out.

$make install
mkdir -p //usr/local/rt2/bin
mkdir -p //usr/local/rt2/WebRT/data
mkdir -p //usr/local/rt2/WebRT/sessiondata
mkdir -p //usr/local/rt2/etc
mkdir -p //usr/local/rt2/lib
mkdir -p //usr/local/rt2/WebRT/html
mkdir -p //usr/local/rt2/local/WebRT/html
/usr/bin/perl tools/initdb ‘mysql’ ‘/usr/local/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 ‘//usr/local/rt2/etc/acl.mysql’
/usr/bin/perl -p -i -e " s’!!DB_TYPE!!‘“mysql”‘g;
s’!!DB_HOST!!’“localhost”‘g;
s’!!DB_RT_PASS!!‘"*“‘g;
s’!!DB_RT_HOST!!‘“localhost”‘g;
s’!!DB_RT_USER!!’“user_rt”‘g;
s’!!DB_DATABASE!!'“rt2”'g;” //usr/local/rt2/etc/acl.mysql
bin/initacls.mysql ‘/usr/local/mysql’ ‘localhost’ ‘’ ‘root’ '
’ ‘rt2’ ‘//usr/local/rt2/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user for RT
ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: YES)
Enter the mysql administrator’s database password to nondestructively reload the database
/usr/local/mysql/bin/mysqladmin: connect to server at ‘localhost’ failed
error: ‘Access denied for user: ‘root@localhost’ (Using password: YES)’
make: *** [acls] Error 1

$make dropdb
/usr/bin/perl tools/initdb ‘mysql’ ‘/usr/local/mysql’ ‘localhost’ ‘’ ‘root’ ‘rt2’ drop
Now dropping the RT2 database.
Enter the mysql password for root:
About to drop mysql database rt2.
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 rt2.

My first thought was that the the password for root@localhost was not set or not set correctly. However, when I try to access mysql with root I must enter in the password, and it is the password I used above.

$mysql -u root
ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: NO)
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31 to server version: 3.23.55

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql>

Therefore, I don’t think it is a problem on mysql side.

Any help would be appreciated.

Thanks,

David Pitts

dpitts@mk.net

I’m trying to install RT and make install keeps erroring out. make
dropdb works fine, however.

Firstly, could you ensure that you only send one copy of your mail?
Plain text and html versions in the same mail does not a polite netizen
make.

Second, there is a difference between ‘localhost’ and ‘default localhost’.
So where the RT install is connecting to ‘localhost’:

ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: YES)

This is not the same as the mysql client connecting to the default
localhost (usually /tmp/mysql.sock or somesuch):

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.

Try ‘mysql -h 127.0.0.1 -u root -p’ to see if you have a permission
problem based on how you connect to the server. Further assistance on
this problem is available on the online mysql manual, www.mysql.com .

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