mysql +svn + mantis 项目验证方式

客官°小女子只卖身不卖艺 2022-06-14 23:56 65阅读 0赞

<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>