Attachments werden nicht mitgenommen

Hilfe zu Znuny Problemen aller Art
Locked
max099
Znuny newbie
Posts: 3
Joined: 17 Nov 2006, 23:29

Attachments werden nicht mitgenommen

Post by max099 »

Hello!

Habe OTRS in einer Test Umgebung laufen. Ein wirklich feines Tool.
Leider holt OTRS keine Attachments vom Pop.
E-mail wird korrekt übernommen. Größe ist auch unter dem Standardwert...

Habe im Log ausserdem einige Errors - haben die was damit zu tun?

Siehe Attachment...

Code: Select all

[Sat Nov 18 00:40:44 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleWritePlain][208] Lost connection to MySQL server during query, SQL: 'INSERT INTO article_plain  (article_id, body, create_time, create_by, change_time, change_by)  VALUES  (2, ?,  current_timestamp, 1, current_timestamp, 1)'
[Sat Nov 18 00:40:44 2006][Error][Kernel::System::Ticket::Article::ArticleGetContentPath][602] MySQL server has gone away, SQL: 'SELECT content_path FROM article WHERE id = 2'
[Sat Nov 18 00:40:44 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndex][363] MySQL server has gone away, SQL: 'SELECT filename, content_type, content_size FROM article_attachment  WHERE  article_id = 2 ORDER BY id'
[Sat Nov 18 00:40:44 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleWriteAttachment][271] 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  (2, 'file-1', 'text/plain\; charset="iso-8859-2"', '255', ?,  current_timestamp, 1, current_timestamp, 1)'
[Sat Nov 18 00:40:44 2006][Error][Kernel::System::Ticket::Article::ArticleGetContentPath][602] MySQL server has gone away, SQL: 'SELECT content_path FROM article WHERE id = 2'
[Sat Nov 18 00:40:44 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndex][363] MySQL server has gone away, SQL: 'SELECT filename, content_type, content_size FROM article_attachment  WHERE  article_id = 2 ORDER BY id'
[Sat Nov 18 00:40:44 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleWriteAttachment][271] 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  (2, 'file-2', 'text/html\; charset="iso-8859-2"', '529', ?,  current_timestamp, 1, current_timestamp, 1)'
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::Ticket::Article::ArticleGetContentPath][602] MySQL server has gone away, SQL: 'SELECT content_path FROM article WHERE id = 2'
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndex][363] MySQL server has gone away, SQL: 'SELECT filename, content_type, content_size FROM article_attachment  WHERE  article_id = 2 ORDER BY id'
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleWriteAttachment][271] 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  (2, '123.pdf', 'application/octet-stream\; name="123.pdf"', '1707731', ?,  current_timestamp, 1, current_timestamp, 1)'
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::Ticket::Article::ArticleGetContentPath][602] MySQL server has gone away, SQL: 'SELECT content_path FROM article WHERE id = 2'
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndex][363] MySQL server has gone away, SQL: 'SELECT filename, content_type, content_size FROM article_attachment  WHERE  article_id = 2 ORDER BY id'
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleWriteAttachment][271] 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  (2, 'abc.JPG', 'image/jpeg\; name="abc.JPG"', '6969', ?,  current_timestamp, 1, current_timestamp, 1)'
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::Ticket::Article::ArticleGetContentPath][602] MySQL server has gone away, SQL: 'SELECT content_path FROM article WHERE id = 2'
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndex][363] MySQL server has gone away, SQL: 'SELECT filename, content_type, content_size FROM article_attachment  WHERE  article_id = 2 ORDER BY id'
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleWriteAttachment][271] 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  (2, 'file-3', 'text/html', '894', ?,  current_timestamp, 1, current_timestamp, 1)'
[Sat Nov 18 00:40:45 2006][Notice][main::FetchMail] Fetched 1 email(s) from 123@abc.at@mail.test.com.
[Sat Nov 18 00:40:45 2006][Error][Kernel::System::PID::PIDDelete][210] MySQL server has gone away, SQL: 'DELETE FROM process_id WHERE  process_name = 'PostMasterPOP3' AND process_host = '10.30.1.99''
[Sat Nov 18 00:50:03 2006][Notice][Kernel::System::PID::PIDCreate] Can't create PID PostMasterPOP3, because it's already running (10.30.1.99/2588)!
OTRS 2.1.2 / Windows
Andre Bauer
Znuny guru
Posts: 2189
Joined: 08 Dec 2005, 17:01
Znuny Version: 5.0.x
Real Name: André Bauer
Company: Magix Software GmbH
Location: Dresden
Contact:

Post by Andre Bauer »

Bitte die Logs in Zukunft einfach mit Posten.
Es bringt ja nichts, wenn man die erst runterladen muss...

Ich schätze mal dein MySQL Server ist so konfiguriert, dass entweder die maximal Zeit zum Ausführen für das Query oder der maximale Upload zu gering eingestellt ist.

Mehr dazu findest du hier im Forum über die Suchfunktion...
Prod: Ubuntu Server 16.04 / Zammad 1.2

DO NOT PM ME WITH OTRS RELATED QUESTIONS! ASK IN THE FORUMS!

OtterHub.org
max099
Znuny newbie
Posts: 3
Joined: 17 Nov 2006, 23:29

Habs gefunden!

Post by max099 »

Musste erst den Speicherort der Datein von DB auf FS ändern.
Interessanter Ansatz, Dateien direkt in eine DB zu speichern. Wäre gar nicht auf die Idee gekommen, dass das jemande macht. DB Kollaps ist damit ja vorprogrammiert...

Danke für die Bemühungen...
OTRS 2.1.2 / Windows
Locked