Is Mod_auth_mysql Installed?

[TheCanadian]

Hello!

 

I'm wondering if mod_auth_mysql is installed on the servers, and if anyone has any experience using it. I've tried creating an .htaccess file using instructions I found online, but all I get is a 500 Internal Server Error.

 

Here's the contents of my .htaccess file (minus the login info):

 

>AuthName "Members Area"
AuthType Basic

Auth_MYSQL_DB ********
Auth_MySQL_Username ********
Auth_MySQL_Password ********
Auth_MYSQL_Password_Table members
Auth_MySQL_Username_Field username
Auth_MYSQL_Password_Field password
Auth_MYSQL_Empty_Passwords Off
Auth_MySQL_Encrypted_Passwords Off
Auth_MYSQL On
Auth_MYSQL_Group_Table members
Auth_MYSQL_Group_Field type

require group Admin

[TweezerMan]

The Error Log in CPanel should indicate why you're getting a 500 error.

 

Looking at phpinfo() on my server, under apache / Loaded Modules, I do not see mod_auth_mysql as being loaded. I would presume this is the same on other TCH servers as well.

 

If you need to know for sure, submit a ticket to the Help Desk and ask them.

[TheCanadian]

Yep, you're right, there it is:

 

>.htaccess: Invalid command 'Auth_MYSQL_DB', perhaps mis-spelled or defined by a module not included in the server configuration

 

Is this module something that can be added? Or is there another way to have a database-driven list of users that would work with the existing modules?

 

PS - if it helps, phpinfo() tells me the following modules are loaded on the server I'm using:

mod_security, mod_auth_passthrough, mod_log_bytes, mod_bwlimited, mod_php4, mod_frontpage, mod_ssl, mod_setenvif, mod_so, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_status, mod_negotiation, mod_mime, mod_log_config, mod_env, http_core

[TCH-Rob]

You would have to open a ticket to see if it can be enabled on that server. You "may" also be able to enable it in your .htaccess file but I am not too familiar with it to say for sure.

[TweezerMan]

Rob: Apache server modules cannot be added or enabled from .htaccess files - this has to be done in the main server config file.

 

TheCanadian: mod_auth_mysql is not a core Apache module, so it is something that would have to manually installed on the server first before it could be enabled. I don't think the Help Desk would be willing to do that, but you can ask.

[TheCanadian]

TheCanadian: mod_auth_mysql is not a core Apache module, so it is something that would have to manually installed on the server first before it could be enabled. I don't think the Help Desk would be willing to do that, but you can ask.

 

Darn... you were right, they won't add it.

 

Can you think of another way of having a password-protected directory access (not just PHP or HTML files) integrated with MySQL? Any suggestions would be helpful!

Thanks

[TCH-Rob]

Well, looky there. I had done a quick Google and noticed something about modifying .htaccess in association with Mod_Auth.. I should read further before posting.