h6e

On Debian:

sudo apt-get install libmysqlclient15-dev
wget http://barry.files.wordpress.com/2008/05/mod_auth_mysql-300-phpass.tgz
tar -zxvf mod_auth_mysql-300-phpass.tgz
cd mod_auth_mysql
make
sudo make install
sudo nano /etc/apache2/mods-available/auth_mysql.load

  LoadModule mysql_auth_module /usr/lib/apache2/modules/mod_auth_mysql.so

sudo a2enmod auth_mysql

In your Apache configuration:

<Location /trac/login>
  AuthType Basic
  AuthBasicAuthoritative Off
  AuthName "realm"
  AuthMySQLEnable On
  AuthMySQLUser XXX
  AuthMySQLPassword XXX
  AuthMySQLDB XXX
  AuthMySQLUserTable wp_users
  AuthMySQLNameField user_login
  AuthMySQLPasswordField user_pass
  AuthMySQLPwEncryption phpass
  require valid-user
</Location>

Then:

sudo apache2ctl restart

Tested on Debian 3.1 'Sarge'

Categories: Debian, Wordpress, Apache, MySQL, HowTos