Configure Apache to use ODBC authentication
I'm trying to connect to a Sql Server via ODBC to serve as the
Authentication mode to a locally installed CollabNet Subversion Server on
a Server running Windows Server 2008 x64.
I found this link that attempted this with an ODBC connection and Apache
2.2. I started by creating an ODBC connection using
"C:\Windows\SysWOW64\odbc32.dll" that successfully connected to the
server. When I attempted to make the same changes in the post with
CollabNet Subversion Server build 4.0.1-3680.113 which uses Apache 2.4, I
got the following error:
ERROR console.CommandLineService - Exit status=1 Process err output:
AH00526: Syntax error on line 5 of
C:/csvn/data/conf/svn_viewvc_httpd.conf:
Can't load driver file apr_dbd_odbc.so
I checked and there was a apr_dbd_odbc-1.dll file in my bin directory, but
I didn't find the .so file anywhere in my C:\csvn directory. I also
checked the folder priveleges, just to make sure it wasn't a permission
issue, and I opened it to Everyone wihtout success. I found a related post
that talked about how to theoritically do this here: Configure Apache to
use SQL Server authentication, but there didn't appear to be any
troubleshooting options.
I don't need to use an ODBC connection, it just looked like my only option
with Windows because FreeTDS and PostgreSQL were only commonly supported
on *nix systems.
Here is my svn_viewvc_httpd.conf file:
LoadModule dbd_module lib/modules/mod_dbd.so
LoadModule authn_dbd_module lib/modules/mod_authn_dbd.so
<IfModule dbd_module>
DBDriver odbc
DBDParams "DATASOURCE=OdbcName, USER=db_user, PASSWORD=xxxxxx"
</IfModule>
Include "C:/csvn/data/conf/ctf_httpd.conf"
SSLEngine On
RedirectMatch ^(/svn)$ $1/
<Location /svn/>
DAV svn
SVNParentPath "C:/SubversionRepositories"
SVNReposName "CollabNet Subversion Repository"
AuthType Basic
AuthName "CollabNet Subversion Repository"
AuthzSVNAccessFile "C:/csvn/data/conf/svn_access_file"
SVNListParentPath On
<IfModule deflate_module>
SetOutputFilter DEFLATE
</IfModule>
AuthBasicProvider dbd file
Require valid-user
# mod_authn_dbd SQL query to authenticate a logged-in user
AuthDBDUserPWQuery \
"SELECT [u].[hash] FROM [dbo].[user] u WHERE [u].[username] = %s"
</Location>
Is there a file that I'm missing in my build? Or am I looking for a
configuration change?
I appreaciate any assistance.
No comments:
Post a Comment