[rt-users] RT FastCGI configuration Issues

[Ruslan Zakirov]

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.