The problem: 1) there's a directory on the server containing multiple svn repositories roots, say /var/svn, with /var/svn/a, /var/svn/b, etc. being repository roots 2) these repositories are accessed via HTTP, handled by Apache2 + mod_dav_svn 3) there's a MySQL user-password database we need to use to authenticate access to those repositories 4) at last the problematic place itself: the repository /var/svn/$username must be accessible (both read and write) only to those who authenticated themselves as "$username" with a valid password from the MySQL database
Currently i've stuck with two solutions (both incomplete) from tons of manuals and how-tos: a) AuthzSVNAccessFile could be a key to such an automatic repository -> user binding, but updating the access rights file on changes to MySQL database looks no way elegant, and will probably become a bottleneck with growing users database b) mod_auth_mysql (whatever one) makes it possible to transparently use the users database in Apache config, but still I'm unable to find a way to automatically Require user $username for a given repository /var/svn/$username. Please reply, if someone has an experience with such a configuration, any ideas/thoughts are welcome.
