[rt-users] rt-mailgate, smrsh, sendmail and attachments

scottchamings at gmail.com scottchamings at gmail.com
Tue Oct 25 23:32:31 EDT 2005


Hi,

When attachments are send through to RT, the job is created but no
attachment to the job.

We are running RT 3.0.10 on Fedora Core 1.

mailq shows:

 /var/spool/mqueue (1 request)
-----Q-ID----- --Size-- -----Q-Time----- ------------Sender/Recipient-----------
j9Q2Fh9l016697  3395073 Wed Oct 26 11:45 <private at sonowsnipped.com>
                 (Deferred: prog mailer (/usr/sbin/smrsh) exited with EX_TEMPF)
                                         "|/opt/rt3/bin/rt-mailgate --queue gen
                Total requests: 1

The syslog contains:

Oct 26 12:51:59 helpdesk RT: RT::Handle=HASH(0xa811440) couldn't
execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=? ' at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 417. 
(/opt/rt3/lib/RT.pm:247)
Oct 26 12:51:59 helpdesk RT: DBD::mysql::st execute failed: MySQL
server has gone away at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 410. 
(/opt/rt3/lib/RT.pm:247)
Oct 26 12:51:59 helpdesk RT: RT::Handle=HASH(0xa811440) couldn't
execute the query 'UPDATE Tickets SET LastUpdated=? WHERE id=? ' at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 417. 
(/opt/rt3/lib/RT.pm:247)
Oct 26 12:51:59 helpdesk RT: DBD::mysql::st execute failed: MySQL
server has gone away at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 410. 
(/opt/rt3/lib/RT.pm:247)
Oct 26 12:51:59 helpdesk RT: RT::Handle=HASH(0xa811440) couldn't
execute the query 'SELECT ACL.id from ACL, Groups, Principals,
CachedGroupMembers WHERE  (ACL.RightName = 'SuperUser' OR 
ACL.RightName = 'SeeQueue') AND Principals.Disabled = 0 AND
CachedGroupMembers.Disabled = 0  AND Principals.id = Groups.id AND 
Principals.id = CachedGroupMembers.GroupId AND
CachedGroupMembers.MemberId = '1' AND ( ACL.ObjectType = 'RT::System'
OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND ( ( 
ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND
(Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR
Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) ) 
LIMIT 1' at /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
line 417.  (/opt/rt3/lib/RT.pm:247)
Oct 26 12:51:59 helpdesk RT: DBD::mysql::st execute failed: MySQL
server has gone away at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 410. 
(/opt/rt3/lib/RT.pm:247)
Oct 26 12:51:59 helpdesk RT: RT::Handle=HASH(0xa811440) couldn't
execute the query 'SELECT ACL.id from ACL, Groups, Principals,
CachedGroupMembers WHERE  (ACL.RightName = 'SuperUser' OR 
ACL.RightName = 'SeeQueue') AND Principals.Disabled = 0 AND
CachedGroupMembers.Disabled = 0  AND Principals.id = Groups.id AND 
Principals.id = CachedGroupMembers.GroupId AND
CachedGroupMembers.MemberId = '1' AND ( ACL.ObjectType = 'RT::System'
OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '1')) AND  (
((Groups.Domain = 'RT::Queue-Role' AND Groups.Instance = 1)  )  AND
Groups.Type = ACL.PrincipalType AND Groups.Id = Principals.id AND
Principals.PrincipalType = 'Group')  LIMIT 1' at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 417. 
(/opt/rt3/lib/RT.pm:247)
Oct 26 12:51:59 helpdesk RT: Ticket 3624 created in queue '' by
private at sosnipped.com (/opt/rt3/lib/RT/Ticket_Overlay.pm:640)


Any ideas?  I have tried a fix I found reagrding doing a symlink from
/usr/bin to rt-mailgate etc but no difference so far....

Thanks

Scott



More information about the rt-users mailing list