[rt-users] unsubscribe

[Steve Gott]

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_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
>>>>   
>>>>       
>> _______________________________________________
>> 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
>>   
> _______________________________________________
> 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

-- 
Steven Gott
eCommerce Intelligence
http://www.eComIQ.com
800-930-5908, Ext 7
Google Analytics Authorized Consultan