Authentication using DB-stored user data... 1

[mk637]

Hi there,

I can be considered as a newbie in web-programming. I have the
following task to accomplish:

Development of a web-based tool, using perl-cgi scripts for dynamic
content on html-pages.

The web-server will be an apache server (version: don't know at the
moment, but could give you the information if required).

There is an existing Oracle-DB with an integrated user-management
(table with users and passwords etc.). The web-tool to be developed is
meant to be a new GUI for the already existing application.

That should be enough as an intro to the problem.

So my question is: how can I use the user-information already stored
in the database for an apache based web-user-login? Is it possible
implement? I have found out the information about LDAP-based login. It
should not be much different to enable a kind of db-connection to
extract login information, or is it?

I would be thankful for a quick reply.

Best regards,

 

[siberian]

Here is an option. Note though that performance will be terrible sinec apache on its own does not have db handle caching.

http://oskin.msk.ru/pub/linux/db/oracle/mod_auth_oracle.html

Search for mod_auth_oracle for more info.

 

[mk637]

Thanks a lot for the link.

Before I spend time in testing this module: have you ever worked whith this modul? Besides performance issues - is it stable? Can you describe any experience with it?

Thanks a lot again.

 

[siberian]

No, if I need to do database authentication I write my own authentication layer in perl usually or I use mod_perl and the generic dbi authentication modules available there that do not have perfomance issues.

I have used basic mod_auth_mysql before and it worked fine. Wasnt the fastest thing on the planet but my load was low so it worked.

If your traffic requirements are high (more then a request a second) this is not the way to go.