httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nilesh Govindarajan <nil...@itech7.com>
Subject Re: [users@httpd] SQL Server authentication
Date Tue, 11 Jan 2011 16:41:25 GMT
On 01/11/2011 09:13 PM, Hendrik Schmieder wrote:
> Mark H. Wood schrieb:
>> On Tue, Jan 11, 2011 at 06:06:16PM +0530, Nilesh Govindarajan wrote:
>>> On 01/11/2011 04:18 PM, Paolo DiCanio wrote:
>>>> The example on that page is for MySql. Unfortunately when using SQL 
>>>> Server,
>>>> the configuration is more complicated, because you can't simply 
>>>> configure
>>>>
>>>>       DBDriver mssql
>>>>
>>>> You have to use something called FreeTDS instead. If someone has 
>>>> actually
>>>> got SQL Server authentication up and running, I'd really appreciate 
>>>> it if
>>>> the could send me the steps, or just post their httpd.conf.
>>>>
>>>> Also, any information about how to configure multiple 
>>>> authentication methods
>>>> (passwd file and database), would be very helpful. If someone can 
>>>> confirm
>>>> whether or not this is even possible, please let me know.
>>>>
>>> APR (mod_dbd, mod_authn_dbd) supports ODBC (provided, 
>>> apr_dbd_odbc.so or
>>> apr_dbd_odbc.dll exists in the system), which is independent of 
>>> FreeTDS.
>>> MSSQL doesn't support ODBC?
>>
>> It does, but my understanding is that ODBC drivers for MSSQL implement
>> ODBC APIs using the TDS protocol.  ODBC is just a common API to talk
>> to various specific drivers, which use various protocols to talk to
>> their proper backends.  According to http://www.freetds.org/ FreeTDS
>> includes an ODBC library, so you'd probably just need to install it,
>> describe it to your driver manager, and tell HTTPD to use it.
>>
>
> It depends on which oS Apache is used.
> For Windows there's an MS-SQL ODBC driver, but for Linux you must use 
> FreeTDS.
>
>
It doesn't support unixODBC?
[sorry for hijacking]

-- 
Regards,
Nilesh Govindarajan
Facebook: http://www.facebook.com/nilesh.gr
Twitter: http://twitter.com/nileshgr
Website: http://www.itech7.com
VPS Hosting: http://www.itech7.com/a/vps


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message