scripts.mit.edu

MIT SIPB Script Services for Athena

sql.mit.edu default storage engine changed from MyISAM to InnoDB

November 20, 2014 at 7:07 pm by in

We have changed the MySQL default storage engine on sql.mit.edu from MyISAM to InnoDB. This change only affects newly created tables. Existing tables are unaffected, with the exception noted below of Trac databases. No user action is required.

InnoDB offers many improvements over MyISAM and has become the default engine upstream as of MySQL 5.5. Even though sql.mit.edu still runs MySQL 5.1, we made this change because it is required by Trac 1.0.2. We have also converted all Trac databases to InnoDB to let them continue working with Trac 1.0.2.

If you wish to take advantage of the new features provided by InnoDB, you can convert existing tables using the ALTER TABLE command. You can still create new MyISAM tables by passing the ENGINE=MyISAM parameter to CREATE TABLE. You can also convert InnoDB tables back to MyISAM with ALTER TABLE.

Note that the version of InnoDB running on sql.mit.edu does not yet support FULLTEXT indexes. We expect this to be eventually fixed when we upgrade to MySQL 5.6 or later. Until then, tables that use FULLTEXT indexes should be left on the MyISAM engine.

scripts.mit.edu Fedora 20 transition

August 26, 2014 at 1:25 pm by in

On Wednesday, August 27th, 2014, all of the scripts.mit.edu servers will be upgraded from Fedora 17 to Fedora 20, which was released on December 17. We strongly encourage you to test your website as soon as possible, and to contact us at scripts@mit.edu or come to our office in W20-557 if you experience any problems. The easiest way to test your site is to run the following commands at an Athena workstation and then visit your website in the browser that opens, but see this page for more details and important information:

athena% add scripts
athena% firefox-test

scripts.mit.edu Fedora 17 transition

June 10, 2012 at 5:20 pm by in

On Tuesday, June 26th, 2012, all of the scripts.mit.edu servers will be upgraded from Fedora 15 to Fedora 17, which was released on May 29. We strongly encourage you to test your website as soon as possible, and to contact us at scripts@mit.edu or come to our office in W20-557 if you experience any problems. The easiest way to test your site is to run the following commands at an Athena workstation and then visit your website in the browser that opens, but see this page for more details and important information:

athena% add scripts
athena% firefox-test

scripts.mit.edu Fedora 15 Transition

November 5, 2011 at 9:00 pm by in

On Monday, November 21, 2011, all of the scripts.mit.edu servers will be upgraded from Fedora 13 to Fedora 15, which was released on May 25. We strongly encourage you to test your website as soon as possible, and to contact us at scripts@mit.edu or come to our office in W20-557 if you experience any problems. The easiest way to test your site is to run the following commands at an Athena workstation and then visit your website in the browser that opens, but see this page for more details and important information:

athena% add scripts
athena% firefox-test

MS Office XML and OpenOffice.org file types added to white list

June 8, 2011 at 11:24 pm by in

Our whitelist of file types served directly to the web has for a long time included .doc, .xls, and .ppt. With the advent of new XML-based Microsoft Office formats, and with the popularity of LibreOffice and OpenOffice.org, there have been requests for whitelisting these additional file types. As of yesterday, the new Office XML filetypes — .docx, .xlsx, .pptx, etc. — as well as ODF file types — .odt, .ods, .odp, etc. — will also be served directly to the web.

In addition to files you place in your locker, this also affects files uploaded to your website via the standard upload feature of apps such as MediaWiki and WordPress.

The full list of whitelisted extensions is posted in our FAQ.

scripts.mit.edu Fedora 13 Transition

September 18, 2010 at 5:04 pm by in

On Sunday, September 26, 2010, all of the scripts.mit.edu servers will be upgraded from Fedora 11 to Fedora 13, which was released on May 25. We strongly encourage you to test your website as soon as possible, and to contact us at scripts@mit.edu or come to our office in W20-557 if you experience any problems. The easiest way to test your site is to run the following commands at an Athena workstation and then visit your website in the browser that opens, but see this page for more details and important information:

athena% add scripts
athena% firefox-test

Certificate Authentication in Safari

February 22, 2010 at 3:40 am by in

If you’ve tried to use our recommended configuration for authenticating users using MIT certificates, you’ve probably discovered that Safari users are not offered the opportunity to select a certificate. This is due to a bug in Safari’s SSL implementation where it will never present a certificate unless the server requires that it present one (we do not require that a certificate be presented, so that we can show a page saying “you need certificates”).

Starting today, we’ve added some additional code that will force Safari to show the certificate selection dialog. If you are using the recommended configuration for certificate authentication, this will take effect for your site automatically. (Specifically, what we now do is that force an SSL renegotation if we find the Safari browser.)

If you are using any other configuration than our recommended configuration, the behavior should not change.

(You can see the technical details of this change in our source browser.)

New Hostname Management Inteface

February 15, 2010 at 7:37 pm by in

The scripts.mit.edu team is pleased to announce a new online interface for managing your scripts.mit.edu hostnames (lovingly called Pony). You can now easily request short URLs to use with your scripts.mit.edu sites and reconfigure your existing hostnames.

WordPress autoinstaller upgraded to version 2.8.5

November 2, 2009 at 1:47 am by in

We’ve upgraded the WordPress autoinstaller on scripts.mit.edu to install WordPress version 2.8.5. This is the most current stable version of WordPress, and includes several security hardening improvements backported from the upcoming WordPress 2.9 release.

Ruby on Rails autoinstaller

August 16, 2009 at 4:37 am by in

At long last, we’ve just deployed a brand new autoinstaller for Ruby on Rails, the popular Ruby based web application framework.

Ruby on Rails has been supported on scripts.mit.edu for quite some time, but the setup process was entirely manual, and involved many nonintuitive steps. You can now get a working Rails installation up and running for your own application in less than 60 seconds by typing

$ add scripts
$ scripts-rails

from any Athena machine, and following the instructions.

This brings the count of autoinstallable applications up to 12:

advancedbook
django
e107
gallery2
joomla
mediawiki
phpbb
phpical
rails
trac
turbogears
wordpress

You can read more about these applications on our quick-start page.

Previous

© 2004-2020, the SIPB scripts.mit.edu project.
These pages may be reused under either the GFDL 1.2 or CC-BY-SA 3.0.
Questions? Contact scripts@mit.edu.

You are currently connected to pancake-bunny.mit.edu.