I have a big problem setting up the RT Database. I have used PERL before but have
set up most of my databses for other software with a mysql script that gets
Is there such a thing for RT?? The installation script craps out because my MySQL
server has very scrict permissions against the root user. In addition to trying to
do the install here. I also tried creating the permissions before the ‘make
install’. Here are my questions during the install marked with a *******.
[root@mail rt-2-0-11]# 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’ ‘rt2’ create
Now creating a database for RT.
Enter the mysql password for root:
I entered the real root password. This one I know ***********
Creating mysql database rt2.
cp etc/acl.mysql ‘//opt/rt2/etc/acl.mysql’
/usr/bin/perl -p -i -e " s’!!DB_TYPE!!’“mysql”‘g;
bin/initacls.mysql ‘/usr’ ‘localhost’ ‘’ ‘root’ ‘’ ‘rt2’ '//opt/rt2/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user for RT
Is this the root password again or creation of a new password for the new user
ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: NO)
I shouldn’t have gotten denied for this. I used the root password for the first one
and it worked in the script. On this one it crapped out.
Enter the mysql administrator’s database password to nondestructively reload the
/usr/bin/perl tools/initdb ‘mysql’ ‘/usr’ ‘localhost’ ‘’ ‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Again I didn’t know whether this means create a password or if there is one in the
documentation to use. Either way it tried connecting with my new password for the
rt_user and it didn’t work
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
WebbGroup Network Systems LLC