This is mod_mysql_userdir for Apache 1.3.xx and Apache 2.xx
The initial code came from mod_ldap_userdir by John Morrissey. It is a fully functional replacement for mod_userdir which allows you to get a users home directory from a MySQL database server. top

What’s New and Changed

Version 1.2 Released!
The 1.2 code base is ready for general release. All the code is released under the GPL
Tested with MySQL 3.xx and 4.1 - Both working.


mod_mysql_userdir 1.2.
mod_mysql_userdir 1.2 RPM for RHEL 3


Current Readme File

mod_mysql_userdir v1.2

mod_mysql_userdir is a module that enables the Apache web server to look up
user home directories (for /~user URLs) from an MySQL database.

1. Author
2. Licensing
3. How do I install and set up mod_mysql_userdir?
4. Changes
5. To Do
6. Thanks

1. Author

Matthew M. Gamble .

Project home page: http://www.mgamble.ca/oss/mod_mysql_userdir/

Feedback is much appreciated. If you are using mod_mysql_userdir successfully,
are having issues, or have some patches, please let me know.

The inital interface and ideas are borrowed from mod_ldap_userdir
John Morrissey, , http://horde.net/~jwm/software/mod_ldap_userdir/ Thanks John!

The 1.1 and 1.2 releases are thanks to bug fixes from Kevin Bonner .See the changelog for full details.

2. Licensing

mod_mysql_userdir is licensed under the GPL.

Copyright (c) 2005 Matthew M. Gamble. All Rights Reserved.

3. How do I install and set up mod_mysql_userdir?

1) Edit the Makefile and set the following:

APXS=/usr/local/apache/bin/apxs <-- Path to apxs binary
LIBS=-lmysqlclient -lz -L/usr/lib/mysql <-- MySQL lib directory
LDFLAGS=-I/usr/include/mysql <-- MySQL headers directory
ACTIVATE=-a <-- apxs switch to activate module (Default should be fine)

2) Change the settings in mysql_userdir.conf to match your enviroment and add the directives to your httpd.conf file.

Redhat / Whitebox / CentOS / Fedora users:

You can edit and copy the mysql_userdir.conf file into /etc/httpd/conf.d directory which will auto-load into the main httpd.conf

3) Restart apache and enjoy (assuming your database is setup, etc)

4) Found a bug? Let me know!

4. Changes


* Makefile: minor cleanups to use the Make macros
* RPM spec: do not overwrite the config file if it already exists.
* Apache conf: add IfModule tags around the config lines so apache doesn't die if the mysql_userdir module isn't loaded
* DIRECTIVES: List the available variables for MySQLUserDirDBQuery. Add info
for MySQLUserDirDBName


* Moved to version 1.1 due to large number of changes
* Patch from Kevin Bonner :

"Changes include: some whitespace cleanup, moved the logging functions to a
standard area and removed the large ifdef clutter in the code, reorder the
MySQL query handling section (should work with MySQL 3.X), add Apache2 hooks
to call child_init_mysql_userdir which sets up the MySQL db connection,
replace %h with the request hostname, removed unused variables/defines"

* Fixed the copyright - should go to Primus
* RPM spec file fixed.

* Code cleanup
* Finish testing on MySQL 4.1 - Working
* Tested on FreeBSD 5.3 - Working
* Tested on RHEL 3 - Working
* Built RPM for RHEL 3

* First public release branch.

5. To Do

* Write configure scripts so I don't have to keep changing the makefile

6. Thanks

* Primus Telecommunications Canada Inc for supporting me up to version 1.02
* John Morrissey, , for writing mod_ldap_userdir