Entries Comments



C&C-installed MySQL binaries

18 December, 2007 (09:04) | mysql | By: agraf

I’ve got some instructions up for how to use the C&C-installed MySQL binaries. Noone should have to install MySQL on ovid or vergil anymore, which will save lots of disk space. This also means you shouldn’t have to install upgrades.

I’ve been using this copy of MySQL for running this blog, and any other MySQL applications I happen to be running, for months, and it works for me. It looks like 26 other accounts are using this copy of MySQL already. Good for them!

Using the C&C-Installed MySQL Binaries
http://www.washington.edu/computing/web/publishing/mysql-installed.html

Update:

The old cron script should now work fine, due to changes in the setup script.

The mysql_upgrade script, which checks all tables in all databases for incompatibilities with the current version of MySQL Server, has a bug that doesn’t allow it to process passwords correctly. We are planning to upgrade MySQL to 5.0.45 on Jan 2nd. This version has the mysql_upgrade bug fixed.

Revising MySQL instructions

18 September, 2007 (14:58) | mysql, web | By: agraf

This week and next week I’m hoping to get all of the MySQL instructions I currently have at www.washington.edu/computing/web/publishing/ revised to reflect the current systems and relatively recent versions of the software they discuss.

Changes I’ve made so far

  • Merged myuw.net MySQL documentation into main docs (still needs some work)
  • Updated the warning about the size of the install on the install page
  • Removed ovid migration-specific notes from install page

Future MySQL documentation goals

  • Create migration and installation instructions for system-wide MySQL installation
  • Develop and publish policies governing how this installation will be upgraded and how databases will be migrated to new versions of MySQL

Moving MySQL from ovid to ovid21

18 June, 2007 (09:30) | mysql | By: agraf

The big move from MySQL 4 on ovid to MySQL 5 on ovid21 is well underway.

date Server # of MySQL
Servers
4/6/07 ovid 262
ovid21 40
4/9/07 ovid 259
ovid21 42
4/11/07 ovid 256
ovid21 53
4/16/07 ovid 253
ovid21 55
4/20/07 ovid 250
ovid21 66
4/23/07 ovid 250
ovid21 67
4/25/07 ovid 246
ovid21 76
4/30/07 ovid 245
ovid21 84
5/2/07 ovid 246
ovid21 87
5/4/07 ovid 244
ovid21 90
5/8/07 ovid 244
ovid21 94
5/14/07 ovid 240
ovid21 106
6/6/07 ovid 230
ovid21 137
6/13/07 ovid 230
ovid21 142
6/18/07 ovid 228
ovid21 148
6/28/07 ovid 228
ovid21 162
7/03/07 ovid 227
ovid21 167
7/09/07 ovid 195
ovid21 200

Instructions for installing MySQL 5 on ovid21 linked below. Now including notes that might help you move from MySQL 4 on ovid!

Installing and Starting MySQL 5.0
http://www.washington.edu/computing/web/publishing/mysql5-install.html

Back from vacation

4 June, 2007 (10:42) | Uncategorized | By: agraf

Today is my first day back from a 2 week vacation wherein I biked down some of the Washington and Oregon coast with some friends. I still have a lot of email to read.

Staff/Faculty/Depts/Courses web and web dev server upgrades

23 February, 2007 (11:05) | web | By: agraf

These servers are going to be upgraded from March to May 2007.  This means a lot of planning, communication, testing, and helping users get their pages and applications working on the new operating system, hardware, and software versions.

The web and web development servers will be moving from AIX to Linux.

The following Web-related software will be upgraded:

  • Apache Server: 1.3.29 -> 2.2.4
  • PHP Hypertext Preprocessor 4.3.10 -> 5.2.1
  • perl Scripting Language 5.6.0 -> 5.8.0

New software will be available:

  • Ruby on Rails (Rails 1.1.6 on Ruby 1.8.4)
  • New PHP capabilities: XML/XSL, multi-byte string functions, openSSL and more
  • New perl capabilities: multithreading, better numeric accuracy, new modules

This upgrade will cause all of the MySQL server running on Ovid to stop working, so people running those will need to install new versions of MySQL.

Any other compiled code will stop working, so people using compiled code on ovid or the web servers will also need to either install new versions or recompile their code.

Since all those scripting languages like Perl, PHP, and Python will be upgraded, people using those should make sure their scripts will run with the new versions.

Further information on the system upgrade can be found at:

Web Server Upgrade
http://www.washington.edu/computing/web/publishing/server-upgrade.html

If you have questions about this upgrade that can’t be answered by that web page, please contact me at help@cac.washington.edu.

Web Accessibility Capacity Building Institute

6 December, 2006 (16:23) | accessibility | By: agraf

Nov 29th - Dec 1st I attended the Web Accessibility Capacity Building Institute (CBI) organized by DO-IT.

Adam at the CBI
(pictures taken by Rick Ells)

The institute has a blog that contains opinions arrived at via group discussions and some additional content I won’t link to from here. Rick Ells, whom I heard about the institute from, is likely to publish his notes at some point. When he does, I’ll link to them.

Web Apps - The Next Generation: Access Opportunity or Challenge

T.V. Raman, Google

  • Users without normal use of vision install multiple screen readers - writing web pages or applications for a specific screen reader is inappropriate
  • Assistive Technology (AT) like screen readers assume a desktop application model. Browsers are presumed to display static pages. Rich applications running in a browser can confuse AT.

Access Goals

  • retain the present level of access
  • increase reach with wider access
    • accessibility to more users
    • accessibility in more contexts

Access Building Blocks

  • Content: include adequate semantics
  • User Interface: degrade gracefully
  • AT: bridge the gap

If something is a menu, say so! People unable to see that it looks like one won’t know otherwise.
What to speak: Content should be separate from format and controls.

How to speak: Aural CSS

When to speak: Event handlers allow spoken feedback to reflect visual updates

RSS is good for accessibility. It’s well-structured and provides a minimum of understandable content.

Community-based captioning may be a good solution for making uploaded video accessible.

Including open APIs in web tools is perhaps the best way of supporting accessibility for those tools, as those affected or in-touch with the challenges of accessibility are best suited to create accessible interfaces.

Assistive Technology Vendor Panel

T.V. Raman, Google
Doug Geoffray, GW Micro

XSL scripts in emacspeak can be exchanged within a community as greasemonkey scripts are, providing a network effect that allows users to simplify their web experience.

The “threshold of indignation” between blind and sighted users is very different. This is why sighted users that attempt to navigate the web via a screen reader alone will become frustrated very quickly.

Macs using OSX Tiger or later include voiceover, a built-in AT application.

W3C Roadmap for Accessible Rich Internet Applications

Rich Schwerdtfeger, IBM & W3C Web Accessibility Initiative

XForms will enable much more accessible web applications and richer form and interface elements. Hopefully browsers will include support for this soon.

Presentation

W3C Web Content Accessibility Guidelines 2.0

W3C Dynamic Accessible Web Content Roadmap

Management Panel: Policies, Practices and Processes for Maintaining Accessibility

Bill Corrigan
Cheryl Hammond
Wei-zhong Wang

  • The legal threat of inaccessible paperless systems required to complete job tasks may drive change in accessibility.
  • How can podcasts be made accessible?
  • Many Captchas aren’t accessible.
    • Alternate solutions include integer addition and audio captchas.
  • Try replacing images on a page with their alt text in order to test them for understandability.
  • Don’t assume that your pages & apps are accessible when they meet a standard.

Accessibility of Rich Adobe Applications

Bob Regan, Adobe

Some of the applications presented are quite a bit more accessible than I expected Flash could be.

Bob has developers use a screen reader for an hour every day for 3-6 weeks in order to give them a feel for how to write applications that will be usable via screen reader.

Working Rails App

23 October, 2006 (13:46) | ruby | By: agraf

Today I got a Rails application working properly on the Alumni server. The application is Tracks, which implements some very specific type of todo tracking. I installed a 5.0.x version of MySQL, since Rails didn’t seem to interact well with a 4.1.x version I already had installed. I altered the .htaccess and dispatch.cgi files in the public/ folder, and made some adjustments to the default DATETIME values, which apparently weren’t compatible with MySQL.

Both of the Rails applications I’ve looked at so far have been intended for use with SQLite. I’m used to using MySQL as the database back-end of web applications, but SQLite may be a better choice with Rails applications.

The application can be accessed on my alumni account: Tracks login .

Log in with the username “guest” and the password “12345″.

Ruby on Rails on Vieyra

18 October, 2006 (14:31) | ruby | By: agraf

Ruby and Rails are now installed on the Alumni web and web development hosts.

Installing Rails applications is a bit different from PHP or Perl, so we might want to write up some instructions for how to get them working.

I ran the ‘rails’ command to test the installation and created this directory.

The next step will be to understand how to install Rails applications created by other people and make them work.

New Position

16 October, 2006 (10:23) | Uncategorized | By: agraf

I started this new position at Computing and Communications on October 9th. Since then I’ve been working on getting up to speed on things that have changed since I left C&C in July, scheduling meetings, arranging access, and filling out insurance forms.

Let me know if you have any questions about web publishing, running databases or scripting languages on the Uniform Access web servers or web development hosts, or if you need help on any projects in these areas.