mortenbra / thoth-gateway

Thoth Gateway: PL/SQL Gateway Module for Microsoft IIS, similar to mod_plsql and ORDS (APEX Listener).
BSD 3-Clause "New" or "Revised" License
16 stars 8 forks source link

Basic Authentication: How To #9

Closed tomhillgreyridge closed 2 years ago

tomhillgreyridge commented 2 years ago

Hi there.

I'm trying out Thoth Gateway to replace ModPLSQL for some old web toolkit (non apex) applications that use Basic Auth. The documentation says that Thoth supports basic auth but I can't see how to set it up from the documentation.

As an example, we have an application which currently has two parts - public and authenticated and looks like this

# Basic url for the application - uses basic authentication so will pop up a prompt
# for an oracle database user and password and use that for the connection
<Location /application/authenticated>
  SetHandler                    pls_handler
  PlsqlDatabaseConnectString    [database connect string]
  PlsqlAuthenticationMode       Basic
</Location>

# public access section - uses hard coded username / password
<Location /application/public>
  SetHandler                    pls_handler
  PlsqlDatabaseConnectString    [database connect string]
  PlsqlAuthenticationMode       Basic
  PlsqlDatabaseUsername         public_user
  PlsqlDatabasePassword         public_password
</Location>

Can this be replicated in Thoth and, if so, how?

Apologies if this is already documented - I did have a good look through the parameters but couldn't see anything specific.

mortenbra commented 2 years ago

Hi,

The Thoth Gateway had support for Basic Authentication prior to version 1.3.7, at which point it was removed.

From the Release Notes (see /doc/release-notes.htm in the download):

Version 1.3.7: