Oddities with the MySQL “Table upgrade required” message

Here’s an obscure thing we spent some time on today that doesn’t affect our customers, but might be useful to someone else searching the Internet. The problem was a MySQL database table that, as far as we can tell, worked perfectly… except that it shows this message when we run CHECK TABLE:

Table upgrade required. Please do "REPAIR TABLE `users`" to fix it!

Read the rest of this entry »

MySQL Security Update

We applied a MySQL security update tonight. The version number remains 5.0.32, and customers should not notice any changes; the update just fixes several security issues.

The update was performed in such a way that new Web server connections were delayed during the 30 seconds or so that MySQL was unavailable on each server. That should mean that as far as scripts on your Web site were concerned, there was zero MySQL downtime.

Software updates: Ruby on Rails, phpMyAdmin, WordPress

We’ve updated several things on our servers today:

  • Ruby on Rails was updated from version 1.2.3 to 1.2.6. (If you use Rails on your site, our page explaining how to freeze Rails explains how you can get total control of Rails updates.)
  • phpMyAdmin was updated from version 2.11.2.1 to 2.11.2.2.
  • The WordPress software that runs this blog was updated to version 2.3.1. That doesn’t directly affect our customers — but if you’ve installed your own version of WordPress on your own site, this is a good reminder to update it: some older versions have security vulnerabilities. (We found that the update from 2.2.X to 2.3.1 was painless.)

Software updates: Webmail, Ruby, Perl, MySQL

We’ve installed several software upgrades on our servers. First of all, updates to our new Webmail system over the last few days fix:

  • An incompatibility with Mac OS Internet Explorer version 5.1 and earlier.
  • A problem that could cause an outgoing message to have an invalid “Reply-To” field in rare circumstances.
  • A bug where messages in the Sent folder could appear out of order.
  • An issue reported by one user that prevented viewing of a message with bad HTML code.

These fixes solve all the bugs that we know of in the new Webmail system (although we have plenty of feature requests that we’re working on). If you’re still using the old system, now’s the time to switch, or to let us know why you’re using the old system so we can address that.

In addition, we also upgraded the following software on our servers Monday night:

  • Ruby security updates (including libopenssl-ruby).
  • Perl and PCRE security updates (this update was intentionally delayed due to the need for extra testing mentioned in the Debian PCRE announcement).
  • MySQL client libraries that provide MySQL 3.23 and MySQL 4.1 backwards compatibility. (Updates to MySQL 5 are forthcoming but not yet ready.)

As always, let us know if you have any questions or concerns.

Major improvements to our Webmail pages

We’re pleased to announce that our new Webmail system is available. You’ll find many improved features:

  • A flexible search feature that lets you search through subjects, senders, and more.
  • The ability to optionally view “unsafe” images in HTML messages.
  • Preferences that permanently remember things such as your time zone and date format.
  • An easier-to-use address book.
  • Optional threaded message display.
  • Message filters (sorting incoming mail into certain folders) and highlighting.
  • Automatic conversion of many foreign-language character sets to UTF-8 display, making it easier to read messages written in other languages.
  • And much more…

If you’re already a Webmail user, you’ll see the new pages the next time you login. If you haven’t tried Webmail before, this page explains how to get started.

By the way, we’ll be keeping our old Webmail system around for a couple of weeks at this special address, just in case anyone experiences any problems and needs to temporarily “downgrade”. If you have any trouble with the new system, do let us know right away so we can address it before the old pages are permanently removed.

We’d also like to thank the more-than-200 people who helped us test the new system over the last few weeks. The new system is better because of your efforts.

phpMyAdmin Updated

We’ve updated phpMyAdmin to version 2.11.2. (In case you aren’t familiar with phpMyAdmin, it’s a Web-based system for managing MySQL databases without requiring you to use the command line; you can find more details on the phpMyAdmin home page.)

Sneak Preview: New Webmail

We’re pleased to announce that our new Webmail pages are available for public “beta testing”. The new Webmail system is a modified version of the popular SquirrelMail software, which has many features the older system lacks.

Read the rest of this entry »

Mailman invitation/verification messages improved

In response to customer suggestions, we’ve changed the appearance of Mailman invitation/address verification messages a little. Most notably, the messages now include your domain name in the subject, which should make it easier for people to recognize who you are and why you’re sending them the message.

You can see a sample on our page describing Mailman invitation messages.

Mail monitoring now checks AT&T and Yahoo

In an earlier post, we talked about how we use a monitoring system that forwards test e-mail to other large ISPs, then checks to make sure the message was promptly delivered.

We already check delivery to AOL, Comcast, GMail and Verizon, and we’ve now added AT&T/SBCGlobal and Yahoo mail. We’ll continue to expand it in the future.

An extensive monitoring and alert system is at the heart of our reliability, really; it’s what allows us to know that things are working properly. We can guarantee that if our customers send mail to those ISPs right now, it’s being delivered. That’s something few other companies even bother to check.

phpMyAdmin updated

We’ve updated phpMyAdmin to version 2.11.0. (In case you aren’t familiar with phpMyAdmin, it’s a Web-based system for managing MySQL databases without requiring you to use the command line; you can find more details on the phpMyAdmin home page.)