<div dir="ltr">I forgot to add, line 19 of my apache config is <b>use Place::Handler::Apache2;</b></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Jan 26, 2014 at 10:11 PM, Brian Hardy <span dir="ltr"><<a href="mailto:bhardy.security@gmail.com" target="_blank">bhardy.security@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello,<div><br></div><div>I've installed RT 4.0.19 and RTIR 3.0 on Ubuntu Server 12.04 in a VM. When I installed RT and rebooted to test, Apache/MySql both came up and I could connect to the web server. However, once I installed RTIR 3 and rebooted, I could not connect to the web server and apache is not running. It appears that apache boots before mysql and this causes an error. I'm getting the following syslog error as well, any assistance would be appreciated.</div>
<div><br></div><div>Thanks,</div><div><br></div><div>Brian</div><div><br></div><div><b>This is my boot.log that shows apache failing because of line 19 of my apache config file (which is a copy/paste from the RT documentation):</b></div>
<div><br></div><div><br></div><div><b>boot.log</b></div><div><p style="margin:0px;font-size:11px;font-family:Menlo">fsck from util-linux 2.20.1</p>
<p style="margin:0px;font-size:11px;font-family:Menlo">/dev/sda1: clean, 84217/1245184 files, 509249/4980480 blocks</p>
<p style="margin:0px;font-size:11px;font-family:Menlo">Skipping profile in /etc/apparmor.d/disable: usr.sbin.rsyslogd</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> * Starting AppArmor profiles [ OK ] </p>
<p style="margin:0px;font-size:11px;font-family:Menlo">[1087] [Mon Jan 27 02:59:21 2014] [warning]: DBI connect('dbname=rt4;host=localhost','rt_user',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105. (/usr/local/share/perl/5.14.2/Carp.pm:168)</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"> </p>
<p style="margin:0px;font-size:11px;font-family:Menlo">RT couldn't connect to the database where tickets are stored.</p>
<p style="margin:0px;font-size:11px;font-family:Menlo">If this is a new installation of RT, you should visit the URL below</p>
<p style="margin:0px;font-size:11px;font-family:Menlo">to configure RT and initialize your database.</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"><br></p>
<p style="margin:0px;font-size:11px;font-family:Menlo">If this is an existing RT installation, this may indicate a database</p>
<p style="margin:0px;font-size:11px;font-family:Menlo">connectivity problem.</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"><br></p>
<p style="margin:0px;font-size:11px;font-family:Menlo">The error RT got back when trying to connect to your database was:</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"><br></p>
<p style="margin:0px;font-size:11px;font-family:Menlo">Connect Failed Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> at /opt/rt4/sbin/../lib/RT.pm line 211.</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"><br></p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"><br></p>
<p style="margin:0px;font-size:11px;font-family:Menlo">[1087] [Mon Jan 27 02:59:21 2014] [warning]: DBI connect('dbname=rt4;host=localhost','rt_user',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105. (/usr/local/share/perl/5.14.2/Carp.pm:168)</p>
<p style="margin:0px;font-size:11px;font-family:Menlo">Syntax error on line 19 of /etc/apache2/sites-enabled/rt:</p>
<p style="margin:0px;font-size:11px;font-family:Menlo">Can't call method "CaseSensitive" on an undefined value at /opt/rt4/sbin/../lib/RT/Record.pm line 375.\nCompilation failed in require at /opt/rt4/sbin/../lib/RT.pm line 732.\n</p>
<p style="margin:0px;font-size:11px;font-family:Menlo">Action 'start' failed.</p>
<p style="margin:0px;font-size:11px;font-family:Menlo">The Apache error log may have more information.</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> * Starting web server apache2 [<span style="color:rgb(195,55,32)">fail</span>] </p></div><div><br></div><div><br></div><div>
<b>/etc/apache2/sites-available/rt</b></div><div><p style="margin:0px;font-size:11px;font-family:Menlo"><VirtualHost *:80></p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> ### Optional apache logs for RT</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> # ErrorLog /opt/rt4/var/log/apache2.error</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> # TransferLog /opt/rt4/var/log/apache2.access</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> # LogLevel debug</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"><br></p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> AddDefaultCharset UTF-8</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"><br></p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> DocumentRoot "/opt/rt4/share/html"</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> <Location /></p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> Order allow,deny</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> Allow from all</p>
<p style="margin:0px;font-size:11px;font-family:Menlo;min-height:13px"><br></p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> SetHandler modperl</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> PerlResponseHandler Plack::Handler::Apache2</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> PerlSetVar psgi_app /opt/rt4/sbin/rt-server</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> </Location></p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> <Perl></p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> use Plack::Handler::Apache2;</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> </Perl></p>
<p style="margin:0px;font-size:11px;font-family:Menlo"> </VirtualHost></p></div><div><br></div><div><br></div><div><b>/var/log/syslog</b></div><div><p style="margin:0px;font-size:11px;font-family:Menlo"><span style="color:rgb(213,59,211)">syslog</span><span style="color:rgb(52,187,199)">:</span>Jan 26 21:59:21 ubuntu <span style="color:rgb(195,55,32)"><b>RT:</b></span> [1087] DBI connect('dbname=rt4;host=localhost','rt_user',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.</p>
<p style="margin:0px;font-size:11px;font-family:Menlo"><span style="color:rgb(213,59,211)">syslog</span><span style="color:rgb(52,187,199)">:</span>Jan 26 21:59:21 ubuntu <span style="color:rgb(195,55,32)"><b>RT:</b></span> [1087] DBI connect('dbname=rt4;host=localhost','rt_user',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 105.</p>
</div></div>
</blockquote></div><br></div>