JUst installed mod_auth_mysql, need some help

It only took 3-4 hours. Not bad considering I've never messed with Apache modules before.

Here is what I did:

Followed instructions in "Read me" file that comes with the mod_auth_mysql-2.20.tar

FTPd that tar file to my /usr/local/src directory

telnet into server as root user
cd /usr/local/src
tar -zxvf mod_auth*
cd mod_auth_mysql-2.20
./configure --with-mysql=/usr/local/mysql --with-apache=/usr/local/apache

# (Press enter) a bunch of lines of text on screen. Looked OK

make

# press enter

a bunch of scrolling text that end with a message that basically says please use your apache's configuse script. Don't remenber exactly what that message was, but I changed into /usr/local/apache/compile directory and entered the ./configure with the exact parameters that the previous message instructed me to do.

After some scrolling text, entered make, then enter, then make install.

Apache recompiled. stopped the runnig Apache by kill -TERM <pid> #(pid found in /usr/local/apache/logs/error.log)

Then restarted the new recompiled apache with ./httpd command. # ./httpd command must be entered from the /usr/local/apache/bin directory

Apache started OK. Checked what modules I got by ./httpd -l
mod_auth_mysql.c was there the last on the list. Very good. I also notived that some of my previous modules was gone. But that's another story. I had to go back and edit the Configuration and Configuration.apaci files in the /usr/local/apache/compile/src directory (since I was not sure which one of those is the actual configuration file, so I edited both)

Made sure that the line:

## On-the-fly activated module
## (configure --activate-module=src/modules/auth_mysql/libauth_mysql.a)
AddModule modules/auth_mysql/libauth_mysql.a

Was at the end of the list.

After editing those files, from the same directory entered ./Configure
make
# important to know that Configure script is not the same as configure script. They are also in different directories.

make install
pressed enter, got the error message that said to try make install from the parent directory. cd .. moved up to parent directory.
make install
enter

It worked.

Stopped Apache again, restarted it again, checked ./httpd -l

All me modules are there, including my mod_perl, mod_rewrite, and whatever else I entered in the Configuration scripts. Of cause the mod_auth_mysql is there too at the end of line. Installation is complete

Now I'm stuck at testing it. In particular I am looking for help on how to use Unix Des encription when intering passwords in to the mysql_auth table.

Also, if I choose to use unencrypted passwords (clear text), whould that mean that the browser will send password in clear text to mod_auth_mysql?

Anyway, please help me with entering account and passwirds into mysql table. I already created the table mysql_auth with all 3 default columns - username, passwd, and group.

I got it!

You don't need to encrypt passwords at all. Just put this directive to your httpd.conf
Auth_MySQL_Encryption_Types Plaintext

Another useful directive:
Auth_MySQL_Empty_Passwords off

Then I created test user in the default table mysql_auth in the default database http_auth

Then entered values into that new table like this:
INSERT INTO mysql_auth VALUES('testuser','blah','testers');

And don't forget to put this into your httpd.conf file at server level:
Auth_MySQL_Info localhost theuser thepass

In this case "theuser" is the user name of the user that has access to http_auth database with the password "thepass"

In case you don't know how to create the user in mySQL and give him right to database, here is the syntax:

First, login to mysql as root;

mysql> GRANT ALL PRIVILEGES ON something.* TO theuser@localhost
IDENTIFIED BY 'thepass' WITH GRANT OPTION;

In this short statement user name theuser is created, the password thepass is created, and he can only use database "something", having every possible permission on "something" database.