Hi Tom

...

On Tue, Apr 10, 2007 at 04:22:15PM +0200, Tom wrote: Is data inserted to OTRS's database compressed?

No.

...

Which storage module is better to use ArticleStorageFS or ArticleStorageDB?

That depends on your needs :). If you have to process many attachments I'd use the FS module. But setting up the DB module is easier because you don not have to care about filesystem permissions.

But If I would like to use FS module there is problem with encoding. I write about this problem here: http://lists.otrs.org/pipermail/otrs/2007-April/018279.html and here I pasted whole description: There are problems with viewing email's body written in attachments as html and plain text when StorageModule->ArticleStorageFS. When I set StorageModule=ArticleStorageFS then when I send email to OTRS in plain text and HTML like it can be done by Thunderbird Mozilla, then when I open this ticket under OTRS I have email body shown also as attachments (plain text, html). Problem is when for example send to OTRS email is ISO-8859-2 encoded and when I'm opening this attachments in new window then there are no polish characters visible (ZZCLÓASe). There is no such problem when as StorageModule is set ArticleStorageDB. What is the Problem? I have in /etc/enviroment LANG="en_US.UTF-8" and in /etc/locale.gen en_US.UTF-8 UTF-8 in the first row . System is Debian.

Does this link help? Its for gentoo but talks about setting locales, maybe playing with this setting will fix the fs storage: http://www.gentoo.org/doc/en/guide-localization.xml -Andy On 4/11/07 1:44 PM, "Tom" wrote:

...

Hi Tom

...

...

On Tue, Apr 10, 2007 at 04:22:15PM +0200, Tom wrote: Is data inserted to OTRS's database compressed?

...

No.

...

...

Which storage module is better to use ArticleStorageFS or ArticleStorageDB?

...

That depends on your needs :). If you have to process many attachments I'd use the FS module. But setting up the DB module is easier because you don not have to care about filesystem permissions.

But If I would like to use FS module there is problem with encoding. I write about this problem here: http://lists.otrs.org/pipermail/otrs/2007-April/018279.html and here I pasted whole description:

There are problems with viewing email's body written in attachments as html and plain text when StorageModule->ArticleStorageFS. When I set StorageModule=ArticleStorageFS then when I send email to OTRS in plain text and HTML like it can be done by Thunderbird Mozilla, then when I open this ticket under OTRS I have email body shown also as attachments (plain text, html). Problem is when for example send to OTRS email is ISO-8859-2 encoded and when I'm opening this attachments in new window then there are no polish characters visible (ZZCLÓASe). There is no such problem when as StorageModule is set ArticleStorageDB. What is the Problem? I have in /etc/enviroment LANG="en_US.UTF-8" and in /etc/locale.gen en_US.UTF-8 UTF-8 in the first row .

System is Debian.

_______________________________________________ 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 orr consulting for your OTRS system? => http://www.otrs.com/

--

Hmm and the only thing in between the file system and the web page is perl correct? Maybe it has something to do with perl. Im most intrigued by this.. Let us know what you find, Andy On 4/12/07 4:33 PM, "Tom" wrote:

I will chcek this precisely toomorow but as I wrote It seems to be OTRS charset encoding converting problem or dont know what. When StorageModule->ArticleStorageFS and I send email encoded in ISO8859-2 to OTRS then attachments with body of that email are not fully readable. When StorageModule->ArticleStorageDB there is no problem. When StorageModule->ArticleStorageFS those attachments are wrote to the disk but now I dont know in which encoding? In encoding they were sent or they are converted to UTF-8 when I have default charset =UTF-8 in OTRS ?

When I create new file with Vi or MC under console with polish characters and afterthat I open them under firefox or IE everything is fine and encoding is UTF-8. So I have set locales to UTF-8.

----- Original Message ----- From: "Andy Lubel" To: "User questions and discussions about OTRS.org" Sent: Wednesday, April 11, 2007 8:42 PM Subject: Re: [otrs] Data compressing

Does this link help? Its for gentoo but talks about setting locales, maybe playing with this setting will fix the fs storage:

http://www.gentoo.org/doc/en/guide-localization.xml

-Andy

On 4/11/07 1:44 PM, "Tom" wrote:

...

...

Hi Tom

...

...

On Tue, Apr 10, 2007 at 04:22:15PM +0200, Tom wrote: Is data inserted to OTRS's database compressed?

...

No.

...

...

Which storage module is better to use ArticleStorageFS or ArticleStorageDB?

...

That depends on your needs :). If you have to process many attachments I'd use the FS module. But setting up the DB module is easier because you don not have to care about filesystem permissions.

But If I would like to use FS module there is problem with encoding. I write about this problem here: http://lists.otrs.org/pipermail/otrs/2007-April/018279.html and here I pasted whole description:

There are problems with viewing email's body written in attachments as html and plain text when StorageModule->ArticleStorageFS. When I set StorageModule=ArticleStorageFS then when I send email to OTRS in plain text and HTML like it can be done by Thunderbird Mozilla, then when I open this ticket under OTRS I have email body shown also as attachments (plain text, html). Problem is when for example send to OTRS email is ISO-8859-2 encoded and when I'm opening this attachments in new window then there are no polish characters visible (ZZCLÓASe). There is no such problem when as StorageModule is set ArticleStorageDB. What is the Problem? I have in /etc/enviroment LANG="en_US.UTF-8" and in /etc/locale.gen en_US.UTF-8 UTF-8 in the first row .

System is Debian.

_______________________________________________ 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 orr consulting for your OTRS system? => http://www.otrs.com/

--