Re: [otrs] dealing with article_attachment table
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 - 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/
[otrs] 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 - 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/
Re: [otrs] dealing with article_attachment table
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/
Re: [otrs] dealing with article_attachment table
Thanx Martin! :D Leonardo Certuche On Thu, Jan 28, 2010 at 2:33 PM, Martin Edenhofer m...@otrs.com 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/ - 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/
Re: [otrs] dealing with article_attachment table
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 leonardo.certu...@itcon-ltda.com Thanx Martin! :D Leonardo Certuche On Thu, Jan 28, 2010 at 2:33 PM, Martin Edenhofer m...@otrs.com 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/ - 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/