[rt-users] Attachments > 1MB creates multiple tickets

[Danie Marais]

Patrick,

I found this in /etc/my.cnf:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable=max_allowed_packet=10M

Does that look right?   Is there a command in mysql that I can use to check
the value of that when mysqld is running? (running mysql-3.23.58-1.9)

Thanks
Danie
----- Original Message ----- 
From: "Patrick LeBoutillier" <patl at fusemail.com>
To: "Danie Marais" <danie.marais at attix5.com>
Cc: <rt-users at lists.bestpractical.com>
Sent: Friday, February 06, 2004 3:43 PM
Subject: Re: [rt-users] Attachments > 1MB creates multiple tickets


> If you are on MySQL, check for this setting in /etc/my.cnf:
>
> max_allowed_packet = 1M
>
> This will cause an error when trying to insert stuff larger than 1M.
>
> Patrick
>
> On Fri, 2004-02-06 at 04:36, Danie Marais wrote:
> > Hi,
> >
> > Whenever someone sends a mail to RT which contains an attachment larger
than
> > 1MB it creates 10 tickets (or 10 entries on the current ticket).
> >
> > What seems to happen is that the mail from sendmail goes into RT
> > successfully but for some reason sendmail thinks it has failed and then
> > sends it again (for a total of 10 times).  When I look in the sendmail
queue
> > the error message is EX_TEMPFAIL.
> >
> > Feb  6 11:09:06 xxx sendmail[24610]: i16711t6023958:
> > to="|/opt/rt3/bin/rt-mailgate --queue
> > support --action correspond --url http://localhost/",
ctladdr=rt at xxx.xxx.xxx
> > (8/0), de
> > lay=02:08:04, xdelay=00:03:01, mailer=prog, pri=1822920, dsn=4.0.0,
> > stat=Deferred: prog mailer (/usr/sbin/smrsh) exited with EX_TEMPFAIL
> >
> > RT settings regarding attachments are:
> >
> > Set($MaxAttachmentSize , 10000000);
> > Set($TruncateLongAttachments , undef);
> > Set($DropLongAttachments , undef);
> >
> > Any ideas?
> >
> > (RH9, RT3.0.8, Perl 5.8.1, http-2.0.47)
> >
> > Thanks
> > Danie Marais
> >
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.bestpractical.com
> > http://lists.bestpractical.com/mailman/listinfo/rt-users
> >
> > Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm