[rt-users] Database relocated onto alternate server

[Keith A McDermott]

Hi there,

I'm moving forward with my testing of RT 3.8.2.

Setup:
Virtual machine (Virtualbox) running RT3.8.2 in Debian Etch.  Web port 
is forwarded to the virtual machine through the host but otherwise there 
is no access to the VM.  I moved the database onto a production database 
server.

RT_SiteConfig.pm has been altered to say:
$DatabaseHost is set to dbproductionserver
$DatabaseRTHost is set to the hostname of the vm host machine

Problem:
In the apache error logs, I get:
DBI connect('dbname=rt;host=dbproductionhost','rt_user',...) failed: 
Access denied for user: 'rt_user at hostmachineHostname' (Using password: 
YES) at /usr/local/share/perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106
[Tue Mar 31 08:58:05 2009] [error] [client hostmachine.ip.goes.here] 
Connect Failed Access denied for user: 'rt_user at hostmachineHostname' 
(Using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n

And I get a 500 server error page returned to me.  However, I can use 
the mysql command line tools from the virtual machine and connect just fine.

Is there possibly a port that's being expected to be open that i need to 
forward or something else that I'm missing?  This seemed like a pretty 
straightforward change in the beginning...

-- 

Keith McDermott
Desktop Support Specialist - PCN
Physics Department, Purdue University

Web:    http://www.physics.purdue.edu/pcn
E-mail: kmcdermo at purdue.edu
Phone:  (765)49-45562
Address:525 Northwestern Avenue
        West Lafayette, IN 47907

Check out our new documentation at:
http://www.physics.purdue.edu/PCN/doc/wiki