<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> 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:<br><br>[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<o:p></o:p></p><p class=MsoNormal>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<o:p></o:p></p><p class=MsoNormal>Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES) at /opt/rt3/bin/../lib/RT.pm line 206<o:p></o:p></p><p class=MsoNormal>Compilation failed in require at /opt/rt3/bin/mason_handler.fcgi line 54.<o:p></o:p></p><p class=MsoNormal>[Fri Sep 02 16:57:37 2011] [warn] [client myhost] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When logging into the database manually with rt_user I have no issues:<br><br>> /usr/local/mysql/bin/mysql -u rt_user -h localhost -p<o:p></o:p></p><p class=MsoNormal>Enter password:<o:p></o:p></p><p class=MsoNormal>Welcome to the MySQL monitor. Commands end with ; or \g.<o:p></o:p></p><p class=MsoNormal>Your MySQL connection id is 173<o:p></o:p></p><p class=MsoNormal>Server version: 5.5.10-log Source distribution<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Oracle is a registered trademark of Oracle Corporation and/or its<o:p></o:p></p><p class=MsoNormal>affiliates. Other names may be trademarks of their respective<o:p></o:p></p><p class=MsoNormal>owners.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>mysql><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> Also when I switch to use the perl handler things work fine:<br><br>[Fri Sep 2 21:11:29 2011] [info]: Successful login for pfincher from myhost (/opt/rt3/bin/../lib/RT/Interface/Web.pm:593)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> I am using apache v2.2.17 and mod_fcgid v2.3.6. Is there something stupid I am missing?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal>Paul<o:p></o:p></p></div></body></html>