459320 - MDC: Serve .ogg files with correct MIME types

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Eric Shepherd [:sheppy]]

In order to support video/audio tag samples, please add the correct MIME types for these files to MDC.  Thanks!

Comment 1

[Dave Miller [:justdave]]

Done.

+# https://bugzilla.mozilla.org/show_bug.cgi?id=459320
+# From http://wiki.xiph.org/index.php/MIME_Types_and_File_Extensions
+# 1 .ogx - application/ogg
+# 2 .ogv - video/ogg
+# 3 .oga - audio/ogg
+# 4 .ogg - audio/ogg
+# 5 .spx - audio/ogg
+# 6 .flac - audio/flac
+# 7 .anx - application/annodex
+# 8 .axa - audio/annodex
+# 9 .axv - video/annodex
+# 10 .xspf - application/xspf+xml
+AddType application/ogg .ogx 
+AddType video/ogg .ogv 
+AddType audio/ogg .oga 
+AddType audio/ogg .ogg 
+AddType audio/ogg .spx 
+AddType audio/flac .flac 
+AddType application/annodex .anx 
+AddType audio/annodex .axa 
+AddType video/annodex .axv 
+AddType application/xspf+xml .xspf 
+

Comment 2

[Dave Miller [:justdave]]

macbook:~ dave$ curl -sI 'http://developer.mozilla.org/@api/deki/files/2926/=AudioTest_(1).ogg'
HTTP/1.1 200 OK
Date: Mon, 13 Oct 2008 06:31:49 GMT
Server: Dream-HTTPAPI/1.5.6.2743
Content-Type: application/ogg
Content-Length: 42324

Comment 3

[Dave Miller [:justdave]]

hmm, that doesn't look like it worked, actually.  On the other hand, the Server: line leads me to believe that's Deki's fault rather than Apache's.

Comment 4

[Eric Shepherd [:sheppy]]

I've emailed MindTouch to see what's up.

Comment 5

[Eric Shepherd [:sheppy]]

OK, here's how to do it so Deki has a clue, according to Roy at MindTouch:

I'm guessing the problem is Deki is associating .ogg files as application/x-octet-stream. To fix this:

In LocalSettings.php:

$wgMimeTypes['ogg'] = 'audio/ogg';

Note this will only apply retroactively to new files that are updated - you can fix old files by going into the database and running a query ("UPDATE attachments SET at_filetype = 'audio/ogg' WHERE at_filetype = 'application/x-octet-stream' AND at_extension = 'ogg';) - BUT BE SURE YOU DO A DATABASE DUMP OF THE ATTACHMENTS TABLE in case my SQL is not up to par ;)

Comment 6

[Jeremy Orem [:oremj]]

For some reason their filetype was application/ogg.  Anyways, I ran:

update attachments set at_filetype = 'audio/ogg' where at_extension = 'ogg';
Query OK, 2 rows affected (0.19 sec)
Rows matched: 2  Changed: 2  Warnings: 0

Also, I made the change in LocalSettings.