[rt-users] RT FastCGI configuration Issues

[Paul Fincher]

Thanks Ruslan.  I figured it was a user error.  It was permissions.

-----Original Message-----
From: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com] 
Sent: Tuesday, September 06, 2011 11:27 AM
To: Paul Fincher
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RT FastCGI configuration Issues

Hi,

So in CLI you don't have errors. Then I suspect permissions and/or environment variables. I see you do things as root in CLI. Try apache's user.

On Tue, Sep 6, 2011 at 7:14 PM, Paul Fincher <pfincher at ghs.com> wrote:
> Hi Ruslan,
>
>   I have attached the output from calling mason_handler.fcgi directly.  I do get a web page from the handler.  What does this tell me? Also there was a question about distro and SELinux mode:
>
> [root at flsupport selinux]# uname -a
> Linux flsupport.ghs.com 2.6.18-194.32.1.el5 #1 SMP Wed Jan 5 17:53:09 
> EST 2011 i686 i686 i386 GNU/Linux [root at flsupport selinux]# sestatus 
> -v SELinux status:                 disabled
>
>   I have also attached my http configuration in hopes it might help.
>
> Thanks for the help,
> Paul
>
> -----Original Message-----
> From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On 
> Behalf Of Ruslan Zakirov
> Sent: Saturday, September 03, 2011 3:27 PM
> To: Paul Fincher
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] RT FastCGI configuration Issues
>
> Hi,
>
> What happens when you run `perl /opt/rt3/bin/mason_handler.fcgi` from command line?
> Without any options it prints html of the login page right into console.
>
> On Sat, Sep 3, 2011 at 1:29 AM, Paul Fincher <pfincher at ghs.com> wrote:
>> Hi,
>>
>>
>>
>>    I am trying to use the FastCGI web handler with RT 3.8.10 and am 
>> having issues.  It appears that rt is unable to login to the database 
>> when using
>> FastCGI:
>>
>> [Fri Sep 02 16:57:35 2011] [notice] Apache/2.2.17 (Unix)
>> mod_ssl/2.2.17
>> OpenSSL/0.9.8e-fips-rhel5 mod_fcgid/2.3.6 mod_perl/2.0.5 Perl/v5.8.8 
>> configured -- resuming normal operations
>>
>> DBI connect('dbname=rt3;host=localhost','rt_user',...) failed: Access 
>> denied for user 'rt_user'@'localhost' (using password: YES) at 
>> /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106
>>
>> Connect Failed Access denied for user 'rt_user'@'localhost' (using password:
>> YES)  at /opt/rt3/bin/../lib/RT.pm line 206
>>
>> Compilation failed in require at /opt/rt3/bin/mason_handler.fcgi line 54.
>>
>> [Fri Sep 02 16:57:37 2011] [warn] [client myhost] (104)Connection 
>> reset by
>> peer: mod_fcgid: error reading data from FastCGI server
>>
>>
>>
>> When logging into the database manually with rt_user I have no issues:
>>
>>>  /usr/local/mysql/bin/mysql -u rt_user -h localhost -p
>>
>> Enter password:
>>
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>>
>> Your MySQL connection id is 173
>>
>> Server version: 5.5.10-log Source distribution
>>
>>
>>
>> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
>>
>>
>>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>>
>> affiliates. Other names may be trademarks of their respective
>>
>> owners.
>>
>>
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input 
>> statement.
>>
>>
>>
>> mysql>
>>
>>
>>
>>   Also when I switch to use the perl handler things work fine:
>>
>> [Fri Sep  2 21:11:29 2011] [info]: Successful login for pfincher from 
>> myhost
>> (/opt/rt3/bin/../lib/RT/Interface/Web.pm:593)
>>
>>
>>
>>   I am using apache v2.2.17 and mod_fcgid v2.3.6.   Is there 
>> something stupid I am missing?
>>
>>
>>
>> Thanks,
>>
>> Paul
>>
>> --------
>> RT Training Sessions 
>> (http://bestpractical.com/services/training.html)
>> *  Chicago, IL, USA — September 26 & 27, 2011
>> *  San Francisco, CA, USA — October 18 & 19, 2011
>> *  Washington DC, USA — October 31 & November 1, 2011
>> *  Melbourne VIC, Australia — November 28 & 29, 2011
>> *  Barcelona, Spain — November 28 & 29, 2011
>>
>
>
>
> --
> Best regards, Ruslan.
>



--
Best regards, Ruslan.