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:
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
@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.
Hi,
I got the same error as well.
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.
Hi Morten
Any news? May we help?
regards
Charly
@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
@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
Hi Morten
Everything works perfect now!
Many thanks!
Charly
Post a Comment