Apache2+svn+mysql Authentication Configuration Entry Detailed steps _win server

######## This configuration is available in httpd.conf or other. conf files
######## APACHE2 supports a variety of authentication/authentication methods, this article only involves MYSQL authentication/authentication Mode
#/svn is the address of the version library that is accessed in the browser or SVN client, such as: HTTP://XXX.XXX.XXX.XXX/SVN
<Location/svn>
DAV SVN
#/var/svn/test is the version library location on the server
Svnpath/var/svn/test
#版本库说明, "title" appears in the authentication window when you access the version library through the version library address
AuthName "Subversion Repository"
#此项目前只能是 Basic, other parameter values are not supported
AuthType Basic
#如果使用 MYSQL for authentication, it must be/dev/null, otherwise it will report: (9) Bad file descriptor:could not open password file: (null)
Authuserfile/dev/null
#关闭基本认证, after testing, this item seems to be omitted, the proposed retention
Authbasicauthoritative off
#打开 MYSQL Certification
Authmysql on
#只用 MySQL certification, that is, as long as the MySQL certification passed, it is considered to have access rights, if set to off, if there are other authentication methods, will continue to carry out other certification (similar and logic)
Authmysql_authoritative on
MySQL database access related configuration items for ###### MySQL authentication ######
#MYSQL数据库 IP
Authmysql_host 127.0.0.1
#MYSQL数据库 access port, can be omitted, default 3306
#Auth_MySQL_Port
#MYSQL数据库 Access User Name
Authmysql_user user_name
#MYSQL数据库 access Password
Authmysql_password Password
###### MYSQL certification used in specific data-related configuration items ######
#存放认证信息的数据库名称
authmysql_db svn_auth_db
#存放认证信息的表名称
Authmysql_password_table Users_test
#存放认证用户名的字段名称
Authmysql_username_field User
#存放认证密码的字段名称
Authmysql_password_field Pass
#密码加密方式, the following options are available: plaintext: plaintext; crypt_des:des symmetric encryption; crypt_md5:crypt_md5 encryption; Crypt:unix Crypt () encryption; PHP_MD5:PHP_MD5 encryption ; SHA1SUM:SHA1 encryption; mysql:mysql PASSWORD () function encryption; the difference between PHP_MD5 and CRYPT_MD5 is not verified.
Authmysql_encryption_types Sha1sum
#是否允许空密码访问, just enter user name access
Authmysql_empty_passwords off
#有三个可用值: User, group, Valid-user, generally use only valid-user
Require Valid-user
</Location>