Документ взят из кэша поисковой машины. Адрес оригинального документа : http://mirror.msu.net/pub/gentoo-portage/www-apache/mod-auth-mysql/files/12_mod_auth_mysql.conf Дата изменения: Sun Aug 9 03:38:18 2015 Дата индексирования: Tue Apr 12 18:18:41 2016 Кодировка:

LoadModule auth_mysql_module modules/apache2_mod_auth_mysql.so

# mod_auth_mysql can be used to limit access to documents by checking
# data in a MySQL database.

# This will enable user-based MySQL authentication of everything
# within /home/httpd. You'll need to do the following as the MySQL
# root user beforehand:
#
# CREATE DATABASE auth;
# USE auth;
# CREATE TABLE users (
# user_name CHAR(30) NOT NULL,
# user_passwd CHAR(20) NOT NULL,
# PRIMARY KEY (user_name)
# );
# GRANT SELECT
# ON auth.users
# TO authuser@localhost
# IDENTIFIED BY 'PaSsW0Rd';
#
# INSERT INTO users VALUES ('testuser', ENCRYPT('testpass'));
#
#
# # If you want tot make mod_auth_mysql work with apache-2.2, please uncomment
# # the following line:
# #AuthBasicAuthoritative Off
# AuthName "MySQL authenticated zone"
# AuthType Basic
#
# AuthMySQLUser authuser
# AuthMySQLPassword PaSsW0Rd
# AuthMySQLDB auth
# AuthMySQLUserTable users
# AuthMySQLNameField user_name
# AuthMySQLPasswordField user_passwd
#
# require valid-user
#

# This will enable group-based MySQL authentication of everything
# within /home/httpd. You'll need to do the following as the MySQL
# root user beforehand:
#
# CREATE DATABASE auth;
# USE auth;
# CREATE TABLE users (
# user_name CHAR(30) NOT NULL,
# user_passwd CHAR(20) NOT NULL,
# user_group CHAR(20) NOT NULL,
# PRIMARY KEY (user_name)
# );
# GRANT SELECT
# ON auth.users
# TO authuser@localhost
# IDENTIFIED BY 'PaSsW0Rd';
#
# INSERT INTO users VALUES ('testuser', ENCRYPT('testpass'), 'user');
# INSERT INTO users VALUES ('testadmin', ENCRYPT('testpass'), 'admin');
#
#
# # If you want tot make mod_auth_mysql work with apache-2.2, please uncomment
# # the following line:
# #AuthBasicAuthoritative Off
# AuthName "MySQL group authenticated zone"
# AuthType Basic
#
# AuthMySQLUser authuser
# AuthMySQLPassword PaSsW0Rd
# AuthMySQLDB auth
# AuthMySQLUserTable users
# AuthMySQLNameField user_name
# AuthMySQLPasswordField user_passwd
# AuthMySQLGroupField user_group
#
# require group admin
#

# Like the above this enables group-based MySQL authentication of
# everything within /home/httpd, but this configuration allows users to
# belong to more than one group. You'll need to do the following as
# the MySQL root user beforehand:
#
# CREATE DATABASE auth;
# USE auth;
# CREATE TABLE users (
# user_name CHAR(30) NOT NULL,
# user_passwd CHAR(20) NOT NULL,
# PRIMARY KEY (user_name)
# );
# CREATE TABLE groups (
# user_name CHAR(30) NOT NULL,
# user_group CHAR(20) NOT NULL,
# PRIMARY KEY (user_name, user_group)
# );
# GRANT SELECT
# ON auth.users
# TO authuser@localhost
# IDENTIFIED BY 'PaSsW0Rd';
# GRANT SELECT
# ON auth.groups
# TO authuser@localhost
# IDENTIFIED BY 'PaSsW0Rd';
#
# INSERT INTO users VALUES ('testuser', ENCRYPT('testpass'));
# INSERT INTO groups VALUES ('testuser', 'user');
# INSERT INTO users VALUES ('testadmin', ENCRYPT('testpass'));
# INSERT INTO groups VALUES ('testadmin', 'admin');
# INSERT INTO groups VALUES ('testadmin', 'user');
#
#
# # If you want tot make mod_auth_mysql work with apache-2.2, please uncomment
# # the following line:
# #AuthBasicAuthoritative Off
# AuthName "MySQL group authenticated zone"
# AuthType Basic
#
# AuthMySQLUser authuser
# AuthMySQLPassword PaSsW0Rd
# AuthMySQLDB auth
# AuthMySQLUserTable users
# AuthMySQLNameField user_name
# AuthMySQLPasswordField user_passwd
# AuthMySQLGroupTable groups
# AuthMySQLGroupField user_group
#
# require group user
#


# vim: ts=4 filetype=apache