[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

svnserve sasl authentication with mysql user table

From: Nils Preusker <n.preusker_at_googlemail.com>
Date: Wed, 8 Oct 2008 17:37:09 +0200


has anyone managed to set up an svnserve instance on windows (SlikSVN),
using sasl to authenticate users against a mysql database? The svn book
mentions the following steps:
- add the following two lines to the repositories svnserve.conf file:
use-sasl = true
- create a main sasl configuration file named svn.conf
- create a registry key named [HKEY_LOCAL_MACHINE\SOFTWARE\Carnegie
Mellon\Project Cyrus\SASL Library] and create the two keys SearchPath
(pointing to the sasl libraries, which in the case of a windows installation
is the bin directory of the svnserve installation) and ConfFile (pointing to
the previously mentioned svn.conf file)

My sasl configuration (svn.conf) looks like this:

pwcheck_method: auxprop
auxprop_plugin: mysql
sql_user: themysqladminusername
sql_passwd: themysqladminpassword
sql_hostnames: localhost:3306
sql_database: thedatabase
sql_select: SELECT password FROM user WHERE user_name = '%u'
sql_verbose: true

I've also tried the above with mysql_user etc. but it didn't make a
difference. It seems like I never even get through to the database, since
when i try to commit to the test repository, nothing shows up in the logs of
my mysql database.

Three things I'd like to verify and I currently can't figure out how to:

1. How do I check if the registry keys are set correctly and the dll's and
config file are found
2. How do I check whether my sasl configuration is correct
3. Are there any log files that could give me a hint what I'm doing wrong?
Right now everything looks ok, I just can't log in when i want to commit to
the repo.

I appreciate your help! Cheers, Nils
Received on 2008-10-08 17:37:37 CEST

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.