<html><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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@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></head><body lang="EN-US" link="blue" vlink="purple"><div class="WordSection1"><p class="MsoNormal">Hi,</p><p class="MsoNormal"> </p><p class="MsoNormal">Upgraded from a working RT 4.0.0 installation to 4.0.7. E-mail processing w/ rt-mailgate works 30% of the time. I’ve been through the install and upgrade docs and I don’t see a step that I have missed. I’ve run the upgrade utility against the database and no errors were reported. </p>
<p class="MsoNormal"> </p><p class="MsoNormal">Here is the output of a working call to rt-mailgate which successfully generates a ticket:</p><p class="MsoNormal"> </p><p class="MsoNormal" style="margin-left:.5in">cat /tmp/test | /var/www/rt/bin/rt-mailgate --debug --queue Support --action correspond --url <a href="http://rt">http://rt</a></p>
<p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal" style="margin-left:.5in">/var/www/rt/bin/rt-mailgate: temp file is '/tmp/VyNUuzDC71/yMNeSbTNLG'</p><p class="MsoNormal" style="margin-left:.5in">
/var/www/rt/bin/rt-mailgate: connecting to <a href="http://rt/REST/1.0/NoAuth/mail-gateway">http://rt/REST/1.0/NoAuth/mail-gateway</a></p><p class="MsoNormal" style="margin-left:.5in">okTicket: 105913Queue: Owner: NobodyStatus: Subject: Requestor:</p>
<p class="MsoNormal"> </p><p class="MsoNormal">However, at other times I run the command and mailgate will die at either User.pm or Principal.pm:</p><p class="MsoNormal"> </p><p class="MsoNormal" style="margin-left:.5in">
cat /tmp/test | /var/www/rt/bin/rt-mailgate --debug --queue Support --action correspond --url <a href="http://rt">http://rt</a></p><p class="MsoNormal" style="margin-left:.5in">/var/www/rt/bin/rt-mailgate: temp file is '/tmp/kJGZbU3Fpg/CL0uaMl5Cq'</p>
<p class="MsoNormal" style="margin-left:.5in">/var/www/rt/bin/rt-mailgate: connecting to <a href="http://rt/REST/1.0/NoAuth/mail-gateway">http://rt/REST/1.0/NoAuth/mail-gateway</a></p><p class="MsoNormal" style="margin-left:.5in">
Not a CODE reference at /var/www/rt/sbin/../lib/RT/User.pm line 1112.</p><p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal" style="margin-left:.5in">Stack:</p><p class="MsoNormal" style="margin-left:.5in">
[/var/www/rt/sbin/../lib/RT/User.pm:1112]</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/User.pm:1206]</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/Ticket.pm:284]</p>
<p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/Interface/Email.pm:1530]</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/share/html/REST/1.0/NoAuth/mail-gateway:61]</p><p class="MsoNormal" style="margin-left:.5in">
</p><p class="MsoNormal" style="margin-left:.5in">RT server error.</p><p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal" style="margin-left:.5in">The RT server which handled your email did not behave as expected. It</p>
<p class="MsoNormal" style="margin-left:.5in">said:</p><p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal" style="margin-left:.5in">Not a CODE reference at /var/www/rt/sbin/../lib/RT/User.pm line 1112.</p>
<p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal" style="margin-left:.5in">Stack:</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/User.pm:1112]</p><p class="MsoNormal" style="margin-left:.5in">
[/var/www/rt/sbin/../lib/RT/User.pm:1206]</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/Ticket.pm:284]</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/Interface/Email.pm:1530]</p>
<p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/share/html/REST/1.0/NoAuth/mail-gateway:61]</p><p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal">And here it dies at Principal.pm:</p><p class="MsoNormal">
</p><p class="MsoNormal" style="margin-left:.5in">cat /tmp/test | /var/www/rt/bin/rt-mailgate --queue Support --action correspond --url <a href="http://rt">http://rt</a></p><p class="MsoNormal" style="margin-left:.5in">RT server error.</p>
<p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal" style="margin-left:.5in">The RT server which handled your email did not behave as expected. It</p><p class="MsoNormal" style="margin-left:.5in">said:</p>
<p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal" style="margin-left:.5in">DBD::mysql::db selectcol_arrayref failed: MySQL server has gone away at /var/www/rt/sbin/../lib/RT/Principal.pm line 621.</p>
<p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal" style="margin-left:.5in">Stack:</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/Principal.pm:621]</p><p class="MsoNormal" style="margin-left:.5in">
[/var/www/rt/sbin/../lib/RT/Principal.pm:531]</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/Principal.pm:447]</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/Principal.pm:330]</p>
<p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/User.pm:1206]</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/Queue.pm:1289]</p><p class="MsoNormal" style="margin-left:.5in">
[/var/www/rt/sbin/../lib/RT/Queue.pm:1245]</p><p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/sbin/../lib/RT/Queue.pm:1223]</p><p class="MsoNormal" style="margin-left:.5in"> [/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm:423]</p>
<p class="MsoNormal" style="margin-left:.5in"> [/var/www/rt/share/html/REST/1.0/NoAuth/mail-gateway:66]</p><p class="MsoNormal" style="margin-left:.5in"> </p><p class="MsoNormal">Any thoughts?</p><p class="MsoNormal"> </p>
<p class="MsoNormal">Damian</p></div></body></html>