Here we go again. Railo Setup Apache-Tomcat with IIS7.5 on Win7x64

My notes from a recent IIS7.5 setup on Win7x64 for Railo 3.3.1.000 Final (which uses Apache-Tomcat)

Started with a blank installation of IIS, by adding it as a feature in Windows 7x64bit

Using my already installed and running Railo 3.2 on Apache:

Edited C:\railoserver\tomcat\conf\server.xml. I changed line 55 back to default port 8888 (Had mine set to 80 previously)

<Connector port="8888" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" />

Restarted Apache.

For some reason, on my workstation the railoserver's connector hadn't been modified by the vivio installer to have the correct path variable "@@installdir@@" replaced with a static value.. (Which is required!)

Edited C:\railoserver\connector\iis7connect.bat and iis7remove.bat

Replaced "@@installdir@@" with "C:\railoserver" 

Ran iis7connect.bat

Created website in IIS, added jakarta as a virtual directory, pointing to C:\railoserver\connector as usual.

Then... Nuts... "Insert picture of ambiguous error here"

Eventually figured out that it wasn't lying to me.. there was a problem with the isapiFilterModule..

Edited: C:\railoserver\connector\isapi_redirect-1.2.30.properties
Replaced "@@installdir@@" with "C:\railoserver" 

(This workstation must have installed strangely... I thought this @@ stuff was supposed to be changed by the installer.. anyways...)

Restarted IIS.

Victory!!

Other Notes:

Read through: http://wiki.getrailo.org/wiki/Server_2008_R2_IIS_7.5_with_Tomcat_and_Plesk

Which mentions about 500.19  .. I only seem to get this error when attempting to setup a webroot outside of IIS   C:\inetpub\wwwroot    and I specifically get 0x8007000d   (Notice the d at the end... which microsoft says is an web.config error.. which it isn't in my case.. removing web.config just changes the error to 500... so I have a permissions issue in this case... great...)


I incorrectly thought it was something to do with web.config attempting to override a setting that had overrides disabled... (It wasn't) : http://learn.iis.net/page.aspx/376/delegating-configuration-to-webconfig-files/

This was actually caused by attempting to enable the rewrite module, when the rewrite module was not installed: http://www.microsoft.com/web/gallery/install.aspx?appid=urlrewrite2

RESTful resources

Learning about REST. http://tomayko.com/writings/rest-to-my-wife

Live Data Ottawa Barometric Pressure

Win 7 64Bit with SQL 2008 DSN Railo 3.2 Connection Problem?

I Just found: http://groups.google.com/group/railo/browse_thread/thread/b7c9614cf39090b5

Not for lack of trying, I couldn't get Railo 3.2 to connect to my local sql2008 datasource on my new 64bit windows pc. Turns out, microsoft changed something for datasources in windows 7..

The solution as it turns out is to create a datasource under "MSSQL - Microsoft SQL Server (Vendor jTDS)"  ... Apparently the regular Microsoft Vendor driver doesn't work for Microsoft anymore.

Customizing Error Messages in Railo 3.2 with IIS 7

I was having difficulty troubleshooting a new app on my server, and couldn't get past IIS'7 Error 500 screen. The default setting is to only show error messages when you're running the site on the server itself. I followed a helpful blog post to enable errors.

Many thanks to http://www.cfmldeveloper.com/post.cfm/enabling-railo-errors-on-iis7

Railo 3.2 Site on IIS7

Railo 3.2 Apache, with IIS7 on Windows server 2008 R2.

I had the Apache server.xml set up correctly, as I've done countless times... but the default document wasn't working... and all non .cfm files were pointing to IIS's default site.

Turns out, I hadn't made a website entry in IIS, to parallel the configuration in Apache's server.xml entry.... Its all making sense now. Requests routed to apache knew where they were because of server.xml, but IIS had to have a configuration to set the webroot for all the other file types (such as .html, .css, and .jpeg)

I still can't figure out how to make a site in IIS that isn't inside C:\inetpub\wwwroot\ as the permissions get all screwy... I'll leave that for another day.

Railo DSN with MSSQL2008r2

So today I had a frustrating hour or so trying to add a new SQL Server Authentication Mode login to my SQLExpress 2008R2 instance using management console (for the purpose of connecting with Railo 3.2 ).. which is supposed to be trivial... turns out it is... when you don't have SQL Server Authentication mode shut off, as it was in my installation.

For me, it was Steps 11 and 12 that were key.

http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/