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:

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: (Apache 2.4) (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.