[rt-users] Pros Only - Install Problem

[Joel Webb]

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
imported.

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 at 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;\
                        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;" //opt/rt2/etc/acl.mysql
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
Enter password:

*************
Is this the root password again or creation of a new password for the new user
called administrator?
*************

ERROR 1045: Access denied for user: 'root at 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
database
Enter password:
/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 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
--
Respectfully,

Joel Webb
WebbGroup Network Systems LLC
www.webbgroup.net
336.841.7241