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

Re: svnserve sasl authentication with mysql user table

From: Daniel Desrosiers <desrosiers_at_vdl2.ca>
Date: Sat, 2 May 2009 16:42:29 -0700 (PDT)

Hello,

has anyone found a way to athenticate svn with sasl on mysql? I too can't
get it to work.

Regards,

Daniel

Nils Preusker wrote:
>
> Hi,
>
> 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:
> [sasl]
> 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
>
>

-- 
View this message in context: http://www.nabble.com/svnserve-sasl-authentication-with-mysql-user-table-tp19881400p23351302.html
Sent from the Subversion Users mailing list archive at Nabble.com.
------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=1065&dsMessageId=2037694
To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_subversion.tigris.org].
Received on 2009-05-03 07:51:18 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.