Apache MySQL authentication: mod

mod_myauth
MySQL authentication module for Apache 2

1. Copyright
Copyright (C) Svein Olav Bjerkeset, 2002-2014

The mod_myauth software is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This software is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License (GPL) for more details.
A copy of the GNU GPL can be found at the following URL:
http://www.gnu.org/copyleft/gpl.html

2. Introduction
The mod_myauth software package provides a DSO module for the Apache Web server making it possible to store usernames, passwords and group names in a MySQL database.
The module is built using MySQL's client library, so you will need to have this library installed in order to compile the module. You will also need to have the Apache WWW server installed of course.
NOTE: This module is for Apache version 2.x only, and will not work with version 1.3.x.

3. Downloading the source
The latest source code for mod_myauth can be downloaded from the following URL:
http://bjerkeset.com/mod_myauth/myauth-1.0.tar.gz
http://bjerkeset.com/mod_myauth/myauth-1.1.tar.gz
http://bjerkeset.com/mod_myauth/myauth-1.2.tar.gz
http://bjerkeset.com/mod_myauth/myauth-1.3.tar.gz
http://bjerkeset.com/mod_myauth/myauth-1.4.tar.gz
http://bjerkeset.com/mod_myauth/myauth-2.0.tar.gz (Apache 2.4)
http://bjerkeset.com/mod_myauth/myauth-2.1.tar.gz (Apache 2.4)

4. Configuration information

Parameter Name Req. Default Description
MyAuthHost No localhost Specifies the hostname of the MySQL server
MyAuthPort No 0 The TCP/IP port number the MySQL server listens on. Default value of 0 uses the standard MySQL port.
MyAuthDB Yes no default Name of the database used for authentication.
MyAuthDBUser Yes no default MySQL user to connect as. Must have SELECT privilege on both user and group table.
MyAuthDBPassw Yes no default Password used for connecting to MySQL.
MyAuthUserTable No users Name of table holding usernames nad passwords.
MyAuthGroupTable No groups Name of table holding group memberships
MyAuthUserField No uname Column name for user names
MyAuthPasswordField No password Column name for passwords
MyAuthGroupField No gname Column name for group names
MyAuthEncryption No MySQL Accepted encryption types (PlainText, Crypt, MySQL, MD5Base64, ALL) to the database after the first query.
MyAuthAuthoritative No on If this flag is set to off, other authentication schemes are allowed to authorize the user after this module has denied access.

Parameter Name	Req.	Default	Description
MyAuthHost	No	localhost	Specifies the hostname of the MySQL server
MyAuthPort	No	0	The TCP/IP port number the MySQL server listens on. Default value of 0 uses the standard MySQL port.
MyAuthDB	Yes	no default	Name of the database used for authentication.
MyAuthDBUser	Yes	no default	MySQL user to connect as. Must have SELECT privilege on both user and group table.
MyAuthDBPassw	Yes	no default	Password used for connecting to MySQL.
MyAuthUserTable	No	users	Name of table holding usernames nad passwords.
MyAuthGroupTable	No	groups	Name of table holding group memberships
MyAuthUserField	No	uname	Column name for user names
MyAuthPasswordField	No	password	Column name for passwords
MyAuthGroupField	No	gname	Column name for group names
MyAuthEncryption	No	MySQL	Accepted encryption types (PlainText, Crypt, MySQL, MD5Base64, ALL) to the database after the first query.
MyAuthAuthoritative	No	on	If this flag is set to off, other authentication schemes are allowed to authorize the user after this module has denied access.