Unable to attach a file larger than 1 MB

[nandozzi]

Hi all,
i have this strange issue. I want to add a file to a ticket that is larger than 1 MB, but each time i tried it i don't receive any error, simple the file wasn't attached.
Anyone knows if there is any configuration to avoid this limit.
Thanks in advance.

P.S. OTRS 3.06

[nandozzi]

It's possible that anyone in the forum have experienced this problem ?
Have you tried to attach a file larger than 1 MB to see if you have the same issue ?
It's a my SQL limit (i use the db as storage) or it's a bug? Please answer me.

[jojo]

pleae give us more information like Operating System, etc.

It could be a MySQL isssue, please run the Support Assessement Module.

[nandozzi]

Ok. I'm using OTRS 3.0.6 on a Linux server (CentOs 5.2). I have tried to change the store option for attachments from DB to FileSystem, but the problem was not solved. If you want to reproduce this problem, you have just to attach a file larger than 1 MB on a phone ticket.

[jojo]

please change you my.cnf settings to have max_allowed_packet = 16M and restart mysql

[nandozzi]

Thanks a lot now it works greatly.
So it was a MySql issue.
THANKS THANKS THANKS