[ILUG] SVN & virtual users

[Stephen Burke]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Thu, 25 Nov 2010, FRLinux wrote:
> I have a new setup in the works for a standard SVN server and am
> looking into virtual users (served by either mean, such as MySQL or
> other). Does anyone have some pointers about this?  Point being no
> direct access to the box obviously and a possibility to integrate that
> with Apache/WebDAV (hence my thinking of MySQL for the job).

See below for a config I have used which works pretty good. Redmine was 
used for setting up and storing users. The config below just auths svn of 
a MySQL database (redmine).

Let me know if you need to know any more details.

Rgds,
Steve Burke


apt-get install libapache2-mod-auth-mysql
a2enmod auth_mysql

<VirtualHost *:80>
         ServerAdmin root at server.com
         ServerName svn.server.com

         <Location />
                 DAV svn
                 SVNPath /var/svn/repos/main

AuthBasicAuthoritative Off
AuthUserFile /dev/null

AuthType Basic
AuthName "Repository"
AuthType Basic
AuthMySQL_Host localhost
AuthMySQL_User redmine
AuthMySQL_Password passwordhere
AuthMySQL_DB redmine
AuthMySQL_Empty_Passwords off
AuthMySQL_Password_Table users
AuthMySQL_Username_Field login
AuthMySQL_Password_Field hashed_password
AuthMySQL_Encryption_Types SHA1Sum

         AuthzSVNAccessFile /var/svn/conf/authz
         Require valid-user
         Satisfy Any

         </Location>
         ErrorLog /var/log/apache2/svn/error.log
         LogLevel debug
         CustomLog /var/log/apache2/svn/access.log combined
</VirtualHost>

As for: /var/svn/conf/authz

# Do NOT edit this file directly on the filesystem. It's under version 
control
# and auto-updates when changes are commited.
# This file is stored in /systems/svn/conf/authz in the repository.

[groups]
sysadmin = user1, user2
team = @sysadmin, user3, user4

[/]
@sysadmin = rw
* = r

[/website]
@team = rw


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFM7tSH21ZxaWXmuiARAqgUAJoDwAWDX3BGkfjWbu/wNAMF/N4Z2ACcD27w
eT4fnM32kRq5TzKBe8Fh2G0=
=OcEN
-----END PGP SIGNATURE-----