Tech support at A2 has been increasingly helpful. They resolved the
MySQL hashed_password issue and I've been able to get my application to
run. Now we're working through FastCGI issues. The Apache error log
shows the following...

[Tue Jul 26 00:19:15 2005] [warn] FastCGI: (dynamic) server
"/home/jcartwri/public_html/rails/dispatch.fcgi" started (pid 10608)
FastCGI: can't start server
"/home/jcartwri/public_html/rails/dispatch.fcgi" (pid 10608), execle()
failed: No such file or directory
[Tue Jul 26 00:19:15 2005] [warn] FastCGI: (dynamic) server
"/home/jcartwri/public_html/rails/dispatch.fcgi" (pid 10608) terminated
by calling exit with status '255'
[Tue Jul 26 00:19:20 2005] [warn] FastCGI: (dynamic) server
"/home/jcartwri/public_html/rails/dispatch.fcgi" restarted (pid 10627)
FastCGI: can't start server
"/home/jcartwri/public_html/rails/dispatch.fcgi" (pid 10627), execle()
failed: No such file or directory
[Tue Jul 26 00:19:20 2005] [warn] FastCGI: (dynamic) server
"/home/jcartwri/public_html/rails/dispatch.fcgi" (pid 10627) terminated
by calling exit with status '255'

My dispatch.fcgi file is actually located at
..../rails/public/dispatch.fcgi so it appears the path is incorrect.
Hopefully we will resolve this issue soon as well.

And finally, adding SetEnv RAILS_ENV production doesn't seem to work in
my .htaccess file. I hacked the environment.rb file to get it to change
environments, but obviously this is not the prefered approach.