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! <rather long log snipppit - sorry.> 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" _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
