Re: Office 2007 documents

[Alan in Toronto-2]

On Thu, June 12, 2008 10:06 am, Lin Young wrote:

> We are using squirrelmail version 1.4.8
>
> When emailing a Word 2007 document with the ".docx" extension, Webmail
> mis-recognizes is as plain-text, causing it to be displayed as garbage
> text to end-users who click on the attachment name or the "View" link.
>
> ".docx" vs. ".doc":
> "
> TextAndPictures1.docx 42 k [ text/plain ] Download | View
>
> DOC-TextAndPictures2-DOC.doc 266 k [ application/msword ] Download

Could it be that no one has yet updated the web server to recognize .docx extensions
and how to handle them?

In the meantime, as a workaround, you could Zip the files before e-mailing them.




-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Tomas Kuliavas]

>> We are using squirrelmail version 1.4.8
>>
>> When emailing a Word 2007 document with the ".docx" extension, Webmail
>> mis-recognizes is as plain-text, causing it to be displayed as garbage
>> text to end-users who click on the attachment name or the "View" link.
>>
>> ".docx" vs. ".doc":
>> "
>> TextAndPictures1.docx 42 k [ text/plain ] Download | View
>>
>> DOC-TextAndPictures2-DOC.doc 266 k [ application/msword ] Download
>
> Could it be that no one has yet updated the web server to recognize .docx
> extensions and how to handle them?

webserver does not care about file types. User's browser tells to
webserver that it is uploading text/plain file.

--
Tomas


-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Alan in Toronto-2]

On Thu, June 12, 2008 11:38 am, Tomas Kuliavas wrote:

>>> We are using squirrelmail version 1.4.8
>>>
>>> When emailing a Word 2007 document with the ".docx" extension, Webmail
>>> mis-recognizes is as plain-text, causing it to be displayed as garbage
>>> text to end-users who click on the attachment name or the "View" link.
>>>
>>> ".docx" vs. ".doc":
>>> "
>>> TextAndPictures1.docx 42 k [ text/plain ] Download | View
>>>
>>> DOC-TextAndPictures2-DOC.doc 266 k [ application/msword ] Download
>>
>> Could it be that no one has yet updated the web server to recognize .docx
>> extensions and how to handle them?
>
> webserver does not care about file types. User's browser tells to
> webserver that it is uploading text/plain file.

I thought there was something about setting correct MIME type on webserver for
various file types.




-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Matthew Hardwick-2]

>>
>> webserver does not care about file types. User's browser tells to
>> webserver that it is uploading text/plain file.
>
> I thought there was something about setting correct MIME type on webserver for
> various file types.
>

Yes it is. We had this problem - you need to add the correct MIME
types to Apache. That's what solved the problem, it's actually more
common to have Office 2007 files recognised as ZIP files.

If you need help with what MIME types to enter, then let me know, and
I will find them again.

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Tomas Kuliavas]

Alan in Toronto-2 wrote:

On Thu, June 12, 2008 11:38 am, Tomas Kuliavas wrote:
>>> We are using squirrelmail version 1.4.8
>>>
>>> When emailing a Word 2007 document with the ".docx" extension, Webmail
>>> mis-recognizes is as plain-text, causing it to be displayed as garbage
>>> text to end-users who click on the attachment name or the "View" link.
>>>
>>> ".docx" vs. ".doc":
>>> "
>>> TextAndPictures1.docx 42 k [ text/plain ] Download | View
>>>
>>> DOC-TextAndPictures2-DOC.doc 266 k [ application/msword ] Download
>>
>> Could it be that no one has yet updated the web server to recognize .docx
>> extensions and how to handle them?
>
> webserver does not care about file types. User's browser tells to
> webserver that it is uploading text/plain file.

I thought there was something about setting correct MIME type on webserver for
various file types.

Try attaching .dwg file in Safari for Windows and in Firefox. Check mime type differences.

If it was webserver thing, unrecognized .docx would be detected as LZW compressed data (application/zip). MS-OOXML and ODF formats are data containers packed with zip.

--
Tomas

[Postmaster-697]

>> We are using squirrelmail version 1.4.8
>>
>> When emailing a Word 2007 document with the ".docx" extension, Webmail
>> mis-recognizes is as plain-text, causing it to be displayed as garbage
>> text to end-users who click on the attachment name or the "View" link.
>>
>> ".docx" vs. ".doc":
>> "
>> TextAndPictures1.docx 42 k [ text/plain ] Download | View
>>
>> DOC-TextAndPictures2-DOC.doc 266 k [ application/msword ] Download
>
> Could it be that no one has yet updated the web server to recognize .docx
> extensions and how to handle them?

webserver does not care about file types. User's browser tells to
webserver that it is uploading text/plain file.

--
Tomas


Huh ??
Apache will convert to text type if it doesnt know
what to do with it..
the .docx needs to be added to the httpd config

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Tomas Kuliavas]

Postmaster-697 wrote:

>> We are using squirrelmail version 1.4.8
>>
>> When emailing a Word 2007 document with the ".docx" extension, Webmail
>> mis-recognizes is as plain-text, causing it to be displayed as garbage
>> text to end-users who click on the attachment name or the "View" link.
>>
>> ".docx" vs. ".doc":
>> "
>> TextAndPictures1.docx 42 k [ text/plain ] Download | View
>>
>> DOC-TextAndPictures2-DOC.doc 266 k [ application/msword ] Download
>
> Could it be that no one has yet updated the web server to recognize .docx
> extensions and how to handle them?

webserver does not care about file types. User's browser tells to
webserver that it is uploading text/plain file.

--
Tomas


Huh ??
Apache will convert to text type if it doesnt know
what to do with it..
the .docx needs to be added to the httpd config

We are not talking about files downloaded from webserver. It is about files uploaded in html multipart/form-data form.

Here goes capture from Live HTTP headers.
---
POST /somepath/src/compose.php HTTP/1.1

...
Content-Type: multipart/form-data; boundary=---------------------------6716000612076580265981341304
Content-Length: 24676
....
Content-Disposition: form-data; name="attachfile"; filename="sample.docx"
Content-Type: application/octet-stream
...
HTTP/1.x 200 OK
...
---

My webserver does not know anything about docx and sample.docx is attached as application/octet-stream.

If it is set by webserver, why Safari sets broken mime type on .dwg files and other browsers don't do that.

--
Tomas

[Lin Young]

Matt Hardwick wrote:

>>> webserver does not care about file types. User's browser tells to
>>> webserver that it is uploading text/plain file.
>>>      
>> I thought there was something about setting correct MIME type on webserver for
>> various file types.
>>
>>    
>
> Yes it is. We had this problem - you need to add the correct MIME
> types to Apache. That's what solved the problem, it's actually more
> common to have Office 2007 files recognised as ZIP files.
>
> If you need help with what MIME types to enter, then let me know, and
> I will find them again.
>  

Hi Matt,

Thank you for your reply.

I added the following lines to /etc/mime.types of my web server and
restart apache; but I still have the same problem. Any idea?

application/vnd.openxmlformats-officedocument.wordprocessingml.document
application/vnd.openxmlformats-officedocument.spreadsheetml.shee

my httpd.conf:

# TypesConfig describes where the mime.types file (or equivalent) is
# to be found.
#
TypesConfig /etc/mime.types


-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Paul Lesniewski]

On Thu, Jun 12, 2008 at 3:36 PM, Res <res@...> wrote:
> On Thu, 12 Jun 2008, Lin Young wrote:
>
>> I added the following lines to /etc/mime.types of my web server and
>> restart apache; but I still have the same problem. Any idea?

Read what Tomas wrote.  The problem is not with downloading files,
right?  If it's a problem with files you are uploading, the problem is
not in Apache.

> Where is your apache?
>
> put a mime.types in your conf dir, eg, mine is:
> /usr/local/apache/conf/mime.types
>
>> application/vnd.openxmlformats-officedocument.wordprocessingml.document
>> application/vnd.openxmlformats-officedocument.spreadsheetml.shee
>
> eh? these are not approved types
>
> see - http://www.iana.org/assignments/media-types/application/
>
> But then again since when does micro$lop do anything compliant :)

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Tomas Kuliavas]

Paul Lesniewski wrote:

On Thu, Jun 12, 2008 at 3:36 PM, Res <[e-mail]> wrote:
> On Thu, 12 Jun 2008, Lin Young wrote:
>
>> I added the following lines to /etc/mime.types of my web server and
>> restart apache; but I still have the same problem. Any idea?

Read what Tomas wrote.  The problem is not with downloading files,
right?

Even if problem happens when files are downloaded, it is not related to apache configuration. Email attachments are never downloaded directly from Apache. When email attachments are downloaded in SquirrelMail, they always go through src/download.php and this script sets content type from email headers and IMAP message bodystructure.

If it is download issue, why text/plain content type is set on docx attachment?

Lin should make sure that email has correct content type headers, try reproducing upload issue in other browser and make sure that it is not related to HTTP proxy. Firefox can have corrupted mime types database. Safari is ... see other my emails or test yourself.

--
Tomas

[Matthew Hardwick-2]

>
> Even if problem happens when files are downloaded, it is not related to
> apache configuration. Email attachments are never downloaded directly from
> Apache. When email attachments are downloaded in SquirrelMail, they always
> go through src/download.php and this script sets content type from email
> headers and IMAP message bodystructure.
>
> If it is download issue, why text/plain content type is set on docx
> attachment?
>
> Lin should make sure that email has correct content type headers, try
> reproducing upload issue in other browser and make sure that it is not
> related to HTTP proxy. Firefox can have corrupted mime types database.
> Safari is ... see other my emails or test yourself.
>
> --
> Tomas
> --

OK the original email wasn't that clear, it's for uploading files, and
Apache config wouldn't have anything to do with this I thought it was
for downloading.

Apache config DOES have *something* to do with it, because before I
added MIME types the problem of them downloading as .zip stopped. I
would suggest that download.php doesn't do it all. I work at a uni,
and we had this problem on 4 or webmail servers with over 10,000 IMAP
users - all using different operating systems and browsers on and off
campus. Adding MIME types solved the problem of downloading as dot ZIP
so whilst in context of the original email MIME types having nothing
to do with the uploading of attachments, I would suggest that MIME
types DO play an effect in downloading attachments proven by the fact
it solved the problem on more than one occasion.

That said, here on campus and at about 6 other installs of
SquirrelMail I use or manage, we don't have a problem with uploading
Office 2007 file types so maybe there is something wrong with Lin's
upload script?

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users

[Tomas Kuliavas]

Matthew Hardwick-2 wrote:

>
> Even if problem happens when files are downloaded, it is not related to
> apache configuration. Email attachments are never downloaded directly from
> Apache. When email attachments are downloaded in SquirrelMail, they always
> go through src/download.php and this script sets content type from email
> headers and IMAP message bodystructure.
>
> If it is download issue, why text/plain content type is set on docx
> attachment?
>
> Lin should make sure that email has correct content type headers, try
> reproducing upload issue in other browser and make sure that it is not
> related to HTTP proxy. Firefox can have corrupted mime types database.
> Safari is ... see other my emails or test yourself.
>
> --
> Tomas
> --

OK the original email wasn't that clear, it's for uploading files, and
Apache config wouldn't have anything to do with this I thought it was
for downloading.

Apache config DOES have *something* to do with it, because before I
added MIME types the problem of them downloading as .zip stopped. I
would suggest that download.php doesn't do it all. I work at a uni,
and we had this problem on 4 or webmail servers with over 10,000 IMAP
users - all using different operating systems and browsers on and off
campus. Adding MIME types solved the problem of downloading as dot ZIP
so whilst in context of the original email MIME types having nothing
to do with the uploading of attachments, I would suggest that MIME
types DO play an effect in downloading attachments proven by the fact
it solved the problem on more than one occasion.

Please provide more information about your setup. Including used Apache version, used modules, proxies, PHP and SquirrelMail versions. If SquirrelMail download functions are broken, they should be fixed. In basic setup Apache has nothing to do with downloaded file headers, because SquirrelMail sets headers for any downloaded file.

--
Tomas

[Alan in Toronto-2]

On Thu, June 12, 2008 12:14 pm, Tomas Kuliavas wrote:

>
>
> Alan in Toronto-2 wrote:
>>
>> On Thu, June 12, 2008 11:38 am, Tomas Kuliavas wrote:
>>>>> We are using squirrelmail version 1.4.8
>>>>>
>>>>> When emailing a Word 2007 document with the ".docx" extension, Webmail
>>>>> mis-recognizes is as plain-text, causing it to be displayed as garbage
>>>>> text to end-users who click on the attachment name or the "View" link.
>>>>>
>>>>> ".docx" vs. ".doc":
>>>>> "
>>>>> TextAndPictures1.docx 42 k [ text/plain ] Download | View
>>>>>
>>>>> DOC-TextAndPictures2-DOC.doc 266 k [ application/msword ] Download
>>>>
>>>> Could it be that no one has yet updated the web server to recognize
>>>> .docx
>>>> extensions and how to handle them?
>>>
>>> webserver does not care about file types. User's browser tells to
>>> webserver that it is uploading text/plain file.
>>
>> I thought there was something about setting correct MIME type on webserver
>> for
>> various file types.
>>
>
> Try attaching .dwg file in Safari for Windows and in Firefox. Check mime
> type differences.
>
> If it was webserver thing, unrecognized .docx would be detected as LZW
> compressed data (application/zip). MS-OOXML and ODF formats are data
> containers packed with zip.

Yes! Of course, you're right. I read the original post quickly and mistakenly
thought it was talking about problems downloading the files.




-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users