MySQL-based Apache user authentication instance

MySQL-based Apache user authentication instance-Linux Enterprise Application-Linux server application information. The following is a detailed description. Apache version: 2.0.54
Required module: mod_auth_mysql
Above software: http://www.bruce.com.cn/software

Apache requires DSO compilation and installation. Assume that apache is installed in the/usr/local/apache directory, and mysql is installed in the/usr/local/mysql directory.

First download mod_auth_mysql: http://www.bruce.com.cn/software... _mysql-2.9.0.tar.gz

[Root @ www software] # tar xzfv mod_auth_mysql-2.9.0.tar.gz
[Root @ www software] # cd mod_auth_mysql-2.9.0
[Root @ www mod_auth_mysql-2.9.0] #/usr/local/apache/bin/apxs-c-I/usr/local/mysql/include-L/usr/local/mysql/lib- lmysqlclient-lm-lz mod_auth_mysql.c
[Root @ www mod_auth_mysql-2.9.0] #/usr/local/apache/bin/apxs-I mod_auth_mysql.la

Edit the httpd. conf file.
[Root @ www mod_auth_mysql-2.9.0] # vi/usr/local/apache/conf/httpd. conf
Add the following lines to httpd. conf: (The following is an excerpt from my httpd. conf)

LoadModule mysql_auth_module modules/mod_auth_mysql.so



AuthType Basic
AuthMySQLHost localhost
AuthMySQLPort 3306
AuthMySQLDB database # database to be accessed
AuthMySQLUser mysql_user # user accessing the database
AuthMySQLPassword user_password # User Password
AuthMySQLPwEncryption md5 # MD5 Encryption
AuthMySQLEnable On
AuthMySQLUserTable user_table # data table to be accessed
AuthMySQLNameField username # username Field
AuthMySQLPasswordField password # password Field
AuthMySQLGroupTable user_table # Same as the user table
AuthMySQLGroupField mygroup # user group field



As you can see from the above configuration, this module does not have special requirements for the user table, as long as the user name and the corresponding password can be found, if you need to verify a group, the group column is required.

All users in the company have the same Group. Therefore, group users are generally used for verification. Therefore, you must add the column user_group in the plog_user table, and update the user_group column of all rows to a fixed

Value, for example, mygroup.

Here, groupTable and UserTable are the same table. If you want a user to belong to multiple groups, you must create another group table.

After completing the preceding steps, add the. htaccess file to the directory to be encrypted as follows:

[Root @ www MySQL] # more/home/bruce/html/software/. htaccess

AuthType Basic
AuthName "resource download is only available to Members"
Require valid-user

Restart apache again

[Root @ www mod_auth_mysql-2.9.0] # service httpd restart

After using this authentication method, your browsing records can be kept in Apache logs. You can view your views using awstats and other log statistics software, the Knowledge Flow inside the company can be clearly viewed.