Rails - Nov 2005 - Deploying a RoR Intranet Application on Windows Server 2003

Hi everyone,

I just finished developing a small reporting application using RoR and
first I''d like to thank the community for the already much praised
awesomeness of this framework.  Now, my situation and question:

This application is pretty small and is probably only going to be used
by 3-4 people at any time.  Also I''m constrained to a Windows server
and I''m far more familiar with deploying on Mac and *nix servers.  I
figured that because of the size of the audience Apache + *CGI seems
like overkill and I''d rather just use WEBrick, which I had a pretty
good experience with in development.

What the best way to set up WEBrick to run continuously on WIndows
Server 2003?  As a service (which I don''t know how to do, but
I''ve
heard tossed around as a solution)?  If so, how would I do that?

Also, I''ve noticed that if I leave WEBrick running for awhile (> 24
hours or so), it will start throwing database related exceptions
(ActiveRecord::StatementInvalid on a query on my index page). 
Restarting the process fixes this.  What''s the best way to fix this in
production?  I''m ok with somehow scheduling a restart while the people
are out of the office (although I don''t know how).

Thanks,
Andrew

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You may be better off just configuring IIS to serve the rails  
application

http://wiki.rubyonrails.com/rails/pages/HowtoSetupIIS

That way you have even more control within Windows Server of setting  
up recycling if you need to, security etc etc.


On 8 Nov 2005, at 10:47, Andrew O''Brien wrote:
>
> What the best way to set up WEBrick to run continuously on WIndows
> Server 2003?  As a service (which I don''t know how to do, but
I''ve
> heard tossed around as a solution)?  If so, how would I do that?
>
> Also, I''ve noticed that if I leave WEBrick running for awhile
(> 24
> hours or so), it will start throwing database related exceptions
> (ActiveRecord::StatementInvalid on a query on my index page).
> Restarting the process fixes this.  What''s the best way to fix
this in
> production?  I''m ok with somehow scheduling a restart while the
people
> are out of the office (although I don''t know how).
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Darwin)

iD8DBQFDcpO8rG6rd6Dh5SERAo72AKCKSllb094reUQ9e47KpOyd/B7SxQCgo9ij
nUIMFrdBx2eJQxlc3C7VylI=I10K
-----END PGP SIGNATURE-----

I would agree with that. As much as I would love to use Apache for
hosting, we are windows shop ( :(  ) and I''m pretty much stuck with
IIS. That being said, setting up rails to run on IIS isn''t to terribly
painful. The wiki is a good start but is missing some of the stuff on
setting up FCGI. Do a google search for
bitslapped rails windows
and you should find another failrly good article to help you out. I''ve
gotten this setup working on several 2003 boxes so far, and while I
can''t say they have been used heavily I don''t see any problems
running
it like this. *crosses fingers*

On 11/9/05, Pete Wright
<peterjwright-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> You may be better off just configuring IIS to serve the rails
> application
>
> http://wiki.rubyonrails.com/rails/pages/HowtoSetupIIS
>
> That way you have even more control within Windows Server of setting
> up recycling if you need to, security etc etc.
>
>
> On 8 Nov 2005, at 10:47, Andrew O''Brien wrote:
>
> >
> > What the best way to set up WEBrick to run continuously on WIndows
> > Server 2003?  As a service (which I don''t know how to do, but
I''ve
> > heard tossed around as a solution)?  If so, how would I do that?
> >
> > Also, I''ve noticed that if I leave WEBrick running for awhile
(> 24
> > hours or so), it will start throwing database related exceptions
> > (ActiveRecord::StatementInvalid on a query on my index page).
> > Restarting the process fixes this.  What''s the best way to
fix this in
> > production?  I''m ok with somehow scheduling a restart while
the people
> > are out of the office (although I don''t know how).
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (Darwin)
>
> iD8DBQFDcpO8rG6rd6Dh5SERAo72AKCKSllb094reUQ9e47KpOyd/B7SxQCgo9ij
> nUIMFrdBx2eJQxlc3C7VylI> =I10K
> -----END PGP SIGNATURE-----
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Nov 10, 2005, at 7:45 AM, Nick Stuart wrote:
> I would agree with that. As much as I would love to use Apache for
> hosting, we are windows shop ( :(  ) and I''m pretty much stuck
with
> IIS. That being said, setting up rails to run on IIS isn''t to
terribly
> painful. The wiki is a good start but is missing some of the stuff on
> setting up FCGI. Do a google search for
> bitslapped rails windows
> and you should find another failrly good article to help you out.
I''ve
> gotten this setup working on several 2003 boxes so far, and while I
> can''t say they have been used heavily I don''t see any
problems running
> it like this. *crosses fingers*

Could you please update the Wiki with your experience?

Thank you!

jeremy
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (Darwin)

iD8DBQFDc6DiAQHALep9HFYRAqD5AJwI90jUhN4Y/XGNWdlEU4W06oFotACfUIrK
X+NmVrJMQBvZkiAAZA07Gyw=ngTA
-----END PGP SIGNATURE-----

Can do.

On 11/10/05, Jeremy Kemper
<jeremy-w7CzD/W5Ocjk1uMJSBkQmQ@public.gmane.org>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Nov 10, 2005, at 7:45 AM, Nick Stuart wrote:
> > I would agree with that. As much as I would love to use Apache for
> > hosting, we are windows shop ( :(  ) and I''m pretty much
stuck with
> > IIS. That being said, setting up rails to run on IIS isn''t to
terribly
> > painful. The wiki is a good start but is missing some of the stuff on
> > setting up FCGI. Do a google search for
> > bitslapped rails windows
> > and you should find another failrly good article to help you out.
I''ve
> > gotten this setup working on several 2003 boxes so far, and while I
> > can''t say they have been used heavily I don''t see
any problems running
> > it like this. *crosses fingers*
>
>
> Could you please update the Wiki with your experience?
>
> Thank you!
>
> jeremy
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (Darwin)
>
> iD8DBQFDc6DiAQHALep9HFYRAqD5AJwI90jUhN4Y/XGNWdlEU4W06oFotACfUIrK
> X+NmVrJMQBvZkiAAZA07Gyw> =ngTA
> -----END PGP SIGNATURE-----
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>