dealing with article_attachment table

Hi there, After less than two months our article_attachment table is occupying 70% of our total database size. Does anyone know about a way of storing articles outside the main database? In the following thread http://www.mail-archive.com/otrs@otrs.org/msg21102.html, Dieter proposes to switch it to filesystem from configuration but I could not find it in SysConfig. Does anyone know where? Any help is much appreciated. Thanks in advance, Leonardo Certuche

Hi Leonardo, Admin -> SysConfig -> Group: Ticket -> Sub Group: Core::Ticket -> Ticket::StorageModule -> FS. After that all new attachments get stored to the local file system. -Martin On 28.01.2010, at 17:55, Leonardo Certuche wrote:
Hi there,
After less than two months our article_attachment table is occupying 70% of our total database size. Does anyone know about a way of storing articles outside the main database?
In the following thread http://www.mail-archive.com/otrs@otrs.org/msg21102.html, Dieter proposes to switch it to filesystem from configuration but I could not find it in SysConfig. Does anyone know where?
Any help is much appreciated.
Thanks in advance,
Leonardo Certuche

Thanx Martin! :D
Leonardo Certuche
On Thu, Jan 28, 2010 at 2:33 PM, Martin Edenhofer
Hi Leonardo,
Admin -> SysConfig -> Group: Ticket -> Sub Group: Core::Ticket -> Ticket::StorageModule -> FS.
After that all new attachments get stored to the local file system.
-Martin
On 28.01.2010, at 17:55, Leonardo Certuche wrote:
Hi there,
After less than two months our article_attachment table is occupying 70% of our total database size. Does anyone know about a way of storing articles outside the main database?
In the following thread http://www.mail-archive.com/otrs@otrs.org/msg21102.html, Dieter proposes to switch it to filesystem from configuration but I could not find it in SysConfig. Does anyone know where?
Any help is much appreciated.
Thanks in advance,
Leonardo Certuche
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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Just a question:
On the help text it says "This is faster but webserver user should be the
otrs user"
We're running suse, our apache user is wwwrun and our otrs user is otrs.
Could you please give me advice on the changes I must make in order to
fulfill this requirement without affecting other applications running on the
same server?
Thanks,
Leonardo Certuche
2010/1/28 Leonardo Certuche
Thanx Martin! :D
Leonardo Certuche
On Thu, Jan 28, 2010 at 2:33 PM, Martin Edenhofer
wrote: Hi Leonardo,
Admin -> SysConfig -> Group: Ticket -> Sub Group: Core::Ticket -> Ticket::StorageModule -> FS.
After that all new attachments get stored to the local file system.
-Martin
On 28.01.2010, at 17:55, Leonardo Certuche wrote:
Hi there,
After less than two months our article_attachment table is occupying 70% of our total database size. Does anyone know about a way of storing articles outside the main database?
In the following thread http://www.mail-archive.com/otrs@otrs.org/msg21102.html, Dieter proposes to switch it to filesystem from configuration but I could not find it in SysConfig. Does anyone know where?
Any help is much appreciated.
Thanks in advance,
Leonardo Certuche
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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Leonardo Certuche wrote :
Just a question:
On the help text it says "This is faster but webserver user should be the otrs user" We're running suse, our apache user is wwwrun and our otrs user is otrs. Could you please give me advice on the changes I must make in order to fulfill this requirement without affecting other applications running on the same server?
Hello Leonardo, we've added the otrs user to the www group of the wwwrun user. Regards Alexander -- radprax Gesellschaft fuer medizinische Versorgungszentren mbH, Bergstr. 7 - 9, 42105 Wuppertal, Fon: +49 202 2489 1110, Fax: +49 202 2489 94 1119 Geschaeftsfuehrer: Andreas Martin, Dr. med. Heiner Steffens, Dr. med. Renate Tewaag Amtsgericht Wuppertal: HRB 19359, St.-Nr.: 5132/5889/0264, DE 814559152 Web: http://www.radprax.de
participants (3)
-
Alexander Halle
-
Leonardo Certuche
-
Martin Edenhofer