Re: [cobalt-users] mod_auth_mysql

["Steve Werby" <steve-lists@xxxxxxxxxxxx>]

"Bayhawk" <bayhawk@xxxxxxxxxxxxxx> wrote:
> Does anyone have a link to a decent guide that would give me some
> information on setting up mod_auth_mysql on a RAQ 4.
>
> I tried to compile, and ive tried to RPM, and neither seem to be working
as
> the path to various pieces are way out of whack on the RAQ's.

I'm running it compiled from source on several systems.  I always compile it
into Apache, but you may be able to install it as a DSO using apxs.  Here's
how I last did it (I think I had no problems installing and using the first
time by following the source instructions).

1. Install mod_auth_mysql

cd /home/downloads/
wget
http://download.sourceforge.net/pub/mirrors/mysql/Downloads/Contrib/mod_auth
_mysql-2.20.tar.gz
cd /home/work/
tar xfvz /home/downloads/mod_auth_mysql-2.20.tar.gz
chown -R root:root mod_auth_mysql-2.20
cd mod_auth_mysql-2.20/

./configure --with-mysql=/home/mysql_v1 --with-apache=/home/work/apache_1.3.
19

2. Configure Apache as usual, adding following line to Apache's
config.status

"--activate-module=src/modules/auth_mysql/libauth_mysql.a" \

3. To test mod_auth_mysql, create MySQL table entry, .htaccess file and add
line to httpd.conf for test site.

create database mysql_auth;
use mysql_auth;

create table mysql_auth (
username char(25) not null,
passwd char(25),
groups char(25),
primary key (username)
);

insert into mysql_auth values ("test1","mypassword","blah");

cd [DIRECTORY TO PROTECT]
pico .htaccess
AuthName                        "Whatever"
AuthType                        Basic
Auth_MySQL_DB                   mysql_auth
Auth_MySQL_Password_Table       mysql_auth
Auth_MySQL_Empty_Passwords      On
Auth_MySQL_Encryption_Types     Plaintext
Auth_MYSQL                      on
order                           deny,allow
require

pico httpd.conf
// Add to proper VirtualContainer block.
Auth_MySQL_Info                        <host> <user> <password>

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/