[rt-users] RT FastCGI configuration Issues

[Paul Fincher]

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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fcgi_mason_handler.out
Type: application/octet-stream
Size: 5737 bytes
Desc: fcgi_mason_handler.out
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110906/ce448734/attachment.obj>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: httpd_config.txt
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110906/ce448734/attachment.txt>