svnserve sasl authentication with mysql user table

[Nils Preusker <n....@googlemail.com>]

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

Re: svnserve sasl authentication with mysql user table

[Daniel Desrosiers <de...@vdl2.ca>]

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@subversion.tigris.org].