Using mod_auth_mysql [SOLVED]

ralvez · 2007-10-13 18:19:08

I have a client that wants to have a "dual" option to the log in process via a web interface.
Currently I have LDAP working to log in into the web site but ... in case the LDAP server would have *any* problem (due to maintenance, or whatever) they want to have a redundant access via mySQL.
Now, redundancy is not a problem (apache allows that) but I do not seem to find anywhere in the repos the module "mod_auth_mysql".
I'm sure this is not an "innovative" scenario and that it is used a lot out there and therefore it must be in the repositories but I'm just querying the wrong name, wright?

So, my question is: where do I find it or rather what's the name I should query? Or ... it does not exist and I have to build it from source?

I apprecitate any help.

R.

Last edited by ralvez (2007-10-19 01:31:49)

ralvez · 2007-10-16 03:16:05

Did I post this in the wrong forum? I cannot believe I'm the only guy doing this type of things ... am I?
Should I post somewhere else other that this forum?

Thanks.

R

snowbear · 2007-10-17 21:50:41

Did you look at mod_authn_dbd & mod_dbd?

ralvez · 2007-10-17 22:16:07

Querying for them does not return any results.
Aside from that, dbd is a different approach using a database which is not MySQL.

Thanks anyway.

R

snowbear · 2007-10-18 17:28:24

I have never heard about mod_auth_mysql before, so I did a search and I think, it has been obsolete since apache 2.1. Apache stock modules (mod_authn_dbd, mod_dbd) should do the job for you, look at example (with PostgreSQL) here: http://httpd.apache.org/docs/2.2/mod/mo … ml#example

from apache documentation:

mod_authn_dbd provides authentication front-ends such as mod_auth_digest and mod_auth_basic to authenticate users by looking up users in SQL tables. Similar functionality is provided by, for example, mod_authn_file. This module relies on mod_dbd to specify the backend database driver and connection parameters, and manage the database connections...

mod_dbd manages SQL database connections using apr_dbd. It provides database connections on request to modules requiring SQL database functions, and takes care of managing databases with optimal efficiency and scalability for both threaded and non-threaded MPMs...

mod_dbd has currently drivers for: MySQL, Oracle, PostgreSQL, SQLite2, SQLite3;

Last edited by snowbear (2007-10-18 18:44:32)

ralvez · 2007-10-19 01:31:08

snowbear,

Thanks for your assistance and for taking the time to look into this, I appreciate it.
I've also been looking for answers as to why I cannot find the module, the reason ... it is built into the standard Apache distribution.
It's not active by default, like the other modules, but uncommenting the line in /etc/httpd/conf/httpd.conf gets the module ready for use.
Once again, thank you very much.

Regards,

R.

Arch Linux

#1 2007-10-13 18:19:08

Using mod_auth_mysql [SOLVED]

#2 2007-10-16 03:16:05

Re: Using mod_auth_mysql [SOLVED]

#3 2007-10-17 21:50:41

Re: Using mod_auth_mysql [SOLVED]

#4 2007-10-17 22:16:07

Re: Using mod_auth_mysql [SOLVED]

#5 2007-10-18 17:28:24

Re: Using mod_auth_mysql [SOLVED]

#6 2007-10-19 01:31:08

Re: Using mod_auth_mysql [SOLVED]

Board footer