Re: [otrs] dealing with article_attachment table

2010-01-29 Thread Alexander Halle

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

2010-01-28 Thread Leonardo Certuche
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

2010-01-28 Thread 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/


Re: [otrs] dealing with article_attachment table

2010-01-28 Thread Leonardo Certuche
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

2010-01-28 Thread Leonardo Certuche
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/