Ignore. Someone showed me how to turn on DBI_Trace (which I'm liking quite a bit) and, I will admit, I found a subtle password mis-type I've missed for the past few weeks of tinkering. Fix that, revert a few code changes and voila - RT works.
Thanks for the help, Keith Keith A McDermott wrote: > 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_u...@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 >>>> <[email protected] <mailto:[email protected]>> 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_u...@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_u...@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_u...@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_u...@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: [email protected] >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.bestpractical.com >>> >>> > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [email protected] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
