Issue 112108 - wiki file upload failure for .odb
Summary: wiki file upload failure for .odb
Status: CLOSED FIXED
Alias: None
Product: Infrastructure
Classification: Infrastructure
Component: _openoffice.org administrative interface (obsolete) (show other issues)
Version: current
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: smaug42
QA Contact: issues@www
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-04 10:00 UTC by hcpotter
Modified: 2017-05-20 10:24 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
DerbyToursDB.odb for ooo2.4.1 using XP SP1 (2.09 MB, application/vnd.sun.xml.base)
2010-06-04 10:04 UTC, hcpotter 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description hcpotter 2010-06-04 10:00:59 UTC 
I have tried several times to upload a 2M odb file to the ooo wiki. The uploader
consistently reports failure for file corruption even  though the input file is
not corrupted. I can email you the file if you would like to try.
Comment 1 hcpotter 2010-06-04 10:04:35 UTC 
Created attachment 69798 [details]
DerbyToursDB.odb for ooo2.4.1 using XP SP1
Comment 2 smaug42 2010-06-06 10:50:16 UTC 
Exact error is:
"The file is corrupt or has an incorrect extension. Please check the file and
upload again."

The ODB file is not corrupt. The ODB file is not being recognized as a
valid/allowed file type.  It's likely a misconfiguration of the MIME types on
the webserver side.  Investigating.
Comment 3 smaug42 2010-06-06 10:50:45 UTC 
Accepting issue
Comment 4 smaug42 2010-06-07 08:32:22 UTC 
From some reason MediaWiki was detecting the odb file as a zip file instead of as:
  application/vnd.oasis.opendocument.database odb
as it is correctly defined in both the apache2/conf/mime.types and
mwiki/includes/mime.types files.
This issue and solution is noted here in the MediaWiki documentation:
http://www.mediawiki.org/wiki/Manual:Mime_type_detection#MIME_type_validation

Added odb to the application/zip mime.type definition, and was able to upload
the database successfully to the Wiki.

The uploaded database file:
http://wiki.services.openoffice.org/wiki/File:DerbyToursDB.odb can be referenced
now within the Wiki using the [[File:DerbyToursDB.odb]] Wiki syntax.