[rt-users] Problems connecting to remote MySql DB

[Vance Wheelock]

My problem is that I'm installing RT on our mail machine. make testdeps
"finds" everything
If I can get by the database part of the install I think everything will
fall in place. What is the easiest way to create the database outside of the
install scripts and how does one easily skip the db part of the install?
Is there any pointers as to what I need in the Makefile in order to have it
correctly connect to a remote database?

The output of 'make install' follows:

[root at mail rt-2-0-15]# 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/' 'xxx.xxx.com' '' 'dba'
'rt2' create
Now creating a database for RT.
Enter the mysql password for dba:
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!!'"xxx.xxx.com"'g;\
                        s'!!DB_RT_PASS!!'"rt_pass"'g;\
                        s'!!DB_RT_HOST!!'"xxx.xxx.com"'g;\
                        s'!!DB_RT_USER!!'"rt_user at xxx.xxx.com"'g;\
                        s'!!DB_DATABASE!!'"rt2"'g;"
//usr/local/rt2/etc/acl.mysql
bin/initacls.mysql '/usr/local/' 'xxx.xxx.com' '' 'dba' 'dba_passwd' 'rt2'
'//usr/local/rt2/etc/acl.mysql'
Enter the mysql administrator's database password to create a new user for
RT
ERROR 1064 at line 4: You have an error in your SQL syntax near
'@xxx.xxx.com IDENTIFIED BY 'rt_pass'' at line 1
Enter the mysql administrator's database password to nondestructively reload
the database
/usr/bin/perl   tools/initdb 'mysql' '/usr/local/' 'xxx.xxx.com' ''
'rt_user at xxx.xxx.com' 'rt2' insert
Now populating database schema.
Enter the mysql password for rt_user at xxx.xxx.com:
Creating database schema.
DBI->connect(dbname=rt2;host=xxx.xxx.com) failed: Access denied for user:
'rt_user at xxx.xxx.com' (Using password: YES) at tools/initdb line 144
Access denied for user: 'rt_user at xxx.xxx.com' (Using password: YES) at
tools/initdb
line 144, <STDIN> line 1.
make: *** [initdb.rtuser] Error 255