Archive for August, 2007

A few highlights from the DC Church IT RoundTable last week (I am doing this from memory, so please feel free to chime in).

Download the Audio

We are hoping to meet again in October and are open for someone to volunteer a space. If you are interested, please let me know.

This past Sunday, Fr. Abraham Fam, a missionary priest in Zambia and close friend, shared with us on how to be an effective missionary.

Mission Life CenterWe just finished combining the Mission Life Center website and blog into a single site that revolves around the blog. Previously we were using Joomla! for the main site and WordPress for the blog. Now the site is running entirely on WordPress. We also are using Flickr instead of Gallery for new photos.

We decided to go with a WordPress only site to allow for simple, straightforward content updates. Other than the main blog, we only needed a few static pages, which WordPress handles well. The new site has a cleaner layout that is easy to navigate and easy to update.

DC CITRTJust a reminder that the DC Church IT RoundTable will be meeting tomorrow, August 24, noon at St. Mark Coptic Orthodox Church in Fairfax. VA.  Lunch will be provided.

Exchange 2003 to Google Apps Migration

Earlier this week we completed a migration from Microsoft Exchange 2003 to Google Apps Education Edition. This step by step howto is also valid when migrating to Google Apps Premier Edition or Non-Profit Edition, but not with the standard edition (Google only supports IMAP migration on premium accounts). There are many reasons why you would want to migrate to Google Apps from Exchange and several reasons not to, but I will leave those for another post.

1. Establish the Google Apps Account
Sign up for Google Apps Premier Edition – $50 / user account / year.
Sign up for Google Apps Education Edition – Non-profit organizations sign up here as well.
Note: Google says that it may take 1-2 weeks to review requests for the education and non-profit editions, but I have found that they usually reply within a day or two.

Already running Google Apps Standard Edition? Submit a request via the upgrade to Education Edition form. If you are running Premier Edition, you will have to downgrade before requesting the Education Edition.

Once you have established the account, you will be directed to the management dashboard for administrators. You can customize Google Apps under the ‘Domain settings’ tab, where you set the organization name, user support info, timezone, custom logo and control advertising.

2. Setup User Accounts
I recommed starting off with setting up user accounts, Google Apps supports several different ways for setting up/syncing accounts:

  • Creating new users one by one – Put in first name, last name and a username. Google can issue a temporary password or you can set it.

Create a new user

  • Bulk account update – You can upload a CSV file with the user account information.

Bulk account update

  • Google Apps LDAP Synchronization Tool – A package for synchronizing Google Apps for Your Domain with an LDAP server.
    • synchronizes users from Active Directory or openldap into Google Apps
    • detects new and exited users automatically and changes Google Apps accounts accordingly
    • handles user id / account renames automatically
    • handles attribute updates automatically
    • keeps track of changes and only propagates deltas (to allow syncing every 10 minutes for example)
  • Additional user managment options are available from Google Enterprise Professional Partners.

If you are migrating less than 100 users, the easiest thing is to create a spreadsheet with username. first name, last name and a temp password (unless you know the passwords) and perform the bulk update. The Google LDAP tool is still a little rough, I’d wait until it matures a bit unless you are very comfortable working with Python and LDAP. If you have a large user base, it is probably worthwhile to take a serious look at some of the Google Partners, Sxip Identity seems to have the most comprehensive single sign-on solution for Active Directory ($5/user/year – education discounts available).

3. Activate Email/DNS Cutover
Give your users a heads up that a new email system is on the horizon and define an outage period. The length of the outage will be mainly dependant on how much mail you have to move and how fast is your upload bandwitdh. It took us about 4 hours move 1GB of email on a 3mb pipe. I would set aside an entire evening/night for the migration.

Google has clear instructions for changing mail exchange (mx) records on the ‘Activate Email’ link. Make sure that you gave the same set of users created before cutting over. The DNS changes may take a few hours to propagate.

Activate Email

Optional: Change the Web address for email to something easy for users to remember, you can do so by clicking the ‘Email’ link on the Dashboard and choosing ‘Change Url’. Google suggests using mail.yourdomain.com. Google will walk you through changing the CNAME record in DNS, setting the destination to ghs.google.com. You may also want to do the same for the rest of the services that Google Apps provides.

4. Begin moving email archives with the IMAP Migration Tool
You will need to make sure that IMAP support is enabled on your Exchange Server and port 143 or port 993 (SSL) is open on your firewall. You will also need an account that has privileges to access all the users mailboxes or each user’s password.

Set up email (IMAP) migration

You can access the IMAP Migration Tool under the Advanced tools tab by clicking on ‘Setup up Mail (IMAP) migration’. Enter all the information for your Exchange server. I found that we did not need an IMAP path prefix but we did need to exclude serveral folders (if you don’t exclude calendar and contacts they will show up as email items). I wouldn’t recommend more than 1 or 2 connections to the server unless your Exchange box is sitting at a data center on a fat pipe.

Establish server connection

Next you will be asked to specify the user accounts to migrate, once again you have a choice whether to do this one by one or via bulk upload. I recommend testing at least one account manually before moving to bulk upload.

Select how you want to specify user account for migration

When entering user accounts to migrate, you will need to specify a username of the format:
YourDomain/AdminUserName/UserMailbox
The password you specify in the next field is that of the AdminUserName you designated.

When you test the connection, if successful, it will list the folders found and the matching excluded folders.

Once the migration job is submitted, Google will give a job details page that will keep you up to date on the progress. Login to the test user account and verify all the email moved over correctly then repeat for the rest of the users (I would recommend smaller batches).

Tangent: We were running two domains on our Exchange server and were only migrating one to Google Apps. We also wanted to keep the old Exchange accounts active (but not receiving mail) just in case. To allow users from the domain that remained on Exchange to send email to the user who migrated off, we had to create external contacts for all the users who left and forward their mail. We also updated the default recipient policy to reflect only the remaining domain.

5. Export/Import Calendar and Contacts
Since we decided to issue temporary passwords, we went ahead exported CSV files from each users Outlook for calendar and contacts and then imported them into their Google account(an effective but cumbersome process). See Google help for details:

Calendar:
How do I migrate events from Microsoft Outlook Calendar to my calendar?

Contacts:
How do I export CSV files from other mail providers?
How do I import a CSV file?

There are more advanced/capable migration solutions available from Google Enterprise Professional Partners.

Note: There are no equivalents in Google Apps for Journal, Notes, and Tasks. Remember the Milk is a good alternative option for tasks that integrates well with Google Calendar.

6. Introduce your users to the world of Google Apps
Rather than inundating our users with too much information, we started them off with just the email and calendar portions of Google Apps. We plan on rolling out Docs and Spreadsheets soon.

Google Apps - Little Flock Christian School

Tuesday night we successfully migrated our school users from Microsoft Exchange to Google Apps Education Edition. By the grace of God and the hard work of two volunteers, David Armanious and Samer Salama, the migration went smoothly. We used the new IMAP migration tool that Google provides on premium accounts (educational institutions and non-profits get premium accounts for free) to move all the email over and then manually imported the contacts and calendar from Outlook for the administrative staff. Over the past two days all the staff and teachers have come in and confirmed that everything is working ok. So far we have gotten mainly positive reviews of Google Apps. I’ll try and post in depth details on the migration soon.

UbuntuIt has been a year since I made the switch to Ubuntu on my primary desktop and I can happily say that I have no regrets. Ubuntu has proven to be a stable, secure and usable operating system that can play reasonably well in a Windows environment. On the school side, we have already migrated from Microsoft Office to OpenOffice.org and are in the process of moving from Exchange to Google Apps. Ubuntu is becoming a serious option for us when Microsoft drops support for XP in April 2009.

My last major concern is systems management and it looks like Ubuntu may be addressing that now with their new Landscape tool, which is included with their paid support contracts. I emailed Canonical (Ubuntu’s owner) about non-profit/educational pricing for support and found that they do offer a 30% discount for educational institutions (no word on non-profits) and an additional 10% discount for large quantities for a total of 40% off. At $250 retail, the discounted price per desktop would be $150/year for 9×5 desktop support. Having a support contract may also help alleviate concerns that my current staff/volunteer team isn’t as savvy with Linux as they are with Windows, although they are eager to learn.

A friend of mine put together this beautiful letter sized print of 1 Chronicles 29:10-18.

High Quality Download: PDF (127mb) TIFF (220mb)

David’s Praise to God

St. George and St. Shenouda Coptic Orthodox Church launched a new web site (running on Joomla!) a few months ago.  On the site you will find an updated presentations page containing the latest Coptic Presentation Applications as well as new interactive lessons that teach you how to read the Coptic language.  Now if only we could get an RSS feed on the presentation page so we know when the new stuff is released…

Apple iMovie Gets an Overhaul – NewTeeVee’s Liz Gannes

Carpe digital by Mark Batterson

Read/WriteWeb’s Richard MacManus highlights IBM’s Report on “Media’s Mean Streets”

Guy Kawaski on The Seven Sins of Solutions