The mailing list for listmasters using Sympa

[Gonzalo Palacios Goicolea <address@concealed>]

Hi All,

 

I tried the test and it showed me a limit of 14700Kb, after that I changed the max_allowed_packet to 32 Mb and ran again the test, showing a limit of al least 21 Mb.

I did some probes and know it’s working correctly.

Thanks very much all for your kindly help

 

Gonzalo

 

De: address@concealed [mailto:address@concealed] En nombre de Ibirisol Fontes Ferreira
Enviado el: jueves, 11 de abril de 2013 14:50
Para: address@concealed
Asunto: Re: [sympa-users] Sympa do not get 'max_allowed_packet' correctly

 

Hi there,

Is easy verify if the modification is working, login in sympa database and execute:

show variables like 'net_buffer_length';

show variables like 'max_allowed_packet';

See the link bellow (another msg of a participant) to know this variables and default values.

Bye,

On 11-04-2013 05:16, Matt Taggart wrote:

Gonzalo Palacios Goicolea writes:

Thanks for your response, it clarified me at the attachment increased size

issue.

Knowing that, why if I have a 'max_allowed_packet' of 20 Mb, sympa database

 is rejecting a 18 Mb email?

Ah I did not read your original email closely enough and didn't realize 

that.

The error in your original message seems to indicate you are running into 

the mysql limit rather than postfix (which might still limit but that would 

happen later) or sympa.

I don't know how sympa stores the message in the database but maybe there 

is some additional metadata/headers that are inflating it?  Maybe David or 

others can comment...

What happens if you set the mysql max_allowed_packet to something much 

larger like 32mb? Also did you try the test listed at

http://www.sympa.org/manual/database#required_tunning_of_database

-- 

Atenciosamente,

Ibirisol Fontes Ferreira

P Please consider the environment before printing this e-mail.

---

This message including any attachments may contain confidential information, according to our Information Security Management System, and intended solely for a specific individual to whom they are addressed. Any unauthorised copy, disclosure or distribution of this message is strictly forbidden. If you have received this transmission in error, please notify the sender immediately and delete it.

---

Este mensaje, y en su caso, cualquier fichero anexo al mismo, puede contener información clasificada por su emisor como confidencial en el marco de su Sistema de Gestión de Seguridad de la Información siendo para uso exclusivo del destinatario, quedando prohibida su divulgación copia o distribución a terceros sin la autorización expresa del remitente. Si Vd. ha recibido este mensaje erróneamente, se ruega lo notifique al remitente y proceda a su borrado. Gracias por su colaboración.

---

Esta mensagem, incluindo qualquer ficheiro anexo, pode conter informação confidencial, de acordo com nosso Sistema de Gestão de Segurança da Informação, sendo para uso exclusivo do destinatário e estando proibida a sua divulgação, cópia ou distribuição a terceiros sem autorização expressa do remetente da mesma. Se recebeu esta mensagem por engano, por favor avise de imediato o remetente e apague-a. Obrigado pela sua colaboração.

---