mysql +svn + mantis 项目验证方式

<Location /repos/test>
#DAV svn
#SVNPath /swp/svn-repository/test
AuthType Basic
AuthName "test SVN Repository"
# Require SSL connection for password protection.
# SSLRequireSSL
<ifModule mod_auth_mysql.c>
# Limit write permission to list of valid users.
<Limit GET PROPFIND OPTIONS REPORT>
Require valid-user
</Limit>
<LimitExcept GET PROPFIND OPTIONS REPORT>
Require group 40 55 70 90
</LimitExcept>
AuthBasicAuthoritative Off
AuthMySQLEnable On
AuthMySQLHost localhost
AuthMySQLUser root
AuthMySQLPassword root
AuthMySQLDB mantisup
AuthMySQLUserTable "mantis_user_table u, mantis_project_user_list_table pl, mantis_project_table p"
AuthMySQLNameField u.username
AuthMySQLPasswordField u.password
AuthMySQLUserCondition "u.enabled = 1 and u.id = pl.user_id and pl.project_id = 2 and p.enabled = 1 and p.id = 2 and \"%U\" like p.file_path"
AuthMySQLPwEncryption md5
AuthMySQLGroupTable "mantis_project_table p, mantis_project_user_list_table pl, mantis_user_table u"
AuthMySQLGroupCondition "p.id = pl.project_id and pl.access_level >= p.access_min and pl.project_id = 2 and u.enabled = 1 and u.id = pl.user_id and pl.project_id = 2 and p.enabled = 1 and p.id = 2"
AuthMySQLGroupField pl.access_level
AuthMySQLAuthoritative ON
</ifModule>
</Location>