[rt-users] Database relocated onto alternate server

[Keith A McDermott]

More Info:

I can successfully connect through mysql command line tools, php test 
script and through a test perl script with the default apache2 config.  
This all leads me to it being something with RT's setup specifically.  
Once I switch back to the RT apache config RT fails to connect to the 
db.  This is when trying to connect from perl 5.8.8, apache2.2.3.  The 
local database was 5.0.32 which worked fine whereas the remote database 
is 4.0.24 which does meet the minimum required version in the docs.

Any other ideas I can try?

Thanks,
Keith

Raed El-Hames wrote:
> Hi Keith;
>
> Most likely the problem is with the @hostname bit not being recognised 
> correctly ..(and cauing permissions problems)
> try to login with rt_user from your rt server to the database via 
> mysql client and tail your sql server log files to determine why 
> rt_user is being denied.
>
> Regards;
> Roy
>
>
>
>
>
> Keith A McDermott wrote:
>> Thanks Odhiambo,
>>
>> Yes - I can connect fine through the standard mysql tools from the same
>> host without issue however, I was trying "rt_user" previously.  It
>> actually does fail when connecting with "rt_user at hostname".  As I
>> manually moved the database over, manually create the user and manually
>> granted the rights (I don't want to run make initialize-database against
>> our very stable and department-wide mysql server), I'll look through and
>> see what else I need to do.
>>
>> Keith
>>
>> Odhiambo Washington wrote:
>>  
>>> On Tue, Mar 31, 2009 at 4:59 PM, Keith A McDermott
>>> <kmcdermo at purdue.edu <mailto:kmcdermo at purdue.edu>> wrote:
>>>
>>>     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...
>>>
>>>
>>> It should be straighforward just as you say.
>>> Have you tested manually connecting to the DB like:
>>>
>>> mysql -h dbproductionserver -urt_user at hostmachineHostname -pSec3t rt
>>>
>>> ?? Did it work?
>>>
>>> If not, then go to the dbproductionserver and give the necessary
>>> privileges for rt_user to connect:
>>>
>>> mysql> GRANT ALL ON rt.* TO rt_user at hostmachineHostname IDENTIFIED BY
>>> "Sec3t";
>>> mysql> flush privileges;
>>>
>>>
>>> -- 
>>> Best regards,
>>> Odhiambo WASHINGTON,
>>> Nairobi,KE
>>> +254733744121/+254722743223
>>> _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>>> "The only time a woman really succeeds in changing a man is when he is
>>> a baby."
>>>                              - Natalie Wood
>>>     
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
>>