Hi All,
My system seems to be eating M$ Word attachments (.doc)
Other types of attachments come in fine.
Below is from my procmail log when a mail with a .doc is received.
Any ideas on what to check would be greatly appreciated!
procmail: Executing "/opt/otrs/bin/PostMaster.pl"
DBD::mysql::db do failed: MySQL server has gone away at
/opt/otrs/Kernel/System/DB.pm line 376.
ERROR: OTRS-PM-1 Perl: 5.8.6 OS: linux Time: Thu Jun 16 10:54:58 2005
Message: MySQL server has gone away, SQL: 'INSERT INTO article_plain
(article_id, body, create_time, create_by, change_time, change_by)
VALUES (861, ?, current_timestamp, 1, current_timestamp, 1)'
Traceback (17577):
Module: Kernel::System::Ticket::ArticleWritePlain (v1.19.2.1) Line: 145
Module: Kernel::System::PostMaster::NewTicket::Run (v1.48) Line: 281
Module: Kernel::System::PostMaster::Run (v1.43) Line: 246
Module: (eval) (v1.16.6.2) Line: 111
Module: /opt/otrs/bin/PostMaster.pl (v1.16.6.2) Line: 85
DBD::mysql::st execute failed: MySQL server has gone away at
/opt/otrs/Kernel/System/DB.pm line 436.
ERROR: OTRS-PM-1 Perl: 5.8.6 OS: linux Time: Thu Jun 16 10:54:58 2005
Message: MySQL server has gone away, SQL: 'SELECT content_path FROM
article WHERE id = 861'
Traceback (17577):
Module: Kernel::System::Ticket::ArticleGetContentPath (v1.19.2.1) Line: 452
Module: Kernel::System::Ticket::ArticleAttachmentIndex (v1.19.2.1) Line: 269
Module: Kernel::System::Ticket::ArticleWriteAttachment (v1.19.2.1) Line: 166
Module: Kernel::System::PostMaster::NewTicket::Run (v1.48) Line: 290
Module: Kernel::System::PostMaster::Run (v1.43) Line: 246
Module: (eval) (v1.16.6.2) Line: 111
Module: /opt/otrs/bin/PostMaster.pl (v1.16.6.2) Line: 85
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
/opt/otrs/Kernel/System/DB.pm line 474.
DBD::mysql::st execute failed: MySQL server has gone away at
/opt/otrs/Kernel/System/DB.pm line 436.
ERROR: OTRS-PM-1 Perl: 5.8.6 OS: linux Time: Thu Jun 16 10:54:58 2005
Message: MySQL server has gone away, SQL: 'SELECT filename,
content_type, content_size FROM article_attachment WHERE article_id
= 861 ORDER BY id'
Traceback (17577):
Module: Kernel::System::Ticket::ArticleAttachmentIndex (v1.19.2.1) Line: 279
Module: Kernel::System::Ticket::ArticleWriteAttachment (v1.19.2.1) Line: 166
Module: Kernel::System::PostMaster::NewTicket::Run (v1.48) Line: 290
Module: Kernel::System::PostMaster::Run (v1.43) Line: 246
Module: (eval) (v1.16.6.2) Line: 111
Module: /opt/otrs/bin/PostMaster.pl (v1.16.6.2) Line: 85
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
/opt/otrs/Kernel/System/DB.pm line 474.
Use of uninitialized value in concatenation (.) or string at
/opt/otrs/Kernel/System/Ticket/ArticleStorageDB.pm line 303.
DBD::mysql::db do failed: MySQL server has gone away at
/opt/otrs/Kernel/System/DB.pm line 376.
ERROR: OTRS-PM-1 Perl: 5.8.6 OS: linux Time: Thu Jun 16 10:54:58 2005
Message: MySQL server has gone away, SQL: 'INSERT INTO
article_attachment (article_id, filename, content_type, content_size,
content, create_time, create_by, change_time, change_by) VALUES
(861, 'file-1', 'text/plain\; charset=US-ASCII', '178', ?,
current_timestamp, 1, current_timestamp, 1)'
Traceback (17577):
Module: Kernel::System::Ticket::ArticleWriteAttachment (v1.19.2.1) Line: 201
Module: Kernel::System::PostMaster::NewTicket::Run (v1.48) Line: 290
Module: Kernel::System::PostMaster::Run (v1.43) Line: 246
Module: (eval) (v1.16.6.2) Line: 111
Module: /opt/otrs/bin/PostMaster.pl (v1.16.6.2) Line: 85
DBD::mysql::st execute failed: MySQL server has gone away at
/opt/otrs/Kernel/System/DB.pm line 436.
ERROR: OTRS-PM-1 Perl: 5.8.6 OS: linux Time: Thu Jun 16 10:54:58 2005
Message: MySQL server has gone away, SQL: 'SELECT content_path FROM
article WHERE id = 861'
Traceback (17577):
Module: Kernel::System::Ticket::ArticleGetContentPath (v1.19.2.1) Line: 452
Module: Kernel::System::Ticket::ArticleAttachmentIndex (v1.19.2.1) Line: 269
Module: Kernel::System::Ticket::ArticleWriteAttachment (v1.19.2.1) Line: 166
Module: Kernel::System::PostMaster::NewTicket::Run (v1.48) Line: 290
Module: Kernel::System::PostMaster::Run (v1.43) Line: 246
Module: (eval) (v1.16.6.2) Line: 111
Module: /opt/otrs/bin/PostMaster.pl (v1.16.6.2) Line: 85
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
/opt/otrs/Kernel/System/DB.pm line 474.
DBD::mysql::st execute failed: MySQL server has gone away at
/opt/otrs/Kernel/System/DB.pm line 436.
ERROR: OTRS-PM-1 Perl: 5.8.6 OS: linux Time: Thu Jun 16 10:54:58 2005
Message: MySQL server has gone away, SQL: 'SELECT filename,
content_type, content_size FROM article_attachment WHERE article_id
= 861 ORDER BY id'
Traceback (17577):
Module: Kernel::System::Ticket::ArticleAttachmentIndex (v1.19.2.1) Line: 279
Module: Kernel::System::Ticket::ArticleWriteAttachment (v1.19.2.1) Line: 166
Module: Kernel::System::PostMaster::NewTicket::Run (v1.48) Line: 290
Module: Kernel::System::PostMaster::Run (v1.43) Line: 246
Module: (eval) (v1.16.6.2) Line: 111
Module: /opt/otrs/bin/PostMaster.pl (v1.16.6.2) Line: 85
DBD::mysql::st fetchrow_array failed: fetch() without execute() at
/opt/otrs/Kernel/System/DB.pm line 474.
Use of uninitialized value in concatenation (.) or string at
/opt/otrs/Kernel/System/Ticket/ArticleStorageDB.pm line 303.
DBD::mysql::db do failed: MySQL server has gone away at
/opt/otrs/Kernel/System/DB.pm line 376.
ERROR: OTRS-PM-1 Perl: 5.8.6 OS: linux Time: Thu Jun 16 10:54:58 2005
Message: MySQL server has gone away, SQL: 'INSERT INTO
article_attachment (article_id, filename, content_type, content_size,
content, create_time, create_by, change_time, change_by) VALUES
(861, 'Existing System - Sketch #1.doc', 'application/msword\;
name="Existing System - Sketch #1.doc"', '1096192', ?,
current_timestamp, 1, current_timestamp, 1)'
Traceback (17577):
Module: Kernel::System::Ticket::ArticleWriteAttachment (v1.19.2.1) Line: 201
Module: Kernel::System::PostMaster::NewTicket::Run (v1.48) Line: 290
Module: Kernel::System::PostMaster::Run (v1.43) Line: 246
Module: (eval) (v1.16.6.2) Line: 111
Module: /opt/otrs/bin/PostMaster.pl (v1.16.6.2) Line: 85
procmail: [17572] Thu Jun 16 10:54:58 2005
procmail: Assigning "LASTFOLDER=/opt/otrs/bin/PostMaster.pl"
procmail: Unlocking ".lock"
procmail: Notified comsat: "otrs@:/opt/otrs/bin/PostMaster.pl"
Kevin Kasner