Deploying to A2 Hosting from Windows

[enspired]

I am admittedly a Ruby Newbie and I am inexperienced in *nix/Apache
environments. I recently set up a hosting account with A2 hosting
(www.a2hosting.com) and am trying to get my first rails app deployed. I
think I'm getting close but I've now encoutered a MySQL binding issue
trying to use the hashed_password functionality.

Does anyone here have experience deploying rails from Windows to A2? I
could use some assistance.

Many Thanks,
Jason

 

[Curt Hibbs]

I am admittedly a Ruby Newbie and I am inexperienced in *nix/Apache
environments. I recently set up a hosting account with A2 hosting
(www.a2hosting.com) and am trying to get my first rails app deployed. I
think I'm getting close but I've now encoutered a MySQL binding issue
trying to use the hashed_password functionality.

Does anyone here have experience deploying rails from Windows to A2? I
could use some assistance.

Depending on what version of MySQL you are using, you might be running
into the problems caused by the fact that MySQL changed the hashing
algorithm used for passwords starting with version 4.1.7. You can find
more info about that here:

http://dev.mysql.com/doc/mysql/en/Old_client.html

Curt

 

[enspired]

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.