Problems connecting to remote MySql DB

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@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@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@xxx.xxx.com’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user@xxx.xxx.com:
Creating database schema.
DBI->connect(dbname=rt2;host=xxx.xxx.com) failed: Access denied for user:
‘rt_user@xxx.xxx.com’ (Using password: YES) at tools/initdb line 144
Access denied for user: ‘rt_user@xxx.xxx.com’ (Using password: YES) at
tools/initdb
line 144, line 1.
make: *** [initdb.rtuser] Error 255

Vance Wheelock wrote:

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

your DB_RT_USER (in Makefile) has whitespace after it. Delete that space.
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances