Normal file attachment size

Use this forum to report bugs and to check for bugfixes and new releases of OpenEMM

Moderator: moderator

BG
Posts: 15
Joined: Fri Jul 04, 2008 2:55 pm

Normal file attachment size

Post by BG »

Hi All,

I found this in the documentation:
1. There is also a difference between the Original size and the Size in e-mail. The reason is that the software converts the file attachment into a sendable format (ASCII-Format) which is about 30 to 40 per cent larger than the original format.
2.Please be aware that the maximum file size is 1 MByte (due to the default settings of the MySQL database for BCOB data fields).

But I'm unable to attach a 448Kb PDF file because I receive "The file you want to upload exceeds the maximum file size for attachments." error.
If I put this pdf into zip it accepts the attachment.

Why it accept the compressed file?
How can I increase the attachment's size?
Can I change the data tpye of the field in the opemm's database to Large BLOB?
Thank you in advance
BG
BG
Posts: 15
Joined: Fri Jul 04, 2008 2:55 pm

file

Post by BG »

Hi

There is no plan to change this field in the database?
Is this by design?
Thank you
bg
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff »

We don't know if this is a bug in MySQL, but it behaves differently if you store a PDF file instead of a file with a different format.

You can change the code to set the limit higher but we know from experience that in this case at least some versions of MySQL will cause an exception.
OpenEMM Maintainer
BG
Posts: 15
Joined: Fri Jul 04, 2008 2:55 pm

file

Post by BG »

Hi Ma,

Thank you for your answer.
Which file shall I change?
bg
Nse
Posts: 5
Joined: Wed Aug 16, 2006 8:51 am
Location: Munich

Post by Nse »

Hi BG,

You should change the file MailingAttachmentsAction in org.agnitas.web.

nse
BG
Posts: 15
Joined: Fri Jul 04, 2008 2:55 pm

file

Post by BG »

Thank you NSE!
bg
MartinBerlin
Posts: 4
Joined: Sat Feb 20, 2010 9:44 am

Post by MartinBerlin »

Dear all

I am very surprised. This thread is now more than two years old and still the constraint about pdf attachment size is in place?

Otherwise, I think, OpenEMM is a very sophisticated application, but a mailing software with attachment constraints like this renders itself useless to a certain degree. Don't you agree?
mmenke
Posts: 30
Joined: Fri Jul 24, 2009 12:14 pm
Location: Germany
Contact:

Re: Normal file attachment size

Post by mmenke »

Since OpenEMM 6.2 you can change the maximum size for attachments in the emm.properties file.
You find it here: /home/openemm/webapps/core/WEB-INF/classes/emm.properties

Please note, that you should also check your MySQL my.cnf (/etc/my.cnf) for the max_allowed_packet setting.
In my case, OpenEMM / Java threw a nice error: java.lang.IllegalStateException: forward() not allowed after buffer has committed.

Increasing the MySQL setting helped to fix this:

[mysqld]
# for openemm
max_allowed_packet=16M

Then just restart MySQL (/etc/init.d/mysql restart).

Hope this helps. I'm updating this old thread, because the info is missing here and the feature is pretty new.
Post Reply