Thursday, July 15, 2010

Apex on Thoth Gateway and IIS 7

Several people have asked for instructions on how to run the Thoth Gateway (a mod_plsql replacement) on Microsoft Internet Information Server (IIS) 7.

I finally had the chance (and the time!) to test the configuration on a server running IIS 7. The biggest challenge was understanding the new administration console user interface for IIS 7; it was was slightly confusing for someone who is used to IIS 6.

After a bit of fiddling, I got the gateway up and running:



I have updated the installation instructions in the latest download package (version 1.2.1) with separate sections for IIS 6 and IIS 7. So download, unzip and read the instructions in the "doc" folder.

And leave a comment if you run into problems (or leave a comment if you managed to get it up and running using the instructions!).

8 comments:

carl.schmid said...

Hi Morten

Thank you very much for the IIS7 installation instructions. Everythin is fine but i receive the following Exception:


[FormatException: Die Eingabezeichenfolge hat das falsche Format.]
System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +7471623
System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +119
System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info) +39
PLSQLGatewayModule.OracleInterface.SetupOwaCGI(List`1 serverVariables, String hostName, String hostAddress, String basicAuthUsername, String basicAuthPassword) +315
PLSQLGatewayModule.PLSQLHttpModule.HandleRequest(Object o, EventArgs a) +823
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75


Versionsinformationen: Microsoft .NET Framework-Version:2.0.50727.4927; ASP.NET-Version:2.0.50727.4927

Do you have any idea, what's wrong?

regards
Charly

Morten Braten said...

@Carl:

Looks like it's a parsing error that happens when the gateway tries to split the client IP address into 4 numeric values and passing them on to the OWA package in the database.

I need to add some more logging and/or an exception handler to the relevant code, will post a comment here when I have a new build available.

Salim Hlayel said...

Hi,

I got the same error as well.

Philip said...

Hi,

Got this working successfully. Thanks for testing & writing up the notes for IIS 7.5 as we are going to use this for an external project.

Do you have any ideas how the authentication on IIS 7.5 could be switched on for internal use? I am looking at Windows authentication so I can trap the REMOTE_USER var.

carl.schmid said...

Hi Morten

Any news? May we help?

regards
Charly

Morten Braten said...

@Carl: I believe I have fixed your problem, but I am currently working on a few enhancements that I would like to roll into the next version along with the bug fix.

This includes proxy user authentication in Oracle using Integrated Windows Authentication on IIS, see http://code.google.com/p/thoth-gateway/issues/detail?id=2 for details.

Should have something ready over the weekend, stay tuned!

- Morten

Morten Braten said...

@Carl: There is a new version of the Thoth Gateway available (1.3.0), please download it and see if it fixes your problem.

- Morten

carl.schmid said...

Hi Morten

Everything works perfect now!

Many thanks!
Charly