How to increase attachment size

Moderator: crythias

Post Reply
GLM
Znuny newbie
Posts: 22
Joined: 08 Nov 2012, 11:06
Znuny Version: 6.0.23
Real Name: Gonzalo López Menéndez
Company: GRUPO MEANA, S.A.

How to increase attachment size

Post by GLM »

OTRS 3.1.11

In Sysconfig:Core:PostMasterMaxEmailSize I have a value of 102400 (100MB) - Messages with
attachments of, by example, 50MB are received, after I open it I see the message but there
is no any attachment.

Thanks in advance.

Regards.
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: How to increase attachment size

Post by reneeb »

Any messages in the OTRS log?
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
GLM
Znuny newbie
Posts: 22
Joined: 08 Nov 2012, 11:06
Znuny Version: 6.0.23
Real Name: Gonzalo López Menéndez
Company: GRUPO MEANA, S.A.

Re: How to increase attachment size

Post by GLM »

Hi,

Please find the attached OTRS.zip (OTRS.log)

Thank you.
Regards.
otrs.zip
You do not have the required permissions to view the files attached to this post.
GLM
Znuny newbie
Posts: 22
Joined: 08 Nov 2012, 11:06
Znuny Version: 6.0.23
Real Name: Gonzalo López Menéndez
Company: GRUPO MEANA, S.A.

Re: How to increase attachment size

Post by GLM »

I forgot to mention some literals were REMOVED to preserve security. Also, the email message had a 50MB file attached. The attached file was not showed in the ticket.
GLM
Znuny newbie
Posts: 22
Joined: 08 Nov 2012, 11:06
Znuny Version: 6.0.23
Real Name: Gonzalo López Menéndez
Company: GRUPO MEANA, S.A.

Re: How to increase attachment size

Post by GLM »

I can not see the response from Greggchabs. I have received an email notification telling me that the user posted a reply.
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: How to increase attachment size

Post by reneeb »

Did you check your mysql settings? The logs say
[Thu Aug 17 11:59:03 2017][Error][Kernel::System::Ticket::Article::ArticleGetContentPath][793] MySQL server has gone away, SQL: 'SELECT content_path FROM article WHERE id = ?'
[Thu Aug 17 11:59:03 2017][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] MySQL server has gone away, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Thu Aug 17 11:59:03 2017][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleWriteAttachment][280] MySQL server has gone away, SQL: 'INSERT INTO article_attachment (article_id, filename, content_type, content_size, content, content_id, content_alternative, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?,
'2017-08-17 11:59:03'
, ?,
'2017-08-17 11:59:03'
, ?)'
This could be triggered when the data is too big for the database. You should think about switching from database to file system for attachment storage.
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Post Reply