The mailing list for listmasters using Sympa

["McLaren, Terrence M" <address@concealed>]

Steve - After doing some more digging, I found the reason to be related to a mySQL config issue.  Previously, I had max_allowed_packet set to 10MB in the .my.cnf which caused an sql write error since the message was over the limit.  I changed it to 64MB and the dB was happy.  She’s happy, I’m happy….   

 

I can report the reply to message for our self-imposed 10MB “sympa message size limit” is now working as designed.

 

Best,

 

-Terry

 

 

[mysqld]

 

# Largest possible packet to be transmitted to or from the mysql server

# the client and server have their own setting

# the default on [client] is 16M, default for [mysqld] server 1MB

# max_allowed_packet = the largest packet that can be transmitted to or from mysql

# min=1024, max=1GB (in multiples of 1024), default=1048576 (1MB)

max_allowed_packet = 64M

 

 

From: Steve Shipway [mailto:address@concealed]
Sent: Tuesday, June 09, 2015 3:19 PM
To: McLaren, Terrence M
Subject: RE: Unable to send template error

 

My guess would be that the message_report.tt2 file has a TT2 syntax error, so the TT2 parsing is ending with an error.

It seems unlikely that the message file is too large for the bulk table (unless it is notifying about a huge message that is then attached to this one), or that the sendmail is returning a fail, and you have already checked permissions.

Steve

 

Steve Shipway

University of Auckland ITS

UNIX Systems Design Lead

address@concealed

Ph: +64 9 373 7599 ext 86487

 

---

From: McLaren, Terrence M [address@concealed]
Sent: Wednesday, 10 June 2015 6:48 a.m.
To: Steve Shipway
Subject: Unable to send template error

Hi Steve – Have you seen this before?  Do you have any idea what might be causing the server to thrown the following log messages?

 

The tt2 files are in the appropriate directories with the correct permissions.

 

-Terry McLaren

 

 

From: McLaren, Terrence M
Sent: Tuesday, June 02, 2015 4:37 PM
To: address@concealed
Subject: reject_report_msg fails for messages that exceed max file size

 

We’re noticing the reply message from Sympa to the user fails to be sent to postfix when a sender sends an email that exceeds max file size limit.

error : Got a packet bigger than 'max_allowed_packet' bytes

 

Sympa appears to try to send the message, throws an error and then files the message into the bad/ directory. 

 

--------

err mail::sending() Failed to store message for list blah

err List::send_file() List::send_file, could not send template /sympa/default/mail_tt2/message_report.tt2 to address@concealed

notice report::reject_report_msg() report::reject_report_msg(): Unable to send template 'message_report' to 'address@concealed'

notice Moving bad file address@concealed to bad/

---------

 

I checked permissions of the template and it has the same permissions as the others tt2 files.

-rw------- 1 sympa sympa  5184 Mar 21  2014 message_report.tt2

 

I also diffed the file with the distribution(6.1.23 & 6.1.24) and verified they are the same.

 

Has anyone else notice this behavior?  Any insight or help will be appreciated.

 

-Terry McLaren

University of Illinois