mod_auth_mysql

[Rich]

It looks like we do not have the module 'mod_auth_mysql' available under our Apache server(s).

Does anyone else have a need for this?

If so would it be possible to get it on our servers?

I'm starting to build up different user rights and having to track all these different .htaccess files is a bit error prone. I'd love to be able to have one database where all my users login name/pw can be stored and managed.

Does anyone know of any downside to asking for mod_auth_mysql to be installed?


Thanks!
R

[eugene]

Do you really need auth to be done via apache? You could use a php/mysql solution. Of course, if you want something that does use .htaccess/.htpasswd, you could do it via a custom php that directly modifies the .htaccess/.htpasswd files.
-Eugene

[eugene]

The .htpasswd files are located according to the following pattern:
/home/username/domains/yourDomainName/.htpasswd/public_html/htmlPath/.htpasswd

username = DirectAdmin username
yourDomainName = your domain name
htmlPath = path of the protected directory

-Eugene

[Rich]

Well....

I already have scripts that use PHP/mySQL for authenticating.

We also have some files which we protect via the .htaccess method. This is easy as we can create any web page, place it in a .htaccess protected directory and you must be authorized by .htaccess/apache to gain access. This works great.

However, with some applications needing the php/mysql database auth, and other needing the .htaccess/apache auth, it would be best if we can have one place to store username/pw's.

Otherwise we need to make sure the sql data matches the .htpasswd
Of course I could write a script to generate the .htpasswd files, but then we have to re-write the output every time the database is updated. Yes, that can be automated too... but....

It seems it would be much easier and less confusing to have the mod_auth_mysql as this is what is it designed for, one database for users/pw's.

I guess I'm trying to make management simple. Why make more work for the admins (me and other), if this can all be automated.

Does this make sense?