[rt-users] RT FastCGI configuration Issues

[Paul Fincher]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110902/b33ad0e6/attachment.htm>