Rt-mailgate error

I just upgrade to 1.3.74 including the dependencies (searchbuilder .33 the
newest DBD::mysql). Web works fine but when I send an e-mail in I get the
following error in the log

RT::Handle=HASH(0x8100008) no row id returned on row creation at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle/mysql.pm line 34,
line 16.
RT::Ticket=HASH(0x87cf448) ->Create couldn’t set EffectiveId: No value sent
to _Set!

RT::Handle=HASH(0x8100008) no row id returned on row creation at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle/mysql.pm line 34,
line 16.
RT::Transaction->Create couldn’t, as you didn’t specify a ticket idUse of
uninitialized value in exists at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Record/Cachable.pm line
88, line 16.
Use of uninitialized value in concatenation (.) at /opt/rt2/lib/RT/Ticket.pm
line 316, line 16.
Ticket couldn’t be created: Use of uninitialized value in numeric eq (==) at
/etc/smrsh/rt-mailgate line 192, line 16.
Use of uninitialized value in join at
/usr/lib/perl5/site_perl/5.6.0/Log/Dispatch.pm line 23, line 16.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 449, line 16.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 198.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 198.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 198.
Create failed: / /

Help is greatly appreciated. Thanks

Eric Mandel
WorldNow
(646) 435-5395 Direct
(646) 772-6161 Cell

Enabling media companies to build powerful new businesses on the Internet.

This message may contain confidential and/or privileged information.

If you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose or take any action based on this
message or any information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail and delete this
message. Thank you for your cooperation.

Update…

I just rolled back to RT-1.3.72 and i receive the same error except now, the
ticket gets created, even though a notification goes back to the requestor
saying ticket creation failed…-----Original Message-----
From: Eric Mandel [mailto:EMandel@worldnow.com]
Sent: Wednesday, May 16, 2001 6:35 PM
To: ‘rt-devel@fsck.com’
Subject: [rt-devel] rt-mailgate error

I just upgrade to 1.3.74 including the dependencies (searchbuilder .33 the
newest DBD::mysql). Web works fine but when I send an e-mail in I get the
following error in the log

RT::Handle=HASH(0x8100008) no row id returned on row creation at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle/mysql.pm line 34,
line 16.
RT::Ticket=HASH(0x87cf448) ->Create couldn’t set EffectiveId: No value sent
to _Set!

RT::Handle=HASH(0x8100008) no row id returned on row creation at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle/mysql.pm line 34,
line 16.
RT::Transaction->Create couldn’t, as you didn’t specify a ticket idUse of
uninitialized value in exists at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Record/Cachable.pm line
88, line 16.
Use of uninitialized value in concatenation (.) at /opt/rt2/lib/RT/Ticket.pm
line 316, line 16.
Ticket couldn’t be created: Use of uninitialized value in numeric eq (==) at
/etc/smrsh/rt-mailgate line 192, line 16.
Use of uninitialized value in join at
/usr/lib/perl5/site_perl/5.6.0/Log/Dispatch.pm line 23, line 16.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 449, line 16.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 198.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 198.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 198.
Create failed: / /

Help is greatly appreciated. Thanks

Eric Mandel
WorldNow
(646) 435-5395 Direct
(646) 772-6161 Cell

Enabling media companies to build powerful new businesses on the Internet.

This message may contain confidential and/or privileged information.

If you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose or take any action based on this
message or any information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail and delete this
message. Thank you for your cooperation.

Rt-devel mailing list
Rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

By ‘newest’ DBD::mysql, I’ll bet you mean the new 2.0 version…which
there’s an explicit note about in the README. it’s beta and badly
badly broken. You should manually downgrade to the latest
Msql-Mysql-modules. I guess I get to experience the joys of making
testdeps much, much smarter :confused:

    -jOn Wed, May 16, 2001 at 06:35:09PM -0400, Eric Mandel wrote:

I just upgrade to 1.3.74 including the dependencies (searchbuilder .33 the
newest DBD::mysql). Web works fine but when I send an e-mail in I get the
following error in the log

RT::Handle=HASH(0x8100008) no row id returned on row creation at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle/mysql.pm line 34,
line 16.
RT::Ticket=HASH(0x87cf448) ->Create couldn’t set EffectiveId: No value sent
to _Set!

RT::Handle=HASH(0x8100008) no row id returned on row creation at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle/mysql.pm line 34,
line 16.
RT::Transaction->Create couldn’t, as you didn’t specify a ticket idUse of
uninitialized value in exists at
/usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Record/Cachable.pm line
88, line 16.
Use of uninitialized value in concatenation (.) at /opt/rt2/lib/RT/Ticket.pm
line 316, line 16.
Ticket couldn’t be created: Use of uninitialized value in numeric eq (==) at
/etc/smrsh/rt-mailgate line 192, line 16.
Use of uninitialized value in join at
/usr/lib/perl5/site_perl/5.6.0/Log/Dispatch.pm line 23, line 16.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 449, line 16.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 198.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 198.
Use of uninitialized value in concatenation (.) at /etc/smrsh/rt-mailgate
line 198.
Create failed: / /

Help is greatly appreciated. Thanks

Eric Mandel
WorldNow
(646) 435-5395 Direct
(646) 772-6161 Cell

Enabling media companies to build powerful new businesses on the Internet.

This message may contain confidential and/or privileged information.
If you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose or take any action based on this
message or any information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail and delete this
message. Thank you for your cooperation.


Rt-devel mailing list
Rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

IP networks were intended to survive nuclear attack, but 12 year old
kids with PCs were not part of the threat model. – mycroft

Scenario

mail.rocketlogix.com recieves mail, then forward onto
typhoon.rocketlogix.com. This worked fine under rt1.07; however I upgreded
to rt 2.0.8 and i keep getting the following error.I have modified my
symlimk to /opt/rt2/etc

he original message was received at Wed, 14 Nov 2001 07:32:33 -0600
from mail.rocketlogix.com [10.1.1.45]

----- The following addresses had permanent fatal errors -----
“|/etc/smrsh/rt-mailgate --queue general --action correspond”
(reason: 2)
(expanded from: support@typhoon.rocketlogix.com)

----- Transcript of session follows -----
Can’t locate config.pm in @INC (@INC contains: /opt/rt2/etc /opt/rt2/lib
/usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl .) at /opt/rt2/lib/RT/Interface/Email.pm line 96.

BEGIN failed–compilation aborted at /opt/rt2/lib/RT/Interface/Email.pm line
96.
Compilation failed in require at /etc/smrsh/rt-mailgate line 17.
BEGIN failed–compilation aborted at /etc/smrsh/rt-mailgate line 17.
554 5.3.0 “|/etc/smrsh/rt-mailgate --queue general --action correspond”…
unknown mailer error 2

----- Original message follows -----

Return-Path: todd.glasgow@rlxtechnologies.com
Received: from mail.rocketlogix.com (mail.rocketlogix.com [10.1.1.45])
by typhoon.rocketlogix.com (8.11.2/8.11.2) with ESMTP id
fAEDWX202698
for support@typhoon.rocketlogix.com; Wed, 14 Nov 2001 07:32:33
-0600
Received: by mail.rocketlogix.com with Internet Mail Service (5.5.2653.19)
id ; Wed, 14 Nov 2001 07:43:49 -0600
Message-ID: 89059DB5E4DDD31194A700902798D6B70150A63E@mail.rocketlogix.comFrom: Todd Glasgow todd.glasgow@rlxtechnologies.com
To: Customer Support support@rlxtechnologies.com
Subject: Test
Date: Wed, 14 Nov 2001 07:43:39 -0600
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain

Test

Any Ideas?

Todd Glasgow
“out of clever sayings…”

Sounds like your rt-mailgate has lost its setgid bit.On Wed, Nov 14, 2001 at 07:49:04AM -0600, todd.glasgow@rlxtechnologies.com wrote:

Scenario

mail.rocketlogix.com recieves mail, then forward onto
typhoon.rocketlogix.com. This worked fine under rt1.07; however I upgreded
to rt 2.0.8 and i keep getting the following error.I have modified my
symlimk to /opt/rt2/etc

he original message was received at Wed, 14 Nov 2001 07:32:33 -0600
from mail.rocketlogix.com [10.1.1.45]

----- The following addresses had permanent fatal errors -----
“|/etc/smrsh/rt-mailgate --queue general --action correspond”
(reason: 2)
(expanded from: support@typhoon.rocketlogix.com)

----- Transcript of session follows -----
Can’t locate config.pm in @INC (@INC contains: /opt/rt2/etc /opt/rt2/lib
/usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl .) at /opt/rt2/lib/RT/Interface/Email.pm line 96.

BEGIN failed–compilation aborted at /opt/rt2/lib/RT/Interface/Email.pm line
96.
Compilation failed in require at /etc/smrsh/rt-mailgate line 17.
BEGIN failed–compilation aborted at /etc/smrsh/rt-mailgate line 17.
554 5.3.0 “|/etc/smrsh/rt-mailgate --queue general --action correspond”…
unknown mailer error 2

----- Original message follows -----

Return-Path: todd.glasgow@rlxtechnologies.com
Received: from mail.rocketlogix.com (mail.rocketlogix.com [10.1.1.45])
by typhoon.rocketlogix.com (8.11.2/8.11.2) with ESMTP id
fAEDWX202698
for support@typhoon.rocketlogix.com; Wed, 14 Nov 2001 07:32:33
-0600
Received: by mail.rocketlogix.com with Internet Mail Service (5.5.2653.19)
id ; Wed, 14 Nov 2001 07:43:49 -0600
Message-ID: 89059DB5E4DDD31194A700902798D6B70150A63E@mail.rocketlogix.com
From: Todd Glasgow todd.glasgow@rlxtechnologies.com
To: Customer Support support@rlxtechnologies.com
Subject: Test
Date: Wed, 14 Nov 2001 07:43:39 -0600
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain

Test

Any Ideas?

Todd Glasgow
“out of clever sayings…”


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.

I am receiving an error whenever I send in a message to rt-mailgate. I ran
the following command (Note: “spamcop” is my email message for testing
purposes):

cat spamcop | /usr/local/rt3/bin/rt-mailgate --action correspond --url
http://X.XX.XXX.XXX --debug --queue General

The ticket IS created in RT, but I receive the following message in the
console:

Connecting to http://X.XX.XXX.XXX/REST/1.0/NoAuth/mail-gateway at
/usr/local/rt3/bin/rt-mailgate line 444, <> chunk 1.
Inside Unless
Should have added value
ok
Ticket: 153
Queue:
Owner: Nobody
Status:
Subject:
Requestor:
RT server error.

The RT server which handled your email did not behave as expected. It
said:

Inside Unless <====== (This is my
problem)
Should have added value <====== (This is my problem
ok
Ticket: 153
Queue:
Owner: Nobody
Status:
Subject:
Requestor:

I have determined that the two lines (indicated by the arrows) is the cause
of the error. I went into rt-mailgate to locate the source of the message
and found that the whole lower block is contained in “$content”, but I can’t
seem to find where the lines “Inside Unless” and “Should have added value”
have been inserted into “$content”.

Any thoughts?

-Phil Shon

Another follow up:

Just thought I should put this out there on the mailing list in case someone
runs into again.

In the web interface I had created some user defined actions. To debug the
scrip I had used print statements saying “Inside Unless” and “Should have
added value” Apparently those print statements were sending those lines
into ‘$content’.

I thought I should share my solution since I shared my problem.

-Phil ShonFrom: “Philip Shon” crazypheel@hotmail.com
To: rt-users@lists.bestpractical.com
Sent: Wednesday, July 14, 2004 12:43 PM
Subject: Re: rt-mailgate error

A follow up:

I tried running the same command again

strange thing happened, the line “Should have added value” has
disappeared.

But I’m still getting an error b/c “Inside Unless” is still there.

Maybe that’ll disappear in about an hour or so :slight_smile:

-Phil Shon

----- Original Message -----
From: “Philip Shon” crazypheel@hotmail.com
To: rt-users@lists.bestpractical.com
Sent: Wednesday, July 14, 2004 8:47 AM
Subject: rt-mailgate error

I am receiving an error whenever I send in a message to rt-mailgate. I
ran
the following command (Note: “spamcop” is my email message for testing
purposes):

cat spamcop | /usr/local/rt3/bin/rt-mailgate --action correspond --url
http://X.XX.XXX.XXX --debug --queue General

The ticket IS created in RT, but I receive the following message in the
console:

Connecting to http://X.XX.XXX.XXX/REST/1.0/NoAuth/mail-gateway at
/usr/local/rt3/bin/rt-mailgate line 444, <> chunk 1.
Inside Unless
Should have added value
ok
Ticket: 153
Queue:
Owner: Nobody
Status:
Subject:
Requestor:
RT server error.

The RT server which handled your email did not behave as expected. It
said:

Inside Unless <====== (This is my
problem)
Should have added value <====== (This is my problem
ok
Ticket: 153
Queue:
Owner: Nobody
Status:
Subject:
Requestor:

I have determined that the two lines (indicated by the arrows) is the
cause
of the error. I went into rt-mailgate to locate the source of the
message
and found that the whole lower block is contained in “$content”, but I
can’t
seem to find where the lines “Inside Unless” and “Should have added
value”
have been inserted into “$content”.

Any thoughts?

-Phil Shon

A follow up:

I tried running the same command again

strange thing happened, the line “Should have added value” has disappeared.

But I’m still getting an error b/c “Inside Unless” is still there.

Maybe that’ll disappear in about an hour or so :slight_smile:

-Phil ShonFrom: “Philip Shon” crazypheel@hotmail.com
To: rt-users@lists.bestpractical.com
Sent: Wednesday, July 14, 2004 8:47 AM
Subject: rt-mailgate error

I am receiving an error whenever I send in a message to rt-mailgate. I
ran
the following command (Note: “spamcop” is my email message for testing
purposes):

cat spamcop | /usr/local/rt3/bin/rt-mailgate --action correspond --url
http://X.XX.XXX.XXX --debug --queue General

The ticket IS created in RT, but I receive the following message in the
console:

Connecting to http://X.XX.XXX.XXX/REST/1.0/NoAuth/mail-gateway at
/usr/local/rt3/bin/rt-mailgate line 444, <> chunk 1.
Inside Unless
Should have added value
ok
Ticket: 153
Queue:
Owner: Nobody
Status:
Subject:
Requestor:
RT server error.

The RT server which handled your email did not behave as expected. It
said:

Inside Unless <====== (This is my
problem)
Should have added value <====== (This is my problem
ok
Ticket: 153
Queue:
Owner: Nobody
Status:
Subject:
Requestor:

I have determined that the two lines (indicated by the arrows) is the
cause
of the error. I went into rt-mailgate to locate the source of the message
and found that the whole lower block is contained in “$content”, but I
can’t
seem to find where the lines “Inside Unless” and “Should have added value”
have been inserted into “$content”.

Any thoughts?

-Phil Shon

Philip Shon wrote:

Another follow up:

Just thought I should put this out there on the mailing list in case someone
runs into again.

In the web interface I had created some user defined actions. To debug the
scrip I had used print statements saying “Inside Unless” and “Should have
added value” Apparently those print statements were sending those lines
into ‘$content’.
:slight_smile:
If you wish to log something from scrip you can use:
$RT::Logger->(“Message here goes”);
Best regards. Ruslan.

I’m getting the following error.
—Paste—
Command output: RT server error.
The RT server which handled your email did not behave as expected.
It said:
temporary failure - RT couldn’t find the queue: general
—End Paste—

I have renamed the General queue to 01-General so that it always
appears first and as the default queue. This error would have been
generated by a reply to an update, so it appears that the queue is
hardcoded somewhere. Where/how do I correct this so that RT uses the
correct queue name?

You can use the DefaultQueue option in 3.8 to do that without renaming
anything.

You hardcode the name of the queue wherever it is that you invoke rt-
mailgate,
typically this would be /etc/aliases or a procmail script, possible a
fetchmail invocation

-kevin

Thanks all. Got it.

Kevin W. Gagel
Network Administrator
Local 5448
My blog:
http://mail.cnc.bc.ca/blogs/gagel
My shared files:
http://mail.cnc.bc.ca/users/gagel--- Original message —
Subject: Re: [rt-users] rt-mailgate error
From: Kevin Falcone falcone@bestpractical.com
To: RT Users RT-Users@lists.bestpractical.com
Date: 06/07/2009 10:02 AM

On Jul 6, 2009, at 12:53 PM, Kevin Gagel wrote:

I’m getting the following error.
—Paste—
Command output: RT server error.
The RT server which handled your email did not behave as expected.
It said:
temporary failure - RT couldn’t find the queue: general
—End Paste—

I have renamed the General queue to 01-General so that it always
appears first and as the default queue. This error would have been
generated by a reply to an update, so it appears that the queue is
hardcoded somewhere. Where/how do I correct this so that RT uses the
correct queue name?

You can use the DefaultQueue option in 3.8 to do that without renaming anything.

You hardcode the name of the queue wherever it is that you invoke rt- mailgate,
typically this would be /etc/aliases or a procmail script, possible a fetchmail invocation

-kevin
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help:http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media. Buy a copy athttp://rtbook.bestpractical.com

Hi, all.

If my rt.log is telling me the below, what this suggests me?

procmail: Executing
“rt-mailgate,–debug,–queue,general,–action,correspond,–url,https://rtracker.rt.pop-sp.rnp.br/rt
Connecting to
https://rtracker.rt.pop-sp.rnp.br/rt/REST/1.0/NoAuth/mail-gateway at
/usr/bin/rt-mailgate line 102, <> line 1.
An Error Occurred

Hugs,

Wagner Pereira

PoP-SP/RNP - Ponto de Presen�a da RNP em S�o Paulo
CCE/USP - Centro de Computa��o Eletr�nica da Universidade de S�o Paulo
http://www.pop-sp.rnp.br
Tel. (11) 3091-8901

I’ve got just about everything setup with the exception of
rt-mailgate. I’m not sure if this is an abnormal setup but I’ve got a
forward facing MTA that contains an alias for my RT address which is
forwards to the RT maching internally called ‘services’. I use a basic
sendmail setup with a unix user called ‘rt’ that contains a .forward
file with the rt-mailgate pipe in it.

Below is the error I receive back from sendmail on the ‘services’
machine. I have 2 questions about this

  1. What is causing the error. Is it the setup I have?
  2. Do I need to reconfigure RT to understand that the MTA receiving
    the mail for RT is services.censored.com? Or will it respect the
    original address the mail was sent to?

I’ve tried to google the error message but it seems there are quite a
few things that can cause this and I can’t seem to find a post that
matches mine.

The original message was received at Mon, 9 Aug 2010 11:41:26 -0700
from [10.2.0.54]

----- The following addresses had permanent fatal errors -----
|/www/php5/rt.censored.com/rt/bin/rt-mailgate --queue general --action
correspond --url http://rt.censored.com/
(reason: Can’t create output)
(expanded from: rt@services.censored.com)

----- Transcript of session follows -----
550 5.0.0 |/www/php5/rt.censored.com/rt/bin/rt-mailgate --queue
general --action correspond --url http://rt.censored.com/… Can’t
create output

Final-Recipient: RFC822; rt@services.censored.com
X-Actual-Recipient: X-Unix; //rt.censored.com/
Action: failed
Status: 5.3.0
Diagnostic-Code: X-Unix; 73
Last-Attempt-Date: Mon, 9 Aug 2010 11:41:28 -0700---------- Forwarded message ----------
From: lord nynex lordnynex@gmail.com
To: rt@censored.com
Date: Mon, 9 Aug 2010 11:41:26 -0700
Subject: test ticket
test ticket

-Nynex

Hi rt-users

I am trying to install rt 4.2.6 and I am getting this error when I send
email to rt-mailgate.
I am using

 centos 6.5
 postfix
 rt 4.2.6 with smime enabled
 https

Can anyone help point me to what might be wrong?

Thanks,
-Dan

(temporary failure. Command output: RT server error. The RT server which
handled your email did not behave as expected. It said:

Login
Best Practical Solutions, LLC corporate logo RT for rt-de.mars.com
Skip Menu | Not logged in.

Login

Login 4.2.6
Username:
Password:


Time to display: 0.017673

»|« RT 4.2.6 Copyright 1996-2014 Best Practical Solutions, LLC.

Distributed under version 2 of the GNU GPL.
To inquire about support, training, custom development or licensing, please contact sales@bestpractical.com.

)

Hi rt-users

I am trying to install rt 4.2.6 and I am getting this error when I send
email to rt-mailgate.
I am using

 centos 6.5
 postfix
 rt 4.2.6 with smime enabled
 https

Can anyone help point me to what might be wrong?

What aliases line are you using? That is, how are you calling rt-mailgate?

  • Alex

That was the tip I needed, I had a trailing /rt/, which was incorrect, on
on my mailgate --url

Thanks!On Fri, Jul 18, 2014 at 2:37 PM, Alex Vandiver alexmv@bestpractical.com wrote:

On 07/18/2014 05:23 PM, Dan Mcqueen wrote:

Hi rt-users

I am trying to install rt 4.2.6 and I am getting this error when I send
email to rt-mailgate.
I am using

 centos 6.5
 postfix
 rt 4.2.6 with smime enabled
 https

Can anyone help point me to what might be wrong?

What aliases line are you using? That is, how are you calling rt-mailgate?

  • Alex