<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 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Baskerville Old Face";
panose-1:2 2 6 2 8 5 5 2 3 3;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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:"Baskerville Old Face","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;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:Consolas;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Baskerville Old Face","serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</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="Section1">
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I completely started over with a fresh installation of RT using the latest version
<span style="font-size:9.0pt;font-family:Consolas">3.8.2</span>. Following the README file that is packed with the new installation, I’m stuck at the Apache configuration. I added the lines for Apache
<span style="font-size:9.0pt;font-family:Consolas">2.x.x</span>:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"><VirtualHost your.ip.address><o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> ServerName your.rt.server.hostname<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"><o:p> </o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> DocumentRoot /opt/rt3/share/html<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> AddDefaultCharset UTF-8<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"><o:p> </o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> # optional apache logs for RT<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> # ErrorLog /opt/rt3/var/log/apache2.error<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> # TransferLog /opt/rt3/var/log/apache2.access<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"><o:p> </o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> PerlRequire "/opt/rt3/bin/webmux.pl"<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"><o:p> </o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> <Location /NoAuth/images><o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> SetHandler default<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> </Location><o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> <Location /><o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> SetHandler perl-script<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> PerlResponseHandler RT::Mason<o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"> </Location><o:p></o:p></p>
<p class="MsoPlainText" style="margin-left:1.0in"></VirtualHost><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here is my rt3.conf file settings:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas">Alias /rt3 "/usr/share/rt3/html"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"># PerlRequire /usr/sbin/webmux.pl<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"><Directory "/usr/share/rt3/html"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> AllowOverride All<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> Options ExecCGI FollowSymLinks<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> RewriteEngine On<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> RedirectMatch permanent (.*)/$ $1/index.html<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> AddDefaultCharset UTF-8<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> SetHandler perl-script<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> PerlHandler RT::Mason<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"></Directory><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"><VirtualHost 172.16.5.163><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> ServerName clehbrtsrv01.broadvox.local<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> DocumentRoot /opt/rt3/share/html<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> AddDefaultCharset UTF-8<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> # optional apache logs for RT<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> # ErrorLog /opt/rt3/var/log/apache.error<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> # TransferLog /opt/rt3/var/log/apache.error<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> PerlModule Apache::DBI<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> PerlRequire /opt/rt3/bin/webmux.pl<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> <Location /NoAuth/images><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> SetHandler default<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> </Location><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> <Location /><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> SetHandler perl-script<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> PerlHandler RT::Mason<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"> </Location><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:1.0in"><span style="font-size:10.0pt;
font-family:Consolas"></VirtualHost><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">When I restart Apache and MySql, I tried accessing the page <a href="http://clehbrtsrv01.broadvox.local/">
http://clehbrtsrv01.broadvox.local/</a> (no /rt3). I get an “Internal Server Error” due to a misconfiguration. Here is my error_log file for Apache:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">[Mon May 18 15:12:12 2009] [notice] caught SIGTERM, shutting down<o:p></o:p></p>
<p class="MsoNormal">[Mon May 18 15:16:16 2009] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)<o:p></o:p></p>
<p class="MsoNormal">[Mon May 18 15:16:19 2009] [notice] Digest: generating secret for digest authentication ...<o:p></o:p></p>
<p class="MsoNormal">[Mon May 18 15:16:19 2009] [notice] Digest: done<o:p></o:p></p>
<p class="MsoNormal">[Mon May 18 15:16:21 2009] [notice] Apache/2.2.3 (CentOS) 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">[Mon May 18 15:17:11 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n<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">[Mon May 18 15:17:14 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n<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">[Mon May 18 15:17:15 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n<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">[Mon May 18 15:17:16 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n<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">[Mon May 18 15:17:16 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n<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">[Mon May 18 15:18:15 2009] [error] [client 172.16.3.38] Connect Failed Access denied for user 'rt_user'@'localhost' (using password: YES)\n at /opt/rt3/bin/../lib/RT.pm line 204\n<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><i>Eric Chatham<o:p></o:p></i></p>
<p class="MsoNormal"><i>MIS Department<o:p></o:p></i></p>
<p class="MsoNormal"><i>Phone: (216) 373-4683<o:p></o:p></i></p>
<p class="MsoNormal"><i>Fax: (216) 373-4669<o:p></o:p></i></p>
<p class="MsoNormal"><i>echatham@broadvox.net<o:p></o:p></i></p>
<p class="MsoNormal"><img border="0" width="230" height="76" id="Picture_x0020_1" src="cid:image001.gif@01C9D7CC.691A95E0" alt="BroadvoxLogo2"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1">CONFIDENTIAL. This e-mail and any attached files are confidential and should be destroyed and/or returned if you are not the intended and proper recipient.<br>
</font>
</body>
</html>