Keith A McDermott wrote: > 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
-- Steven Gott eCommerce Intelligence http://www.eComIQ.com 800-930-5908, Ext 7 Google Analytics Authorized Consultan _______________________________________________ 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
