System Admin

Is that another Radhakrishna on your QC team?

Second month in a row without a major Microsoft patch incident – patches apply properly, systems reboot as intended, no BSoD’s, no application incompatibilities. Just like it’s supposed to work.

Are we starting to see a trend in improved patch release management at Microsoft?

Office 2007 MIME types for Apache

An interesting bug came up in the OWN Forums over the weekend, when downloading Office 2007 Word (docx) document from an Apache hosted site, the file either comes up garbled (application/octet-stream) or opens up a zip folder. This is usually the case when you have a mime-type and content-type mismatch and can get even uglier.. so what’s the solution? You have to define new Office 2007 mime types in your web server (or more precisely, server-side mime type database) so it knows how to communicate the content properly to the web browser. Office 2007 uses the new zipped XML OpenDocument format. After Googling for a few minutes and not finding the solution on the first four pages of searches I came to my buddy David Overton’s page – Now I remember where I read about the new Office 2007 mime types! I’m sure David will be extatic to know his hard work (which applies to IIS6 by the way) is now going to help Apache users everywhere get Office 2007 documents easilly. Joke aside, truth is Apache is the dominant web server and there is at least 70% chance you’re browsing an Apache site (you are right now, it’s what powers Vladville!) or about 98% chance if you’re not in a corporate environment.

Office 2007 mime types from David Overton.

First you’ll notice that there are many different mime types associated with Office 2007 OpenDocument format for just Word documents and templates: .docx, docm, dotm, dotx:

.docm = application/vnd.ms-word.document

.docx = application/vnd.openxmlformats-
officedocument.wordprocessingml.document
.dotm = application/vnd.ms-word.template
.dotx = application/vnd.openxmlformats-officedocument.

wordprocessingml.template

You can hardcode in one of these at a time, however, there is a shortcut. Just open your /etc/mime.types and add this to the last line:

application/vnd.openxmlformats       docx pptx xlsx

Restart the Apache service and you’re set. This takes care of the top three popular Office 2007 formats. If you don’t have access to the system mime type configuration (you likely don’t) you can always override the settings using your .htaccess file. Enjoy and thank David! Here is the end result:

Office2007mime

Extra note: Above applies to Apache servers hosted on Linux, however, if you host your Apache server on Windows the server distribution is likely shipping a mime configuration database in a specific path, one that you may or may not be able to find easilly. No worries, you can always add the content types directly to the httpd.conf file which is very easy to locate in most popular Windows Apache distributions such as Vertrigo. To add the new mime type directly in Apache httpd.conf (for Linux fans, /etc/httpd/conf/httpd.conf):

AddType  application/vnd.openxmlformats  .docx .pptx .xlsx

Please note that httpd.conf definitions override the /etc/mime.types definitions and dependant on the directory configuration, htaccess can (and usually does) override both.

Patch Tuesday: Cousin Joel Returns

(Note: All Windows Server post-SP2 issues will be refered to as Cousin Joel edition)

Microsoft released an out-of-band patch yesterday to cover the recent .ani/.cur exploits. These are causing confirmed issues with Windows Server 2003 SP2, SBS 2003 SP2, Windows XP, etc.

Here is something from Susan.

In short, you might need another reboot this month. Some have reported that restarting the system manually (Start, Shutdown) does not produce the same result as Reboot Now prompt after the patch installation. I have no scientific data to back that one up but if it works for you any differently please let me know.

Followup comment:

Susan Bradley says:
  btw
Susan Bradley says:
  change that to start, shutdown and ensure you select reboot
Susan Bradley says:
  otherwise on a remote machine you just turned it off  Image unavailable

Ok, if you’re reading this post and needed to see that disclaimer.. please.. do not come back to Vladville. It’s only a matter of time till you find something sharp laying around here and you hurt yourself. That big loud box in the “computer room” is a wine cooler, do not touch it, CEO has 1882 Merlot in it, if you break it you’ll be fired.

ALERT: Microsoft Windows 2003 Service Pack 2 Out

Microsoft has released Microsoft Windows 2003 Service Pack 2 for both 64–bit and 32–bit editions. It is flagged as a high priotity update meaning that if you have your box set to automatically apply updates you will likely be seeing this message just as your server is rebooting.

We got a bit blind-sighted by the decision to release SP2 today. Usually major service packs are announced well in advance. Will update when I find out more, in the meantime carry on with due dilligence and proceed carefully.

Update: SP2 has since been moved off the High Priority list.

Virtual PC 2007 is out

Microsoft Virtual PC 2007 is out — must admit, that is one heck of a presentation in terms of a web site. In terms of what’s new:

  • Support for Windows Vista as a host
  • Support for Windows Vista as a guest
  • Support for Windows Vista 64–bit as a host
  • Improved performance compared to Virtual PC 2004

I think nearly everyone has moved over to Vmware Server by now but Virtual PC 2007 remains the lone free workstation version for cheap and easy emulation. Give it a spin.

(Virtual PC… not Virtual Server.. Yeah, I know, I’m a jackass.)

DST patch fun

Susan talks about the DST issues on her latest podcast.

DST of course is the Daylight Savings Time and is observed by a number of countries in order to reduce energy utilization by messing with the clock and when people wake up. Basically, politicians controlling the clock. And since we’re lately bombing everything without cause having increased energy costs the US government decided to extend the DST period by 4 weeks, creating a major havoc in the way DST is calculated. Combine that with Microsoft’s patch quality assurance as of late and you have a making of a spectacular mess that we as system administrators now get to clean up.

So go listen to Susan and prep your workforce. The Exchange MVP circles have had a blast discussing the DST, among them the following hilarious comments.. So, how are the brightest Exchange experts dealing with the DST KB article #926666?

I am planning to drink heavily until April 1st.


Ok, as I drill into this here, I really think that the easiest answer is to just outlaw meetings from 3/11-4/1. 


No meetings allowed from march 11 to april 1. 


I'm going to resign on 3/10 and then get a new job on Apr 2.

I don’t care who you are, that right there is funny  Hope the humor helps you through the patch.

Interesting Training Opportunities for the 2007 Wave

So I went through the lineup of webcasts Microsoft has lined up for November and things are really starting to heat up. First of all, these webcasts are delivered by TechNet presenters, friendly speak for “coherent technical people”, so you know its going to be great. I’ve registered for these, and will unfortunately miss the UC overview one since I’ll be in Vegas that week… but these look quite impressive:

An In-Depth Look at Windows SharePoint Services 3.0 and Office SharePoint Server 2007 (Level 200)
Wednesday, November 01, 2006 - 11:30 AM - 12:30 PM Pacific Time

TechNet Webcast: Microsoft Unified Communications Overview (Level 100)
Friday, November 03, 2006 - 9:30 AM - 10:30 AM Pacific Time

TechNet Webcast: High Availability and Clustering in Exchange Server 2007 (Level 300)
Monday, November 06, 2006 - 9:30 AM - 10:30 AM Pacific Time

TechNet Webcast: Introduction to Windows PowerShell Scripting in Exchange Server 2007 (Level 200)
Friday, November 17, 2006 - 9:30 AM - 11:00 AM Pacific Time
Kevin Remde, TechNet Presenter, Microsoft Corporation

Momentum Webcast: A Sneak Peek at Outlook 2007 and Exchange Server 2007 (Level 100
Monday, November 27, 2006 - 9:00 AM - 10:00 AM Pacific Time

Optimizing your Infrastructure with Windows Vista, Exchange Server 2007, and the 2007 Office System (Level 100)
Wednesday, November 08, 2006 - 11:00 AM - 12:00 PM Pacific Time

Angry Vlad

People often wonder what causes things like Vladfire and other acts where I pour more gasoline on the fire. I tend not to share what goes on in my professional life because, honestly, putting this type of stuff in writing hurts. Nobody likes to document their abhorent failures or reinforce that no matter how far we get in documenting and perfecting the process things tend to go horribly wrong.

Such is the case that happened yesterday. Let’s play a little game here of “Guess how this goes wrong”; Here is the scenario, one of the customers servers needs to be reprovisioned as they are ready to move to MySQL 5 and start implementing their old spaghetti php-mysql code as stored sql procedures.

Vlad: I would like to have one of the servers reimaged with CentOS 4.3, minimal install. The box in question is a small Dell SC420 server in … rack, it is the only one of the kind. It is labeled as … as far as I recall

Make the system one big ext3 partition filling up all available space (- swap of course)

Username: root
Password: …

Disable firewall
Disable SeLinux
Grub Boot Manager

IPADDR=…
NETMASK=255.255.255.128
GATEWAY=…

Connected to the … switch.

Please update the ticket when you unplug the server before you proceed - I want to make sure that the correct server is being reimaged and not a production one.

Now if you’re in IT you can probably see where this one is heading. So here is Marlon’s response:

Marlon: We will begain the install now and update you once the work is complete.

Thanks!

Ok, sounds like he didn’t read the last part of the ticket, doesn’t it? Maybe I’m misinterpreting what “update the ticket when you unplug the server before you proceed” – perhaps I’m also misinterpreting what “once the work is complete” means too, but I’m smart enough to clear it up. Here is my response:

Vlad: I just want to make sure the correct box is pulled off the rack - as far as I can tell this system is still online.

Now certainly Marlon will read this part and respond with something along the lines of  “Not a problem, will update the ticket when I unplug it and before the imaging starts” but instead I get one of these:

Marlon: Currently, we do not have CentOS 4.3 on hand. WOuld you like me to proceed with CentOS 4.2?

Am I talking to the wall here?

Vlad: Absolutely -- but the server I wanted you to reimage is still online. Have you pulled it off the rack yet? I have to make sure that the correct one is pulled off because I no longer remember the label that was placed on it.

Now certainly at this point he understands what needs to be done here, case closed. Right? Right?

Kevin: Vlad,
The server should now be down. OS installation is in progress.

Umm. Not quite.

[root@… ~]# uptime
 14:29:11 up 20 days, 23:39,  0 users,  load average: 0.00, 0.00, 0.00–

Yup, They reimaged a production server. What more can you possibly say?

Vladville is Back

Woohoo, bigger and better than ever. Over the weekend I finally threw away Google's Blogger service and ported all of my posts and comments over to my own servers. The upside is that there are a whole lot more features and things I can do with Vladville now that I could not do with Blogger. The downside: spam. I feel its a good tradeoff and I am sure it will be easier to handle than all the downtime and mistakes Blogger used to make.

So here it is - fully powered by WordPress on CentOS Linux 4.3. There is still a Windows 2003 box behind the SBS Show for media streaming but that will soon either disappear or be upgraded, I have not fully decided how I'll be streaming future media content off Vladville - but you can bet there will be a LOT!

The move was very simple. Porting the Vladville theme to WordPress was less than amusing but after seeing what this can do I will be changing the theme again to something more Web 2.0ish. I would like to thank my friend Pablo Averbuj for helping me out yesterday with Apache Rewrites. You see, Blogger publishes the Atom XML as /rss/vladville.xml - its something thats in thousands and thousands of RSS feeds out there. Well, WordPress publishes feeds as /feed/rss2 or /?feed=rss. Since there was no way to do an internal redirect that would work here is the actual Rewrite rule Pablo came up with:

 <IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^rss/vladville.xml /index.php?feed=rss2 [P,L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>

The interesting rule is the one that is matching requests to /rss/vladville.xml and redirecting them to /index.php?feed=rss2. We tried this over and over and over again and could not get it to do internal redirection. Finally Pablo threw in a P in there (for proxy) and it works. What more can you ask for?  Here is an interesting conversation we had after we decided it was good enough:

Pablo: So you're returning RSS2 but aren't they expecting Atom?

Vlad: Yes.

Pablo: Eh, F em if they can't take a joke :)

So if your feed is broken happy belated April Fools day. For different feeds from Vladville (if its broken) use the following:

http://www.vladville.com/feed/rss2

http://www.vladville.com/feed/atom

That ought to do it!